Solution

(swoosh)…- [Instructor] So remember the challenge here,…was to make the bot a bit more robust,…by allowing it to check,…that the particular ticker actually exists…in the Quandl database,…and producing some kind of useful error message…back to the user if they ask for a ticker…that we just simply don't know about.…And I also gave you your starting clue,…which is that if you go to this URL here,…Quandl will give you a zip file…listing all the supported tickers.…Let's go ahead and open that.…

The zip archive.…With one file,…and we can make some observations about that file.…Well, it's clearly a CSV.…Column A contains a list of tickers,…but they're orchestrated slightly by the fact…we've got the word WIKI/ in front of it,…so we're going to have to deal with that.…We'll also observe that there's no header on there,…so if we're going to read this…with something like the CSV provider,…we will need to do something about that fact.…Let's see if we can make a set of supported tickers.…

We might as well call it tickers.…Whenever you're wanting to get something from the internet,…