Excel Equity Curve

bezieh · 2018-06-02T13:56:37+00:00

Hey guys! I got 6/7 strategies that seem really nice, and i would like to put them all in excel so i can see how the EQ curve will be with them all combined, and what the max drawdown is in amount of money and in time, so i would know what to expect in the future of live results. Appreciate the help, kind regards 🙂

Viewing 6 posts - 1 through 6 (of 6 total)

Author

Posts
06/02/2018 at 2:56 PM #72055 quote

bezieh
Participant

Average

Hey guys!

I got 6/7 strategies that seem really nice, and i would like to put them all in excel so i can see how the EQ curve will be with them all combined, and what the max drawdown is in amount of money and in time, so i would know what to expect in the future of live results.

Appreciate the help, kind regards 🙂

06/02/2018 at 7:35 PM #72070 quote

Despair
Blocked

Master

You can drag’n drop the trades from each backtest directly to a spreadsheet.

06/02/2018 at 8:56 PM #72077 quote

bezieh
Participant

Average

how? i cant copy the trades from the backtest

06/02/2018 at 9:24 PM #72079 quote

Despair
Blocked

Master

Drag’n drop 🙂

06/02/2018 at 9:30 PM #72081 quote

Vonasi
Moderator

Master

What Despair is trying to say is just click hold drag and release the contents of the Detailed Report window into Excel like this example. Do that with all the strategies and then get Excel to calculate what you need to know and graph it.

[attachment file=72082]

Screenshot_1.png

06/02/2018 at 11:40 PM #72089 quote

bezieh
Participant

Average

I copied in 3 strategies backtest results, and instead of getting an EQ curve, i just get alot of bars and i cant see anything..

doesnt become a well defined line as a eq curve, why? i put the option “line, stacked together”
Author

Posts