Challenge #482: Company Share Price Analysis

[alineruizcampos]

Like others, could not get the variance to match :(

Spoiler

[Bobbyt23]

Lots going on in this one. Not sure on part 5!

Spoiler

[DaisukeTsuchiya]

I can't match the answer.

Spoiler

[AkimasaKajitani]

My solutioin!

Unfortunately, I don't know how to calculate the exact volatility value.

Spoiler

[abacon]

This one took some thinking, I don't think I got question 5 exactly right but this was fun.

Spoiler

[AnaKomissaroff]

That was fun!
Here is my solution

[KLTerrell]

Whew! THANK YOU @JBevan89 for adding the comment for the Q5 formula. The instructions to use Open, Close, High, and Low are misleading and I went down a way too long rabbit hole before checking that comment!

This was super fun.  Thanks!

Spoiler

My file has my first (way more complicated .... I should say way *over-complicated* attempt at Part 2. I first read it as max day - min day instead of the difference across each day.

[RolandSchubert]

Spoiler

[ahsanaali]

Spoiler

 

[RWvanLeeuwen]

First, I'd like to mention that this type of challenge is much more approachable when KPIs are clearly defined.

Here's my take:

Spoiler