Screener provides complete flexibility to customize the result columns and even create our own financial ratios.

The financial ratios created are calculated on the fly for all the stocks and can be used in custom screens.

To create a custom ratio, go to create financial ratios page.

You will receive a ratio-creating form, similar to one used for creating custom screens.

**Unlike screen queries, we don’t use inequalities but provide a mathematical formula for our ratio.**

In above example we create a new custom ratio to calculate difference of current price of the stock from its 52-week low price.

Similarly we can create a ratio to calculate our own DCF Value ratios or any other valuation ratio.

**These custom ratios can be also used in creating custom screens.**

For any assistance in creating custom ratios, leave a comment below.

It would be nice if you could show the definition of a “user created financial ratio”. This will help understand whether the ratio was correctly created.

Maybe if we could add comments to these, it would further help us refine these ratios so that they are useful for everyone.

It would also be nice if you could support (=) operator in addition to the () operators.

This is a good idea. Will try to show the formulas for user ratios.

I couldn’t get your point for ‘=’ operator. It can be used in screens. Can you please give an example on how to use it in ratios. I will try to include it too.

Could you please tell me the formula used in “user created financial Ratio” Intrinsic Value. I would like to use it but am not sure how it has been calculated and if it would suit my purpose.

Hi Ravindra, it is a very old user created ratio and we won’t recommend using it. It has been carried forward from the old screener version and thus we haven’t been able to remove it. We will be doing so soon.

Thanks for pointing it out,

Pratyush

Hi,

I really liked the site and the ease with which the screens can be developed.

Please help me with a screen to identify companies reducing debt YOY (i.e. I am looking for comparison over previous year). The keywords here allow ‘Debt 3Years back > Debt to equity’.

‘Debt 1Years back > Debt to equity’ OR ‘Debt last year > Debt to equity’ is NOT allowed.

Hello Shiv, am glad that you liked the Screener.

You can compare preceding year debt using this:

`Debt preceding year > Debt`

Thanks for trying Screener.

Can you please help me to find EPS growth (CAGR) for last 5 years?

hi, can you please tell me the formula you use for calculating book value.

for eg. Sun pharma book value is given as Rs. 136.76. Can you pls show the formula using items from Balance sheet as to how you arrived at this number. Thank you. B

Hi, in screener we include the trailing quarterly profits for the calculation of current book value.

Thus in case of Sun Pharma, the net worth is:

Equity = 103.56

+ Res = 12062.79

+ Jun = 795.55

+ Sep = 319.64

+ Dec = 881.30

Total = 14162.84

Number of Eq. Shares = 103.56

Thus the book value taken = 14162.84 / 103.56 =136.76

[The above does not take the interim dividends into account as we don’t have that data currently. We will include that too soon.]

Hope that helps.

Do let me know if you still have some queries.

Thank you so much Pratyush! Yes you hit the bulls-eye with your answer! -B

suppose I want to use if then else type construct, or some sort of mathematical function like sign(Net Profit – Cash flow). Typically, these things to make a scoring model for multiple stocks, and sorting around it.

Hi Ashu, you can use IF clause using:

IF(condition, value if true, value if false)

[same as we do in excel].

Hope that helps.

I want to create screen for debt free company with high ROE

Try something like following:

Debt to equity 20%

Hi Pratyush, I could not find a variable for Payables or Sundry Creditors. Is there one or can I create a custom ratio for one?

Hello Nasir,

We don’t have the variable for payables and sundry creditors (it is not bifurcated and provided by the data source, though they provide the total of “Current liabilities”).

Dear Admin,

1) The PE ratio which is mentioned in the watch list page. Is it PE calculated using TTM EPS/last financial year EPS or One year forward PE ? Plz help

2) How to calculate one year forward PE? Since, expected quarterly profit number is already available. Do we also do forecasting on annual basis which can help to decide on valuation of 1 yr and 2 yr forward PE ratio?

Your reply will be really helpful and appreciated.

Regards,

