Find Jobs
Hire Freelancers

Do some Excel Work

zł30-90 PLN

完了済み
投稿日: 7年近く前

zł30-90 PLN

完了時にお支払い
I have some work, in an Excel spreadsheet. I need a small macro written than will run when data is pasted. The macro is to do as much/all of the following: What needs to be done: 1. data in columns A to J will be provided from a 3rd party 2. data is to be sorted according to symbol (col D), time (col C) and quantity (G). The net result must be zero. To accomplish this, you will need to have the macro sort the data so that a letter B (buy) is offset by enough letters S so that it will equal 0. e.g. BUY 200, Sell 50, Sell 50, Sell 100 = 0. If col E starts with a letter B the first quantity (col G) will always be positive. If on the other hand col E start starts with SS then this will mean the first quantity (in col G) will always need to be changed to a negative (-). for example, SS 200 will need to be changed to be SS -200. Then the following quantities related to that trade need to be added to equal 0. Continuing with the above example, SS -200, B 50, B 100, B50 =0. The data should have a line designating the end and beginning of a new trade. 3. Col J will need to be summarised for each trade 4. Col L needs a formula. If first entry in Col E is B (stands for BUY) then the formula needs to return "Opening Range Breakout". If, on the other hand, the first entry is Col E is SS, it needs to return "Opening Range Breakdown". 5. Col N needs a formula. If first entry in Col I is "Margin", needs to return "Long", otherwise "Short". 6. Col O needs a formula. The trade sorted from point 2. is to have the profit added together from Col J. 7. Col U (commissions payable) is to be summarised from a vlookup table in sheet "Comms - IB". Each trade needs to have a commission payable number calculated. 8. Col A is to be text version of date in Col B (in format "ddd") eg Thu, Fri, Mon etc. An example of the daily dump is also attached so you can see what the macro needs to work on. Please contact me if you are keen on this small macro work!
プロジェクト ID: 14326085

プロジェクトについて

5個の提案
リモートプロジェクト
アクティブ 7年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Hi, i have done similar type of work in my past. And i have a team with me for data entry work with 99% accuracy. We can discuss the details over chat, and i can share my past experience. Stay tuned, I'm is still working on this proposal.
zł75 PLN 1日以内
5.0 (1 レビュー)
0.8
0.8
この仕事に5人のフリーランサーが、平均zł206 PLNで入札しています
ユーザーアバター
I can definitely help you with that! I am a Web Developer, Network Engineer and a Professional Websites Automation Expert... I've done many web automation script for various clients.. Let me know and we can have a quick chat. thank you for giving me a wonderful opportunity to service you! Cheers Zia
zł222 PLN 3日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
A proposal has not yet been provided
zł75 PLN 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi, my name is Lilian, I have Microsoft Word, PowerPoint, Exce course, I have 8:00 working hours available, and I am interested in helping you in your new business.
zł555 PLN 0日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
For an accountant MS Excel is his bread and butter and so is the case with me. I have an experience of 6 years working on MS Excel and preparing Macros during my job and as a freelancer. Stay tuned, I'm is still working on this proposal.
zł105 PLN 4日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

POLANDのフラグ
Gdynia, Poland
5.0
1
お支払い方法確認済み
メンバー登録日:6月 12, 2017

クライアント確認

このクライアントからの他の仕事

Youtube marketing
zł90-750 PLN
ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。