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

Question

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?

Answer 1

You may try:

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