1. How to use GuruFocus - Tutorials
  2. What Is in the GuruFocus Premium Membership?
  3. A DIY Guide on How to Invest Using Guru Strategies
Articles (1332) 

PremiumPLUS (P+) Membership Announcement: GuruFocus

April 27, 2015

Over the years we have gotten a lot of requests from our subscribers to add different investors to our List of Gurus. Our users also want to apply the GuruFocus Premium Platform to the investors that are not tracked on GuruFocus. The demand has been strong and we certainly cannot add all of them. We don’t want to disappoint our subscribers and would love to make our platform available to them so that they can follow their favorite investors and generate profitable ideas. This has pushed us to develop our Premium PLUS (P+) membership.

Manual of Stocks

Warren Buffett (TradesPortfolio) said in a BusinessWeek Interview in 1999: “I think I could make you 50% a year on $1 million. No, I know I could. I guarantee that.

Then he said in 2005: Yes, I would still say the same thing today. In fact, we are still earning those types of returns on some of our smaller investments. The best decade was the 1950s; I was earning 50% plus returns with small amounts of capital. I could do the same thing today with smaller amounts.

In order to help our subscribers find the companies that are “way off the map,” GuruFocus developed the Manual of Stocks, which aims to cover every stock traded worldwide. Currently it covers all of the 78,000+ stocks.

GuruFocus' Manual of Stocks covers each company in one page. It consists of all of the key valuation parameters, financial indicators such as profitability and financial strength, dividends, and the last 10 years of financial data. You can download a Free Sample here.


You can now backtesting your investing strategies with GuruFocus PremiumPlus membership. The backtesting data is available starting 2006. 

  1. Under the “Backtesting” tab, you can set up your backtesting parameters:
    1. The year you want to start the backtesting (up to 3 years for Premium Members and 10 years for PremiumPlus Members.)
    2. The frequency you want to rebalance the portfolio (quarterly, semi-annually, and annually)
    3. How you want to rank the list with, only the filters you selected are available for the ranking
    4. In which order to rank the list
    5. Up to how many stocks you want to have in the testing portfolio
  2. The results of the backtesting will be displayed after the calculation is finished. You can see the annual and overall performances of strategy from the “Performance” tab. You can also check out the historical holdings from the “Results” tab.

Excel User-Defined Functions

We are very pleased to announce that we have released GuruFocus Excel User-Defined Functions. This function is called GURUF. GURUF works just like existing Excel functions such as SUM, COUNT, etc., but is much more powerful. With GURUF you can call and get all the historical financial data and key statistics data of more than 70,000 stocks that are traded on the world markets.

With GURUF function, you will be able to create your proprietary methods of looking at ownership and financial information via spreadsheets. Updating the spreadsheets is just one mouse click.

If you have not done so, please come to GuruFocus Excel Add-in page to download GuruFocus Excel Add-in. After that, please follow these steps to activate GURUF:

  1. Open Excel and log in to GuruFocus Excel Add-In. There will be a new tab with a button that says "Insert Guru Functions." Please see the screenshot below:

gurufocus tab

  1. Click on the button. It will download the new Excel User-Defined Functions from GuruFocus’ website. Then click "OK" to install. Please click "OK" for all test steps.
  2. Close Excel. When you restart, the functions should be ready.
  3. Click on "Login" again to log in your account.
  4. Type in any cell "=GURUF("AAPL","price")" and you should get the current price for AAPL stock.

Track All 13F Filers

Our Premium PLUS (P+) membership tracks the trades and portfolios of all the institutional investors that file 13F and 13D/13G forms. There are 4000+ of them and you can check out the list here. At the Premium Plus level all of the GuruFocus tools can be applied to the portfolios of the 4000+ investors. Subscribers can now build their Personalized List of Gurus out of a much bigger universe of investors, follow their trades and portfolios on GuruFocus or through email alerts, and combine their portfolios with other GuruFocus tools to generate the most profitable ideas.

These are some of the features:

  1. Trades, portfolios and trading history
  2. Consensus picks
  3. Bargains
  4. Activist actions
  5. Combinations with other GuruFocus fundamental screeners
  6. Email alerts, etc.

You can add any of them into your Personalized List of Gurus. You can also filter by their assets under management, portfolio turnover and portfolio concentration.

Excel Add-In

An Excel Add-In has been made available to subscribers to do fully customized research. All GuruFocus data can be downloaded to Excel through the Add-In. Research templates are built into the Add-In, and users can create fully customized calculations and charting tools based on the templates we provide.

This makes it very easy to check out the aggregated portfolios of multiple investors. It is ideal for investors who love to do research. It will be very convenient for family office operations and funds of funds to track the aggregated portfolios of a group of hedge funds and mutual funds.

Users can also put their own portfolios in the Add-In, and the results can be saved. One click on the “refresh” button will get the latest data from GuruFocus, and your calculations and charts will be updated with the latest data. You can check it out here.


We have also developed an API which allows you to dynamically pull data from our website. This will make it possible for you to combine GuruFocus data with your models.

You can check it out here.


These are some of the features that come with Premium PLUS membership, in addition to the Premium features. To compare Premium PLUS vs. Premium, please click here.

If you are not a subscriber yet, you are invited to take a 7-day FREE Trial. If you are not satisfied and cancel within 30 days of the subscription, you will get a full refund.

Rating: 4.4/5 (8 votes)



Iasilver premium member - 3 years ago

The excel add-in should be made available to Premium members.

Newyorkpapi premium member - 3 years ago

The whole thing should be for premium members

Cluther974 - 3 years ago    Report SPAM

The excel add in should be made available to premium subscribers

Gurufocus premium member - 3 years ago

Cluther974 , Premium Member can use Excel add-in now.

Gurufocus premium member - 3 years ago

Excel Add-In and API are now available to all Premium Members, too.

Kkgajrani premium member - 1 year ago

Is this supported with latest version of Excel i.e. 2016 ?

Gurufocus premium member - 1 year ago

it works on all versions of Excel. but works best on 2016.

Please leave your comment:

Performances of the stocks mentioned by GuruFocus

User Generated Screeners

DBrizanall 2018dec16 1023p
alexvemailapprox R2k by mkt cap
pbarker46REITs, Canada
kislevamnonlooks goos
kislevamnontoo much
kislevamnonbad p to b & p to s
jtepper2High margin businesses
Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to $400 per referral. ( Learn More)

GF Chat