Objective: An Excel function that will retrieve stock quotes from the internet. Description: Instead of manually updating the prices for each of the stocks I follow, I want a stock quote function to retreive prices for me. Stock price data should come from a free quote site like Yahoo or some other site. I was thinking about calling a simple function, like =stockquote("IBM"). It would return one data item, the current price of IBM. If the price is unavailable or the symbol is incorect, an error value should be returned. If I were to hit the calculate key (F9), it would go out and a request a fresh quote. Software: Excel 97 for Windows.
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.
Excel 97 and Windows 98