Comments

You must log in or register to comment.

Impossible-Lab-7819 t1_j2dglgj wrote

Homie opened up excel for the first time ever and ran straight to Reddit

47

plinkoplonka t1_j2dg48q wrote

This is one of the most vague posts I've ever seen.

(And it's not really related to futurology.)

What specifically is the problem you're trying to solve? Why can't you fix the problem yourself? Why would someone else be able to solve it any easier than you would?

And how is this futurology if it's just a problem you're having now?

It sounds like you're just frustrated with excel...

21

prescience6631 t1_j2dit9k wrote

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.

10

Coolguy69Christ t1_j2duju9 wrote

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

longblackdog t1_j2dvzx4 wrote

I do this for a living and love it. How can I help? Also why is this in this sub?

2

wannabecpa93 t1_j2dp25k wrote

What time of modeling. Also if you’re just trying to do a DCF the Present value you’re looking for is not the “future” of this sub you think it is.

Try a Fillmore finance related sub, also try making your question a bit more specific. There’s so many different types of financial models.

1

Eddy_Bl t1_j2duj0r wrote

Expectation: financial modelling sucks

Reality: what happens if I don't put the parenthesis between the 2+2 and the x2

1

Futurology-ModTeam t1_j2dx4s9 wrote

Rule 2 - Submissions must be futurology related or future focused.

1