Unable to import historical tick data

[pfdtrader24]

I am unable to import historical tick data that I purchased from Disktrading on the web. It will begin importing the data and at some random percentage uploaded, it will give the same error message and need to abort. Not sure what is causing this or what to do. 1 min and daily historical data from the same source import just fine, no problems.

[NinjaTrader_Ray]

Please check the log tab, any specific error messages?

[pfdtrader24]

I get one of 3 different errors.

1. Volume in line 1 (or 2) is invalid since it is <= 0. This line and subsequent invalid volume lines have been modified and replaced by a value of 1.

2. Failed to call 'Add' method for period type 'Tick': Exception of type 'System.OutOfMemoryException' was thrown.

3. $EURUSD: Date/Time format error in line 32322846: Exception of type 'System.OutOfMemoryException' was thrown.: '20040123 152000; 1.2592,0'

[NinjaTrader_JoshP]

Hi pfdtrader24,

How is your data formatted? From the last error message I think it is not formatted correctly. Please see this article: http://www.ninjatrader-support.com/H...V6/Import.html

[NinjaTrader_Dierk]

On (2) and (3): Try to split up the import data files, since you hit the wall due to RAM excess.

[pfdtrader24]

Here is the format of the tick data (AUDUSD)

20000630 110100 0.6003 0

It all looks correct to me (except the 0 for volume?)

The file sizes are very large and I tried to split the file up in Excel, but couldn't get it to import more than the first 1,048,576 rows (which is only the first 2 years of so, out of an approx. 10 year file). I am not experienced with Excel, so forgive me if I am overlooking something obvious. Thanks in advance for the help.

[NinjaTrader_Ray]

Put in some dummy value in replace of the zero.

[pfdtrader24]

Ray, I was just going to put a "1" in place of all zeros. Any idea as to how I can split up these large files to re-format/re-save them?

[NinjaTrader_Ray]

Just use any text editor, cut chunks out, put it into another file and save.

[mason]

Tip: use BK ReplaceEm http://www.orbit.org/replace/
It is a lot faster than notepad.