prescience6631
prescience6631 t1_j2dut8g wrote
Reply to comment by Coolguy69Christ in Financial modeling by Ok_Mathematician431
Appreciate the version tracking; however, you’re still gonna want that -100% instead of 0!
No reason daily returns should be floored at 0 — this is a sophisticated and conservative model!
prescience6631 t1_j2dit9k wrote
Reply to Financial modeling by Ok_Mathematician431
In excel use the below formula:
= Iferror((1+rand()-.5) ^ (1/252) - 1,0)
The above perfectly models your daily returns
Edit: like any good financial model the first draft has a massive/glaring error. The iferror statement should be (XXX, -100%) in this case (let’s call this v2) — hopefully no one made critical life investment decisions based on the v1 model.
prescience6631 t1_j0bjzmt wrote
Reply to comment by Stopa42 in 5 second toaster and kettle by F1NNTORIO
Setting my house on fire for 5-second kettle is a reasonable tradeoff, where do I sign up?
If I nuke my neighborhood can I have 5-second pizza or hot pockets?!
prescience6631 t1_j6hw0qy wrote
Reply to comment by Omniouz in Venus fly trap on the hunt by c0ntr0ll3dsubstance
This always makes me a little sad….no justifiable reason but it does