Indicator Using Excel Data

[Avs29]

Hello!

I have an excel sheet with indicator values and corresponding timestamps. I'd like to be able to import the data so that I can overlay what I already have in my spreadsheet onto the ES chart. Is there a simple way to do this in NT8?

[NinjaTrader_ChrisL]

Hello, thanks for writing in. You will need to implement an indicator that can open up the excel file and match each date/value pair to the Time[] series supplied to the indicator. Unfortunately, this is not something directly supported by our NinjaScript library but it is possible since all it takes is C# code. I have a semi-related example here though it does the opposite of what you want to do:

https://ninjatraderecosystem.com/user-app-share-download/charttocsv/

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.

[Gerrtrudd]

I ran into something similar last month and ended up using Excel spreadsheet to web app to pull streaming values from Excel right into my custom indicator without reloading. Once I set up the link and mapped the cells correctly, the data updated live inside NinjaTrader. It's way easier than dealing with file read operations or timers in OnBarUpdate.