5

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?

Improve this question
1

2 Answers 2

Reset to default
6

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.

Improve this answer
1
  • +1. That is a neat hack. It will work until Google Finance redesigns their quote pages.
    – Ben Miller
    Commented Mar 26, 2021 at 20:24
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.

Improve this answer
1
  • 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
    Commented Nov 6, 2020 at 16:22

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .