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.
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.
Microsoft Excel 2002 for Windows.