The reason is that I want this every quarter for the last 20 quarters, the FHist is point in time weekly and doesn’t really fit the bill because I want to compare quarterly fundamentals. I understand this could be done with alot of mumbo jumbo custom formula but it would make the equation way too big inside a loopsum or anything if I have to deconstruct (mktcap + DbtTotQ - (CashPSQ * ShsOutMR) and then MktCap… Adding these two would make things very practical.
Put forth a feature request, because I want to vote this thing a 5 out of 4.
Not that’s it’s hard to calculate FHist(“MktCap”, n) or to do ShareCur(n)*Close(n), but it would be AWESOME if MktCap() line item function were available in such a way that negated the effects of splits, dividends, and other corporate actions.
Line items for EV seem like a no-brainer, as well, especially given the amount of room this fills up by going about it longhand.
Quant, I’m sure you know that MktCap and EV are not static for the quarter. How would you sugeest to deal with this? Which day of the quarter should be the MktCap?
@ Chipper6
The day of the quarter release for each company? Since each company have a different release date for earnings, all that matters would be to line the EV and MktCAP at the same date as fundamentals get released.
The goal of this would unlock new ratios like an Enterprise Value Beta.
Well… MktCap would be the dynamic portion, but everything else (given the data available) would be static in a given quarter. Even so, you could just accept that EV can change daily (vis-a-vis the SharesCur(BarsAgo) semantic) but that non MktCap components of EV would revert back to the most recently reported quartlerly data.