Just started working for www.carbibot.com and we looking for assistance on excel/vba analysis.
We will pre-pay for the 1st job, 50% and then 50% upon completion. Ongoing work is possible.
We need to analyse monthly trade data sets.
The issue is excel does not have the functionality that we need, with think that VBA will enable us to develop the functionality that we need.
We have thousands of trades, with time stamps and the size of each trade.
What we need to do is be able to adjust two parameters:
1. clearance time - the time it takes after executing a trade by minutes; 1, 5, 15, 30, 45, 60, 90, 120, 240
2. trading pool - total size of money available to invest by 100,000 USD; 100, 200, 300, 400, 500, 600, 700, 800, 900, 1000, 1100, 1200, 1300, 1400, 1500, 1600, 1700, 1800, 1900, 2000
So that we can analyse the number of trades that can be executed with a set trading pool size with a given clearance time.
This will enable use to analyse ROI over the month with different paramaters.
I am looking for a mix of experience and value