Exporting to excel

[rocky9281]

Hello,

Is it possible to export the following 7 columns of Real time data into excel for 5 symbols simultaneously. And the version of NT to be used is 6.5 :
1. Trade time
2. Last Traded Price
3. Last Traded volume
4. Bid size
5. Bid rate
6. Ask size
7. Ask Rate

Please guide me how to do it.

[NinjaTrader_RyanM1]

Hi rocky9281,

Thanks for the post. This project is beyond what we could provide support for, but hopefully this information below could get you started. I would recommend using version 7 for this but you're welcome to try on 6.5.

Please see community member Dionysus post here for help creating NinjaTrader > Excel DDE link:

http://www.ninjatrader.com/support/forum/showthread.php?p=212407#post212407

The market analyzer columns are not editable indicators, so you will need some way to work with the script files outside of NinjaTrader, like visual studio or a text editor. You will find these files here:
Documents\NinjaTrader 7\bin\custom\market analyzer.

Good luck!

[alexstox]

Indicator value export

Hello. Please help to issue task - export value of indicator for several instruments to Excel. Or if it possible - on one window in NT7.
Example
<Instrument> <Indicator> <periods> <value>

[NinjaTrader_RyanM1]

alexstox,

You can look into this sample here for help using NinjaScript to write to a file.

http://www.ninjatrader.com/support/forum/showthread.php?t=3475

One of our members has also put together this nice guide on integrating NT with Excel:

http://www.ninjatrader.com/support/forum/showthread.php?p=212407#post212407

[alexstox]

And any ideas to output those info to NT window? Because it's hard for me to understand fro, that example how to add 5 futures names and indicator values for it.
<instrument> <open> <indicator value>

For example, can I add indicator value to MarketAnalyzer window?

Why MarketAnalyzer window has no data? Even historical with Kinetick EOD?

Or maybe there are some possibilities to plot in DataBox?

[NinjaTrader_RyanM1]

Market Analyzer is a real time quote sheet. You can use it to display indicator plots, and all the built in market analyzer columns. It is not designed for historical data.

You can send information to the output window with Print() commands. More information on this is available here:

http://www.ninjatrader.com/support/forum/showthread.php?t=3418

[Aloakdutt]

how to import excel rt data of indian market from Nest or odin to nt7 and backfill too...?

Request guidence from members...

[Aloakdutt]

but the link provided is dead ... for DDE

[NinjaTrader_Bertrand]

You refer to the link Ryan shared in post #4? This seems to be working alright for me here.

[schematics]

If you use Excel for trading and market data analysis - you might be interested in looking at another Excel tool - IB Excel Trader. It let's you trade directly from Excel, and you can build your own algorithm using formulas and VBA macros

http://www.tradinggeeks.net/downloads/interactive-brokers-excel-trader/

[OldGrantonian]

If you use Excel for trading and market data analysis - you might be interested in looking at another Excel tool - IB Excel Trader. It let's you trade directly from Excel, and you can build your own algorithm using formulas and VBA macros

http://www.tradinggeeks.net/download...-excel-trader/

I downloaded this program last Wednesday. I've been trying to get it to work ever since. I cannot get past the first "Compile error". I'm getting help from Interactive Brokers, ExcelForum, and stackOverflow. I haven't had a reply from TradingGeeks since Friday.

Are you actually using this program? If you are, I would be most grateful if you could answer a few questions.