Excel Equity Curve

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #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 🙂

    #72070 quote
    Despair
    Blocked
    Master

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

    #72077 quote
    bezieh
    Participant
    Average

    how? i cant copy the trades from the backtest

    #72079 quote
    Despair
    Blocked
    Master

    Drag’n drop 🙂

    #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 Screenshot_1.png
    #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”

Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.

Excel Equity Curve


General Trading: Market Analysis & Manual Trading

New Reply
Author
author-avatar
bezieh @bezieh Participant
Summary

This topic contains 5 replies,
has 3 voices, and was last updated by bezieh
7 years, 8 months ago.

Topic Details
Forum: General Trading: Market Analysis & Manual Trading
Language: English
Started: 06/02/2018
Status: Active
Attachments: 1 files
Logo Logo
Loading...