See how MarketXLS helps you take advantage in the markets.
Guru Screen Functions are used to filter out stocks based on the winning investment strategies of stock market legends such as Warren Buffet, Benjamin Graham, Robert Piotroski etc. They are a part of MarketXLS since its foundation has been laid down. These screens are of immense value to the customers and users of MarketXLS. These screens are naturally embedded with hundreds of years of acumen and experience in stock market. A company needs to meet specific predetermined criteria and certain parameters to be accepted on these screens. They aid in quick decision-making.
The software previously had separate templates for each guru screen. The users had to enter their various requirements. The analysis of stocks using these guru screens used to be a slightly lengthy procedure. However, in our latest update, we have mutated and simplified these screens. Each template has been converted into single ready-to-use function. This article will provide a brief description on these guru screen functions.
In this release, we have added many advanced Guru Screen functions. There are 17 new guru screen functions in this update.
Here is a list of Guru Screen functions MarketXLS is offering in this new release:
You might have noticed that all the functions start with the letter “gs”. The letters “gs” are the abbreviation of the words guru screen. The significance behind using these two words is that it helps the user in easy identification of functions. All the functions starting with “gs” fall under the category of guru screen functions.
These ready-to-use functions pull the data of all those stocks which match with the criteria of the respective screens. This facilitates in easy comparison of stocks. It also helps in easier identification of new good stocks. We will learn about this feature in the step-by-step procedure given in the following section of this blog.
In this article, we will be looking at one of the guru screen functions and how to use it in MarketXLS.
We will be taking the example of Zweig Screen to explain the steps of using these guru screen functions.
The strategy for Zweig Screen given by the investment advisor Martin Zweig is based on identifying companies with strong growth in earnings and sales. For a stock to meet the Zweig Screen check, it must meet many earnings-related criteria, which indicate potential earnings growth at a high rate in the long term. This means it should be consistent over several consecutive years, has accelerated in recent quarters, and is sustainable.
For more details visit: https://marketxls.com/zweig-screen-parameters-analysis/
Step-by-step procedure of using MarketXLS to perform analysis on stocks using guru screens
Step 1: Open a new excel workbook and enter the formula of the Zweig Screen function as shown in the image below. You can see, as you type “=gs”, a list of guru screen functions automatically appear in the built-in drop-down suggestion list of functions of excel. Thus, MarketXLS provides you with a wide range of options to select from to perform analysis on stocks.
Step 2: Enter the formula of Zweig Screen – “=gs_Zweig_Screen” or select the function of Zweig Screen from the drop-down list. Open and close the parenthesis without entering any values in between them. The software will automatically pull the values, criteria and parameters of the screen.
Step 3: The software pulls the data of all the stocks whose parameters match with the criteria of the screen. In this case, the software has pulled 18 stocks out of 15072 stocks. These 18 stocks match with the criteria set by the Zweig Screen.
How to find whether a particular stock falls under the criteria of the Guru Screen or not?
Step 4: This will help you to ascertain whether the stocks, which you are looking for, are accepted by the Zweig Screen or not. You can search for the stock ticker, which you are looking for, in the filter dropdown provided. If you find the ticker available in the dropdown, that particular stock is accepted by the screen. For example, in this case, we searched the ‘MSFT’ stock in the filter dropdown, and we found it. This means that the Zweig Screen accepts the Microsoft stock. You can apply the same procedure for other stocks and other screens.
(These functions should not be considered as an advertisement or advice, professional or otherwise. You are requested to consider all the risk factors, including your financial condition, suitability to risk-return profile, and other similar conditions. These functions do not account for any professional advice but are merely some guidelines to explain the concept.)
None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person. These templates should not be considered as an advertisement or advice, professional or otherwise. You are requested to consider all the risk factors, including your financial condition, suitability to risk-return profile, and other similar conditions. These templates do not account for any professional advice but are merely some guidelines to explain the concept. The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein.
The article is written to help users collect the required information from various sources deemed to be an authority in their content. The trademarks, if any, are the property of their owners, and no representations are made. All trademarks referenced are the property of their respective owners. Other trademarks and trade names may be used in this document to refer to either the entity claiming the marks and names or their products. MarketXLS disclaims any proprietary interest in trademarks and trade names other than its own or affiliation with the trademark owner.