How can I import trades from CSV files?

 

Tradingstats gives you the option to import trades from CSV files, the only thing you have to do is to create a new account for CSV format from “New Account” option and then import a .CSV file with this structure:

Ticket– Ticket number to identify your trade in the sequence
Open Time – Time when the trade was opened (YYYY.MM.DD HH:MM:SS)
Type – Type of trade (BUY – SELL)
Size – Number of lots to trade (0.01, 0.3, 1.3, etc..)
Item – instrument to trade (EURUSD, USDJPY, etc…)
Open Price – Instrument price when the trade was opened
S / L –  Stop loss price
T / P – Take profit price
Close Time -Time when the trade was closed (YYYY.MM.DD HH:MM:SS)
Close Price – Instrument price when the trade was closed
Commission – Commission charged by the broker to the trade
Taxes – Taxes charged by the broker to the trade
Swap – Interest won or lost in the operation
Profit – Result of the trade in money
State – Status of the trade (It should be CLOSED)
Comment – Remark about the trade that we want to keep in our records

Here you have an example of a trade:

23978917, 2014.10.31 12:45:28, sell, 1.00, eurusd, 125.597, 0.00000, 0.00000, 2014.11.03 11:05:10, 124.976, -5.50, 0.00, -0.08, 496.90, Closed, ‘This is a comment’

Additionally, you can add administrative trades to add or withdrawl money from your account, you should use BALANCE as the Type of trade. This is an example of administrative trade:

23978798, 2014.10.31 12:43:11, balance, Demo deposit, , , , , , , , , ,10000.00,Closed, ‘This is a comment- First deposit’

And here you have a sample with a sequence of trades with its header:

Ticket,Open Time,Type,Size,Item,Open Price,S / L,T / P,Close Time,Close Price,Commission,Taxes,Swap,Profit,State,Comment

23978798,2014.10.31 12:43:11,balance,Demo deposit,,,,,,,,,,10000.00,Closed
23978917,2014.10.31 12:45:28,sell,1.00,eurusd,125.597,0.00000,0.00000,2014.11.03 11:05:10,124.976,-5.50,0.00,-0.08,496.90,Closed,’This is a comment – First trade’
23978937,2014.10.31 12:45:48,buy,1.00,usdjpy,111.644,0.000,0.000,2014.10.31 14:41:41,111.681,-5.50,0.00,0.00,26.34,Closed
23978971,2014.10.31 15:57:26,buy,1.00,gbpusd,159.704,0.00000,0.00000,2014.11.03 10:50:59,160.009,-5.50,0.00,0.16,244.08,Closed
23986984,2014.10.31 14:41:51,sell,1.00,gbpusd,160.068,0.00000,0.00000,2014.11.03 12:31:06,159.989,-5.50,0.00,-1.84,63.21,Closed
24070721,2014.11.03 10:57:42,sell,0.75,usdjpy,112.860,0.000,0.000,2014.11.03 14:31:34,113.614,-4.13,0.00,0.00,-398.16,Closed
24072469,2014.11.03 11:04:58,buy,0.75,usdchf,0.96466,0.00000,0.00000,2014.11.04 23:59:34,0.95997,-4.13,0.00,-0.19,-292.05,Closed
24083204,2014.11.03 12:31:27,buy,0.75,eurusd,124.978,0.00000,0.00000,2014.11.04 23:59:21,125.458,-4.13,0.00,-0.96,286.95,Closed
24092586,2014.11.03 14:32:09,sell,0.75,audusd,0.87174,0.00000,0.00000,2014.11.03 20:33:29,0.86894,-4.13,0.00,0.00,168.31,Closed
24118276,2014.11.05 07:52:07,sell,0.75,usdjpy,114.188,0.000,0.000,2014.11.26 17:10:59,117.590,-4.13,0.00,-17.37,-1 735.19,Closed

24118291,2014.11.03 20:34:31,buy,0.75,eurjpy,142.189,0.000,0.000,2014.11.05 10:14:42,143.188,-4.13,0.00,-1.58,523.26,Closed,’This is a comment – Last trade’

Please, take in account that if you have to include all the columns and if you don’t have some information you have to enter 0.00 on the empty field.

And to make the job even easier, an Excel template to import trades with CSV format to Tradingrex you can use to start adding your own trades, don’t forget to export the file as .CSV when you finish entering the trades!

If you have any problem with this procedure send us an e-mail to support@tradingstats.com and we will be glad to help.