RT data to excel

bandlab2

Well-Known Member
#1
i need realtime data in an excel. i just need ltp, hi, lo. thats all . but i need this every 1 second and i need only for NSE Nifty stocks. i dont have metastock or any other s/w, i have my custom s/w which reads data from excel.

is there a povider for this? yahoo gives me 15 min late and NSE gives data refeshe every 1 min but i need every 1 sec or tick by tick. i searched the forum, didnt find any solution

appreciate any help on this
 

Sunil

Well-Known Member
#4
Bala,
I have been playing with SK's TT for sometime now...

For my own NR system on EOD basis, where I need 20 stocks' OHLC values after 3:30, I save the market-watch window of TT (which has the same 20 stocks) in csv format, and from there, it is very easy to copy/paste or to convert in excel format, for our personal R&D.

Since I know why you need this RT data to excel, you can ask Uthuman (he has SK's TT) to save this market-watch window with your list of stocks in csv format (and then to excel format) every 15mins (or whatever time duration u want).
Infact, you can link the data from your S/W to this mkt-watch excel, and simply keep saving mkt-watch every 5mins

I know it sounds cumbersome for live 2652 with a bunch of stocks, but this is as close & accurate I could source RT data better than yahoo.
 
Last edited:

bandlab2

Well-Known Member
#5
thanks sunil for the reply. i can do same thing with TTAdvance, save the market watch to excel every N minutes. its not only cumbursome but not serve my objective, i do need RT data every 1 sec or max 5 sec.

any paid service would be fine too
 

Similar threads