Dhaval Shah

Mumbai

1. PE is trailing 12 months. But in the cases where the quarterly results are not available, the annual results are automatically picked up.

2. We created expected quarter based on statistical formulas. But it rarely gives a right dependable figure. We only use in the Pros/Cons analysis with a good margin of safety to just get a guess about what direction the results are expected by markets. I guess, using it for forward pe can be more harmful than useful.

Do let me know if you have any queries,

Pratyush

Ok. Thanks Pratyush.

Btw, the website is very useful and user friendly.

I would want to make few ratios, shall connect to you again for that.

Regards,

Sir pls suggest ratios by which can get companies like aban kittex page eicher mrf

Is it possible to use MIN/MAX (to take minimum/maximum of 2 values) function for creating new ratios?

Hi CoolKal,

Min/Max functions are not available. You can use the IF condition instead. Something like, IF(value1 > value2, value1, value2) , which is same as in Excel.

Hope that helps,

Pratyush

in a few seconds

Sir pls suggest ratios by which can get companies like aban kittex page eicher mrf

hi Pratyush , I have been using your website for last 2 months only but i have stopped looking and searching for other sites since i found this.

its really well thought, well planned like it understands beforehand what we are looking for. Thanks for providing such facility.

now two things i would like to add here

1. i have been looking for EPS growth for 3 or 5 years but could not trace it please advice how to go about it

2. whenever we receive an email from your server, it will be much nicer if the data about companies is put is a tabular form like our own customized coulmns

that way comparison will be easy.

thanks again for all the good work. Best Regards

was just wondering as how to create a ratio like market cap to averge operating profitr of last five years in respect oif any company

Hi Vinit,

There are variables for Average Earnings 5Year and Average Earnings 10Year . You can use these in custom ratio option to create your own Price to Earning 5year variable using market capitalization and these variables.

Hope that helps,

Pratyush

Hi, can you pls tell

how to create percentage growth variables? For example market cap growth, what would be the variables?

Hi Vijayant,

Currently we don’t have the historical market cap variables in screener. We wish to add them in future.

Regards,

Pratyush

How can we see the formula of the public ratio created by others?

Hi Jignesh, we do plan to make the formula available for user ratios. However, I haven’t been able to spend much time on it. Will try to add it soon.

Thanks for the feedback,

Pratyush

HI

hi, can anyone let me know how to take average of TTM and last year trade receivable averge>>>

Hi Sabe, you might want to use the variable “Debtor days” for this purpose. It considers the average of receivables.

Hope that helps,

Pratyush

Hi Pratyush,need your help.. Profit growth in screener is based on which quarters?I know that it should be trailing of 12 months v/s previous 12 months, but which month you considered in screener for the calculation.. pls tell me.. for nay scrip..

thanls in advance

Profit growth is calculated on last 4 declared quarters vs 4 declared quarters before that.

Hope that helps,

Pratyush

Is there any screener which shows technicals ? say for e.g. Directional Movemnt . and various weekly/monthly averages along with macd ?

Mahesh Vakharia

Hi Mahesh,

As per my understanding, there are many good technical websites and softwares. As we are not into technicals, however, we can provide you much help.

Regards,

Pratyush

Hi, I am trying to get ROCE average of 5 years. Could you guide please?

Hi Pratyush, could you tell me if there’s a way to look at all the results(say there are 1500 results spread across 30 pages) of a particular formula on a single screen…or export them to an excel?

Hi Manvir,

Though it is currently not possible in screener, we will try to add the feature of exporting the results in future.

Thanks, mate. I would love to see this feature added in future. And great job on the website.

Is it possible to screen stocks of a single Industry?

Hi Shirish, screening in a single industry is currently not possible. You can however view all the companies in a particular industry by entering the sector name in the top search box and selectiing the last option of showing all results.

Hope that helps,

Pratyush

how can i find a company name in which Retail investors holding less than 10 % stake in this company .

Hi Pratyush,

Can I delete a quick ratio that I have created? if not could you please add that feature also

