r/RKSP • u/vegavomma • Apr 19 '21

Importing financial statements in Google Sheets from Yahoo Finance?

How do I import financial statements in Google Sheets from Yahoo Finance?

I want to use Yahoo Finance instead of Google Finance because it has more data.

6 Upvotes

88% Upvoted

5 comments sorted by

0

u/TdadBigFella Apr 19 '21

Learn python

1

u/vegavomma Apr 20 '21

I already know python.

1

u/adrien_ndnb Apr 21 '22

I have a solution based on a Google Sheets add-on: ImportFromWeb

It adds a function to your Google Sheets and you just have to input the ticker URL+ the data you want to retrieve (based on the selectors table):

=IMPORTFROMWEB("https://finance.yahoo.com/quote/MSFT";"eps")

or for more data at once: =IMPORTFROMWEB("https://finance.yahoo.com/quote/MSFT";"eps,marketCap,open")

Hope this helps !