{"id":922,"date":"2014-12-10T15:14:45","date_gmt":"2014-12-10T20:14:45","guid":{"rendered":"http:\/\/www.amibroker.com\/kb\/?p=922"},"modified":"2014-12-10T15:25:14","modified_gmt":"2014-12-10T20:25:14","slug":"copy-backtest-result-to-excel","status":"publish","type":"post","link":"https:\/\/www.amibroker.com\/wordpress\/kb\/2014\/12\/10\/copy-backtest-result-to-excel\/","title":{"rendered":"How to copy backtest trade list to a spreadsheet"},"content":{"rendered":"<p>There are several ways to transfer the backtest results to a spreadsheet.<\/p><ol><li>Immediately after the test we can just click on the results list with right mouse button and choose <strong>Copy<\/strong> from the menu. It is also possible to click on the results and use <strong>Ctrl+C <\/strong>key shortcut.<p><img src=\"\/\/www.amibroker.com\/kb\/wp-content\/uploads\/2014\/12\/copyex1.png\" alt=\"Copy Trade List\" \/><\/p><p>The operation will copy the entire list, so there is no need to select all rows manually.<\/p><li>After the test, we can also use <strong>File->Export<\/strong> 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.<p><img src=\"\/\/www.amibroker.com\/kb\/wp-content\/uploads\/2014\/12\/copyex2.png\" alt=\"Export Trade List\" \/><\/p><li>Backtest results are also accessible through the Report Explorer:<p><img src=\"\/\/www.amibroker.com\/kb\/wp-content\/uploads\/2014\/12\/copyex3.png\" alt=\"Backtest Report Explorer\" \/> <\/p><p>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 <strong>Edit->Copy Table<\/strong><\/p><p><img src=\"\/\/www.amibroker.com\/kb\/wp-content\/uploads\/2014\/12\/copyex4.png\" alt=\"Copy Table\" \/><\/p><p>Unlike the regular Copy option, <strong>Copy Table<\/strong> 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.<\/p><\/ol>","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[39],"tags":[14,15,44,31],"_links":{"self":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/922"}],"collection":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/comments?post=922"}],"version-history":[{"count":3,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/922\/revisions"}],"predecessor-version":[{"id":940,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/922\/revisions\/940"}],"wp:attachment":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/media?parent=922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/categories?post=922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/tags?post=922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}