Data File Format

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.

Bar data format

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

 


Copyright © 2017 YLoader.com
http://www.yloader.com

info@yloader.com