Excel Macro Web Query
Closed - This job posting has been filled and work has been completed.
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/20
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