20-minute delayed stock and option quote downloader for Excel

IN PROGRESS
Bids
1
Avg Bid (USD)
$75
Project Budget (USD)
$30 - $250

Project Description:
Project Background:

Some years ago Microsoft offered an add-in for Excel that allowed near-real time (20 minute delayed) stock and option quotes to be downloaded into an Excel spreadsheet. Microsoft subsequently stopped supporting the application, but it continued to work for me in later versions of both Excel and the Windows operating system. Recently, however, I upgraded my operating system (Windows 8) and find that the add-in no longer works with my version of Excel (2007).

Project Description:

I require a simple add-in or VBA module in which I can:

a) enter a ticker symbol (either stock or option) into cell A1.
b) retrieve (from a website such as Yahoo! Finance, CBOE, or other) the 20-minute delayed bid and ask price and insert these values into cells B1 and C1, respectively.
c) retrieve these bid and ask values any time that the ticker symbol changes, and/or I choose to retrieve more recent updates by invoking the macro / add-in.

The add-in should be able to accommodate multiple tickers that might be added as additional rows in column A.

Skills required:
Excel
Qualifications required:
us_eng_1 US English - Level 1
Hire JHLLC
Project posted by:
JHLLC United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 75
in 1 days