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: 25072
#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
Cumulative Delta (custom days to load) + Reset time by DannyP96 Started by DannyP96, 05-18-2026, 02:38 PM	1 response 27 views 0 likes	Last Post by NinjaTrader_ChelseaB Yesterday, 09:24 AM
Stochastic RSI Divergence by CarlTrading Started by CarlTrading, 05-11-2026, 05:56 AM	0 responses 117 views 0 likes	Last Post by CarlTrading 05-11-2026, 05:56 AM
RSI Candles Divergence by CarlTrading Started by CarlTrading, 05-10-2026, 08:12 PM	0 responses 69 views 0 likes	Last Post by CarlTrading 05-10-2026, 08:12 PM
Horizontal line with price by Hwop38 Started by Hwop38, 05-04-2026, 07:02 PM	0 responses 226 views 0 likes	Last Post by Hwop38 05-04-2026, 07:02 PM
BarBigTrade by CaptainJack Started by CaptainJack, 04-24-2026, 11:07 PM	0 responses 413 views 0 likes	Last Post by CaptainJack 04-24-2026, 11:07 PM

Announcement