8 ms·
Show HN: Free 30-year financial statements visualization
- Rastonbury 4y agoI get an error when trying to create a custom metric for unlevered free cash flow. "Invalid left-hand side expression in postfix operation"
- gyosko 4y agoVery nice! Where did you pull your data from? Are there any good financial api/datasets out there available for financial data?
- Mo3 4y agoNot 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 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 4y agoI am going to say not if you’re running high $$$ boxes. I would not rely on Polygon for anything beyond PA.
- melony 4y agoHow accurate are their fundamentals calculations?
- froh 4y agoWhy?
- Mo3 4y agoI 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 4y agoPA?
- kleinishere 4y ago"personal account" - vs. the fund(s) an investor may work on as part of their day job
- Mo3 4y agoOh.. I meant price action. But I guess it’s true for both!
- traceroute66 4y ago> 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 4y agoOk so...what are the usual suspects?
- traceroute66 4y agoBloomberg, Refinitiv, CapitalIQ, Factset
- traceroute66 4y agoFirst 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 4y agoBe the change you want to see in the world.
- Rocket89 4y agoI 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).
- deleted 4y ago[deleted]
- formerkrogemp 4y agoIFRS is used in over 100 countries. Parts of it's implementation are left to the individual countries, but the US is the only country to use GAAP. Every country has some room for individual regulstion of the financial standards of course, but that doesn't make, say, dutch securities less inherently trustworthy than US securities because they don't report on a GAAP basis.
- samfisher83 4y agoThis is pretty awesome where is the data coming from?
- catchmeifyoucan 4y agoAlso curious to know - seems like it's not up to date
- gbasin 4y agoGreat tool, thanks for building
- randoglando 4y agoThis is amazeballs!
- user3939382 4y agoI'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.
- deepsun 4y agoYes, 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 4y agoOne 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 4y agoIs 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
- formerkrogemp 4y agoThe accounting of "cryptocurrency" is still being developed, but, yes, Bitcoin holdings take an impairment when their value drops below a certain point. This doesn't typically affect cost basis. It may be deducted as losses on a tax return but that might impact cost basis. I've heard from other accountants (a year or so ago, so take this with a lump of salt) that some companies are trying to account for cryptocurrency as inventory, as a "hot asset," as cash equivalents, or as intangibles.
- gowld 4y ago"is ${FOO}topea" a new trend in naming things, a play portmonteau / prtmontrois on "utopia" / "footopia" Example photopea.com
- cobertos 4y agoTIL that photopea is not "Photo Pea"
- raymondmoay 4y agoJust like the naming tbh... it's kinda cute and the domain is available.
- johnwheeler 4y agoThis 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 https://dataroma.com
- Seanambers 4y agoThis is a nice and handy site!
- reducesuffering 4y agoTwo great features would be calculations of the ratios like P/E, YoY revenue growth, YoY profit growth, and side by side comparison.
- raymondmoay 4y agoComing right up
- sgallant 4y agoThis is very well done!
- yessql 4y agoThis is fantastic. Would love to be able to have logarithmic y-axis!
- raymondmoay 4y agoWill do~
- RyanShook 4y agoGreat resource and love the interface. Thanks!
- random314 4y agoThis is great. For 30 year time horizons, a log plot will be useful
- ars 4y agoPlease add logarithmic plots - and IMO they should be the default.
- raymondmoay 4y agoWill do!
- i-das 4y agoThe corresponding source code seems to be here: https://github.com/RaymondMoay/fintopea https://github.com/RaymondMoay/fintopea
- raymondmoay 4y agoWow 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 4y agoI 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?
- atonse 4y agowhoa you built this to get your first job? excellent job!
- throwaway8486 4y agowhy make private?
- gennarro 4y agoOh very cool. Not available now. Anyway to see the codebase?
- ne0flex 4y agoNice 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.
- ge96 4y agoI 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 4y agoThanks! Made this for myself while learning testing.
- Rocket89 4y agoThis 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!!
- bryceneal 4y agoAs someone who has spent some time looking at some of the more popular alternatives for this type of information (i.e. the top results when googling), I find the simplicity of the UI here pretty refreshing. I think the name to be a little odd, though. It's a little forgettable and the meaning is a little unclear. I might suggest trying to think of a different name.
- 2Gkashmiri 4y agoNice. I would love to have a "ratios" tab just for the kicks, NP ratio, gp, stock turnover, working capital turnover, income tax paid ratio, earnings, pbt ratio, pat ratio, depreciation to sales. That said, as someone who makes financial statements for a living, there is a lot of room for "adjustment" if you are determined and even to an extent that while preparing fs, we can just decide if we want to pay less income tax so we can increase expenses by reducing cash and leave the entries to be made by management later just to secure our records
- maddynator 4y agovery nice. Simple and clean
- lappet 4y agothis is super cool. can you share what you use to build the front end? I love the data layout and graph plotting.
- abc03 4y agoThis is great! One question: How would you save best the financial statements in the DB?