Requesting Tick Data via Excel VB
Hello 
Basically I want to do my charting and price analysis in excel instead (but keep placing orders manually via NinjaTrader, so no need for any automated order placing). I want to establish a connection between NT and Excel that would allow me to have price data flowing from the NT to the Excel. (and that's it)
I've done some research and became aware of the COM Interface with Visual Basic, and before I spend sometime studying it, I would like to first know if it's possible to use it to:
1) Request some historical tick data (e.g. of the 3 previous days), from NT to excel
2) Continue to add new ticks in real time, from NT to excel
quite similarly to what a normal chart within NT does (i.e. request historical data and keep updating it in real time).
So can this be done? and if not, is there another way to do it (other than the COM interface)?
Basically I want to do my charting and price analysis in excel instead (but keep placing orders manually via NinjaTrader, so no need for any automated order placing). I want to establish a connection between NT and Excel that would allow me to have price data flowing from the NT to the Excel. (and that's it)
I've done some research and became aware of the COM Interface with Visual Basic, and before I spend sometime studying it, I would like to first know if it's possible to use it to:
1) Request some historical tick data (e.g. of the 3 previous days), from NT to excel
2) Continue to add new ticks in real time, from NT to excel
quite similarly to what a normal chart within NT does (i.e. request historical data and keep updating it in real time).
So can this be done? and if not, is there another way to do it (other than the COM interface)?
Comment