Try this. It works. Missed the previous q equation earlier
Net Profit latest quarter > 1.5Net Profit preceding quarter AND
Net Profit preceding quarter > 1.5 Net profit 2quarters back AND
Net profit 2quarters back > 1.5* Net profit 3quarters back AND
Net profit > 1
Hi, Whether there is any provision in screener to upload xml statements from XBRL Annual Financial statements filed by unlisted companies and download the details in the pre-determined excel format we have set for the profile.
For the March 2017 numbers pretax profit is displaying as 79.45, however after tax it displays as 204.75. If you notice, this mistake is also true for the prior years of 2015 and 2016. This bug seems to be there in the TTM numbers as well.
There is a info called “Expected to give good quarter” in Pros section for some of the stocks. Is there any possible way to sort the stocks based on this criterion.
Or is there any other way to decide which stocks can give good quarter through screen?
Basis their expected quarterly numbers, I had created a ratio by the name of Expected Quarterly OPM. You can put the below query to find out companies who are expected to post better quarterly OPM as compared to their latest quarterly OPM :
Expected Quarterly OPM > OPM latest quarter
These expected numbers were already present in Screener.in and to read about how they are derived you will have to search through this thread or read through tweets of the developers @pratyushmittal@ayushmit
And if you are not looking for Quarterly OPM but Quarterly Net profit then you can use the below query
Expected quarterly net profit > Net Profit latest quarter
the nos match with those put out in AR. The difference is due to the Share of Profit / (Loss) of Associate amounting to 14,944.72 lacs. I guess screener doesnt have a field for that. Rest seems to be ok
@pratyushmittal Is there any custom filter on the works where one can compare metrics of companies within the same industry and also input queries by selecting a particular industry?
Do anyone here has success using Mac numbers application to create file in xlsx format and using export to excel function. I have been getting error
Error 500: Whoops! Something has broken down.
Sorry, but the requested page is unavailable due to a server hiccup.
Our engineers have been notified, so check back later.
You can also help us by describing the problem here. @pratyushmittal
@pratyushmittal
There seems to be some problem with the Dividend Amount for MAR-16 and MAR-17 for Balmer Lawrie & Company Ltd.
It seems to be coming as blank in the Downloaded Excel in the “Data Sheet” sheet.
But in the UI it seems to be showing values.