GuruFocus Google Sheets Add-on

The GURUF function works with common Excel functions like SUM, AVERAGE and COUNT that allow for deeper analysis on financial data on over 90,000 stocks around the globe. One click refreshes the data, allowing users to retrieve stock financial data without leaving the Excel Add-in.

Examples:

=GURUF(“AAPL”,”Price”) gives Apple’s current price.
=GURUF(“AAPL”,”Revenue”,”-15”,”A”) gives Apple’s revenue over the past 15 years.
=GURUF(“AAPL”,”Net Income”,”2021”,”Q”) gives Apple’s net income for each quarter in 2021.
=GURUF(“AAPL”,”Total Assets”,”2010:2020”,”A”) gives Apple’s total assets for each year from 2010 to 2020.
=GURUF(“AAPL”,”Per Share Data”,”-30”,”A”) gives the entire per share data table for Apple over the past 30 years.

The GURUG function retrieves trades and portfolio data on more than 8,000 financial institutions and over 15,000 mutual funds directly into Excel, allowing for further analysis on a guru’s trade history. One click refreshes the data, allowing users to retrieve guru portfolio data without leaving the Excel Add-in.

-> Guru Portfolio Data:
A snapshot of a guru’s 13F portfolio holdings at a specific portfolio filing date

-> Guru Trade Data: View a guru’s trade history as of a specified starting date:

Examples:

=GURUG(“Warren Buffett”,”Portfolio”) gives Warren Buffett’s most-recent 13F equity portfolio.
=GURUG(“Warren Buffett”,”Buy”,”2021-03-31”) gives Warren Buffett’s new buys since the March 2021 quarter.

The GURUE function allows you to retrieve data on over 4,600 economic indicators like price indexes, commodity prices, foreign exchange rates, gross domestic product and market valuation indicators.

Examples:

=GURUE(“10-Year Treasury Constant Maturity Rate”) gives the current 10-year Treasury constant maturity rate.
=GURUE(“S&P 500 Index”,”2019:”) gives the S&P 500 index prices since 2019.
=GURUE(“WTI Crude Oil”,”2019:2021”) gives the WTI Crude Oil prices from 2019 to 2021.