Excel Macro Web Query

Closed - This job posting has been filled and work has been completed.
Data Science & Analytics Quantitative Analysis Posted 2 years ago

Fixed Price

Delivery by April 7, 2013

$30.00

Budget

Details

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


About the Client

(5.00) 5 reviews

Australia
Sydney 02:08 PM

8 Jobs Posted
75% Hire Rate, 1 Open Job

Over $10,000 Total Spent
8 Hires, 1 Active

$7.44/hr Avg Hourly Rate Paid
1,874 Hour

Member Since Aug 28, 2012