กำลังดำเนินการ

VBA excel - Backtest trading data

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.

ทักษะ: Excel, Metatrader, Visual Basic

ดูเพิ่มเติม: data ajax website excel vba, data report design excel vba, excel vba report example, download several stock data date range excel vba, read data serial port excel vba, trading forex excel vba, data reconciliation using excel vba, backtest excel vba, tranfer data txt file excel vba excel, data yahoo finance excel vba addin, write xml data file using excel vba, excel vba dll example, getting data as400 using excel vba, data transfer word excel vba, data entry project excel vba, swot analyse seo, trading system lab, mtgo trading bot, trading bot java, pic trading site, sample j2ee stock trading system, trading bangladesh, analyse imei, send trading signals mt4 platform, trading dde

เกี่ยวกับผู้ว่าจ้าง:
( 11 บทวิจารณ์ ) Glen Iris, Australia

หมายเลขโปรเจค: #12202169

มอบให้กับ:

nevo1234

Dear sir I am an expert in excel and also I am an economist (BA+MBA) by profession, with over 10 years of experiance. I have vast experience in excel and VBA and i am confident i can assist you with your requireme เพิ่มเติม

$35 AUD ใน 3 วัน
(3 บทวิจารณ์)
2.0

freelancer จำนวน 44 คน กำลังประมูลอยู่ที่ราคาเฉลี่ย $78 สำหรับงานนี้

$30 AUD ใน 1 วัน
(272 บทวิจารณ์)
6.7
esalem

Hi, I am Forex trader and also MQL4 programmer in addition to VB,C#,C++ programming languages. In addition to that I am also developing solutions for TradingStation, TradeStation, NinjaTrade, cTrader, TWS from IB, เพิ่มเติม

$578 AUD ใน 7 วัน
(32 บทวิจารณ์)
6.6
cugamelover

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 เพิ่มเติม

$300 AUD ใน 5 วัน
(135 บทวิจารณ์)
6.7
paris2785

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 เพิ่มเติม

$100 AUD ใน 3 วัน
(101 บทวิจารณ์)
6.1
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 290 projects. Plea เพิ่มเติม

$100 AUD ใน 7 วัน
(102 บทวิจารณ์)
6.2
katilinas

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!

$100 AUD ใน 1 วัน
(78 บทวิจารณ์)
5.6
macroPOL

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.

$111 AUD ใน 3 วัน
(55 บทวิจารณ์)
5.4
$30 AUD ใน 2 วัน
(132 บทวิจารณ์)
5.6
abdolah2014

hi I am so interested in your project and I have some experience about the stock market too start the chat to discuss more ............................................

$25 AUD ใน 10 วัน
(29 บทวิจารณ์)
5.1
schoudhary1553

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 เพิ่มเติม

$34 AUD ใน 1 วัน
(76 บทวิจารณ์)
5.3
ksriniravi

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 เพิ่มเติม

$120 AUD ใน 2 วัน
(36 บทวิจารณ์)
4.7
teeares

I have created many macros in Excel. I can create one to your exact specifications. Please message for more discussions.

$25 AUD ใน 1 วัน
(46 บทวิจารณ์)
4.8
haibg2111

Dear the client, My name is Hai, I'm an expert in VBA programming and excel templates. I've helped many businesses create their financial, risk management. tatistics models in the insurance, banking, and financial i เพิ่มเติม

$150 AUD ใน 1 วัน
(13 บทวิจารณ์)
4.4
archanaoswal

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 เพิ่มเติม

$120 AUD ใน 1 วัน
(9 บทวิจารณ์)
3.4
ksinghrajeev

Hello There, Here are some of my work examples. Project Report Automation - [url removed, login to view] Log Report Automation - [url removed, login to view] เพิ่มเติม

$100 AUD ใน 7 วัน
(6 บทวิจารณ์)
3.7
shivaparvathi108

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 เพิ่มเติม

$10 AUD ใน 0 วัน
(25 บทวิจารณ์)
3.8
$300 AUD ใน 7 วัน
(2 บทวิจารณ์)
2.7
eddock

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

$30 AUD ใน 2 วัน
(1 บทวิจารณ์)
2.1
insidenetsoft

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 เพิ่มเติม

$40 AUD ใน 3 วัน
(7 บทวิจารณ์)
1.8
vivirain

Hi, I'm interested in the job. I'm an Excel expert with rich experiences in Excel VBA programing. I have confident that I can get it done with good quality. However, regarding to below requirement you have me เพิ่มเติม

$45 AUD ใน 2 วัน
(4 บทวิจารณ์)
2.0