Excel: Extracting Stock Information
Obtaining information about publicly traded companies within Excel
The learning path in Excel is never ending. One has to remain humble and keep all doors open with this tool. I haven’t been using Excel that much lately. This is what happens when you only use Tableau and SQL… What new features am I missing in Excel to learn?
This week I learned how to obtain stock information for a given company via Excel. The use case was to generate a quick table of publicly traded companies with their corresponding ticker symbol, stock price, employees, industry and address.
What I found frustrating was not being able to extract revenue, WHY? Unless someone has a trick, let me know in the comments.
You can watch the video below on how to do this: