Live data from Hacker News

Show HN: I built a website to create financial models for any stock online

useequityval.com

131–140 of 166 posts

Re: Show HN: I built a website to create financial models for any stock online

#131

Earlier quoted context omitted.

Any way do regional and or segment breakouts? The way I see your tool, it's a great tool for the back of the napkin-ers but as it is right now, it doesn't obviate modeling because you're still going to have to do the breakouts in excel. Also, I think it'd be great to set your defaults assumptions for a stock to breakeven pricing, and allow users to adjust from there. I see a tool like this being useful, but I think p…

You'd be surprised to learn then that most PE deals run on the back of literal pen and napkin models. In our process at my former firm, one of the largest megafunds out there, we would scout and model new opportunities using elaborate models, report them to the MDs who would then literally whip out a notepad or a napkin mid-presentation to decide whether the investment had potential. If it was in the grey zone, it wa…

That doesn't surprise me at all, I've heard it's the same in private credit. I think a lot of the initial ground work that's done in due diligence and modelling is more to flush out any red flags than to inform the investment decision itself, and a model is only as good as its assumptions anyway...

Re: Show HN: I built a website to create financial models for any stock online

#132

I’m consistently surprised at the lack of basic financial literacy in the HN crowd. The title says this is a tool to create financial models , not that it is a well-tuned financial model. Yeah, you have to make better assumptions than straight-line extrapolation from last year’s trend to arrive at reasonable valuations. The point is that this shows you what assumptions you have to make to arrive at a rationally-calcu…

>The models that make the big bucks are the ones that ingest a ton of other external data to predict the numbers that go in the data entry cells here. And yeah, those don’t get posted online for free. Do such models even exist? As far as I know NN are only good at function approximation. Why do we think that the market evolves according to a mathematical function? To me, financial markets seem chaotic in nature.

Yes but it's not really about the number crunching itself (NN's or something else), but more about modelling the "wider world" ("macro") outside the company that could drive its business. Like if you wanted to project an oil company's cash flows into the future, you'd do a lot of analysis and number crunching on things like IEA projections, known oil reserves, risk scenario analysis and the like.

Re: Show HN: I built a website to create financial models for any stock online

#133

Very nice, coincidentally I have been thinking about making a similar tool lately, but I'd make it quite a bit more conservative. I'd want to be able to define a model like "I think the fair value of a company is its net current assets plus its last 5 years of earnings", and have the tool email me whenever I can buy shares in any company substantially below that price, or sell them substantially above. It wouldn't be…

> I'd want to be able to define a model like "I think the fair value of a company is its net current assets plus its last 5 years of earnings", and have the tool email me whenever I can buy shares in any company substantially below that price, or sell them substantially above.

Be careful with investing using a model like this: you're basing the value of the company entirely on its historical performance and not at all looking at what its future may look like. It's a great way to end up in value traps.

Exaggerated example, you see Intel's stock price has taken a huge dive that puts it under your limit so you buy a bunch of the stock. But it turns out the reason Intel is now cheap is because ARM, AMD and NVidia have eaten its lunch, and its future looks incredibly shaky.

Likewise, selling stocks that are substantially above some past valuation is also a good way to exit from positions that are likely to continue to outperform. Stocks get "re-rated" by the market when their future prospects have improved. That's not a great time to exit the stock - if anything it's a time to buy more.

YMMV, value investing is still successful of course, but you do need to look forwards not backwards.

Re: Show HN: I built a website to create financial models for any stock online

#134

I’m consistently surprised at the lack of basic financial literacy in the HN crowd. The title says this is a tool to create financial models , not that it is a well-tuned financial model. Yeah, you have to make better assumptions than straight-line extrapolation from last year’s trend to arrive at reasonable valuations. The point is that this shows you what assumptions you have to make to arrive at a rationally-calcu…

[deleted]

Re: Show HN: I built a website to create financial models for any stock online

#135

I’m consistently surprised at the lack of basic financial literacy in the HN crowd. The title says this is a tool to create financial models , not that it is a well-tuned financial model. Yeah, you have to make better assumptions than straight-line extrapolation from last year’s trend to arrive at reasonable valuations. The point is that this shows you what assumptions you have to make to arrive at a rationally-calcu…

Please don't sneer, including at the rest of the community.

https://news.ycombinator.com/newsguidelines.html

Re: Show HN: I built a website to create financial models for any stock online

#137
post #117

Earlier quoted context omitted.

This caught out the current Show HN poster, so I imagine the comment could be useful to future Show HN posters. Besides, the comment wasn't unkind to the present poster and is actually kind to future posters, so the admonishment and down-votes seem unwarranted.

My tip is to re-evaluate why you think you are getting downvoted to better understand your tone and wording rather than assume the downvotes are not warranted.

I'm not the one getting down-voted.

Re: Show HN: I built a website to create financial models for any stock online

#139
post #131

Earlier quoted context omitted.

You'd be surprised to learn then that most PE deals run on the back of literal pen and napkin models. In our process at my former firm, one of the largest megafunds out there, we would scout and model new opportunities using elaborate models, report them to the MDs who would then literally whip out a notepad or a napkin mid-presentation to decide whether the investment had potential. If it was in the grey zone, it wa…

That doesn't surprise me at all, I've heard it's the same in private credit. I think a lot of the initial ground work that's done in due diligence and modelling is more to flush out any red flags than to inform the investment decision itself, and a model is only as good as its assumptions anyway...

Spot on. We used a bunch of screening processes to mine opportunities, then use models to weed out the duds, or to buttress our investment thesis before presentation to the MDs.
Post reply on HN