web service for description & exchange

[GrumpyTrader]

When charting a stock that isn't in the database nt8 will add the instrument but leave the description blank and set the exchange to default. I want to write an addon that will let me look up stocks and add the affiliated information from the quote information from one of the data feeds.

Could you point me in the direction on how to do that?

[Calonious]

Couple of things you are going to need here.

First, a webservice to get the info based on the stock. Yahoo is open and free. There are others out there but a good google search will get ya started.

Second, Instruments are stored in SQL Compact Edition. Just make sure you got a reference for the correct dll to it and then do some studying on how to make queries to the NinjaTrader.sdf.

You should be able to get the relevant info from the database on which data objects don't have a description and then make your web call and get that info back and then do an update to the database for it.

NT doesn't support doing any database changes through code to the NinjaTrader.sdf so just keep that in mind when you start getting into this.