Dear All,
We identified a problem with 5Y average ratios (the ones that end in 5YAvg). These ratios use the annual statements and require 5 valid values to compute. Any N/As will cause the ratio to be NA.These ratios have the “fallback during preliminary data” disabled since they are mostly income statement related (which is usually pretty complete).
However this is not ideal. Take for example PayRatio5YAvg. It uses a cashflow line item for the dividends and does exhibit temporary NAs. In the image below see AMGN in the fundamental charts. As you can see PayRatio5YAvg goes to NA during prelimary data while GMgn%5Yavg never does. A much better value for PayRatio5YAvg would have produced the previous value instead of NA.
We’re analyzing all our 5YAvg ratios to see which ones are more prone to temporary NAs. The ones we identify will be changed to fallback to the previous 5 years with NAs during prelim reports. We expect to release this in a few days.
Please let us know of questions/concerns.
Thank you
