[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)