'How to get X-year low price of a stock with Google Finance using Google Sheets
I can currently get the 52-week low of a stock by using this call in Google Sheets.
=GOOGLEFINANCE("NYSE:UBER","low52")
How do I get the 3-year and 5-year low of a stock?
For a 3-year low I tried something like this:
=GOOGLEFINANCE("NYSE:UBER","price",TODAY(),=EDATE(TODAY(),-12*3))
However this returns a list of the past 20 prices, not a single value representing the lowest value over the past X-years.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
