Helping You Develop The Wealth Creation Mindset Through Real Life Examples
How To Customize Your Workspace On Screener.in For Analyzing Stocks Like A Pro
How to customize your workspace on screener for analyzing stocks like a pro

How To Customize Your Workspace On Screener.in For Analyzing Stocks Like A Pro

#How to customize your workspace on screener.in for analyzing stocks like a pro

Have you ever wished that there was a tool which could make analyzing stocks so much easier.

I mean a platform which could show us important financial ratios, financial statements for past ten years, track changes in promoter holding, provide all updates related to the stock in one place and also send you updates through email.

Not only this but also give you the power to create your own queries to search stocks based on fundamental parameters.

A smart investor needs a process in place to help him discover new stocks and track any developments in the company. 

Folks. You need not look anywhere else. Screener.in is the tool of choice for analyzing/tracking stocks listed on Indian stock exchanges (NSE & BSE). It helps you as an investor to stay on top of your game.

The objective of this post and subsequent posts on screener.in is to help you in getting acquainted with this amazing website so as to enable you to use this tool like a PRO.

The step by step process that we will follow is that we will first customize your workspace on screener.in and in upcoming posts we will learn to analyze companies using our customized workspace.

So for this post let us begin and customize your workspace on screener.in for analyzing stocks.

First Things First: Create An Account On Screener

In case you do not have an account on screener then you can create one.

It is a very easy 2 step process where you enter your email id and a chosen password for screener followed by an email verification.

In case you are new to screener.in then I recommend you read the blog post I had shared earlier:

How to make a watchlist of stocks based on good quarterly results

As a part of the above post, I have shared a brief insight into screener, its features and also the process of creating an account on screener.

Once you have registered yourself on screener.in then the next step as part of the customization process is to type the name of a company in the text box as pointed out by the green arrow.

For our example I have chosen a stock named PI Industries as shown below.

search for a company name on screener.in

2. Getting Acquainted With The Layout

customize your workspace on screener for analyzing stocks by modifying important ratios layout

As you search for PI Industries in the search bar and select the stock, a layout as shown above is displayed.

Please note that layout displays the following:

2a. Name of the company

2b. A short description of what it does

2c. Eleven links to different sections of the web page related to PI Industries (like chart, analysis, peers, quarters and so on). I have highlighted them using different colours for your reference.

It is important to note here that each of these is a link to a specific section on the web page related to PI Industries.

So if you were to click on chart it will take you to the stock chart of PI Industries. A click on the balance sheet will display the balance sheet from March 2009 to 2020.

2d. A few financial terms like market cap, current stock price, book value, PE ratio, ROE etc.

3. Let Us Begin & Customize Your Workspace On Screener.in

From this point onwards the actual work begins.

What I mean by customization is that I want to add some financial parameters to the existing financial parameters like market cap, book value as discussed in point 2d above.

We will carefully select those financial ratios that are very important for analyzing a company. By adding the relevant ratios here we can quickly scan a company’s financial health.

A quick look at the snapshot below shows us the default financial parameters already provided by screener prior to customization.

default financial parameters provided by screener

Now we need to add more financial information to the default setup to enable us to quickly gauge the financial health of the company. Therefore we will be adding the following information:

Please note that I frequently use these parameters as part of my stock analysis. You are free to add more information that you think is necessary for analyzing stocks.

1. Debt to equity and Interest coverage

2. Average return on capital employed 5 years (ROCE 5 year average) & Average return on equity 5 years (ROE 5 years average)

3. Return on assets

5. OPM 5 year (operating margin 5 year average) and OPM (most recent operating profit margin)

6. Operating cash flow 10 years

7. Cash conversion cycle

8. Free cash flow 5 years, free cash flow preceding year

9. Average Debtor days 3 years

10. Unpledged promoter holding and pledged percentage

11. EVEBIDTA

12. Average Dividend payout 3 years

In case you need some help with understanding these ratios then please visit my earlier posts below:

5 Important profitability ratios which describes ROE/ROCE, Operating profit margin, Return on assets

2 critical financial ratios which talks about debt to equity, interest coverage and promoter pledging of shares

9 warning signs for investors to detect fraud – 8th point in this post talks about the importance of debtor days and operating cash flows/cash flow from operations.

4. How To Add Financial Parameters To The Default Financial Information

This step is actually pretty simple. All we need to do is type the financial parameter/ratio in the text box adjacent to “Add Ratio”. Please see the screenshot below.

add ratio feature as part of customize your workspace on screener for analyzing stocks

