Welcome to the Forum

Creating an account is currently only possible via registration at SimFin.

Missing 2017 Q4 data for AA (Alcoa)?

Hello,

I was looking at the bulk download data and noticed that Current Assets & Current Liabilities data is missing for 2017 Q4 for Alcoa corporation. FYI, I used the following for download:

Fundamental Detailed
Period End Date
TTM

and I was looking at:
Ticker = AA
SimFinID = 367153

There is Current Assets & Current Liabilities data for 2016 Q4, then 2017 Q1 Q2 Q3, then next is 2018 Q1. I'm not sure why 2017 Q4 is missing for these two values. There is, however, 2017 Q4 data for some of the other fundamental values.

Is this a data error, or is there some reason this data is missing? I was also wondering if there was a systematic issue that might predict other missing data points for other companies & time points too.

I tried to look in Fuse, but don't know how to display Quarterly info in Fuse (it only seems to show Annual info).

Charles


Comments

  • Hi Charles,

    this is weird. I'll compile new bulk download files in the coming days, I'll check the data again and maybe it was a mistake that is fixed by now.
  • Great thanks!
  • Hi Thomas,

    I found some other companies for which there are some odd missing values in the Period Enddate table:

    SimFin ID = '36105'
    Ticker = 'ABAX'

    There seem to be a bunch of missing values for the year 2016, even though there are pretty consistently reported values from 2011-2015, and then 2017-2018. The number of missing values seems to vary by metric. Here are some examples of metrics for this company that are missing some values:

    'Cash from Operating Activities' : Missing 2016-06-30 value (other 2016 values are there)

    'COGS': Missing 2016-06-30, 2016-09-30, 2016-12-31 values (2016-03-31 value is present)

    'Current Assets': Missing all values from 2016 (but 2015 & 2017 values are all there).

    'Dividends': Missing 2016-06-30 value (other 2016 values are there)

    This is some inconsistency that I can't figure out. This is with the most recent compiled database, btw.

    Charles




  • Hi Charles,

    thanks for looking into this. I'll try to compile the bulk download for ABAX only in the coming days and see why the values are missing, from what I can see online there shouldn't be any missing values.
Sign In to comment.