Real Time data on Excel

blackhawk · 03-02-2012, 09:05 AM

Hi,

Is it possible to have real time data exported from NT to Excel?
I tried to place DDE indicator into an S&P 500 chart and get the data into excel with this formula: =ES|ES!Last but this solution is not working. The process is explained there: http://www.volumedigger.com/NinjaTra...rader_DDE.aspxI'm Using Excel 2007 and ZenFire real time demo data.

Than you for your help

NinjaTrader_RyanM · 03-02-2012, 09:18 AM

Hi blackhawk,

Unfortunately we do not provide support for this but you could check this thread for reference/help:
http://www.ninjatrader.com/support/f...407#post212407

blackhawk · 03-04-2012, 04:17 PM

Thank you for your help Ryan, but i cannot find anywhere interop.microsoft.office.interop.excel.dll. for office 2007. I also downloaded de microsoft Pia and installed it but this dll is not in my computer
Could you help me to find this library?
Thank you

Laserdan · 03-04-2012, 04:53 PM

in the post NinjaTrader_RyanM provided you there are links to the interops:

Download details: 2007 Microsoft Office System Update: Redistributable Primary Interop Assemblies

03-02-2012, 09:05 AM	#1
blackhawk Junior Member Join Date: Feb 2012 Posts: 9 Thanks: 0 Thanked 0 times in 0 posts	Real Time data on Excel Hi, Is it possible to have real time data exported from NT to Excel? I tried to place DDE indicator into an S&P 500 chart and get the data into excel with this formula: =ES\|ES!Last but this solution is not working. The process is explained there: http://www.volumedigger.com/NinjaTra...rader_DDE.aspxI'm Using Excel 2007 and ZenFire real time demo data. Than you for your help
	Facebook Twitter YouTube

03-02-2012, 09:18 AM	#2
NinjaTrader_RyanM NinjaTrader Customer Service Join Date: Sep 2009 Location: Denver, CO Posts: 8,117 Thanks: 249 Thanked 418 times in 415 posts	Hi blackhawk, Unfortunately we do not provide support for this but you could check this thread for reference/help: http://www.ninjatrader.com/support/f...407#post212407 Ryan M NinjaTrader Customer Service Use Kinetick, NinjaTrader’s preferred market data service - Learn More Free online training events - View Schedule
	Facebook Twitter YouTube

03-04-2012, 04:17 PM	#3
blackhawk Junior Member Join Date: Feb 2012 Posts: 9 Thanks: 0 Thanked 0 times in 0 posts	Thank you for your help Ryan, but i cannot find anywhere interop.microsoft.office.interop.excel.dll. for office 2007. I also downloaded de microsoft Pia and installed it but this dll is not in my computer Could you help me to find this library? Thank you
	Facebook Twitter YouTube

03-04-2012, 04:53 PM	#4
Laserdan Senior Member Join Date: Aug 2008 Location: North Carolina Posts: 157 Thanks: 6 Thanked 9 times in 5 posts	in the post NinjaTrader_RyanM provided you there are links to the interops: Download details: 2007 Microsoft Office System Update: Redistributable Primary Interop Assemblies
	Facebook Twitter YouTube

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

The following user says thank you to Laserdan for this post:
NinjaTrader_Bertrand

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Real time data feed from excel sheet	recshenoy	General Programming	1	08-27-2011 01:31 PM
Data Streaming Into Excel and connecting Ninja to Excel	cjgovi	Connecting	13	02-28-2011 10:21 AM
no real time time data by using zenfire	Adamthoery	Charting	2	10-05-2010 04:46 AM
real time DDE to and from excel?	Kablooie!	Automated Trading	2	12-31-2009 07:46 AM
Exporting Cum dom to excel real time	jsl12	SuperDOM and other Order Entry Windows	1	10-13-2008 09:33 AM