Spreadsheet integrations?

[kiu827]

Is there any way I can stream real-time data from Ninja Trader to either Excel or Google Sheets? I have done some research and it looks like NinjaTrader does not support this natively. I have looked at many add-on for both Excel and Google Sheets like this lists of stock price in Excel, Market XLS, Market Stock View, Stock Price in Google Sheets, etc... but none of them have the capability to connect to a 3rd party data provider like Ninja Trader. Really appreciate any help, thanks

[NinjaTrader_Emily]

Hello kiu827,

Thank you for your post.

First, I would like to clarify that NinjaTrader is not a market data provider. Data is provided by our connectivity providers that can be connected to NinjaTrader to view live and/or historical data. There is an indicator available that writes historical bar and indicator data to a CSV file that could be imported to a spreadsheet, although this does not stream real-time continuously.


This indicator is publicly available on our NinjaTrader Ecosystem website:

• https://ninjatraderecosystem.com/use...ad/charttocsv/

Otherwise, if you would like to stream real-time data into a .txt file this would be possible using StreamWriter. We have a reference sample of an indicator that writes data to a text file that can be imported into Excel if you need to create a spreadsheet from the data. The sample may be found here:

https://ninjatrader.com/support/forum/forum/ninjascript-educational-resources/reference-samples/3581-indicator-using-streamwriter-to-write-to-a-text-file#post3581

Please let me know if I can be of further assistance.

The NinjaTrader Ecosystem website is for educational and informational purposes only and should not be considered a solicitation to buy or sell a futures contract or make any other type of investment decision. The add-ons listed on this website are not to be considered a recommendation and it is the reader's responsibility to evaluate any product, service, or company. NinjaTrader Ecosystem LLC is not responsible for the accuracy or content of any product, service or company linked to on this website.