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: 25074
#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
CopierLite_V3.0 by CaptainJack Started by CaptainJack, 05-29-2026, 05:09 AM	0 responses 320 views 0 likes	Last Post by CaptainJack 05-29-2026, 05:09 AM
BarBigTrade by CaptainJack Started by CaptainJack, 05-29-2026, 12:02 AM	0 responses 203 views 0 likes	Last Post by CaptainJack 05-29-2026, 12:02 AM
Ergonomic Charts Enhanced by charlesugo_1 Started by charlesugo_1, 05-26-2026, 05:03 PM	0 responses 190 views 1 like	Last Post by charlesugo_1 05-26-2026, 05:03 PM
Cumulative Delta (custom days to load) + Reset time by DannyP96 Started by DannyP96, 05-18-2026, 02:38 PM	1 response 283 views 0 likes	Last Post by NinjaTrader_ChelseaB 05-21-2026, 09:24 AM
Stochastic RSI Divergence by CarlTrading Started by CarlTrading, 05-11-2026, 05:56 AM	0 responses 238 views 0 likes	Last Post by CarlTrading 05-11-2026, 05:56 AM

Announcement