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

Web Applications Asked on January 3, 2022

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.

knowing it that I am bit late but it may help someone else,

Try =googlefinance("NSE:IDEA","high",WORKDAY( TODAY(), -2 ))

• it will work for that specific date only, ie, previous day or previous day when market was opened, which ever is the case. Hope that google consider specific Stock Exchange Holiday list as well when using this particular formula though not checked that aspect.

where "NSE:IDEA" is the stock listed in NSE

Currently trying Google Finance in many possible ways as possible to get insights. If anyone wanting me to share more such formula to get specific data, please let me know and I will share. Hope you will share more and more specific formula examples to fetch specific market data based on more and more specific logical requirements to get insights on the market.

Answered by Sujith Ambraith on January 3, 2022

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

=INDEX( GoogleFinance( "NSE:"&A2 , "all" , TODAY()-2 ) , 2, 3) - Pre. High

=INDEX( GoogleFinance( "NSE:"&A2 , "all" , TODAY()-2 ) , 2, 4) - Pre. Low

=INDEX( GoogleFinance( "NSE:"&A2 , "all" , TODAY()-2 ) , 2, 6) - Pre. Volume

Answered by Vinod GM on January 3, 2022

=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.

Answered by dgnk on January 3, 2022

• use INDEX to filter it out like:

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

Answered by user0 on January 3, 2022

Related Questions

Google Sheets Alternate Row Color by Unique Sorted Values

1  Asked on December 15, 2021 by xzila

Google Sheets Filter Multi Column List With Another List Using A Function

2  Asked on December 15, 2021

How can I go back from YouTube TV to ‘normal’ Youtube

1  Asked on December 15, 2021 by user55949

How to stop Google from translating a language for good

3  Asked on December 11, 2021 by jaaq

A Google Sheets format that returns time durations in days, hours, and minutes

1  Asked on December 11, 2021 by matthew-daly

How to fit 15 minutes onto Google Calendar in single lines

2  Asked on December 8, 2021

Does Mailchimp notify for unsubscriptions?

1  Asked on December 8, 2021 by user54099

Inbox to Gmail transition. How to manage labels instead of bundles

1  Asked on December 8, 2021 by thegreatwhatsit

Why is @channel disabled in Slack threads?

2  Asked on December 8, 2021 by tgar

Remove upstream from forked repository on GitHub

2  Asked on December 6, 2021 by nathan-arthur

google sheets, making a dropdown list based on user input

1  Asked on December 6, 2021 by user230962

Change the country where Google account is managed

1  Asked on December 6, 2021

Google Sheets conditional formatting based on cell above it

2  Asked on December 6, 2021

How to open sheets to a specific tab based on days of the week?

1  Asked on December 5, 2021 by eduardo-castillo-visani

Search Twitter for Tweets Containing Polls

2  Asked on December 3, 2021 by elad-ratson

How can I delete a SINGLE article in pocket?

1  Asked on December 3, 2021 by jonny-bowden

How to search in the current slack channel?

2  Asked on December 3, 2021

How to search old versions of web pages, e.g., YouTube videos?

1  Asked on December 1, 2021 by lifeinthetrees

How to Add RTL Tables to a Google Document

1  Asked on December 1, 2021 by azriel-lider

Identifying all Shared Drive permissions of a user

1  Asked on December 1, 2021