Hi Experts,
Can someone help me get the previous day closing PE and PB data in google sheets. I have tried using the IMPORTXML (“URL”, “XPATH”) command but it doesn’t work: =IMPORTXML(“https://www1.nseindia.com/products/content/equities/indices/historical_pepb.htm?fromDate=01-01-2014&toDate=01-10-2014","//*[@id=“replacetext”]/table/tbody[1]/tr[3]/th[2]”)
Any help will be really appreciated.
Regards,
Abhishek