I do a lot of processing with Python on the trades list from Strategy Performance Report.
Currently I need to:
- View the report
- Save it as XLSX
- Remove all the other tabs except trades list (even when I only check to export "List of Trades", empty tabs are still generated)
- Save it as CSV
- Use my python script to read the CSV and do the analysis
I need to do that every week, and sometimes more often, for each of my systems.
Is there a quicker way to get the trades list? if there'd be an option to just get the trades in a csv file, it will save a lot of work.
Exporting trades
-
- Posts: 63
- Joined: 13 Sep 2016
- Has thanked: 30 times
- Been thanked: 8 times
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2957 times
Re: Exporting trades
Hello TraderWalrus,
That is possible to export only the List of Trades in csv format from the Portfolio Performance Report.
That is possible to export only the List of Trades in csv format from the Portfolio Performance Report.
-
- Posts: 63
- Joined: 13 Sep 2016
- Has thanked: 30 times
- Been thanked: 8 times
Re: Exporting trades
Nice one. If you could add a column to the output, specifying which strategy initiated the trade (either a strategy ID or a name), it will be perfect.
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2957 times
Re: Exporting trades
TraderWalrus,
Do you need to get the strategy name or the signal name in the file?
Do you need to get the strategy name or the signal name in the file?
- Attachments
-
- strategies vs signals.png
- (13.23 KiB) Downloaded 808 times
-
- Posts: 63
- Joined: 13 Sep 2016
- Has thanked: 30 times
- Been thanked: 8 times
-
- Posts: 63
- Joined: 13 Sep 2016
- Has thanked: 30 times
- Been thanked: 8 times
Re: Exporting trades
Any prospects for that being added? If portfolio trades can be exported to one file, with some indication of the originating strategy per trade, I could do my analysis on all strategies together in matter of minutes.
Currently I guess differentiation between the strategies could be done by somehow passing a name to the signals of that strategy and using it in the entry or exit order name.
Currently I guess differentiation between the strategies could be done by somehow passing a name to the signals of that strategy and using it in the entry or exit order name.