The custom ribbon (named “Stock Quotes”) offers an Update button to retrieve (to be more precise to recalculate) all stock related formulas at once. 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 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.You'll want to make sure that the site on which you find the files appears reputable and that the files are for the same version of Excel that you are using. You could also do a search on the Internet for the names of the files that make up the Analysis ToolPak. If they are not on your system, or if you are missing some of them, then you can copy them from someone else's machine-provided that person is using the same version of Excel you are. If you locate the files on your system, but they are not in the proper directory, you can copy them all there. This particular path is for Office 2003 the "Office11" portion of the path will change depending on the version of Excel you are using.
You need all four of these files to use the full functionality of the Analysis ToolPak they should be located within the following default installation directory:Ĭ:\Program Files\Microsoft Office\Office11\Library\Analysis (Use the Windows Search function to look for them, while Excel is closed.) In that case, you should check to see if these four files are on your system.
The easiest way to do this is with the Office Setup program, but that won't do you any good if you don't have the Office CDs.
If the Analysis ToolPak is, indeed, not listed in the Add-ins dialog box, then you need to install it.
If the Analysis ToolPak is listed in the dialog box, then simply select the check box beside the add-in, click OK, and you can start to use it. If you don't activate the add-in, you can't use it.) The easiest way to check is to simply display the Add-ins dialog box by choosing Add-ins from the Tools menu. (Installation is only one step in using the Analysis ToolPak. The first thing you will want to do is make sure that it isn't already installed and just not activated.
Karen is wondering if there is any way to get this add-in without the CDs. She needs the Analysis ToolPak add-in for a school project, but she cannot find her Microsoft Office CDs.