Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #69: Web Stock Data

MattD
Alteryx Alumni (Retired)

Here's a solution!

 

Spoiler
Challenge 69 Solution.PNG

 

Former Alteryx, Inc. Support Engineer, Community Data Architect, Data Scientist then Data Engineer
estherb47
15 - Aurora
15 - Aurora

Well, the yahoo link doesn't seem to be working for me today, so I connected through Yahoo Finance and downloaded the HTML. 

A bit of cleaning, a bit of RegEx, and voila! A useable table. When I can actually connect to the API, I will post a new solution.

 

Spoiler
Spoilerimage.png
sehengratis
5 - Atom

I totally agree with you DanG

 

a-ok-emoji-arancho-doc-translation-localization-services.png

Pavel_G
6 - Meteoroid

Yahoo API doesn't work and I used "Barchart on demand". It's free, but requires registration.

The solution can be improved by creating input for dates, splits, dividends, time-frames (weekly or daily).

 

Spoiler
symbols.pngInkedFormula Tool_LI.jpgScreenshot - 2017-05-31 , 15_24_35.pngfinal table.png

 

LordNeilLord
15 - Aurora

Hey @MattD,

 

The Yahoo link is dead for this challenge!

 

Any chance you could supply an alternative?

JoeM
Alteryx Alumni (Retired)

It's come to my attention that the Yahoo Finance API closed down. Instead, I've updated the original post to use a call to the Google Finance API. The differences between the APIs are minimal and you can expect one less field from the Google API.

Get back to it @LordNeilLord!

LordNeilLord
15 - Aurora

Nice and straight forward approach :)

 

Spoiler
Weekly Challenge 69.png


Thanks for updating the link @JoeM

 

@SeanAdams 71 down, 3 to go!

vishalgupta
7 - Meteor
 
A_Twa
8 - Asteroid

Great challenge, I hadn't yet had an opportunity to use the download tool. Thanks!

nick_ceneviva
11 - Bolide

Solution attached!