Challenge #482: Company Share Price Analysis

[martinson]

Having some issues getting the data, looking forward to getting it set up and having a crack

[dkienstra]

@Pilsner How did you input the data from the ZIP-file whilst making the distinction between the several companies still possible. When I import the ZIP-file as a whole, the output for the File Name is 'Archive. See image below as a demonstration:

'

[pilsworth-bulien-com]

Hello @dkienstra 

Great question. Once I'd downloaded the data from Kaggle and then unzipped it, I used the following configuration in a standard Input Data tool:

Spoiler

The * acts as a wild card to get all files within the archive folder that end in "data.csv". Then option 4 lets you choose what to include, filepath/ name wise. 

 

Please let me know if this doesnt work.

Regards - Pilsner

[olga_strubbe]

Gotcha, thank you, @JBevan89     

[JGonzalez1015]

My solution

Spoiler

[myastarling]

Here's my solution. I am not sure what formula I should have been using for volatility because I got dramatically different results - I used what I was taught in business school for annualized volatility which was the standard deviation of the difference in the closing price * the square root of the number of trading days. I wouldn't normally use these entire datasets to compare the volatility of the different stock and these are all capturing different time periods but I don't have enough information otherwise.

[Yogesh1795]

Answers are different from Output, maybe because of data

[dkienstra]

@Pilsner, many thanks! The wildcard solution works perfectly.

[RebekaMazuchova]

:)

[Erin]

I got 1-4 but it took me way too long just for those (series of rookie mistakes). I didn't attempt question 5. If Pilsner struggled, then I don't stand a change. 😂