i am not able to create my desired financial ratio…… whenever i click to create financial ratios page it shows ERROR 404…….secondly i am not able to view all Popular Screens……please guide for same………..

create custom ratio page is not working?

i am not able to create new ratios pleae help

Hi,

I need to export to excel and also make a few custom ratios. Is it possible? I am unable to find any links on screener for the same.

Regards

Anuj

Would be great if you could add the “Custom Ratio” and “Export to Excel” back!

Hi Pratyush,

It would be really great if you could add the “Creating custom ratios in Screener” and “Export to Excel” back!

M i the only one or is the link to create custom ratio not working anymore for all.

Create Ratios Page is not working … Pls Help

Hi…I want to screen stocks with gross profit margin > 20 % on yearly as well as 5 year basis. What code should I write for this? And what exactly does profit growth mean? Also, your ‘create financial ratios page’ is not available. Please help…

RESP SIR I WANT TO CREATE A AVERAGE PRICE OF LAST 3 YEARS , HOW TO CREATE IT , THE HEADER WOULD BE BASE PRICE .

how to calculate future price target ,wHAT FORMULA SHOULD BE USED

Hi Pratyush,

I would like to have a ratio of Market cap to operating profits, also would like: market cap to profits. Currently, we have market cap to quarterly profits only. How can I create those? I tried the create ratio link, but it’s dead: http://www.screener.in/create/ratio/

I want to create a ratio -BV/FV . I consider this will be quite useful for meaningful inter-firm comparison and better understanding of Earnings and Dividend ratios too.

I tried but could not, due to authentication failure. Pl guide.

Venkatesan

[email protected]

hi

how return on capital employed 5year calculated. is it profit of last five years added and divided by ROCE of last 5 years added or latest profit divided by avg ROCE of 5 years.

regards

Hi Pratyush,

How can i add a custom formula. I want to run a screen on market cap growth

Sameer

If I want to check the formula of a already existing ratio, how can I do it?

Many Thanks.

Can you please explain, how to calculate COGS from data sheet?

Hi I want to add last three years closing price /no of counts days , also we cannot get industry pe in the chart can someone help

Will like to a formula of last three years average WAP price . CAN SOME ONE HELP

create financial ratios page — first fix this page, its broken. Simple google tools will help you monitor boken pages.

Hi want to calculate average assets of previous and current year. as well as the average shareholders equity

how can i do it

How to create a equation with square root

how can i get ROE and Debit to equity … from last three years

Create financial ratio page is not working. pl help.

Hi,

I had created a ratio Net Sale per share = Net Sales / No of shares.

Had seen for Vedanta, It appears to give an incorrect number.

Net Sale per share as per website: 204.65

Net Sale per share as per calculation: 248.88

Sales for Mar’17 = 72,225.03 Crs

No of shares outstanding = 2,90,19,13,068.

Request you to check and let know.

Thanks,

Abhishek Sharma

it would be very helpful if screener.in provide stock screening based on sector

Hi All,

I am trying to create my own ratio but I notice that http://www.screener.in/create/ratio/ link is not working!!!

I just want the functionality of “QoQ Profits”.. This list only last quater.. but I want the “QoQ Profits” of last 8 quarters..

Any help will be really appriciated.

Thanks,

Abhishek

Hi,

Can you pls give me query for:

Interest based-debt should be less than or equal to 25% of Total Assets.

Interest income plus returns (currently considered @8%) from interest-based

investments should be less than or equal to 3% of the total income.

Receivables plus cash and bank balances should be less than or equal to 90% of Total Assets.

Thanks.

How to Create your own rations. Error 404

What is the FORMULA for Year to Date (YTD) Returns (or) 3 yrs Stock Return Ratio ??????????

or 1 Year Stock Performance/Return ???

Any idea how to create custom ratios Eg: PEG and Fair Price .. kindly share formula

For every query i enter it shows me, invalid, pls help

How to create a equation with square root ? Can you please help?