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!
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.
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
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.
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.