Why vishnu chemical’s EPS shown much lower in screener than the company reports? For Q2 EPS reported by company in their Fin Statement was Rs 29/- where as screener shows it as Rs 5.45/-…
How to get 3 yr avg p/b?
Go to chart, select Price to Book, you can see the P/B over any period of time.
Can we get 3 yr avg on like we get 3 yr avg pe?
(Don’t look for averages as for some companies, outliers will drag your averages. Look for median PE instead.)
Here is how you can get 3 year median PE.
You can see Median PE for 3, 5 or 10 years. You can do look at Median EV/EBITDA, Price to Book and Mcap/sales.
For example: Median PE (last 3 years) for TCS is 32.5 in the below image.
How do you write a query to check a given variable for EACH of the last N years.
For instance I want to screen companies with an ROE greater than X, in EACH of the last 5 years.
1 Like
Hello Team, Elecon Engineering - screener shows zero pledge but BSE data shows about 5 % promoter shares are pledged. Can you please check.
2 Likes
With the new accounting rules, Lease Liabilities are now being considered as ‘Debt’. As such, the Debt/Equity ratio is getting skewed and queries end up excluding businesses which otherwise don’t have much long term borrowings, but have higher lease liabilities (eg retailers/QSR etc).
eg: JubilantFoodworks will be excluded from a query with ‘D/E < 0.75’ criteria since the Lease Liabilities of Rs2187cr gets included in ‘Debt’ which bloats up the D/E to 1.12, even though real Long Term borrowings are only Rs138cr;
How can we write a query which excludes Lease Liabilities and only considers Long Term Borrowings when calculating Debt/Equity ratio? I don’t think there is an option to subtract ‘Lease Liabilities’ form ‘Debt’ when writing queries.
Help appreciated! Thanks.
-Kunal
7 Likes
Why do you want to exclude lease liabilities? It is debt afterall.
Leases are contractual commitments that has to be paid in good or bad times, and failure to do so will lead to loss of control over assets.
Yes, there are companies that put clauses around not paying leases in bad times, and Jubilant Foodworks might play that game.
So, if you really want to screen out companies based on the criteria you mentioned.
Use Yahoo Finance
You do need to create a custom screener in Python with Yahoo Finance Module.
You can select only Debt in the form of Bonds/Bank Loans as seperate to Capital Leases.
Hope this helps!
4 Likes
When you run a query it runs for Standalone data. How can you make screener.in query run on consolidated data?
1 Like
What is debt and what is not, can very quickly end up being a spiraling discussion. So, to each his own when it comes to what they want to consider as ‘debt’ and what not. Few may consider even ‘Account Payables’ as debt because it too is a ‘Liability’ which the company needs to fulfill, akin to ‘Lease Liabilities’
The question was specific to ‘Long Term & Short Term’ Borrowings/Debt. These borrowings have a periodic interest payment associated with them along with some asset collateral (based on debt structure). This isn’t always the case with ‘Lease Liabilities’.
As for my question regarding the Screener query, hope there is a way to exclude ‘Lease Liabilities’ from ‘Long Term & Short Term’ Borrowings/Debt so investors can calculate the plain vanilla ‘Debt/Equity’ ratio (which was the case all these years)!
2 Likes
How does one look into (others) user created ratio or formula?
Was trying to replicate a ratio but was unable to see the actual content - the actual formula.
Can read the description - but not beyond that.
Any help is appreciated. Thanks
Maybe there is a feature that hides the query details for others.
Did not check all but the query details are visible for the screeners that are present here, so what you are searching for must be present in the page too, is it not?
Thanks for the response.
No it is not on the ‘screens’ link you have kindly pasted. It is a ratio, and only the description of the ratio is available in box when filtered & chosen.
Will try to check if there’s any other indirect way to check upon the number being presented by the ratio.
Post a screenshot so that we can understand what exactly is coming up and what is not shown.
Any response on this?
{Thanks for following up.}
So here I am trying to find what exactly is the formula behind the ratio ‘cash debt contingent liabilities by mcap’.
Yes I see the description, shortname, but is there any way to see the formula. Tried replicating the formula as presented in the description, but was not able to match the answer presented by the ratio when chosen as a column for display.
When we are exporting data to excel, is there any way to also get the business segment wise data as well? Assuming that the user has take the paid subscription.