Improve Handling of '-' values in Screener
under review
C
Cuddly Unicorn
Dear Koyfin Support,
I would like to report a bug in the stock screener regarding the "Net Debt/EBITDA" filter. When applying the filter "Net Debt/EBITDA > 3.5x", the screener incorrectly excludes the Kazakhstan company "National Atomic Kazatomprom" (look at attached pictures "Screener parameters 1" and "Screener Results 1").
However, upon removing this specific filter, the screener correctly identifies and lists "National Atomic Kazatomprom". It appears the current filter logic incorrectly excludes companies showing "-" instead of numerical values (look at attached pictures "Screener parameters 2" and "Screener Results 2").
I have attached screenshots demonstrating this issue clearly:
Screenshot with the "Net Debt/EBITDA" filter applied, showing the company excluded.
Screenshot without the filter, showing the company correctly included.
Could you please investigate and resolve this issue?
Thank you for your assistance.
Best regards
Photo Viewer
View photos in a modal
Conor MacNeil
updated the status to
under review
Conor MacNeil
Merged in a post:
Screener - Issue with Net Debt/EBITDA Filter
C
Cuddly Unicorn
Dear Koyfin Support,
I would like to report a bug in the stock screener regarding the "Net Debt/EBITDA" filter. Specifically, I want to filter companies with Net Debt/EBITDA lower than 3.5x, including companies that have net cash positions. However, the screener incorrectly excludes companies with net cash positions, such as the Kazakhstan company "National Atomic Kazatomprom," because the system labels these companies' Net Debt/EBITDA as "-".
When I remove this filter, the screener correctly identifies and lists "National Atomic Kazatomprom". It seems the current filter logic mistakenly excludes companies displaying "-" instead of numerical values.
I have attached screenshots demonstrating this issue clearly:
Screenshot with the "Net Debt/EBITDA" filter applied, showing the company excluded.
Screenshot without the filter, showing the company correctly included.
Could you please investigate and correct this issue?
Thank you for your assistance.
Best regards
Photo Viewer
View photos in a modal
C
Cuddly Unicorn
If you say so can you tell me how do I filter out companies with Net debt/ebitda>3.5x and not filter out those companies that have Net debt/ebitda="-"? You should also consider that a lot of companies with net cash positions have Net Debt/Ebitda="-" while in reality should be negative. When I filter out companies with Net Debt/ebitda>3.5x I don't want to filter those companies who have a net cash position.
In sunnary how do I filter those companies that have a Net Debt/Ebitda lower than 3.5x (including those with net cash positions)?
Conor MacNeil
Cuddly Unicorn: This is where the improvement lies. We plan to address the handling of '-' values more effectively in the future. For example, companies like Amazon which have '-' for dividend yield, should be scannable for dividend yield metrics. Today they are not.
We are aware of the improvement here, so i'll migrate this to feature requests for now.
Conor MacNeil
Hi Al,
The company doesn't have a value for net debt / EBITDA (LTM), implied by the dash '-' mark in the cell.
As of mid-2020, the company's net debt entered negative terratory, so a net debt / EBITDA (LTM) calculation cannot be calculated.
The net debt / EBITDA (LTM) of this company is therefore not "0", it simply doesn't have a net debt / EBITDA (LTM) multiple. This works as expected.
Photo Viewer
View photos in a modal