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?


2 Answers 2


Use this formula in Google Sheets:


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

  • +1. That is a neat hack. It will work until Google Finance redesigns their quote pages.
    – Ben Miller
    Mar 26, 2021 at 20:24

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
    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 .