Welcome to the Forum

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

Inconsistent publish dates across reports

Hello, I see occasionally that income statements, balance sheets and cash flow reports belonging to the same report period do not have the same publish date in your database. This happens in ~5% of the cases. Is this an error or is this due to restatements?

Comments

  • Hi, can you post a link to a company/report where this occurs? I can then investigate this.
  • Hi, see below some examples, where for each ticker/timestamp you can see the three publish dates, whose are not all the same....


    balanace sheet cash flow income statement
    ('AA', Timestamp('2016-09-30 00:00:00')) 2016-12-01 00:00:00 2017-08-03 00:00:00 2016-12-01 00:00:00
    ('AA', Timestamp('2016-12-31 00:00:00')) 2017-03-15 00:00:00 2017-03-15 00:00:00 2017-05-10 00:00:00
    ('AAOI', Timestamp('2013-09-30 00:00:00')) 2013-11-14 00:00:00 2014-08-12 00:00:00 2013-11-14 00:00:00
    ('AAOI', Timestamp('2013-12-31 00:00:00')) 2014-03-06 00:00:00 2014-03-06 00:00:00 2014-08-12 00:00:00
    ('AAP', Timestamp('2009-12-31 00:00:00')) 2010-06-02 00:00:00 2010-11-17 00:00:00 2010-11-17 00:00:00
    ('AAPL', Timestamp('2009-06-30 00:00:00')) 2009-07-22 00:00:00 2010-04-21 00:00:00 2009-07-22 00:00:00
    ('AAPL', Timestamp('2009-09-30 00:00:00')) 2009-10-27 00:00:00 2009-10-27 00:00:00 2010-04-21 00:00:00
    ('AAPL', Timestamp('2017-03-31 00:00:00')) 2017-02-01 00:00:00 2017-05-03 00:00:00 2017-02-01 00:00:00
    ('AAPL', Timestamp('2017-06-30 00:00:00')) 2017-05-03 00:00:00 2017-08-02 00:00:00 2017-05-03 00:00:00
    ('AAWW', Timestamp('2011-06-30 00:00:00')) 2011-08-02 00:00:00 2012-05-03 00:00:00 2011-08-02 00:00:00
    ('AAWW', Timestamp('2011-12-31 00:00:00')) 2012-02-15 00:00:00 2012-02-15 00:00:00 2012-05-03 00:00:00
    ('AAXN', Timestamp('2011-06-30 00:00:00')) 2011-08-08 00:00:00 2012-05-10 00:00:00 2011-08-08 00:00:00
    ('AAXN', Timestamp('2011-12-31 00:00:00')) 2012-03-13 00:00:00 2012-03-13 00:00:00 2012-05-10 00:00:00
  • Hi, did you have the chance to look into this issue?
  • Hi nathans, I was busy with the share counts today. I have to fix one other thing then I'll investigate this. I'll let you know here.
  • Ok - is this data from the bulk download? Or how did you compile it.
  • Yes this is data from the bulk download. I downloaded via your API and read each of the 3 data bases using sf.load_income, sf.load_balance and sf.load_cashflow
  • Ok, thanks. I'll look into it later today.
  • It seems like this could be a bug in the bulk download files, as the dates are consistent on the website, at least for AA that I just checked. I'll try to fix it on Monday.
  • checking this now again.
  • should be consistent now.
This discussion has been closed.