CODEWITHSUNDEEP
google-sheets
maxhugen
maxhugen

Reputation: 1944

GoogleFinance - Adjusted Stock Close Price

Is there a method to use GoogleFinance() in Google Sheets to get the Adjusted Close price, which adjusts for Splits and Dividends like Yahoo Finance?

Upvotes: 2

Views: 4857

Answers (2)

TVC
TVC

Reputation: 77

Googlefinance only returns close prices, not adj close. For example, PSA paid $2 dividend on Dec 13, 2022. Googlefinance returns closing price 301.42, not 299.42 after adjustment as shown on Yahoo! Finance.

One method is to calculate adj close from close, which is time-consuming.

2nd method: use python to download adj close with yfinance library

3rd method: excel->get data from web->paste link of the stock's historical prices from web, e.g. https://finance.yahoo.com/quote/AAPL/history/

It looks like the 3rd method is most convenient.

Upvotes: 0

JohnA
JohnA

Reputation: 1107

I believe the historical Price from Google Finance is adjusted

=GOOGLEFINANCE("GOOG", "Price", DATE(2021,6,16))

Matches the adjusted column in Yahoo Finance

enter image description here

enter image description here

Upvotes: 1

Related Questions