December 10, 2014
How to copy backtest trade list to a spreadsheet
There are several ways to transfer the backtest results to a spreadsheet.
- Immediately after the test we can just click on the results list with right mouse button and choose Copy from the menu. It is also possible to click on the results and use Ctrl+C key shortcut.
The operation will copy the entire list, so there is no need to select all rows manually.
- After the test, we can also use File->Export option from the main program menu to export the results list to a CSV or HTML file, which could be opened from Excel later on.
- Backtest results are also accessible through the Report Explorer:
In order to open detailed report for the particular test it is enough to double-click on the selected line. Then, after we navigate to Trade List page, to copy the results, the best option to use is Edit->Copy Table
Unlike the regular Copy option, Copy Table transforms HTML tables into CSV format and copies it into clipboard so tables can be pasted easily to Excel. Also it divides Entry/Exit columns into separate Entry/exit date/price columns.
Filed by AmiBroker Support at 3:14 pm under General
Comments Off on How to copy backtest trade list to a spreadsheet