In Progress

Stock Quote Function in Excel

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

See more: microsoft excel spreadsheet, bid quote, ask excel, excel stock quote, microsoft spreadsheets, microsoft excel price, visual basic form excel, strong g, spreadsheet microsoft excel, excel function, excel add-in, excel add in, symbol part, add stock, call function, excel spreadsheet source code, trade stock, excel cell, work quote, stock spreadsheet excel, stock excel, add quote, excel yahoo spreadsheet, excel stock symbol price, excel connection

About the Employer:
( 1 review ) United States

Project ID: #2853922

Awarded to:

bijak

See private message.

$29.75 USD in 14 days
(1 Review)
1.4

10 freelancers are bidding on average $93 for this job

psergei

See private message.

$63.75 USD in 14 days
(439 Reviews)
8.6
rkumarvw

See private message.

$42.5 USD in 14 days
(43 Reviews)
6.0
jsmorgan24

See private message.

$72.25 USD in 14 days
(30 Reviews)
4.2
jademtech

See private message.

$17 USD in 14 days
(9 Reviews)
3.3
tzachh

See private message.

$42.5 USD in 14 days
(3 Reviews)
1.9
customcodervw

See private message.

$46.75 USD in 14 days
(2 Reviews)
0.7
jayjuch

See private message.

$63.75 USD in 14 days
(0 Reviews)
0.0
nettyvw

See private message.

$425 USD in 14 days
(0 Reviews)
0.0
daidalos

See private message.

$85 USD in 14 days
(1 Review)
0.0
bengreyling

See private message.

$85 USD in 14 days
(0 Reviews)
0.0