How to Download selected stock daily closing price in excel from Zerodha?

gss · January 3, 2018, 7:21pm

How to Download selected stock daily closing price in excel from Zerodha or other source?

Sanket · January 4, 2018, 8:40am

You can get the daily OHLC from the Bhav Copy
https://www.nseindia.com/products/content/equities/equities/archieve_eq.htm

gss · January 4, 2018, 10:37am

Thank you for reply. What I want is historical closing price of selected stocks (say nifty 100) on daily basis on single excel file added automatically based on formula. Yahoo finance was providing such data but they have stopped it now.

Srinivas · January 4, 2018, 11:23am

Yahoo finance still does have historical data.

Is this what you are looking for?

gss · January 4, 2018, 11:55am

It is available on site only. Can I fetch it in excel based on the formula entered in cell of excel sheet and excel is updated daily automatically?

Srinivas · January 4, 2018, 11:57am

Can this be done with macros?

gss · January 4, 2018, 12:10pm

Can you please suggest macros?