![]() |
Exporting Sim Broker Transactions to Excel |
| 16:34 Johnny: Is there
a possible way to get the transaction in Sim broker onto an excel spread
sheet ?
16:39 Ensign Kimball: The 'Transaction Log' will display all the orders that have been placed, filled, and canceled. A dashed line will appear in the log when trades have been exited and the current position is Flat. The log can be printed by clicking on the Ensign Windows Print button on the main Toolbar (or select File | Print from the menu). The log will be saved when the Simulation Broker window is closed. A Log file of the trades is saved to the \ENSIGN\BROKER folder using the Symbol and the Date as the file name. For example, IBM1205.TXT would be the IBM broker file for December 5th. Click the Clear Log button to clear the Transaction Log entries and remove the trade arrows from the chart. 16:39 Ensign Kimball: The .TXT file is where the data is saved. If you can import the info to Excel, then you can view it. 16:40 Johnny: Ok thank you |