bell notificationshomepageloginNewPostedit profiledmBox

Hoots : Get Revenue Details in Google Sheets using Google Finance 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", - freshhoot.com

10% popularity   0 Reactions

Get Revenue Details in Google Sheets using Google Finance
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?


Load Full (1)

Login to follow hoots

1 Comments

Sorted by latest first Latest Oldest Best

10% popularity   0 Reactions

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.


Back to top Use Dark theme