Fully customizable investing research and analysis tools
Listing updated:January 25, 2024
Works with:
GuruFocus Add-on for Google Sheets provides a fully-customizable investing research and analysis add-on that allows users to pull up to 30 years of historical financial data on over 90,000 stocks from regions around the globe.

Users can also access several pre-built templates that output fundamental data and a wide range of metrics measuring financial strength, profitability, valuation, growth and momentum.

Download the templates below:

Powerful GURUF function

The GURUF function works with common Google Sheets functions like SUM, AVERAGE and COUNT that allow for deeper analysis on the data. One click refreshes the data, allowing users to retrieve GuruFocus data without leaving the Google Sheets.


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

Stock Summary Template

GuruFocus Tools Stock Summary Template retrieves a snapshot of a company’s fundamental data, including the GF Score and its five ranking components: financial strength, profitability, growth, valuation and momentum.

30-year Historical Financials Data Template

GuruFocus Tools Historical Financial Data Template retrieves up to 30 years of historical per share data, ratios, income statement, balance sheet, cash flow statement, valuation ratios and quality metrics.

DCF Calculator Template

GuruFocus DCF Calculator Template gives a company’s intrinsic value based on a two-stage discount free cash flow or discount earnings model.

Invest, Investment, Investor, Stocks, Financials
Additional information
PricingFree of charge trial
Privacy policy
Terms of service
GuruFocus Add-on for Sheets will ask for the permissions shown below. Learn more
GuruFocus Add-on for Sheets will need access to your Google account
This will allow GuruFocus Add-on for Sheets to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Associate you with your personal info on Google
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Jason Herbst
October 31, 2022
$500 Annual Sub required.
Is this review helpful?
Profile Picture
Michael H
May 25, 2022
Not free, requires $500 subscription
Is this review helpful?
1-2 of 2
Clear search
Close search
Google apps
Main menu