Anyplace to fetch data of previous day ohlc data of Nifty 50

Hi,
I am trying to fetch data from excel the previous day High, Low, Closing prices for an intraday Pivot System, I am able to get the current market prices, is there any way apart from downloading the bhavcopy where I can get the ohlc prices of the previous day in excel itself so I can automate it?

Thanks in advance!