=min(index(query(sort(GOOGLEFINANCE("NSE:SBIN","low",today()-100,100,"WEEKLY"),1,False),"select * limit 10",1),,2))

This is a formula for finding low of last 10 weeks as far as I understand can some one explain me this formula in detail?

  • Hi. Your description of the formula is pretty right. There are 5 nested functions: GOOGLEFINANCE, SORT, QUERY, INDEX, and MIN. Perhaps you would you let us know which of these you don't understand? NSE:SBIN - do you know what ticker symbol this represents? – Tedinoz Jul 18 at 8:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.