When using fundamental data fields I am noticing that fields such as market_cap, enterprise_value is not current as of the day of the query.
They are flat for an entire quarter and seem calculate once for an entire quarter.
How can I work around this?
One solution that comes to mind is to get the total number of outstanding shares and calculate these numbers the 'price' on each data.
But there is a problem. I am trying to do an overall market/index level fundamental study.
So I am trying to add up the market_caps/enterprise_value of all the stocks in the data base or a sector/market_cap subset to get the total market_cap of the entire space.
- functions where I can query for fundamental data does not have access to price data.
- price data is only available to a limited subset of stocks and not for all the stocks so I cannot do what I am trying to do.
Sarvi
PS: some data are quarterly and some are annual. For example. ev_to_ebitda != enterprise_value/ebitda and there is no easy way to calculate trailing 4 quarter ebitda. Right now I reverse engineer the annual ebitda from the ev_to_ebitda and enterprise_value :-)
