Export Open Trade Data to .csv for Z-Strategies

Posted By: Martin_HH

Export Open Trade Data to .csv for Z-Strategies - 11/06/23 17:11

Hi there,

I am using Google Sheets to analyse and monitor the open and closed trades of my different strategies. In the scripts ,I am exporting the open trades and strategy statistics via the file or report functions to .csv files. The closed trades are already available (e.g. demotrades.csv for Live testing).
With a Google script, I have automated the import of the open and closed trades .csv files to Google sheets (time based).
Now,I am able to aggregate the data of the different strategies from my portfolio. The Zorro .htm status file is already a good overview, but only for a single script and not for the full portfolio (even when I have several assets, algos and time frame in one script).

Now my question, I am also using two Z-strategies. Due to the fact, that I cannot update the source code by my own, I am looking for a method to grab the data for the open trades. So far I did not find a possibility except to parse the .htm status file, but this is very complex and does not really work in a robust way. Also the Log file is not the easy source to come to a solution.

Anyone has an idea how to grab the open trades data for Z-Strategies?

PS: The broker information is not sufficient for me, because of the missing Zorro details (Algo, Time frame and so on).
Posted By: Martin_HH

Re: Export Open Trade Data to .csv for Z-Strategies - 11/07/23 10:02

Well, I found a simple solution via the import function in Google sheets. I import the .htm file it is converted in a sufficient way. Now, I can automate this easily.

Martin
© 2024 lite-C Forums