@vibhor_vaish - yes, one can do that by adding custom/quick ratios. We are thinking of providing a customizable row in the ratios table.
We are very serious about data accuracy. Kindly email us at support@screener.in if you have any doubts/observations, team will help provide reasons/reconciliation.
Hello Screener Team,
This year for Q1, YoY comparisons will be meaningless because last year Q1 was under complete lockdown. Key sectors like automobiles reported zero sales in April 2020. It will be more meaningful to make YoY comparisons against Apr-Jun 2019 instead. Can you please add ratios for that so that we can make Q1FY22 Vs. Q1FY20 comparisons? Thanks ! @ayushmit@pratyushmittal
Hi, Thanks for the response. I meant in the Ratios section which can be used to frame queries and can then also appear in the output. At present we have all these âpreceding year quarterâ, if we can have âyear before preceding yearâ. It will be useful in New Results tab as well.
@ayushmit@pratyushmittal
Will it be possible to synchronize the Key Points section at the top for similar industry companies for eg) banks.
HDFC bank page shows segmental revenues but not key financial ratios while Kotak Mahindra bank shows ratios and not segmental revenues. Can both show both kinds of data.
Is there a way to download the underlying sections of cash flow as well. For example, when I download data to excel, all I get right now is Cash Flow Statement divided into Operating, Investing and Financing activities.
I want to be able to download the parts that make up these sections as well.
Hello Ayush,
One Twitter User pointed out an interesting Metrics to evaluate the Moat / Efficient cos through
EBIT conversion.
EBIT conversion = EBIT margins / gross margins
i.e For example, if a company does $10 billion in revenue but has 10% gross margins, thatâs $1 billion in gross profit.
But say the company brings in $300 million in EBIT.
Thatâs a 3% EBIT margin or 30% EBIT conversion (300 mil/1 bil)
I tried putting this formula in saved ratios on Screener --it doesnât allow me anything beyond latest Quarter i.e EBIT latest quarter /GPM latest quarter
So 2 Questions
1)Is there a way to get this in Screener to evaluate yearly or any other flexible timeframe
2) I also couldnât get EBITDA added to the formula as it doesnât recognize it âŚ
Hence, how to get these 2 things sorted in Screener formulas ?
Hi.
Any way to create specific ratios using separate data tabs : for eg) receivables last year(from operating cash flows etc.) @ayushmit@pratyushmittal
I am a paid subscriber of screener.in
Posted several questions a couple of weeks ago but no response from âpremiumâ support! Hence posting on this forum for discussion of the questions and if there is a way to get these information
It is not possible. We can do up to 3 years back only.
FCF 1Y ago= Free Cash Flow Last Year
FCF 2Y ago=Free Cash Flow Preceding Year
FCF 3Y ago = Free cash flow 3years - Free cash flow last year -Free cash flow preceding year
But we cannot compute FCF 4Y ago or FCF 5Y ago. To do these, we have to do so company by company by using the âExport To Excelâ feature of screener.in