Creating A MSN-like Stock Quotes Add-In For Excel 2007 Using User-Defined Functions And Ribbons
Today I wrote an article about implementing a managed Excel 2007 add-in with C#. The stock quote add-in for Excel 2007 behaves similar to the "MSN MoneyCentral Stock Quotes" add-in you can download from Microsoft (see "Excel 2003/2002 Add-in: MSN Money Stock Quotes"). The add-in is developed from scratch, not using Visual Studio Tools for Office (VSTO).
Once the add-in is installed and registered you can use the user-defined function (UDF) named “PSQ” to retrieve a stock quote price, date, time and name for a given stock symbol from the Yahoo finance service.
IMPORTANT: The "MSN MoneyCentral Stock Quotes" is not available anymore.
Related Blog Posts
Click here to show related blog posts.