Přejít k obsahu | Přejít k hlavnímu menu | Přejít k vyhledávání

Trouble importing historical data from Ninjatrader

1 replies

3 years ago #268096

I just exported a set of TICK data from Ninjatrader, and the code looks like below:

20200609 080001 2540000;15.95;15.9;15.95;100
20200609 080006 7420000;15.9;15.21;15.95;200
20200609 080006 7420000;15.9;15.21;15.95;200
20200609 080204 4670000;15.95;15.21;15.95;135

It doesn’t seem like SQ has an option to import data in this format. Does anyone know how?

Cheers

3 years ago #268138

Hello,

the import is possible if you slightly modify the format. NT8 uses format “20200609 080001 2540000;15.95;15.9;15.95;100″ where the bold part represents the millisecond fraction but it should rather be 0000254. Their format is not compatible with what Java expects

If you can, use Excel to modify the millisecond fraction and then you will be able to import using this format into SQX

yyyyMMdd HHmmss SSSSSSS

Attachments:

You must be logged in to view attached files.

Viewing 1 replies (of 1 total)

Risk Disclosure:
Futures and forex trading contains substantial risk and is not for every investor. An investor could potentially lose all or more than the initial investment. Risk capital is money that can be lost without jeopardizing ones’ financial security or life style. Only risk capital should be used for trading and only those with sufficient risk capital should consider trading. Past performance is not necessarily indicative of future results.

Hypothetical Performance Disclosure:
Hypothetical performance results have many inherent limitations, some of which are described below. no representation is being made that any account will or is likely to achieve profits or losses similar to those shown; in fact, there are frequently sharp differences between hypothetical performance results and the actual results subsequently achieved by any particular trading program. One of the limitations of hypothetical performance results is that they are generally prepared with the benefit of hindsight. In addition, hypothetical trading does not involve financial risk, and no hypothetical trading record can completely account for the impact of financial risk of actual trading. for example, the ability to withstand losses or to adhere to a particular trading program in spite of trading losses are material points which can also adversely affect actual trading results. There are numerous other factors related to the markets in general or to the implementation of any specific trading program which cannot be fully accounted for in the preparation of hypothetical performance results and all which can adversely affect trading results.

Testimonial Disclosure:
Testimonials appearing on www.strategyquant.com may not be representative of the experience of other clients or customers and is not a guarantee of future performance or success.