VBA excel - Backtest trading data
$10-30 AUD
Paid on delivery
I have a number of excel spreadsheets (all in the same format). In each spreadsheet, each row contains end of day historical price data and a numbers from technical indicators
The columns are OPEN, HIGH, LOW, CLOSE, INDICATOR 1, INDICATOR 2, INDICATOR 3,
I would like you to program a VBA macro to run several strategies (probably less than 5 strategies) on the data.
A strategy is a set of rules to enter and exit trades. For example an entry signal might be: IF moving average value (20 days) > moving average value of (100 days) then BUY a stock.
I will provide the rules to you to code for each strategy.
I would also like information shown such as profit/loss on each trade, total profit loss on the account, number of winning/losing trades, % of winning/losing trades, what % of the total capital is lost at any one time (drawdown) etc.
Project ID: #12202169
About the project
43 freelancers are bidding on average $80 for this job
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y More
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind o More
Greetings! I have worked on a number of similar projects. I understand what needs to be done. I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of aut More
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in analysis of stock trading data in Excel and presentation of the results using custom dashboards, macros More
Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
Hello, I am Excel and VBA expert. I can complete this project Please note that I have 100% completion rate and 5-star feedback on 50 projects.
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a reservation system - Built a complex shift allowance c More
hi I am so interested in your project and I have some experience about the stock market too start the chat to discuss more ............................................
I have created many macros in Excel. I can create one to your exact specifications. Please message for more discussions.
Hello, The key features that I see in a project like yours would be the professional presentation of the resulting data and the accuracy. The modules of this application would be divided in INPUT Sheets, PARAM Sh More
Hi Employer, I have completed very similar projects in the past. I have total 6+years of experience with excel VBA macro. I can complete this work within a day also if I have a clear requirement. I am ready to star More
I have many years experience in the financial services sector and have completed similar projects.. Contact me so I can expertly complete this project for you. Thanks, Ed
Hi, I am professional trader with technology background. I can develop this system for you by adding various other feature that you have asked for like 1) Optimization - You are running your strategy like 20 DMA- n More
Hi Sir, I have more than 10 years experience in writing VBA macros and excel automation with different MS applications i.e. Outlook, Word, SQL etc.