20-minute delayed stock and option quote downloader for Excel - repost 2

Closed

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: Word

See more: option quotes excel, yahoo-finance, windows 8 price, simple stock ticker, price for vba for excel, microsoft excel for windows 8, excel macro to word, excel for windows 8, Cboe, bid quote, vba for word, microsoft excel vba, microsoft excel price, macro microsoft word, find in vba, excel 2013 vba, vba word, spreadsheet microsoft excel, minute, finance in excel, finance excel, excel finance, excel and word project vba, Excel and VBA, Excel add-in

Project ID: #4456991

2 freelancers are bidding on average $93 for this job

buyaspreadsheet

Why pick me? Simply because it is done, see PM. Kind regards, Andrew

$75 USD in 1 day
(0 Reviews)
0.0
blforce

Hello miazeem, sounds like a fun project to work on! I have experience writing advanced plugins for office that handle large amounts of data. This will be simple by comparison. Let me know when you want me to get start More

$110 USD in 3 days
(0 Reviews)
0.0