What I want is to create a dashboard in excel to view company information for companies listed on the Australian Stock Exchange.
Very similar to this: http://www.get-digital-help.com/2010/02/16/create-a-dynamic-stock-chart-using-a-web-query-and-a-drop-down-list-in-excel/
I want to have a tab in excel where I can choose any Australian company listed on the ASX through a drop down menu and it will pull data from Yahoo Finance through a web query on that company (Modified through the URL).
See attached: When the yellow drop down list is changed to a different company, the query should pull new data (and a graph)
I honestly think this is a relatively simple project for an experienced user in excel.
Skills: yahoo, finance