Advanced Screener.in: Custom Formulas and Forensic Screens

For investors who already write basic Screener.in queries and want screens that hold up. The first half is about writing formulas properly: handling nulls, zero denominators and negative values, building composite scores in one query, and testing multi-year consistency. The second half turns those skills into forensic screens: cash conversion, accruals, other income dependence, capitalisation creep, receivable and inventory build-ups, the cash-and-debt paradox, Piotroski and Beneish style scoring, and promoter pledge and dilution filters. It closes by testing screens against real Indian collapses such as DHFL, Manpasand and Yes Bank, and by building a quarterly review routine that separates genuine red flags from false positives.