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)

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

Is there a way to do this?

Something like this =let(x,googlefinance("NSE:RELIANCE", "close", Today()-182,182),filter(x,choosecols(x,2)=min(choosecols(x,2)))) — user11222393, Aug 17 '23 at 07:07

score 0 · Accepted Answer · answered Aug 17 '23 at 07:08

0

You may try:

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

answered Aug 17 '23 at 07:08

rockinfreakshow

But is the last 6 month presented in 180 days or some other number, as the trading day are different than the Annual calendar days – Wrathyimp Aug 17 '23 at 07:12
And how to remove the time stamp? Just the date only – Wrathyimp Aug 17 '23 at 07:13
Sorry I dont get your first question. coming to second one, easy way is to select the timestamp cell & use `Format`>`Number`>`Date` – rockinfreakshow Aug 17 '23 at 07:16

1 Answers1