Connect a sheet excel for trading automatic

[Miglio]

hello, I want to connect a simple sheet of excel with ninja trader, the trading system is completely external to ninja, the rows excel would want to have only 2 cells
1= buy
2= sell

you know if it is possible?
how I can make?

[NinjaTrader_Dierk]

You would try to drive the ATI functionality in NinjaTrader by e.g. the DLL interface: http://www.ninjatrader-support.com/HelpGuideV6/Functions2.html

[Miglio]

Hello excuse the delay, I explain you what quickly serves
I have a trading system constructed on excel & vba.

I have need that the SR executes the orders with these conditions:

cell a1 = 0 (flat)
cell a1 = 1 (buy)
cell a1 = -1 (sell)
for being just fine


cell a2= number contract for long trade
cell a3= number contract for short trade


All the rest I in the calculation sheets manage it.

Or I can send via vba the 3 commandos to the SR.

You can help me or this platform is not adapted to the application.

[Miglio]

here one example for my TS

[NinjaTrader_Dierk]

Unfortunately we are no Excel experts. NinjaScript consultants are available to help program your trading system in Excel. Additional information is located here - http://www.ninjatrader.com/webnew/partners_onlinetrading_NinjaScript.htm
ou might consider

[radusor23]

Hello, it is possible join on ninja Trader on Microsoft exel ? how I can make it ?

[NinjaTrader_Jason]

Hello radusor23,

Unfortunately I do not understand your inquiry, could you please clarify?

What do you like to accomplish as per NinjaTrader and Excel?

[radusor23]

Hello Jason,
It´s possible cooperate ninja trader with microsoft
exel 2007 for example through API or through any else system ....
Can I see these value - for example: open, low, hight, close,
various indicator value etc ..
there in exel ? How can I make it?

[NinjaTrader_Josh]

radusor23,

Please be more specific as to what your requirements are for using Excel? You can use Excel's Visual Basic functionality to trade to NinjaTrader through the COM interface. Please see here for some more information on this: http://www.ninjatrader-support.com/HelpGuideV6/helpguide.html?VB60Sample

[radusor23]

Hello Jason,

Ok... I attempt it.. thank you very much...

[chameleon123]

hello ninjas,

I have a similar question - I need to connect ninjatrader with excell. It should work like this: I move the cross hair over the chart, click on the given point (or push some key, it doesn't matter), and the date, time and price are automatically copied to given excell tables. I need it for speeding up my manual backtesting.

Is it possible to create such function? I am no programmer, so forget about C# or macros...

Thank you

[NinjaTrader_Josh]

chameleon123,

Unfortunately such would require advanced custom programming that is outside of what we can offer support for. If you want this professionally done you may want to consider one of these 3rd party NinjaScript Consultants here: http://www.ninjatrader.com/webnew/partners_onlinetrading_NinjaScript.htm

[nightriderx]

Will the COM interface allow me to access data from running indicators and strategies? Or is limited to the raw price/data feed? If so can you recommend a way to pull in indicator values into Excel?

[NinjaTrader_Jason]

Hello nightriderx,

Unfortunately the COM interface is not supported in NinjaTrader 7. It is only supported in NinjaTrader 6.5.

It is not supported to access indicator and strategy data. You can find a list of functions that can be used at the link below.
http://www.ninjatrader-support.com/HelpGuideV6/Functions3.html

In addition, please see the following forum thread for instructions to export data to Excel.
http://www.ninjatrader.com/support/forum/showthread.php?t=14807