pull historical data

brucelevy

Senior Member

Join Date: Feb 2015

Posts: 409
#1

pull historical data

08-05-2017, 08:25 AM

How can I pull historical data into excel? I have cqg and kinetick as well as replay data. No need for real time data. I see there is data in the DB file but cannot access the file type.

Last edited by brucelevy; 08-05-2017, 08:29 AM.
Tags: None
NinjaTrader_ChelseaB

NinjaTrader Customer Service

Join Date: Dec 2012

Posts: 25064
#2

08-06-2017, 02:24 PM

Hello brucelevy,

Likely you can export the data from the Tools -> Historical Data Manager -> Export tab.

Exporting

http://ninjatrader.com/support/helpGuides/nt7/exporting.htm

Then use Excel to import and format the data.

Text Import Wizard - Microsoft Support

https://support.office.com/en-us/article/Text-Import-Wizard-c5b02af6-fda1-4440-899f-f78bafe41857

Although you can’t export to Excel directly from a text file or Word document, you can use the Text Import Wizard in Excel to import data from a text file into a worksheet.

Or you could write this to a .cvs file.

Export to Excel (indictors) - NinjaTrader Support Forum

https://ninjatrader.com/support/forum/showthread.php?p=515473#post515473

Support for the development of custom indicators using NinjaScript.

Chelsea B.NinjaTrader Customer Service
Comment

Topics	Statistics	Last Post
Cyclic RSI by CarlTrading Started by CarlTrading, Yesterday, 11:51 AM	0 responses 18 views 0 likes	Last Post by CarlTrading Yesterday, 11:51 AM
Andean Oscillator by CarlTrading Started by CarlTrading, Yesterday, 11:48 AM	0 responses 23 views 0 likes	Last Post by CarlTrading Yesterday, 11:48 AM
AnchoredVWAP—DrawingTools by CaptainJack Started by CaptainJack, 03-25-2026, 09:53 PM	0 responses 30 views 0 likes	Last Post by CaptainJack 03-25-2026, 09:53 PM
AnchoredVP—DrawingTools by CaptainJack Started by CaptainJack, 03-25-2026, 09:51 PM	0 responses 17 views 0 likes	Last Post by CaptainJack 03-25-2026, 09:51 PM
OrderFlow Highlighted Cells Update by Mindset Started by Mindset, 03-23-2026, 11:13 AM	0 responses 23 views 0 likes	Last Post by Mindset 03-23-2026, 11:13 AM

Announcement