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 on screener.in is to help you in getting acquainted with this amazing website and customizing your workspace for stock analysis.

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 blue 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

understanding the layout on screener after entering a company name

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 (About and Key Points shown on the right hand side)

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 wish to add some financial parameters to the default 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 (market cap, current price etc as highlighted below)

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 years

5. OPM 5 year (operating margin 5 year average)

6. Operating cash flow 10 years

7. Cash conversion cycle

8. Free cash flow 5 years

9. Average Debtor days 3 years

10. Unpledged promoter holding, pledged percentage and change in promoter holding

11. Average Dividend payout 3 years

12. EVEBIDTA

In case you need some help with understanding the importance of 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 below “Add Ratio to table”. Please see the screenshot below.

debt to equity added via add ratio feature in screener

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. 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 through add ratio feature in 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 (as highlighted in snapshot below) and now want to rectify it. Here is how you can do it.

Just click on “Edit ratios” as pointed out by the blue arrow in the snapshot below

edit ratios

Once we click on “Edit ratios”, we get an option to remove any ratio we desire (as shown in the napshot below).

The following steps (also shown in the snapshot below) will help you replace OPM 10Year with OPM 5Year.

1. In step 1, we will remove OPM 10Year (highlighted in green box)

2. Here we type OPM in the textbox under “Filter Ratios”. Once we type OPM, screener displays all ratios relevant to OPM

3. Out of 8 ratios related to OPM, we select OPM 5Year

manage or edit ratios on screener

On completing steps 1 to 3, you need to select “Save Quick_Ratios”. This will save the changes we just made.

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

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 provides a peer comparison for each stock with other companies in the same/similar industry.

In order to view the peer comparison for PI Industries, you can either scroll down the page displaying financial information of PI Industries or click on “Peers” from the top of the page (as shown below)

select Peers to visit the Peer comparison section on Screener.in

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

default financial parameters for peer comparison on screener

We can see that PI Industries is being compared with other companies like UPL, Rallis India, Dhanuka Agritech etc. All these companies belong to the agrochemical sector.

The default financial parameters on which these companies are being compared are current market price, PE ratio, Market cap, Dividend Yield% etc.

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 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. Change in promoter holding

In order to add the above financial ratios, you need to click on “Edit Columns”, as shown in the screenshot below.

edit columns peer comparison 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 blue arrow in screenshot above). On typing debt or debt to equity screener prompts you with matching options.

Now select the checkbox adjacent to “Debt to equity”, as highlighted by the green colored arrow. The moment checkbox is selected, debt to equity is added as a new column.

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

We can now repeat this step for all financial ratios we require for peer comparison.

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. Benefit Of Adding Financial Ratios In Peer Comparison

The advantage of adding customized financial ratios to peer comparison is that it offers a quick way to compare the companies on their financial parameters.

customization peer comparison screener complete

For example, a quick glance at peer comparison above, helps me register the following important points as an investor:

1. Based on quarter profit var% (quarterly profit growth Year on Year basis), Sumitomo Chemicals seems to have reported a big jump in net profit (144410.53%). This makes me curious as an investor and I need to figure out the reason for this sharp increase.

PI Industries also reported a healthy 61.35% increase in net profit as compared to same quarter last year. Bharat Rasayan, Dhanuka Agritech and Meghmani Organics also have posted double digit profit growth.

As an investor, I give the most weightage to quarterly profit, sales variance and change in promoter holding. The reason being any fundamental improvement in the company will start reflecting in its financial results and the promoter will also start increasing his stake in the company

2. No significant change in promoter holding in any company was seen.

3. UPL is the weakest company based on lowest ROCE 5Yr of 18.27%. It also has poor Interest coverage ratio (3.09) and very high debt to equity ratio (1.7). It also reported flat sales and profit growth.

4. Meghmani Organics also seems to be weak on leverage parameters as compared to other companies. It has an interest coverage ratio of 7.15 and debt to equity of .5 but due to double digit sales and profit growth, I will still read about this company.

5. PI Industries, Sumitomo Chemicals, Bharat Rasayan and Dhanuka Agritech seem to be fare well on most financial parameters. Their ROCE 5Yr> 20%, debt to equity is less than .1,  interest coverage is far greater than UPL and Meghmani Organics.

In this way we can do a quick comparison of companies from the same sector and draw inferences. It has happened many times that I was analyzing a company and the peer comparison helped me in finding another good company.

8. Do Not Hesitate To Experiment With Your Workspace

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.

The financial parameters that I have used are based on my preferences. There may be other financial information that you may find useful. So please tweak the parameters and experiment with your workspace.

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