Can I create an excel spreadsheet out of data from backtest? Exporting History is not enough.

Created at 20 Dec 2017, 21:31
How’s your experience with the cTrader Platform?
Your feedback is crucial to cTrader's development. Please take a few seconds to share your opinion and help us improve your trading experience. Thanks!
AR

aronbara664

Joined 29.10.2017

Can I create an excel spreadsheet out of data from backtest? Exporting History is not enough.
20 Dec 2017, 21:31


Hi there,

I'd like to know whether there's a possibility of integrating Excel with cAlgo.

I know it's possible to export the History to an Excel Spreadsheet, however that's simply not enough.

I have certain data which I gather from the backtest that I'd like to put into an excel spreadsheet to further analyze data & then better the performance of my robot.

So far I've been printing out the data I need to the Log and tried to make an Excel & CSV file out of that, but that doesn't work and is not economical. 

So I thought maybe there could be a possibility of creating an Excel Spreadsheet from cAlgo? 

Hopefully I described the issue in great enough detail,

 

Thank you!


@aronbara664
Replies

aronbara664
21 Dec 2017, 12:44 ( Updated at: 21 Dec 2023, 09:20 )

Hi there!

Thank you very much! This is really cool but I have one problem though:

When I try running this, it works for the first time, then I get this error: 


@aronbara664

aronbara664
21 Dec 2017, 12:55

Nevermind, I think I got it now :-)


@aronbara664