Welcome to the Forum

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

Negative common-outstanding-basic and/or common-outstanding-diluted

Hi tf

Ran a check on outstanding shares basic/diluted.
Been getting many negative values which I assume related to some mishap in split related calculations on your side.

Please have a look:
Entire list is here: https://pastebin.com/MyiDhhTg

AAL, common-outstanding-basic, common, period, 2011-12-31, Q4, 2011, -503060000
AAL, common-outstanding-basic, common, period, 2011-12-31, H2, 2011, -84030000
AAL, common-outstanding-diluted, common, period, 2011-12-31, Q4, 2011, -503060000
AAL, common-outstanding-diluted, common, period, 2011-12-31, H2, 2011, -84030000
AAWW, common-outstanding-basic, common, period, 2015-09-30, TTM-3.75, 2015, -226719
AAWW, common-outstanding-basic, common, period, 2015-06-30, TTM-4, 2015, -82719
AAWW, common-outstanding-basic, common, period, 2015-03-31, TTM-4.25, 2015, -6242750
AAWW, common-outstanding-basic, common, period, 2014-12-31, Q4, 2014, -75219876
AAWW, common-outstanding-basic, common, period, 2014-12-31, H2, 2014, -25118938
AAWW, common-outstanding-diluted, common, period, 2015-09-30, TTM-3.75, 2015, -138123
AAWW, common-outstanding-diluted, common, period, 2015-06-30, TTM-4, 2015, -14873
AAWW, common-outstanding-diluted, common, period, 2015-03-31, TTM-4.25, 2015, -6256356
AAWW, common-outstanding-diluted, common, period, 2014-12-31, Q4, 2014, -75393492
AAWW, common-outstanding-diluted, common, period, 2014-12-31, H2, 2014, -25164746
ABC, common-outstanding-basic, common, period, 2014-06-30, TTM-5, 2014, -1857433
ABC, common-outstanding-basic, common, period, 2014-03-31, TTM-5.25, 2014, -538683
ABC, common-outstanding-basic, common, period, 2013-12-31, TTM-5.5, 2014, -289933
........................................
YGYI, common-outstanding-diluted, common, period, 2017-03-31, TTM-1.75, 2017, -75495260
YGYI, common-outstanding-diluted, common, period, 2016-12-31, Q4, 2016, -361413152
YITD, common-outstanding-basic, common, period, 2015-12-31, Q4, 2015, -673441282
YITD, common-outstanding-basic, common, period, 2015-12-31, H2, 2015, -609347959
YITD, common-outstanding-basic, common, period, 2015-09-30, TTM-0.5, 2015, -140690949
YITD, common-outstanding-basic, common, period, 2015-03-31, TTM-1, 2015, -3494095
YITD, common-outstanding-basic, common, period, 2014-12-31, Q4, 2014, -583255829
YITD, common-outstanding-basic, common, period, 2014-12-31, H2, 2014, -546953885
ZHNE, common-outstanding-basic, common, period, 2016-09-30, TTM-2.5, 2016, -1848750
ZHNE, common-outstanding-basic, common, period, 2015-12-31, Q4, 2015, -37533000
ZHNE, common-outstanding-basic, common, period, 2015-12-31, H2, 2015, -14007000
ZHNE, common-outstanding-basic, common, period, 2015-09-30, TTM-3.5, 2015, -8110750
ZHNE, common-outstanding-basic, common, period, 2014-12-31, Q4, 2014, -60241000
ZHNE, common-outstanding-basic, common, period, 2014-12-31, H2, 2014, -13929000
ZHNE, common-outstanding-diluted, common, period, 2015-12-31, H2, 2015, -14007000
ZHNE, common-outstanding-diluted, common, period, 2015-09-30, TTM-3.5, 2015, -9264250
ZHNE, common-outstanding-diluted, common, period, 2014-12-31, Q4, 2014, -64855000
ZHNE, common-outstanding-diluted, common, period, 2014-12-31, H2, 2014, -16236000

