Viewing a single comment thread. View all comments

Coolguy69Christ t1_j2duju9 wrote

Reply to comment by prescience6631 in Financial modeling by Ok_Mathematician431

Bro here’s v2-edit12312022

=isnumber(iferror((1+rand()-.5)^(1/252)-1,0))

2

prescience6631 t1_j2dut8g wrote

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!

2