Offline data provider in CSV format

CSV file data format

In TSLab, you can use CSV files as an offline data provider. The contents of the file must be in the specified format.

The only data format recognized for CSV files:

1️⃣ The order of writing data in columns:

DATE;TIME;OPEN;HIGH;LOW;CLOSE;VOL;

The order and the format of writing data in rows:

MM/dd/yyyy;HH:mm;open;high;low;close;volume;

2️⃣ The file should not have a header line. The line above is indicated as an instruction; it should not be in the file.

3️⃣ It is necessary to use bars starting from minutes and above.

4️⃣ There should be no empty lines in the file. Data is read until the first empty line.

5️⃣ You must use a semicolon character (;) as a column separator.

6️⃣ As a separator of the fractional part of the number, you must use the dot sign (.)

7️⃣ The number must be written without spaces.

8️⃣ The format of writing Date: MM/dd/yyyy

9️⃣ The format of writing Time: HH:mm

Important!

The time written in the csv file is perceived by the program as UTC time. In the data provider, you can use the Local time setting, according to the time settings in windows.

🔟 At the end of each line, use a semicolon (;)

An example of writing data in the CSV file

04/13/2020;20:00;8699;8745;8686;8742;5925;
04/13/2020;21:00;8743;8774;8739;8750;4309;
04/13/2020;22:00;8750;8763;8735;8738;1519;
04/13/2020;23:00;8738;8785;8736;8778;2740;
04/14/2020;00:00;8776;8779;8752;8771;3112;
04/14/2020;11:00;8763;8807;8754;8795;28022;
04/14/2020;12:00;8798;8805;8763;8794;29381;
04/14/2020;13:00;8794;8801;8778;8789;16258;

You can download an example of filling the CSV file:

353B

ExampleCSV.csv