Excel Macro Web Query

Excel Macro Web Query

Closed - This job posting has been filled and work has been completed.

Job Description

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

Open Attachment