As you can see above there is a text box next to “Add Ratio” as highlighted by the blue arrow. In order to add our first ratio “debt to equity” simply type debt or debt to equity and screener will prompt you with suggestions.

We will select debt to equity and that is it. Just as you select this option it will be added to your default financial information as highlighted in the green box below.

debt to equity added via add ratio feature as part of customize your workspace on screener

We need to repeat this process for all other parameters listed in point 3 above and finally your layout will be customized as shown below.

layout after adding the desired financial parameters on screener

5. What If I Want To Delete or Edit Financial Parameters While Adding Ratios

Let us consider that while adding OPM 5 years, you added OPM 10 years instead and now want to rectify it. Here is how you can do it.

Just click on Edit ratios as pointed out by the green arrow in the snapshot below

 

edit ratios

Once we click on Edit ratios we get an option to remove any ratio we desire. So now all we need to do is to remove operating cash flow 10 years (highlighted in green blox).

For this you need to just click on the cross (as highlighted by the blue arrow) and then select on “Save Quick_Ratios”. This will remove operating cash flow 10 years from the display.

You can also delete multiple ratios at one go and even drag the ratios around in the order you like.

manage or edit ratios on screener

With this we have completed one major step in customizing your workspace on screener.in

6. Just One More Step Away From Customizing Your Workspace On Screener.in

There is one more place on the web page where we need to customize the financial ratios.

Screener gives a peer comparison for each stock you analyze with other companies in the same/similar industry.

Suppose you wish to see the peer comparison for PI Industries then either you can scroll down the page displaying financial information of PI Industries or click on “Peers” from the top of the page (underlined in blue line) as shown below

customizing workspace on screener important ratios layout

On doing so the peer comparison for PI Industries will be displayed as shown below.

We can see that PI Industries is being compared with other companies like UPL, Rallis India, Dhanuka Agritech etc.

The default financial parameters for comparison are current market price, PE ratio, Market cap etc.

defaut financial parameters for peer comparison on screener

Our objective is to make some changes to these default parameters so that we can compare PI Industries with other players in the industry more efficiently.

7. Customizing Peer Comparison Financial Ratios

I am going to share with you the financial parameters that I use to compare multiple companies but you are free to add ratios of your choice.

So here we go. We will be adding the following financial parameters to the peer comparison:

Please note that this list will not be as exhaustive as the one we used earlier as we don’t want to end up with too many ratios to look at in a single row. So I will be adding the most important ones.

1. Debt to equity and interest coverage ratio

2. Average Return on capital employed 5 years

3. OPM 5 year

4. Cash conversion cycle

5. Free cash flow 5 years

6. EVEBIDTA

In order to add the above you need to click on “Edit Columns” as shown in the screenshot below (pointed by the green arrow):

edit coloumns peer comaprison screener

Once you click edit columns you will see an option to “Filter Ratios” were you can type the above financial parameters and keep selecting them one by one.

Let us try to add Debt to equity ratio as a column.

adding debt to equity in peer comparison screener

First type debt to equity in the text box as highlighted by the green arrow. On typing debt or debt to equity screener prompts you with matching options.

Now we need to just select the checkbox adjacent to Debt to equity as highlighted by the yellow colored arrow. The moment checkbox is selected debt to equity is added as a new coloumn.

You also have the option to drag the ratios in the order that you wish for. Finally click on “Save Columns” blue colored button to finalize the changes.

Here is a snapshot of peer comparison once we have added all the necessary columns

customization peer comparison screener complete

With this our you have customized your workspace for analyzing stocks.

8. After Customization The Stage Is Now Set For Analyzing Stocks

With this you have learnt to customize your workspace on screener.in. We have successfully modified the financial information that we need for analyzing stocks.

Now the fun part of analyzing stocks using this very foundation will begin from my next post. So stay tuned Folks.

In my next post I will show you how to use this customized data along with other features provided by screener for a comprehensive stock analysis.

An analysis that can prevent you from investing in stocks of poor performing companies and identify good companies.

That’s all from my side friends. I hope you found the information useful. Please feel free to reach out to me in case you face any difficulty in customizing screener or for any other stock related query.

I will be happy to hear from you. Until then stay safe. Please don’t forget to share this post and do subscribe by clicking on the green button below.

Disclaimer: Stock mentioned in this post is only for tutorial purpose. Author does not recommend any stock. Please do your due diligence before investing

Subscribe Now. Keep Yourself Updated with the latest posts on investing, personal finance, wealth creation mindset, mindfulness and more from Introspecting Investor

Leave a Reply