By default, data downloaded for each symbol is saved in a file having the name of that symbol and the extension csv by default. This can be adjusted however by using the Output settings: strings can be prepended and/or appended to the symbol part of the file name and the file extension can be changed.
The format described below is relevant mostly if fixed formatting settings are used. If regex formatting is used, data can be saved in virtually any format.
The date format depends on several settings (see the Settings section). They can be in US or European format, and or they can have the month and day fields padded with 0s up to 2 digits.
Historical data files are saved in CSV format with the following columns:
Date |
Open |
High |
Low |
Close |
Volume |
There is no title row in the data files.
Data example when using the US date format
11/15/2010 |
49.8578 |
50.3459 |
49.4693 |
49.6884 |
2806900 |
11/16/2010 |
50.8041 |
51.8999 |
50.7443 |
50.9535 |
5451100 |
11/17/2010 |
50.6547 |
50.7244 |
49.9773 |
50.3957 |
4875700 |
11/18/2010 |
50.6049 |
51.1727 |
50.2164 |
50.9535 |
4379900 |
11/19/2010 |
50.9535 |
52.2784 |
50.8639 |
51.87 |
4025700 |
The same data using the European date format:
15/11/2010 |
49.8578 |
50.3459 |
49.4693 |
49.6884 |
2806900 |
16/11/2010 |
50.8041 |
51.8999 |
50.7443 |
50.9535 |
5451100 |
17/11/2010 |
50.6547 |
50.7244 |
49.9773 |
50.3957 |
4875700 |
18/11/2010 |
50.6049 |
51.1727 |
50.2164 |
50.9535 |
4379900 |
19/11/2010 |
50.9535 |
52.2784 |
50.8639 |
51.87 |
4025700 |
In case the option to add the symbol name to the file to column is on, and the column number is 1 for example, the resulting data will be:
11/15/2010 |
symbol |
49.8578 |
50.3459 |
49.4693 |
49.6884 |
2806900 |
11/16/2010 |
symbol |
50.8041 |
51.8999 |
50.7443 |
50.9535 |
5451100 |
11/17/2010 |
symbol |
50.6547 |
50.7244 |
49.9773 |
50.3957 |
4875700 |
11/18/2010 |
symbol |
50.6049 |
51.1727 |
50.2164 |
50.9535 |
4379900 |
11/19/2010 |
symbol |
50.9535 |
52.2784 |
50.8639 |
51.87 |
4025700 |