Text files with historical data

Text data source format

To correctly load data from a text file, you must write the first line of the document in the following format:

<DATE>,<TIME>,<OPEN> ...,<VOL>

If this string is missing, the program will display the message "Format string not found" Possible options for parameters used in the header:

<TICKER>

Tool name. Optional

<PER>

Period. Integer.

<DATE>

Date yyyymmdd

<TIME>

Time hhmmss

<OPEN>

Candle opening price (bars only)

<LOW>

Candle low price (bars only)

<HIGH>

Candle high price (bars only)

<CLOSE>

Candle closing price (bars only)

<VOL>

Volume of the bar (or deal)

<OI> или <INTEREST>

Open Interest

<LAST>

Trade price (used for tick data)

<MSEC>

Milliseconds

<TRADENO> или <ID>

Trade number (for ticks) Integer

<LAST>

Last value (for ticks)

<OPER>

Trade direction (for ticks) "B", "S"

<ASK>

The price of the best sell offer in the order queue (at the time of closing the bar, deal)

<ASKQTY>

Volume of the best offer

<BID>

Best demand price

<BIDQTY>

Best demand volume

<STEPPRICE>

Price step

An example of writing data in a text file

Example #1. Period one minute

<TICKER>,<PER>,<DATE>,<TIME>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>
NYMEX.PL,1,20140801,000000,1462.9,1463.4,1462.9,1462.9,16
NYMEX.PL,1,20140801,000200,1463.6,1463.8,1462.9,1462.9,19
NYMEX.PL,1,20140801,000300,1463.8,1463.8,1463.8,1463.8,1
NYMEX.PL,1,20140801,000600,1463.2,1463.2,1462.70,1462.9,19

Example #2. Period 1 tick with trade number

<DATE>,<TIME>,<LAST>,<VOL>,<ID>
20160713,100000,94150,2,1538194180
20160713,100000,94120,1,1538194181
20160713,100000,94100,1,1538194182
20160713,100000,94100,2,1538194183
20160713,100000,94100,1,1538194184

Example #3. 1 tick period with trade direction and best bid and offer data, with open interest

<DATE>,<TIME>,<MSEC>,<TRADENO>,<LAST>,<VOL>,<OPER>,<ASK>,<ASKQTY>,<BID>,<BIDQTY>,<INTEREST>,<STEPPRICE>
20190108,100000,000,2206980738,1.1473,1,B,1.1515,1951,1.1462,4187,103604,6.78181
20190108,100000,000,2206980739,1.1478,1,B,1.1515,1951,1.1462,4187,103604,6.78181
20190108,100000,000,2206980740,1.1478,1,B,1.1515,1951,1.1462,4187,103604,6.78181
20190108,100000,000,2206980741,1.1483,4,B,1.1515,1951,1.1462,4187,103604,6.78181

Last updated

Was this helpful?