Google Sheets formula to find previous day high of a share price

Posted on

Whether you’re just starting out with Google Sheets or are a seasoned pro, sooner or later one of your formulas will give you a formula parse error message rather than the result you want. However, every Formula user, irrespective of whether it’s a beginner or expert, has invariably come across a formula parse error in Google Sheets at least once in their life (and if you haven’t. you soon will). It can be frustrating, especially if it’s a longer formula where the formula parse error may not be obvious. In this article, we will talk about some common formula parse errors in Google Sheets, like Google Sheets formula to find previous day high of a share price, and how to fix it.

Need previous day high/low price of a share.
This formula gives answer

=googlefinance("nse:"&columno.,"high",today()-2.1)

This gives an answer with date and time in separate columns.
But I need only the value of a particular share price.
Will anyone help me out.

Answer :

I think this will help you

=INDEX( IF(ISNA(GOOGLEFINANCE("NSE:"&A2,"high",TODAY()-1))=TRUE, IF(ISNA(GOOGLEFINANCE("NSE:"&A2,"high",TODAY()-2))=TRUE, GOOGLEFINANCE("NSE:"&A2,"high",TODAY()-3),GOOGLEFINANCE("NSE:"&A2,"high",TODAY()-2)),GOOGLEFINANCE("NSE:"&A2,"high",TODAY()-1)),2,2)

This will fetch the previous day market high.

  • use INDEX to filter it out like:

    =INDEX(GOOGLEFINANCE("nse:"&O18, "high", TODAY()-2.1), 2, 2)

    0

=INDEX( GoogleFinance( “NSE:”&A2 , “all” , TODAY()-2 ) , 2, 2) – Pre. Open

Leave a Reply

Your email address will not be published. Required fields are marked *