=INDEX(GOOGLEFINANCE(“NSE:”&C$4,“price”,$B7-1), ROWS(GOOGLEFINANCE(“NSE:”&C$4,“price”,$B7-1)), 2)
This was the formula suggested by @Anand_Jain. After a bit of struggle it is working for me. Please note that C$4 refers to the cell where the stock name is written. $B7 in this formula is the place where the date is written. Please make the correct reference.
For some reason copying did not work. I entered the formula and then it started to.
| Subscribe To Our Free Newsletter |
