Hello Viswa
I’m not sure if you’re using the most efficient way to source the raw data for each stock. Following formula gives you the raw price data for last 365 days
=query(sort(googlefinance(“NSE:”& A2,“price”,today()-365,today()),1,0),“select Col2”)
Replace A2 with any stock you want
You can change the no. of day from 365 to any number you want
Hope this helps
Praveen
| Subscribe To Our Free Newsletter |
