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: 21858
#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
Strategy handing off to ATM successfully but ATM settings ignored. by halgo_boulder Started by halgo_boulder, Today, 08:44 AM	0 responses 1 view 0 likes	Last Post by halgo_boulder Today, 08:44 AM
Order flow + trade detector alerts? by drewski1980 Started by drewski1980, Today, 08:24 AM	0 responses 3 views 0 likes	Last Post by drewski1980 Today, 08:24 AM
Labeled Line & Rays...Why is this not standard? by rdtdale Started by rdtdale, Yesterday, 01:02 PM	2 responses 17 views 0 likes	Last Post by rdtdale Today, 07:54 AM
Unable to load custom assembly. Please Reinstall NinjaTrader by TradeSaber Started by TradeSaber, Today, 07:18 AM	0 responses 7 views 0 likes	Last Post by TradeSaber Today, 07:18 AM
QuantityUpDown changing Foreground color by PaulMohn Started by PaulMohn, Today, 05:00 AM	0 responses 10 views 0 likes	Last Post by PaulMohn Today, 05:00 AM

Announcement