VBA excel - Backtest trading data
$10-30 AUD
Płatność przy odbiorze
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.
Numer ID Projektu: #12202169
O projekcie
44 freelancerów złożyło ofertę za $78 w tym projekcie
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 Więcej
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!
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 Więcej
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.
hi I am so interested in your project and I have some experience about the stock market too start the chat to discuss 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 Więcej
I have created many macros in Excel. I can create one to your exact specifications. Please message for more discussions.
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 Więcej
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 Więcej
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
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 Więcej
I'm a master of Excel, I know VBA very well and often use my skills in Excel in office job (formulas, tables, diagrams etc).
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 Więcej