The following two screenshots show the add-in in action using the German version of Excel: The add-in also implements a custom ribbon of the new Office “Fluent” user interface. =PSQ(B4 'TIME') to retrieve the last price time =PSQ(B4 'DATE') to retrieve the last price date =PSQ(B4 'NAME') to retrieve the company name =PSQ(B4 'PRICE') or just =PSQ(A1)to retrieve the last price The following formula samples show the usage of the PSQ function: 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Ī given stock symbol from the Yahoo! finance service. The add-in is developed from scratch, not using Visual Studio Tools for Office (VSTO). This article describes how to implement a managed stock quote add-in for Excel 2007 in C# that behaves similar to the “MSN Mone圜entral Stock Quotes”Īdd-in you can download from Microsoft (see “Excel 2003/2002 Add-in: MSN Money Stock Quotes”). Then check if the Add-In 'ParagoStockQuote.Functions' is available in the list and is marked. Then open the Excel Add-In Manager dialog by pressing the button on the Add-Ins dialog window (see button on the bottom of the dialog). The list Active Add-ins should contain the ' Stock Quotes Function Add-In' (COM-Add-In) as well as

Options dialog and click the menu item Add-Ins.

Download setup - 878 KB (See the Installation Instructions section below)īefore using the add-in you should check if the installation has been executed correctly.

Download stock quotes into excel 2007