Get Revenue Details in Google Sheets using Google Finance

Question

Recently I learned about GoogleFinance and it's feature to use Google Sheets to provide you with all stock market data using a formulae for eg.   =GOOGLEFINANCE("GOOG", "price", "1/1/2014", "12/31/2014", "DAILY")
I read the doc that I found, however, I was not able to find any info if I can get the revenue of a particular stock using the same feature as well.
There should be something since, Google shows me the data on its tab when I check

How can I get this info in google sheet as well?

D Stanley · Answer

The documentation for the GOOGLEFINANCE API lists the attributes that are available depending on the type of security you're querying. None of them give you any detail about revenue - the closest is EPS (Earnings Per Share) which is net earnings, not just revenue.
You'll need to find another API or another data vendor to get revenue details.

user107993 · Answer

Use this formula in Google Sheets:
=IMPORTXML("https://www.google.com/finance/quote/TSLA:NASDAQ","//table//tr[contains(@class,'roXhBd')]")

This will bring up a list of the company's financial performance.

Get Revenue Details in Google Sheets using Google Finance

2 Answers

Add your own answers!

Ask a Question