Excel to Ninjatrader DDE Data feed

August 11th, 2018, 05:25 PM

Hi, my share terminal has RTD to excel connection. & I made a DDE data feeding connection with that excel to Multichart.

But is it possible to do the same kind of data feed from my Excel sheet to Ninjatrader? If anyone please share the code for the dll making which will create an external connection for Ninjatrader, I'll be really thankful to you.

Here is my excel file, from where I would like to send data to Ninjatrader.
xxx.dropbox.com/s/ps3a7wntpm25xsg/PiRtd%202.xlsm?dl=0

[Not able to post the link, xxx stands for www]

Thank you.

August 12th, 2018, 03:46 AM

There are several catches to your question.

1. It is not possible (without a bit more heavy lifting) to have NT read multiple datastreams simultaneously, you are able to open two connections, but if only one of them will provide datafeed to NT. I know this because a long time ago i wanted to create an additional datafeed, only to find out that it was not possible (a way around that constraint is to have NT talk to one component, using one of the built-in data feeds, and externally make a kind of traffic agent that interacts with several datasources (including your excell source) making it look to NT as a single source)

2. Depending on what you want to do and where your data comes from, the extra pass through Excell may not be needed, can you share more on that ?

3. There is a DLL in NT that allows you to inject little amounts of data, the DLL has been discussed in other threads already and is mentioned in the NT help also

https://ninjatrader.com/support/helpGuides/nt7/?automated_trading_interface_at.htm

You may want to look at the following calls in the DLL

Code

int Ask(string instrument, double price, int size)

Sets the ask price and size for the specified instrument. A return value of 0 indicates success and -1 indicates an error.

 

int AskPlayback(string instrument, double price, int size, string timestamp)

Sets the ask price and size for the specified instrument for use when synchronizing NinjaTrader playback with an external application playback. A return value of 0 indicates success and -1 indicates an error. The timestamp parameter format is "yyyyMMddhhmmss".

 

int Bid(string instrument, double price, int size)

Sets the bid price and size for the specified instrument. A return value of 0 indicates success and -1 indicates an error.

 

int BidPlayback(string instrument, double price, int size, string timestamp)

Sets the bid price and size for the specified instrument for use when synchronizing NinjaTrader playback with an external application playback. A return value of 0 indicates success and -1 indicates an error. The timestamp parameter format is "yyyyMMddhhmmss".

August 12th, 2018, 07:04 AM

rleplae

There are several catches to your question.

1. It is not possible (without a bit more heavy lifting) to have NT read multiple datastreams simultaneously, you are able to open two connections, but if only one of them will provide datafeed to NT. I know this because a long time ago i wanted to create an additional datafeed, only to find out that it was not possible (a way around that constraint is to have NT talk to one component, using one of the built-in data feeds, and externally make a kind of traffic agent that interacts with several datasources (including your excell source) making it look to NT as a single source)

2. Depending on what you want to do and where your data comes from, the extra pass through Excell may not be needed, can you share more on that ?

3. There is a DLL in NT that allows you to inject little amounts of data, the DLL has been discussed in other threads already and is mentioned in the NT help also

You may want to look at the following calls in the DLL

Code

int Ask(string instrument, double price, int size)

Sets the ask price and size for the specified instrument. A return value of 0 indicates success and -1 indicates an error.

 

int AskPlayback(string instrument, double price, int size, string timestamp)

Sets the ask price and size for the specified instrument for use when synchronizing NinjaTrader playback with an external application playback. A return value of 0 indicates success and -1 indicates an error. The timestamp parameter format is "yyyyMMddhhmmss".

 

int Bid(string instrument, double price, int size)

Sets the bid price and size for the specified instrument. A return value of 0 indicates success and -1 indicates an error.

 

int BidPlayback(string instrument, double price, int size, string timestamp)

Sets the bid price and size for the specified instrument for use when synchronizing NinjaTrader playback with an external application playback. A return value of 0 indicates success and -1 indicates an error. The timestamp parameter format is "yyyyMMddhhmmss".

I'm looking for only data feeding not the trading solution from NT. I have seen earlier that some people using dedicated dll extension application to data feed in NT. So, logically the idea is same, I just need the dll extension for my Excel sheet. Though DDE is old technology but still very much useful for many cases like mine.

August 12th, 2018, 10:53 AM

trader159

I'm looking for only data feeding not the trading solution from NT. I have seen earlier that some people using dedicated dll extension application to data feed in NT. So, logically the idea is same, I just need the dll extension for my Excel sheet. Though DDE is old technology but still very much useful for many cases like mine.

There is no DDE support in ninjatrader.

What I explained is to create a module outside Ninjatrader that does support DDE.
That module would then talk to you Excel.
On the other side the module would talk to Ninjatrader using the library i mentioned.

There are two other options in increasing degree of difficulty
1. make the same module talk to the TCP/IP port of the ATI (default 36973)
2. make a full connector (see my comment on only one connector working at a time for market feed)

Alternatively you can make a socket connection from your XLS sheet in visual basic
see this example, you would then talk to the ATI port

https://www.example-code.com/excel/socket_connect.asp

Hope this clarifies

August 12th, 2018, 01:49 PM

If anyone please help me to give the proper file for my mentioned excel file, which will do the work then it would be really helpful. because I still can't figure out how do I implement it.

Thank you.

August 12th, 2018, 01:51 PM

trader159

If anyone please help me to give the proper file for my mentioned excel file, which will do the work then it would be really helpful. because I still can't figure out how do I implement it.

Thank you.

Ready-made, i have not seen such a solution,
i was replying to a question in the 'ninjatrader programmming' section of the forum
means it needs to be developed, no click and clack solution available to my knowledge

I'm still not convinced that DDE or Excel is a must with regards to datafeed

December 19th, 2018, 10:52 AM

i have almost same problem

my brokers give API connection for data feed(web socket) as well as for placing order.
API .net dll already available as open source , link to excel already provided free of cost with user guide & videos.

i need bridge between API with NT.

so want to hire some programmer
i am ready to pay his cost

October 30th, 2019, 02:57 PM

rlygangesh

i have almost same problem

my brokers give API connection for data feed(web socket) as well as for placing order.
API .net dll already available as open source , link to excel already provided free of cost with user guide & videos.

i need bridge between API with NT.

so want to hire some programmer
i am ready to pay his cost

Even though this post is old, i would like to know if anyone has found the solution?

My broker too provide APIs for both data and trading. I have a very limited knowledge of programming. So I cant develop my own app. Also, I'm not a regular day trader now due to my job timings. I m mostly into swing trades based on EOD so never bothered much about RT feed in ninja.

Considering you are from India, you should contact Joydeep for the same. But since he developed his own Ninja (Arthachitra) , he is unlikely to help out with NT.

Regards,...

Excel to Ninjatrader DDE Data feed

Discussion in NinjaTrader

Excel to Ninjatrader DDE Data feed