[HN Gopher] Show HN: Free 30-year financial statements visualiza...
       ___________________________________________________________________
        
       Show HN: Free 30-year financial statements visualization
        
       Author : raymondmoay
       Score  : 181 points
       Date   : 2022-04-28 14:34 UTC (8 hours ago)
        
 (HTM) web link (www.fintopea.com)
 (TXT) w3m dump (www.fintopea.com)
        
       | ge96 wrote:
       | I see an E2E test on there, I wonder about this for my own code
       | if it's enough.
       | 
       | Sucks to add unit test to an existing app on the other hand E2E
       | is nice.
        
         | raymondmoay wrote:
         | Thanks! Made this for myself while learning testing.
        
       | Rocket89 wrote:
       | This is nice. Reminds me a lot of koyfin before they went
       | pay2play.. now I found myself some other open source tools. Thank
       | you for this!!
        
       | ars wrote:
       | Please add logarithmic plots - and IMO they should be the
       | default.
        
         | raymondmoay wrote:
         | Will do!
        
       | randoglando wrote:
       | This is amazeballs!
        
       | RyanShook wrote:
       | Great resource and love the interface. Thanks!
        
       | random314 wrote:
       | This is great. For 30 year time horizons, a log plot will be
       | useful
        
       | yessql wrote:
       | This is fantastic. Would love to be able to have logarithmic
       | y-axis!
        
         | raymondmoay wrote:
         | Will do~
        
       | Seanambers wrote:
       | This is a nice and handy site!
        
       | gowld wrote:
       | "is ${FOO}topea" a new trend in naming things, a play portmonteau
       | / prtmontrois on "utopia" / "footopia"
       | 
       | Example photopea.com
        
         | raymondmoay wrote:
         | Just like the naming tbh... it's kinda cute and the domain is
         | available.
        
         | cobertos wrote:
         | TIL that photopea is not "Photo Pea"
        
       | johnwheeler wrote:
       | This is amazing! I love that you can plot the data on a graph
       | with 2 clicks.
       | 
       | If you're into superinvestor activity like gurufocus, I can
       | recommend something in the same simple, bare-bones spirit as this
       | site (though it is ad-driven). Check out https://dataroma.com
        
       | i-das wrote:
       | The corresponding source code seems to be here:
       | https://github.com/RaymondMoay/fintopea
        
         | raymondmoay wrote:
         | Wow resourceful! I open sourced this to get my first job in
         | code. Gonna private it for now, and consider open sourcing it
         | again when I secure some requirements.
        
           | dmane11 wrote:
           | I need to build something similar for my job, so this already
           | gave me couple of ideas. Thank you for sharing this! How did
           | you aggregate all of this data? Did you fetch it from EDGAR?
           | Or do you have a subscription to CapIQ or something?
        
       | gyosko wrote:
       | Very nice! Where did you pull your data from? Are there any good
       | financial api/datasets out there available for financial data?
        
         | traceroute66 wrote:
         | > Are there any good financial api/datasets out there available
         | for financial data?
         | 
         | I assume you mean other than the usual suspects ? ;-)
         | 
         | Try IEX Cloud or Quandl, both are quite US-centric although
         | Quandl does have a small amount of international stuff.
         | 
         | But really, for consistent quality and coverage its hard to
         | escape the usual suspects.
         | 
         | P.S. Don't forget to read the small print properly ! Many
         | companies make a differentiation between internal use and
         | publishing on the web for others to consume.
        
           | DennisP wrote:
           | Ok so...what are the usual suspects?
        
             | traceroute66 wrote:
             | Bloomberg, Refinitiv, CapitalIQ, Factset
        
         | Mo3 wrote:
         | Not OP, but I am in charge of engineering and operating a high-
         | performance quantitative algorithm engine at my company and I
         | can wholeheartedly recommend https://polygon.io.
         | 
         | We continously pull their whole dataset in one minute intervals
         | as well as receive real-time feeds for the whole universe over
         | websockets and they haven't complained once.
        
           | lvl102 wrote:
           | I am going to say not if you're running high $$$ boxes. I
           | would not rely on Polygon for anything beyond PA.
        
             | melony wrote:
             | How accurate are their fundamentals calculations?
        
             | Mo3 wrote:
             | I was talking about PA. They have proven themselves very
             | reliable for it so far.
             | 
             | Fundamentals and other information is being pulled directly
             | off NASDAQ etc, of course. Polygon does not offer a lot of
             | data in these regards.
             | 
             | Realistically for $$$ systems you want to have more than
             | one source for every datatype anyway and then aggregate the
             | data yourself.
        
               | Rocket89 wrote:
               | PA?
        
             | froh wrote:
             | Why?
        
       | traceroute66 wrote:
       | First questions:                      - What's the data source
       | for this ?            - What's the restatement policy of the data
       | display?            - Why the limitations on period types ?
       | - Any plans to add common size display option ?
       | 
       | Second, an observation. Please don't take this the wrong way, but
       | I'm tired of seeing yet another financial website that only
       | covers US companies.
       | 
       | Any man and his dog can provide data for US companies, there's a
       | whole world out there and its tiresome to constantly see these
       | US-centric views of the financial wold.
       | 
       | Whilst I appreciate you might claim you're only doing it for
       | launch or whatever, I'd still rather you launched with a wider
       | perspective than just US.
        
         | supertofu wrote:
         | Be the change you want to see in the world.
        
         | Rocket89 wrote:
         | I mean.. the largest most liquid market in the world is the us
         | equities market.. every foreign investor worth his salt (and
         | his time) spends time researching and ultimately investing in
         | us equities. Not to mention every country has their own
         | accounting/financial disclosure laws so the data will
         | inherently be untrustworthy. Hell even Canadian financials are
         | hard to discern from the American pov given FFRS (or whatever
         | the foreign reporting system is called).
        
       | user3939382 wrote:
       | I'm reminded of an analysis I heard about GE from a friend of
       | mine in finance. He said for a while (many years ago) everyone
       | knew the earnings were cooked because the consistent performance
       | was basically impossible, but everyone was making money and went
       | along with it. He said one way they were able to cover their
       | tracks is every so often changing their accounting methodologies
       | enough so that long term comparisons like this were rendered
       | useless for forensic accounting purposes. I find that all very
       | interesting if it's true.
        
         | raymondmoay wrote:
         | You are right, this is as general as it can get for the initial
         | screening phase for me. I then deep dive into the reports.
        
         | rapht wrote:
         | All companies cook their earnings to a certain extent, exactly
         | in view of having a nice, regular, consistent performance...
         | because markets over-react (in one way or another) to anything
         | that is not nice, regular, consistent.
         | 
         | The only thing not subject to interpretation is cash, but you
         | have kind of the reverse problem: most of the time, it's
         | difficult to intepret anything from it... of course, that's why
         | modern accounting was invented. As we say in French: c'est le
         | serpent qui se mord la queue (the snake's biting its own tail).
        
         | deepsun wrote:
         | Yes, but at the same time there are GAAP (generally accepted
         | accounting principles), limiting how much you can change the
         | methodologies, so you can rig only so much.
        
           | Rocket89 wrote:
           | One of the new laws regarding accounting was daily mark-to-
           | market accounting of assets and investments. $AMZN just took
           | a $7.6B hit due to this ($RIVN write down). So it's hit or
           | miss. I remember Buffett complaining about this change a year
           | back or so.
        
             | Ntrails wrote:
             | Is this the same magic that means microsystems has to take
             | a MtM writedown every time its bitcoin tanks, but cannot do
             | so when it goes up? xD
             | 
             | I am generally pretty pro expecting the MtMing of liquid
             | assets, but very sympathetic to areas where hard to price
             | illiquids are unpleasant
        
         | rudyfink wrote:
         | You might enjoy a book called Financial Shenanigans
         | (https://www.amazon.com/Financial-Shenanigans-Fourth-
         | Accounti...). It's essentially examples of detective stories
         | based on financial statements.
        
         | somethoughts wrote:
         | One thing to watch out for - is to look at continued growth of
         | the line item - Goodwill and Intangibles on the balance sheet.
         | Goodwill is when it pays well over book value to buy another
         | company. Intangibles are hard to value assets like IP (a movie
         | library, patents, etc.).
         | 
         | Excessive goodwill occurs when a legacy company can no longer
         | organically grow earnings so it has to buy other companies
         | (perhaps over paying) to show earnings growth.
         | 
         | Intangibles can make a debt laden balance sheet less negative
         | if the value of "synergy and secret sauce" are over stated and
         | never written down.
         | 
         | You can see GE's Goodwill and Intangibles peaked in 2017 when
         | Jeffrey Immelt got replaced and John Flannery started to do the
         | write-downs for which he was sacked. Larry Culp seems to be
         | doing it more even handedly.
         | 
         | https://www.wsj.com/articles/how-ge-built-up-and-wrote-down-...
         | 
         | https://www.macrotrends.net/stocks/charts/GE/general-electri...
        
           | lotsofpulp wrote:
           | Governments do this with deferred compensation schemes like
           | defined benefit pensions and retiree healthcare. There are
           | conveniently no laws around calculating the cost of benefits,
           | and of course no recourse for today's leaders not funding
           | them in the first place, so they can hide a lot of today's
           | labor costs in understated pension and retiree healthcare
           | liabilities.
        
         | easytiger wrote:
         | Another trick is constantly buying companies/writing off stuff
         | and abusing "goodwill" to give hard to compare yoy accounts. I
         | can think of a number of companies who did things like that
         | (e.g. Steinhoff) that later got found out (though they did
         | other things too like pushing debt off their balance sheets to
         | patsy companies)
        
       | samfisher83 wrote:
       | This is pretty awesome where is the data coming from?
        
       | gbasin wrote:
       | Great tool, thanks for building
        
       | reducesuffering wrote:
       | Two great features would be calculations of the ratios like P/E,
       | YoY revenue growth, YoY profit growth, and side by side
       | comparison.
        
         | raymondmoay wrote:
         | Coming right up
        
       | ne0flex wrote:
       | Nice site. I'm actually in the process of building almost the
       | exact same type of application, guess I'll have to find a new pet
       | project.
        
       | sgallant wrote:
       | This is very well done!
        
       ___________________________________________________________________
       (page generated 2022-04-28 23:00 UTC)