Stock Quote Add-In For Excel 2013


The Stock Quote Add-In For Excel 2013 is a small add-in based on the fantastic Excel-DNA library to retrieve stock data from Yahoo using the PSQ function.


The add-in is providing an Excel function called PSQ to retrieve stock data and a function called PFX to retrieve foreign-exchange rate data like quote or rate, name, date and time for the passed symbol. See the following formula samples:
  • =PSQ(A1;"PRICE") or just =PSQ(A1)
  • =PSQ(A1;"DATE")
  • =PSQ(A1;"TIME")
  • =PSQ(A1;"NAME")
  • =PFX(A1;"RATE") or just =PFX(A1)
  • =PFX(A1;"DATE")
  • =PFX(A1;"TIME")
  • =PFX(A1;"NAME")



This add-in is based on a previous version I wrote for Excel 2007 and Excel 2010. Below I have listed a couple of links to the old version:

Blog with Stock Quote Add-In posts:

Stock Quote Add-In For Excel 2007 (CodeProject)

Creating A MSN-like Stock Quotes Add-In For Excel 2007 Using User-Defined Functions And Ribbons (PDF)

Last edited Oct 7 at 12:07 PM by jbaurle, version 12