File format description for uploading to the trades analysis service
File format requirements:
A file must have "csv" extension and character ";" as a separator.
The first line in the file must contain column names.
There must be no any open position in the file (volume of BUY trades must be equal to volume of SELL trades).
DATE - date of the trade in format YYYYMMDD, where YYYY - year, MM - month, DD - day;
TIME - time of the trade in format HHMMSS, where HH - hours (24-hour format), MM - minutes, SS - seconds;
DIRECTION - trade direction: BUY or SELL.
PRICE - trade price;
QTY - trade volume;
TICKER - name of the finantial instrument;
STRATEGY - name of the strategy to get statistic per strategy;
COMMISSION - commission per share/contract;
POINTCOST - cost of the finantial instrument point, it;s using for money result calculation.
Example of the file:
Create a file in Excel
Fill column names:
Fill in data for each column:
Save the file in csv format with ";" as separator:
Create a file in a simple text editor
Open Windows notepad or any other text editor:
Fill in column names. Use ";" as a separator:
Fill in the data for each column:
Save the file with the name "file name.csv":