|
Working with Excel (tools, indicators, conversion ...)
Here is a tool for combining trading results into an Excel spreadsheet from multiple accounts.
Put the EA where you want to start collecting results. This dumps the data so Excel can ingest it. Put that path in the Startup worksheet of the Excel spreadsheet along with which currency pair you want to extract and the name of the tab/worksheet you want the results to be placed. After extracting the information, it creates a Summary sheet of all of the sheets it analyzed with results by date & tab. It's not as pretty as the other, but I had a lot of kludged code in that which was customized for the sordid way I have my folders laid out.
When you launch the spreadsheet, you have to enable macros or it can't work. All of the source for the spreadsheet macros & EA are included as well as an instruction sheet, so tweak to your own tastes.
|