Challenge #482: Company Share Price Analysis

[SteveY02]

Completely confused about Question 5. There are several methods to calculate volatility; I think the author needs to specify which formula we should use.

[Carolyn]

Solved

Huge thank you to @Kenda for posting the Input files!

Spoiler

I had some rounding differences in #2 and #3.

For #5, I did 100 * ([High] - [Low]) / [Close], which got me close to the solution in the file

[Qiu]

There are some parts I was not able to fully understand. 😁

Spoiler

[alexnajm]

Done, with some help from the previous posts about the volatility formula! Still not sure what the correct formula is though...

Spoiler

[patrick_digan]

Spoiler

[Tedevans]

Spoiler

Great challenge!

Used the same volatility equation, as one I found in the comments:

100 * ([High] - [Low]) / [Open]

[TurboToad]

#482

Spoiler

[Kamran1991]

My solution

[Linas]

Good challenge, but some numbers are not perfectly the same because of rounding.

Spoiler

 

[TH]

In this one the main issue is, more than anything else, figuring out what question is *actually* being asked.

This is why I included comments in my submission for what each sub-question actually means.

Here are some hints relating to what I discovered. (You can get some more detail by looking at my workflow.)

Q1 - This question does NOT mean the lowest and highest values over the life of the stock.

Q2 - "Cumulative Gain" in this context refers to daily amounts. The closing amount on one day is not always equal to the opening amount the next day. 

Q3 - Average daily

Q4 - This refers to the month and NOT to the year-month. E.g. 2019 June and 2002 June are considered together.

Q5 - Many ways exist to calculate volatility, and the challenge does not indicate which is the correct value.