05-11-2018, 06:43 PM
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
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.
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.