GuruFocus Excel Add-In
GuruFocus Excel Add-in allows users to download and retrieve historical stock financial data, guru portfolio data, economic indicator data and industry overview data using a fully-customizable add-in platform. The add-in provides up to 30 years of historical data on over 90,000 stocks from around the globe, over 8,000 institutional investors and more than 4,600 economic indicators.
* Compatible with Office 365 (Windows, Mac and web) or Windows Office 2021+. If you are using earlier version of Office, please use old version of GuruFocus Excel Add-in
Fully customizable research on Excel
GURUF function: Retrieve Historical Stock Financial Data
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.
=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.
GURUG Function: Retrieve Guru Portfolio Data
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:
=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.
GURUE: Retrieve Economic Indicator Data
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.
=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.
GURUI: Industry Overview / Median Data
The GURUI function allows you to retrieve data on the industry-median figures for a specific industry group.
=GURUI(“USA”,”Technology Overall”,”PE Ratio”) gives the current industry median price-earnings ratio for U.S. technology stocks.
=GURUI("USA", "Retail - Cyclical", "Operating Margin %", "2019:") gives the industry-median operating margin for U.S. cyclical retail companies for each quarter since 2019.
See how GuruFocus Excel Add-in can help you invest from start to finish
View income statement and cash flow statement data across several fiscal-year quarters. The template also reports a six-year growth rate.
Key Fundamental Data Summary
View key fundamental data for a stock, including GF Score, Financial Strength, Profitability, GF Value, Growth and Momentum metrics.
Fair Value Calculator Template
Calculate a stock’s fair value using a two-stage valuation model based on discounted free cash flow or earnings.
User Portfolio Template
Track gains and key statistics for stocks in your portfolio.
Peter Lynch Chart Template
View a stock’s price line compared to valuation bands based on earnings, book value and sales.
Historical Charts Template
Visualize a company’s fundamentals using a wide range of historical charts. The data includes earnings, free cash flow, equity and liquidity metrics.
Tutorials and Manuals
GuruFocus Excel Add-in Tutorial: Equity Screen And GURUF
Warren Buffet's Trades: Downloading To Excel Using GURUG
Frequently Asked Questions
Which version of Excel is supported by GuruFocus Excel Add-in?
The new Excel Add-in currently supports Office 365 and one-time purchase versions of Office 2021 and later. It supports Office on Windows, macOS and webpage.
What are the advantages of using GuruFocus Excel Add-in?
- It is fully customizable.
- You can pull data directly from GuruFocus databases and research stocks without leaving Excel.
- One click refreshes all data.
- Plenty of functions and templates have been built in GuruFocus' Excel Add-in, and they make your research more efficient.
- You can save your work and easily come back later to check your research for buying and selling a stock.
Do I need a Premium Membership to take the advantage of GuruFocus Excel Add-in?
Premium Plus and Premium Members can use this application. Premium Members have a data download limit. The data and valuation template that is available to download depends on the regions the users subscribed to.
How do I uninstall GuruFocus Excel Add-in?
Select "Insert" tab on Excel ribbon and click "My Add-ins". Select "GuruFocus Add-in" and click Option menu on the top right, then select "Remove".
What's the limit of GURUF usage?
Premium user has 2000 queries, premium plus user has unlimit usage， free user can not access Excel add-in also GURUF. Every user's usage will be reset at the first of every month.
How do you count queries?
Every call of formula will be counted as 1 query.
How to fix #NAME errors?
Clicking Reload Data button will fix most of #NAME? issues. If there are cell array keep displaying #NAME?, please click one cell of the array, then press CTRL + /, and then click the “Fix #NAME Array” button.