=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 The following formula samples show the usage of the PSQ function:Ĭopy Code =PSQ(B4 'PRICE') or just =PSQ(A1)to retrieve the last price 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.