Trade history excel export from TOS and import into TradingDiary Pro

<< Click to Display Table of Contents >>

Navigation:  Import > Thinkorswim >

Trade history excel export from TOS and import into TradingDiary Pro

TradingDiary Pro trading journal supports importing data for Thinkorswim clients.

 

Start Thinkorswim trading software. Go to the Monitor tab and select Account Statements.

 

Monitor tab

Monitor tab

 

Change the date range according to how many days you would like to import.

 

Please make sure that the following columns are visible (only visible columns are exported to the excel file):

 

Cash & Sweep Vehicle - Cash Balance:

 

oRef #

oMisc Fees

oCommissions & Fees

oAmount

 

Order History - Account Order History:

 

oTime Placed

oSpread

oSide

oQty

oPos Effect

oSymbol

oExp

oStrike

oType

oStatus

oOrder ID

 

Trade History - Account Trade History:

 

oExec Time

oSpread

oSide

oQty

oSymbol

oExp

oStrike

oType

oPrice

oOrder ID

 

Equities (optional):

 

oSymbol

oDescription

oQty

oTrade Price

oMark

 

Futures (optional):

oSymbol

oDescription

oQty

oSPC

oExp

oMark

 

Options (optional):

oSymbol

oOption Code

oExp

oStrike

oType

oQty

oMark

oMark Value

 

 

To change the visible columns in each section please click on the small gear icon at right (highlighted by yellow). Each section has it's own setup.

 

Account Statement setup

Account Statement setup

 

 

Click on the small lines icon next to the arrow and click on the Export to file menu.

 

Export to excel file

Export to excel file

 

A file dialog window appears. Change the file type to CSV (comma separated value).

Save your statement. For example into the Documents/TOS_Statements/ directory.

 

Go back to TradingDiary Pro. Set Thinkorswim as the import module. For detailed information read the Import Introduction chapter.

 

Click on the 'Import/Import - TOS CSV File' menu. A file dialog appears. Select the previously saved csv file and click on Open.

 

Done. Now you can see the import manager which shows the number of the imported elements.

 

You can check the video tutorial as well.