@stuti_agarwal I have had the same problem several times. Update column by column (stock by stock) and then when the price has been pulled, copy / paste Special (values only) in the same place so that Network is not strained. Leave the last line alone as a formula so that you can extend it later.
If you working on this sheet, clearly you can copy the numbers on my sheet.
If you are working on a different set of stocks, another way would be to download historical data from NSE and then copy paste against the appropriate date. This is very tedious as you have to download csv data, Open in XL or Google Sheet and then copy paste appropriately.
Subscribe To Our Free Newsletter |