How to get a historical weekly and monthly high, low and close price in Google Sheet?
Google-sheets – Weekly high low and close price
google sheets
Related Topic
- Google-sheets – How to get 15 mins high low data from Google Finance
- Google-sheets – Google Sheets formula to find previous day high of a share price
- Google Sheets – Using GOOGLEFINANCE for High & Low with Timestamp
- Google-sheets – how to get max high of the given days excluding weekly off days
- GOOGLEFINANCE – Get High & Low and Timestamp in Google Sheets
- Google Sheets – Fetching Stock Price Highs and Lows
Best Answer
Google does not support monthly intervals.
For historical weekly information on high and low and close prices use the following formula:
(Replace your values accordingly)
Functions used: