Search code examples
google-sheetsgoogle-finance

How to get Lowest price of Stock in Google Finance for the past 6 months

I want to use Google Sheets to find the lowest price a stock has reached in the last 6 months.

I have tried various formulas:

=googlefinance("NSE:RELIANCE", "close", Today()-365,125)

  • it shows full previous year data with date columns.

=MIN(INDEX(GOOGLEFINANCE("NSE:RELIANCE","price",DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())), TODAY()),0,2))

  • it shows only price column no dates

Is there a way to do this?

Solution

  • You may try:

    =let(Σ,googlefinance("NSE:RELIANCE","price",today()-180,today()),
     filter(Σ,index(Σ,,2)=min(index(Σ,,2))))