Has anyone made an EBITDA surprise factor using ConsEst and FHist? Is that possible?
If anyone has successfully built an EBITDA surprise factor, I'd really appreciate it if you could share how you implemented it correctly.
This isn't buildable with what's exposed today.
The EPS version is buildable because EPSEst(0, QTR) is aligned to reported quarters and has the same indexing as Actual(). The two pair cleanly. There's no EBITDAEst(), and no generalized Estimate() function that mirrors Actual() across the other line items.
So a proper EBITDA surprise needs a period-pinned historical EBITDA estimate, which is the scaffolding we already have for EPS and Sales, but not EBITDA.
2 Likes