Comments

  • Thanks. Yes, we noticed this recently too. I'll take some days next week to tackle all the issues with shares outstanding and share prices, this is top priority now.
  • Hi tf

    Thank you for addressing this matter with elevated priority.

    I really like SimFin, mainly for the good pricing model (I am SimFin+ Pro subscriber) and your responsiveness for fixing issues.

    I actually had also Intrin.io subscription and I was disappointed to find out that their data is infested with such issues as well.

    So for now, sticking with SimFin. And hope to get those little problems ironed out asap.

    BR,
    agmonm
  • Glad to hear this and thanks for supporting us!
  • negative shares are excluded now in the bulk download (starting tomorrow morning) and I improved the monitoring of the share counts, I'll try to fix as many problems as possible manually now.
  • Negative/zero share counts should be fixed now for all companies. I'm working on fixing large changes in share counts now.
  • I just scraped again all the shares outstanding data for all companies, and I still spot fairly the same amount of data with negatives.

    Here is the list, updated 10 minutes ago:
    https://pastebin.com/rRuE5wqZ

  • I just figured out that the negative values appear 97% of the time in the Q4+H2 reported periods. Maybe that helps.
  • edited January 12
    Yes, but this should have been fixed. What code do you use to download the files? It looks like this is not data from the most recent files (I just checked AAL and AAWW from your file, and the data is different from the most recent quarterly income data file from the bulk download).
  • Ah - are you using the web API? Because I fixed the share calculation that led to negative share values for the bulk download files only so far. I'll adapt the calculation for the web API tomorrow.
  • Yes, I am using web API to get JSON responses: https://simfin.com/api/v1/companies/id/{companyId}/shares/aggregated

    Isn't all the data being driven from the same singular location for both the Web API and the bulk download?
  • I rebuilt a big part of the backend for the new bulk download to store the data more efficiently, API v2 that I’m currently working on will be using this as well, but the current API v1 is still using the „old“ system, so right now there are 2 different places the data is retrieved from... this is not ideal of course but just temporary while I’m working on making the switch to the new system (which will be much faster also by the way)
  • edited January 13
    Ok, I switched the /shares/aggregated endpoint of the web API to the new system as well now.
    There is a slight change in the display of the data now due to the new system: Trailing Twelve month values are not displayed as "TTM-offset" anymore but instead are just labeled "TTM", the fyear field is also null for these.
  • Great, thanks. I confirm that most issues are now gone.
  • edited January 14
    Still, quick query now returns the following anomalities:
    AMT, common-outstanding, common, point-in-time, 2014-06-30, None, None, -2810026
    AMT, common-outstanding, common, point-in-time, 2013-03-31, None, None, -1036125
    BLK, common-outstanding, common, point-in-time, 2013-12-12, None, None, -4662497
    BLK, common-outstanding, common, point-in-time, 2012-12-31, None, None, -2376881
    BLK, common-outstanding, common, point-in-time, 2011-12-31, None, None, -1413642
    BLK, common-outstanding, common, point-in-time, 2010-12-31, None, None, -703460
    FL, common-outstanding, common, point-in-time, 2008-02-02, None, None, -4523000
    FTR, common-outstanding, common, point-in-time, 2012-06-30, None, None, -2063950
    GLW, common-outstanding, common, point-in-time, 2012-12-31, None, None, -1649000000
    GLW, common-outstanding, common, point-in-time, 2011-12-31, None, None, -1636000000
    GLW, common-outstanding, common, point-in-time, 2010-12-31, None, None, -1626000000
    GLW, common-outstanding, common, point-in-time, 2009-12-31, None, None, -1616000000
    GLW, common-outstanding, common, point-in-time, 2008-12-31, None, None, -1609000000
    LQDT, common-outstanding, common, point-in-time, 2012-06-30, None, None, -505067
    MCHP, common-outstanding, common, point-in-time, 2010-03-31, None, None, -33461000
    MTZ, common-outstanding, common, point-in-time, 2012-12-31, None, None, -9467286
    MTZ, common-outstanding, common, point-in-time, 2011-12-31, None, None, -4593663
    RATE, common-outstanding, common, point-in-time, 2012-12-31, None, None, -50000
    SMCI, common-outstanding, common, point-in-time, 2010-06-30, None, None, -445028
    SMED, common-outstanding, common, point-in-time, 2013-06-30, None, None, -25360
    XRAY, common-outstanding, common, point-in-time, 2008-12-31, None, None, -14248000

    That's the whole list. Good job tf! Appreciated!
  • I'll fix these today, thanks.
  • FL is what SimFin ID? Because Footlocker (which should be FL) doesn't have negative shares.
    Fixed AMT, BLK, FTR, GLW, LQDT, MCHP, MTZ, RATE, SMCI, SMED, XRAY
  • I'm using the v1 Web API. It's still there.
    Do you want to share the v2 with me privately? I can help beta test it.

    Regarding FL, yes, it is Foot Locker.

    {
    "figure": "common-outstanding",
    "type": "common",
    "measure": "point-in-time",
    "date": "2008-02-02",
    "period": null,
    "fyear": null,
    "value": -4523000
    },
  • edited January 19
    Ok I reloaded the shares for footlocker, should be fixed now.
    V2 isn't really ready for beta testing, but I'll share it with you once it is.
This discussion has been closed.