Gekko Forum
Help with charting - Printable Version

+- Gekko Forum (https://forum.gekko.wizb.it)
+-- Forum: Trading discussion (https://forum.gekko.wizb.it/forum-1.html)
+--- Forum: Automated Trading (https://forum.gekko.wizb.it/forum-2.html)
+--- Thread: Help with charting (/thread-57150.html)



Help with charting - Henry151 - 05-11-2018

Hi guys,

So I'm trying to make a chart to help me visualize backtest data;

I've got the detailed_exposures.csv file, which as you know is structured like

Code:
Entry at (UTC)    Exit at (UTC)    Exposure    Entry balance    Exit balance    P&L    Profit
2017-08-26 05:00    2017-08-28 05:10    2 days    99.7    98.899    0.8    -0.80%
2017-08-28 20:40    2017-08-29 13:40    17 hours    98.603    105.704    7.1    7.20%
2017-08-29 18:30    2017-09-02 11:00    4 days    105.387    107.681    2.29    2.18%
2017-09-03 13:40    2017-09-03 15:10    2 hours    107.358    110.483    3.12    2.91%



I'm trying to figure out how I can chart it so that I've got an X axis that is "Time" and a Y axis that is "Balance."


So i would take a chart that has "time" on the bottom, and take each "entry at" and "entry balance" and plot them onto the chart, and each "exit at" and "exit balance" and plot them onto the chart. I think. But I'm not sure. And how the heck would I do that anyway?

Any help much appreciated. Or any guidance at all about how I can chart this data in an insightful or meaningful way.