Challenge #69: Web Stock Data

[acarter881]

This one's pretty tough - the Browse tool in the sample output helped a lot.

Spoiler

[leonhekkert]

Here's my solution.

Borrowed a piece of someone elses macro. This workflow determines the amount of columns to parse (based on number of ',') and uses that information in the macro where the parsing happens.

It is, however, very slow. Does someone have an idea about a faster approach?

Spoiler

[rachel_lynch]

Spoiler

[AnnaELawrence]

Spoiler

[FrederikE]

Spoiler

[ExploreMore]

Spoiler

 

[martinding]

Spoiler

Seems like the link is broken again...

[Brian32]

Challenge Solution:

Spoiler

[CMWalsh]

Had some issues with the link, as others have noted.

Ended up working with a different link (thanks to user ExploreMore for listing an alternative in their solution screenshot), and unsure if it was identical data or just very similar.  My output is not exactly the same, but this was a good challenge.

Spoiler

[Abiramm1]

The link was busted for me - but in the spirit of the game I've provided an iterative macro that I used to parse cheese information from www.cheese.com. The iterative macro deals with pagination and could be a cool future challenge