Google-sheets – Google sheet formula for previous 7 day high

This is the job for query function:

=query(A:B, "select todate(A), max(B), min(B) where A is not null group by todate(A) order by todate(A) asc label todate(A) 'Date', max(B) 'High', min(B) 'Low'", 1)

Here is the query string with line breaks for readability: it's mostly self-descriptive.

select todate(A), max(B), min(B) 
where A is not null 
group by todate(A) 
order by todate(A) asc 
label todate(A) 'Date', max(B) 'High', min(B) 'Low'

The "todate" command converts a date-time sheet object to a query date object.

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.