Excel Macro Web Query

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

Fixed Price

Budget: $30
Delivery by April 7, 2013

Start Date

April 4, 2013


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

Sydney 05:52 AM

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 Hours

Member Since Aug 28, 2012