NinjaTrader Support Forum  
X

Attention!

This website will be down for maintenance from Friday May 24th at 6PM MDT until Saturday May 25th at 11AM MDT. We apologize for the inconvenience. If you need assistance during this time, please email sales@ninjatrader.com


Go Back   NinjaTrader Support Forum > NinjaScript File Sharing > NinjaScript File Sharing Discussion

NinjaScript File Sharing Discussion Discussion for shared NinjaScript files.

Reply
 
Thread Tools Display Modes
Old 03-30-2010, 10:15 AM   #1
Praveen
Junior Member
 
Join Date: Mar 2010
Posts: 3
Thanks: 0
Thanked 0 times in 0 posts
Default exporting historical data in CSV format

Hi
can anyone tell me if there is a way to export historical data in CSV/ASCII format. I can only export it to a text file, using the Tools option
ManY Thanks
Praveen is offline  
Reply With Quote
Old 03-30-2010, 10:44 AM   #2
NinjaTrader_Bertrand
NinjaTrader Customer Service
 
NinjaTrader_Bertrand's Avatar
 
Join Date: Sep 2008
Location: Germany
Posts: 22,384
Thanks: 252
Thanked 967 times in 950 posts
Default

Praveen, welcome to our forums - yes this is correct the export would be txt, you would import using Excel and then save / modify it to be csv style.
NinjaTrader_Bertrand is offline  
Reply With Quote
Old 03-30-2010, 11:10 AM   #3
Praveen
Junior Member
 
Join Date: Mar 2010
Posts: 3
Thanks: 0
Thanked 0 times in 0 posts
Smile Exporting data in CSV format

Thank you so much for your response. I need the data in the following format
DATE
mm/dd/yyyy
TIME
hh:mm
OPEN HIGH LOW CLOSE
Unfortunately when I export the data using the Tools on a notepad, I get the following:
20100228 180300;1101.25;1101.25;1101.25;1101.25;1

I don't know what the underlined and bold numbers are when I export the data on the notepad( I have underlined them and made them bold to draw attention to them) at the start and end of OHLC. I need to get the date and time instead
can you please advise how that can be done
Last edited by Praveen; 03-30-2010 at 11:31 AM.
Praveen is offline  
Reply With Quote
Old 03-30-2010, 11:14 AM   #4
NinjaTrader_Bertrand
NinjaTrader Customer Service
 
NinjaTrader_Bertrand's Avatar
 
Join Date: Sep 2008
Location: Germany
Posts: 22,384
Thanks: 252
Thanked 967 times in 950 posts
Default

The is the date and the volume of the exported data - as the resulting format would be -

Code:
yyyyMMdd HHmmss;open price;high price;low price;close price;volume
http://www.ninjatrader-support.com/H...V6/Export.html
NinjaTrader_Bertrand is offline  
Reply With Quote
Old 03-30-2010, 01:15 PM   #5
Praveen
Junior Member
 
Join Date: Mar 2010
Posts: 3
Thanks: 0
Thanked 0 times in 0 posts
Default

Thank you very much...really appreciate your help.
Praveen is offline  
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Use standard CSV format for historical data import Iggy22 Suggestions And Feedback 8 10-17-2010 10:43 PM
NT 7 Bug - Exporting the Trades grid to CSV values rugobal Version 7 Beta General Questions & Bug Reports 6 03-16-2010 01:05 PM
Exporting Historical Data to Excel katiewc Miscellaneous Support 4 02-09-2010 04:21 PM
Converting eSignal OnDemand output file format to NT historical data input format AnotherTrader Connecting 0 09-15-2009 07:21 AM
Exporting Historical Data (Date Format Issue) zwentz Miscellaneous Support 3 07-10-2009 11:08 AM


All times are GMT -6. The time now is 10:03 PM.