Historical data help

Radical · 09-08-2009, 12:44 PM

I just came into possession of roughly 4 months of tick data as one file in CSV format. I would like to import this to Ninja, but I've come across the following problem:

As of now, the data looks like this in excel, and I have no idea how to get it into the correct format:

Quote:

05/15/09 09:45:01 AM 16600 16600 16600 16600 1
05/15/09 09:45:01 AM 16600 16600 16600 16600 1
05/15/09 09:45:01 AM 16600 16600 16600 16600 1
05/15/09 09:45:01 AM 16600 16600 16600 16600 2
05/15/09 09:45:01 AM 16600 16600 16600 16600 1

Does anyone have any ideas on how I'd be able to change the format to the correct one?

NinjaTrader_Bertrand · 09-08-2009, 01:04 PM

Radical, you would need to use Excel's data manipulation options and then save the result to a semicolon delimited file.

Radical · 09-08-2009, 04:15 PM

Do you know by any chance how I would go about doing that? I don't have much experience with Excel.

NinjaTrader_Bertrand · 09-09-2009, 04:04 AM

Unfortunately I can't give you a step by step walkthrough, but for a start I suggest to check into this blog and the solutions / ideas offered there - http://blogs.msdn.com/excel/archive/...-in-excel.aspx

Radical · 09-09-2009, 02:24 PM

Thanks, I'll give that a look through.

09-08-2009, 01:04 PM	#2
NinjaTrader_Bertrand NinjaTrader Customer Service Join Date: Sep 2008 Location: Germany Posts: 22,377 Thanks: 252 Thanked 966 times in 949 posts	Radical, you would need to use Excel's data manipulation options and then save the result to a semicolon delimited file. Bertrand NinjaTrader Customer Service Use Kinetick, NinjaTrader’s preferred market data service - Learn More Free online training events - View Schedule
	Facebook Twitter YouTube

09-08-2009, 04:15 PM	#3
Radical Senior Member Join Date: Sep 2008 Posts: 543 Thanks: 80 Thanked 187 times in 131 posts	Do you know by any chance how I would go about doing that? I don't have much experience with Excel.
	Facebook Twitter YouTube

09-09-2009, 04:04 AM	#4
NinjaTrader_Bertrand NinjaTrader Customer Service Join Date: Sep 2008 Location: Germany Posts: 22,377 Thanks: 252 Thanked 966 times in 949 posts	Unfortunately I can't give you a step by step walkthrough, but for a start I suggest to check into this blog and the solutions / ideas offered there - http://blogs.msdn.com/excel/archive/...-in-excel.aspx Bertrand NinjaTrader Customer Service Use Kinetick, NinjaTrader’s preferred market data service - Learn More Free online training events - View Schedule
	Facebook Twitter YouTube

09-09-2009, 02:24 PM	#5
Radical Senior Member Join Date: Sep 2008 Posts: 543 Thanks: 80 Thanked 187 times in 131 posts	Thanks, I'll give that a look through.
	Facebook Twitter YouTube

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Historical Tick Data to Market Replay Data Convertor	MXASJ	Suggestions And Feedback	5	12-18-2012 03:51 AM
Historical data / Esignal data – Strategy Analyser mismatch	drolles	Strategy Development	9	05-27-2009 07:03 AM
Which data provider will give me the most historical data for GBP/JPY?	Babatot	Charting	13	05-22-2009 06:55 PM
Real time data overwriting historical data	jriverac	Charting	1	02-05-2009 12:42 PM
Can't show latest data point from historical data file	xewoox	Charting	3	12-31-2008 07:16 AM