Intraday Options data from nseindia.com to EXCELL

Hello all friends,

I looking for a soft ware or macros which can get the Options data automatically update on intraday basic to the microsoft excel. I has to do calcualations in the excel from the price of the options from the nseindia webside and then use that that result in to the amibroker software for chartings.

I has try the webquery download in the excel but that data is not remain there and after the refresh the new data appere in that cell, so I can not make a database in the excel for using it in the amibroker software for charting.

So I want help from the expert in the excel or macros programing for my problems.

Thank you and best of luck.

Yes, I had same problem with excel, I could not store data in excel, it refreshes, but based on that i had created some charts like IO, change in OI, change in OI %, PCR like that.

now i am building a website on my own, as of now i have completed loading the data from NSE website and storing in data base for every 2 mins during market hours.

so i have to build various charts based on that data for intraday.

-Gopi