IMPORTANT: fixes to NAs in 5Y averages will be released tonight

Dear All,

We previously reported a new bug that affect 5Y averages. The fix for this will go live later tonight.

The fix affects 5Y average factors, like PayRatio5YAvg, during preliminary reporting periods: NA is returned when values are missing instead of falling back to the last known value. While all 5Y ratios might be affected, most have very few occurrences. This is because most 5Y avg ratios use line items that are usually present during preliminary reports. The main two exceptions are:

PayRatio5YAvg
EBTDMgn%5YAvg

These factors during busy annual reporting periods, like around February, have around 250 companies showing NA’s briefly. For a “picture” of these problem see AMGN below. The slanted lines in the fundamental chart (representing missing values) are now replaced by straight lines (meaning no NAs)

Very sorry about this . Please let us know of any questions/concerns.

Thanks


Thanks Marco, looking forward to testing out the changes.