Excel Sheet - Options

#1
Hi All,

I am search an excel sheet that can pull up options data from nseindia.com

Please advise if such an excel sheet be formed that can pull such data automatically or at a single click.

I want to include Nifty and all stocks having options.

Screenshot Example:

Thanks mates.....
 
Last edited:

manishchan

Well-Known Member
#2
Hi All,

I am search an excel sheet that can pull up options data from nseindia.com

Please advise if such an excel sheet be formed that can pull such data automatically or at a single click.

I want to include Nifty and all stocks having options.

Screenshot Example:

Thanks mates.....
You can download FnO bhavcopy everday from NSE website..
 

manishchan

Well-Known Member
#4
---------------

That doesn't solve the purpose. I want only selected ones.
I dnt knw wht exactlu u want. Bhavcopy gives u list of all.. just select wht u need. In d first post u say u want for nifty nd all stocks.. so all will have about 10 calls nd 10 puts mij.. which means about 20*50 for just NIFTY 50. There are 140 scritps in options.. each having 10+ puts nd calls strike..

Post in details wht exactly u r looking for..
 
#5
I dnt knw wht exactlu u want. Bhavcopy gives u list of all.. just select wht u need. In d first post u say u want for nifty nd all stocks.. so all will have about 10 calls nd 10 puts mij.. which means about 20*50 for just NIFTY 50. There are 140 scritps in options.. each having 10+ puts nd calls strike..

Post in details wht exactly u r looking for..
---------------------

Only the details of the symbols I enter in the sheet. Eg. SBIN Strike Price 2700 for current month.

pls share the link of bhav copy where I can get the historical data for call/put of stocks.

many thanks - aman
 

Similar threads