Stock Quote Function in Excel

Avg Bid (USD)
Project Budget (USD)
$30 - $100

Project Description:
Wanted: a function that returns the value of the last trade price for that stock given a stock symbol . This function should be available in Excel. I'd prefer the function be available via an add-in so that I can call it from various spreadsheets easily. You can assume an internet connection when the function is called. I don't have a strong preference for the site used (e.g. yahoo, msn, etc). I plan to call the function many times within the same spreadsheet for different symbols. The values (quotes) should be refreshed when the spreadsheet is recalculated. I will pay more for features such as a parameter for getting the bid, ask, volume, or time of last trade instead of the last price. I will be building spreadsheets based on the stock quotes. It is important that the function not affect any part of the spreadsheet except the cell from which it was called. The program needs to be documented in English particularly where parsing is done. If the source site changes its layout then we will have to know what code to modify. =StockQuote(symbol) or =StockQuote(symbol, type) where type is a parameter equal to last, bid, ask, volume, or time. Last is the default if the type is omitted.

## Deliverables

Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.

## Platform

Microsoft Excel 2002 for Windows.

Skills required:
Apple Safari, Engineering, Google Chrome, Microsoft, MySQL, PHP, Software Architecture, Software Testing, Visual Basic, Windows Desktop
About the employer:
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.

$ 63.75
in 14 days
Hire rkumarvw
$ 42.5
in 14 days
Hire jsmorgan24
$ 72.25
in 14 days
Hire jademtech
$ 17
in 14 days
Hire tzachh
$ 42.5
in 14 days
Hire bijak
$ 29.75
in 14 days
Hire customcodervw
$ 46.75
in 14 days
Hire bengreyling
$ 85
in 14 days
Hire nettyvw
$ 425
in 14 days
Hire jayjuch
$ 63.75
in 14 days