Excel Equity Curve

• 06/02/2018 at 2:56 PM #72055
  bezieh

  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 🙂

  

  bezieh

  Participant

  Topics: 11

  Replies: 25

  Been thanked: 1 time
  06/02/2018 at 7:35 PM #72070
  Despair

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

  

  Despair

  Blocked

  Topics: 97

  Replies: 1034

  Been thanked: 217 times
  06/02/2018 at 8:56 PM #72077
  bezieh

  how? i cant copy the trades from the backtest

  

  bezieh

  Participant

  Topics: 11

  Replies: 25

  Been thanked: 1 time
  06/02/2018 at 9:24 PM #72079
  Despair

  Drag’n drop 🙂

  

  Despair

  Blocked

  Topics: 97

  Replies: 1034

  Been thanked: 217 times
  06/02/2018 at 9:30 PM #72081
  Vonasi

  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.

  

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1810 times
  06/02/2018 at 11:40 PM #72089
  bezieh

  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”

  

  bezieh

  Participant

  Topics: 11

  Replies: 25

  Been thanked: 1 time
• Author
  Posts