NSE ,BSE Live Data Feed into SQL DB

[4investor]

Dear Gurus

I have an assignment for writing strategy application for which it is necessary for me to get real time NSE & BSE Live Feed directly into My SQL DB , Can anybody guide me From where ans How can i get this ?

Also Please let em know If I have to pay to any agency for this ?

I urge all gurus to respond ASAP

Thanks in Anticipation

 

[tradermessage]

try contacting http://www.capitalmarket.com/

as far as i know they were providing the feed which could be saved in ms sql database.. they might have come up with the live realtime feeds aswell..
you also get company information from them.

 

[bunny]

RT feed are provided by authorized as well as non-authorized data vendors. Most of these provide the feed in binary format that is suitable to popular charting softwares like Amibroker, metastock, etc. If you can decode this binary and put it into MySQL db, you can do it.

My concerns are: Will your MySQL db be able to handle so much load? You will have to run INSERT and complex SELECT queries at every other moment.My personal experience is that it slows down and needs db maintenance as the volume of data grows. As an alternative to this, you can consider using inbuilt scanning functions of Amibroker. You can write custom strategies in Amibroker using AFL language - which is easy to understand and adapt.