Challenge #69: Web Stock Data

[ExploreMore]

The URL is broken again and it looks like it has been for a while. Can you please fix this? So many eager participants with no way to participate in this challenge!

ETA: I am tagging the account that now posts the latest challenges in the hopes that it will call more attention to the issue. It's possible that the retired users from years ago were getting notified but not the new account.

@AYXAcademy 

[BenFr]

Used an alternative mushroom link: https://datahub.io/machine-learning/mushroom/r/mushroom.csv 

Spoiler

[kcfuiks]

Attached data to be parsed for others looking to complete this challenge. 

[Shelbey]

Spoiler

I would have solved this challenge, but sadly, my access was denied... 

[MatthewBr]

Access Denied - Booo

[ARussell34]

I did it in three tools! However, I didn't round the outputs to have the same decimal places for all cells, but otherwise the output is almost an exact match for the Alternate Output.

[brandowd]

Like others I got access denied for the original URL so I tried those supplied by @Jonny and @BenFr. Although the one by BenFr wasn't the same as the 'completed' one it still was a useful exercise to have a go at both.

Whilst organising the field names I initially used the "save field configuration" ('Select' tool) and then edited the xml file but to be honest I found it far easier just to copy the text from the 'XML View' and then manipulate it in Vim. Saving to a *.yxtf seems to be ok as long as you don't start to want to order fields as then things go a bit wrong. 

Spoiler

[TimN]

Spoiler

Used Jonny's URL

Thanks to @Jonny for a working URL.

[MichelleL]

Used URL/data from @Jonny to solve.  Similar to original data.  

URL: https://query1.finance.yahoo.com/v7/finance/download/SAND.ST?period1=1592992927&period2=1624528927&i...

Replace the URL in the text input tool with this one & solve away!

[simon_inviso]

Unfortunately i got an "access denied" as many others. Too bad!