How to Download selected stock daily closing price in excel from Zerodha or other source?
You can get the daily OHLC from the Bhav Copy
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.
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?
Can this be done with macros?
Can you please suggest macros?