Show HN: Every CEO and CFO change at US public companies, live from SEC

(tracksuccession.com)

162 pontos | por porsche959 9 horas atrás

26 comentários

  • thedougd
    8 horas atrás
    What would also be very interesting is a graph of relationships and movements. Let's see just how incestuous the boards really are, and what's going on with serial CEOs who move from one business to the next.
    • StrauXX
      7 horas atrás
      Northdata [1] does basically this, but mostly ingests European data currently. Perhaps they will expand to ingest US data as well at some point. Not affiliated with them in any way. I just use them to look into company structures every now and again.

      [1] https://www.northdata.com/

    • abstracthinking
      8 horas atrás
      I worked on a knowledge graph map using Wikidata to get relationship between people and organizations, but data was limited to family, basic stuff. Being from Europe, there isn't an open data analogue of SEC. Now I will download this data, it is open so no license at all, and try to show these kind of relationships. It has the potential of being very investigative, especially for USA residents.
      • HWR_14
        6 horas atrás
        Is it that Europe doesn't have any open data analogues of the SEC, or is it that each European country has its own open data analog?
        • abstracthinking
          6 horas atrás
          Each european countries has various orgs, types of license. It is easier to start from SEC to integrate that data into my site, also you have to test a bit what users care about.
          • jasonjayr
            4 horas atrás
            Wondering aloud -- this is clearly PII, but it's public information. The site would be subject to GDPR, and other rules from the EU, and folks may want to have their data hidden or removed. What would be the exposure for sourcing EU data?
    • porsche959
      5 horas atrás
      Interesting idea...tracking which execs move together or which board members overlap across companies. Maybe in next turn
    • czbond
      4 horas atrás
      > incestuous

      Is it that? Or would it be similar to when you have a lot of responsibility (like leading a company) you tend to bring along people you know you can trust and can help you succeed?

  • culi
    1 hora atrás
    Essentially a cleaner, filtered, partial front-end for https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&C...
  • hliyan
    8 horas atrás
    Given this is failing due to HN hug of death, might I suggest that you do a periodic batch, save the results and serve static?
    • porsche959
      8 horas atrás
      Thank you very much. Great call
  • Nuzzerino
    7 horas atrás
    Getting “literally who” vibes from the list of execs that were listed with a job title but not a company name.

    Mobile browser, if that makes a difference (maybe one of the people on the list helped me downsize as well at some point without me realizing it).

    • porsche959
      5 horas atrás
      thats a bug. thanks for flagging. The company name is there but gets cut off on mobile. Will fix the layout.
  • WA
    7 horas atrás
    Nice idea. Small thing: the categories are pretty much fixed. If you have to abbreviate a never-changing category like "Consumer Defen..." in a widget, your design doesn't work in this aspect.
  • artembugara
    5 horas atrás
    You can also check any signal from publicly available sources using tools like CatchAll.

    For example, "CEO and CFO appointments at US public companies in the last two weeks" found 142 records [0]

    You can also set up monitors to get updates.

    [0] https://platform.newscatcherapi.com/catchall/example/gtm--ex...

  • abstracthinking
    8 horas atrás
    Interesting, you should save part of the data to do some caching and avoid api requests for old positions.
    • porsche959
      8 horas atrás
      Thank you for the suggestion
      • abstracthinking
        7 horas atrás
        Look now that the site loads, is it a bit sketchy that you are asking 50 dollars subscription, one can't even navigate the site a bit without subscribing. You don't even have a working and tested product and already want to make money.
        • porsche959
          7 horas atrás
          The explore page is free and always will be. The main site shows real time changes too, just capped at a few recent ones. The $50 is for the full feed, alerts, search, comp data. Comparable to other sales intel tools but I hear you on letting people try more before paying. Gonna work on that.
          • richwater
            6 horas atrás
            Would you consider making a stale dataset (3day, 1 week, idk..?) available for other projects (but also protect your revenue stream?) I assume the value in the paid option would be real-time updates but I'm not sure exactly what the target consumer is
            • porsche959
              5 horas atrás
              Yeah been thinking about that. A delayed public feed or an API with a lag makes sense. The real-time piece is where the paid value is so anything older than a few weeks/months could be opened up
  • karmelapple
    5 horas atrás
    Great proof of concept!

    At the top it says:

    > 2,100+ > CEO, CFO, Board, and other executive changes tracked in the past 30 days

    Could you add a little metric there such as how many companies are being tracked, and perhaps how that compares to the previous 30 days, or 6 months ago, or 12 months ago?

    Maybe a graph showing how many changes happen each month, so we can see when things are more volatile or not.

  • chollida1
    4 horas atrás
    Nice work.

    I remember giving this task to a summer co-op 10-12 years ago. it was alot harder to scrape the edgar site then and gather all for form 4 filings without the new api call first interface and the XBML markup in 10-K and 10-Q filings.

  • aayushkumar121
    4 horas atrás
    This feels like the start of a “people layer” for public companies—almost like a Bloomberg terminal but focused purely on executive movement.

    Curious if you’ve looked at second-order signals yet (e.g. clusters of execs moving across the same companies)?

  • itissid
    8 horas atrás
    Interesting. How do you yourself use this(I am assuming of course you built it out of a need to want to have to track this data)?
    • porsche959
      8 horas atrás
      I originally built it to track competitive moves in a specific sector. Turns out sales teams and recruiters get the most value from it as new exec hires are a strong outreach signal
  • eddy_cammegh
    8 horas atrás
    How does the comp extraction work? 8-K prose has no standard format so curious whether you're running it through an LLM or using a rules-based parser, and how you handle amendments where the actual figures show up in a later filing.
    • porsche959
      8 horas atrás
      The 8-K text gets run through an LLM to extract the structured fields. It handles the variation in format pretty well. For amendments, the system picks up the amended filing and updates the record — the comp figures sometimes only appear in the amendment.
  • tristor
    7 horas atrás
    I think one of the interesting things here is that many senior executives make similar base pay to very senior ICs. The primary compensation difference is in their equity compensation, where executives get massive PSU/RSU packages, while senior ICs get much more modest packages. A senior IC may have 30-50% of their compensation as stock, while a typical senior executives may have as much as 97% of their compensation as stock.
    • balderdash
      7 horas atrás
      I think this is a good thing? At least from the perspective of aligning incentives with shareholders?
      • zipy124
        5 horas atrás
        No. It encourages short term thinking which can boost profits whilst harming long term performance. As an insider you can usually hide the long term consequences until after you have liquidated your stock.
      • rustystump
        6 horas atrás
        Sbc is not always good for shareholders if anything it can obfuscate actual valuations
      • tristor
        6 horas atrás
        Maybe? I think the jury might still be out on whether equity compensation aligns incentives. Most equity compensation is treated same-as-cash for the perspective of taxation, and unless there are regulatory or contractual limits affecting holdings, it's commonplace for executives to offload shares as they vest as part of normal compensating activities just like your typical FAANG engineer does.

        I was thinking it was interesting more from the socioeconomic perspective:

        1. Senior execs are still "working for the man", even if their compensation is materially different from other employees, except in the case of founders of mega-caps.

        2. From a socioeconomic lifestyle perspective, the primary differentiator is that senior executives can afford larger one-time costs/upfront costs due to their equity compensation, but have to maintain fairly similar ongoing costs to senior ICs. E.g. a senior exec can afford to buy a nicer house in SFBA because of Prop 13 limiting ongoing property taxes and the ability to shell out more up front to either avoid a mortgage or minimize payments, but their ongoing lifestyle expenses otherwise are most likely not materially different.

        Basically, given the rhetoric, I was expecting that senior execs were essentially living in a totally different parallel world from senior ICs in tech, but it doesn't seem that this is really the case /other than/ probably social connections and society. In both cases these employees are highly compensated, but still ultimately employees, and neither is on a rocketship into the billionaire class. The difference between a billionaire and a 50-millioniare (senior exec) is about a billion dollars, the difference between a billionaire and a 3-millionaire (senior IC) is about a billion dollars.

        Maybe my take is wrong, but I'd expect that is more about fringe benefits (e.g. access to corporate PJ) than direct compensation.

  • mtam
    7 horas atrás
    Is the equity piece one-time or yearly grants? I think it is adding up yearly salary with one-time equity grants. Also, how about bonuses?
  • baxtr
    8 horas atrás
    Nice job! Is there a way to double click on any name to see more details on the person like previous positions or current compensation?
    • porsche959
      7 horas atrás
      Thanks - currently the name just links to a basic linkedin search but this is a good idea for a future feature
  • gmatt
    3 horas atrás
    been mulling visualizing this for years.. nice work.
  • djfobbz
    8 horas atrás
    The site fails to load...it just gets stuck in a fetching state. Another downside of vibe programming.
    • UqWBcuFx6NV4r
      7 horas atrás
      Another downside of AI is that people for whom today is obviously their first day using the internet will buy into the AI culture war without restraint and blame every little thing under the sun on “AI”. I can assure you that message boards were bringing websites down since before you were born.
    • xnorswap
      8 horas atrás
      Sites going down under load is hardly a new phenomenon.
      • djfobbz
        7 horas atrás
        Sure, it's not new. Neither are memory leaks and race conditions...but we still expect competent engineers to avoid them. It's like opening a store but the doors jam the moment customers walk in. A crowd isn't the problem, your setup is.
    • porsche959
      8 horas atrás
      Back up now...first time getting real traffic. Appreciate the patience.
    • baxtr
      6 horas atrás
      That idea is actually a perfect example for a good use of vibe coding.

      It was just an idea first, now it’s a decent website to test the viability of the idea.

      I don’t think it was intended for anything else than so if there is real demand for this.

      • nbiznich
        5 horas atrás
        I lost you on the "decent website" part. OP's whole point is that the site isn't working. Lol
  • arikrahman
    7 horas atrás
    Says it's unable to respond at the moment.
    • porsche959
      5 horas atrás
      Should be back up now. Got hit with way more traffic than expected.
  • gbibas
    7 horas atrás
    You hit on something that AI can be really good at, which is shining light on corporate activities. Salary and movement are great, and interesting, but this could also help parse things like entry and exits into business markets where companies often quietly add or remove things from their filings. Keep going.
    • porsche959
      7 horas atrás
      you are absolutely right - filings have a ton of signals beyond just the exec changes. Market entries, risk factor changes, material agreements. Lot of room to expand.
  • htrp
    7 horas atrás
    did you write the SEC parsers yourself or use oss/off the shelf tech?
    • porsche959
      7 horas atrás
      Built it myself. The filing structure is somewhat consistent enough to parse programmatically, then an LLM handles the unstructured parts (with a lot of trial and error)
      • just_once
        6 horas atrás
        And you just scrape it straight from sec.gov?
  • leobuskin
    7 horas atrás
    What's the backend? I'd recommend to migrate such project to the edge (Cloudflare, etc)
  • infecto
    7 horas atrás
    Fun project but meh on subscription. This data already exists in much better detail including full network graphs of people and many additional data points. Financial data is a hard problem because it’s not only hard to offer something new but also your only real consumer unless novel data is going to be retail.
    • porsche959
      7 horas atrás
      Agreed, the big providers like Bloomberg cover this space with way more depth. I'm building for the teams that can't justify those budgets (small sales teams, independent recruiters, solo advisors)
      • infecto
        7 horas atrás
        What’s the value add though? This could be vibe coded out in a couple hours of coding and some more incremental time to process historical filings.

        And I don’t mean this in a negative way simply that this is just a 30min UI around a 1 hour LLM data pipeline.

        • porsche959
          5 horas atrás
          Totally fair. The value is just that it's built and working, you get the data in real time without having to set anything up yourself.

          It's definitely vibecodeable but there's a decent amount of edge cases and ongoing maintenance that add up. I'm sure an actual engineer could do it way better. I just wanted the product, couldn't find one at a reasonable price, so I built it.

    • abstracthinking
      7 horas atrás
      I agree with you, site also looks too much a one day vibecoded stuff. Can you give me references where I can these graphs of people, I am interested because I am working on something similar.
  • Thoko14
    8 horas atrás
    Interesting part will be what do we read out of that data
    • porsche959
      5 horas atrás
      100% - will be cool to see any recurring patterns, which sectors churn most, how comp varies by industry, etc. Gets more useful as the dataset grows.
  • mikedillion
    8 horas atrás
    “Real time”
    • mistrial9
      8 horas atrás
      a CTO at Starbucks started his presentation with "How many employees does Starbucks have?" .. and spends an hour explaining dynamic assesments.. hint- there is no count at any hour because the massive, distributed system has edge states and some noise.

      Starbucks CTO explains carefully that they do not actually know how many employees there are, in their own enterprise, at any give hour

  • peerscope
    6 horas atrás
    [dead]
  • dilberx
    6 horas atrás
    [dead]