0

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

enter image description here

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

1
1

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.

1
  • It is interesting that in this Google support answer it claims at the top that one of the things you can do with Google Finance is "See revenue trends and changes." But I agree, there doesn't seem to be a way to actually do it. – Ben Miller - Remember Monica Nov 6 '20 at 16:22
1

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.

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.