Stock Quote Function in Excel

This project was awarded to bijak for $29.75 USD.

Get free quotes for a project like this
Project Budget
$30 - $100 USD
Total Bids
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.

Awarded to:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online