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)

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

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))))