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

Normster
8 - Asteroid

This one seemed pretty direct. I noticed that I completed it half the steps.

Spoiler
Spoiler Alert!

 

Normster_0-1600370330198.png

 

OwenBData
8 - Asteroid

My submission!

 

Christoph_Ebersbach
8 - Asteroid

Attached 🙂

Thanks!

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_1-1600872056978.png

 


 

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission

Tony_Castillo
9 - Comet

I tried to stick to the original challenge of pulling stock data. Instead of using Yahoo Finance, I pulled the NASDAQ OMX global index values over time using the quandl API. It was one of the free datasets available. The free dataset did not include the additional fields of open, volume, etc but I think this gets the subject points across from the original challenge.

 

https://www.quandl.com/data/NASDAQOMX-NASDAQ-OMX-Global-Index-Data 

 

Spoiler
TC_bot_0-1601475606921.png

 

simbert
8 - Asteroid

Nice easy challenge to start the day!

Spoiler
simbert_0-1601540338446.png

 

rajatsadan
8 - Asteroid

@MattD  Interesting challenge!!

 

I had a query regarding the final results. 

Spoiler
I arrived at the solution using multiple  'Text to Column' and 'Select' tool to arrive at the solution which matches with the output in Start File. However, when I checked the Challenge_69_Solution file provided, the solution was arrived using multiple 'Summarize' and 'Union' Tools. Is there something I am missing in my workflow? Or does it seem right to proceed with the same workflow?? Kindly help out. Much Appreciate!!
OwenBData
8 - Asteroid

My Solution:

Spoiler
Challenge 69.PNG
WernerE
8 - Asteroid

Thanks