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?

Ben Miller
  • 116,785
  • 31
  • 330
  • 429
Aklank Jain
  • 159
  • 1
  • 1
  • 2

2 Answers2

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.

Ben Miller
  • 116,785
  • 31
  • 330
  • 429
user107993
  • 61
  • 1
  • 2
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.

D Stanley
  • 145,656
  • 20
  • 333
  • 404