Banner Image
Jürgen Bäurle
Projects  ·  Work  ·  Blog  ·  Contact

Stock Quote Add-In For Excel 2016 and 2013

IMPORTANT NOTICE

The Stock Quote add-in is using the Yahoo Finance service to retrieve the stock quotes. The service seems to be terminated by Yahoo without any notice on 11/01/2017. I will try to find an alternative solution as soon as possible, but I’m not sure how long it will take. You may check out this site or GitHub from time to time for a new version to download.


A few years ago Microsoft was providing the MSN MoneyCentral Stock Quotes Add-In for Excel 2002 and it was a really neat tool, but all of a sudden this tool was not avaiable anymore. My Stock Quote Add-In For Excel is the replacement of the MSN Add-In, based on the fantastic Excel-DNA library to retrieve stock data and FX rates from the Yahoo! Finance site using new Excel functions.

Are you using Excel 2010 or Excel 2007? Then you may download the installer on this page.

Usage

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”) ==> EST Time
  • =PSQ(A1;”DATELOCAL”)
  • =PSQ(A1;”TIME”) ==> EST Time
  • =PSQ(A1;”TIMELOCAL”)
  • =PSQ(A1;”NAME”)
  • =PFX(A1;”RATE”) or just =PFX(A1)
  • =PFX(A1;”DATE”) ==> EST Time
  • =PFX(A1;”DATELOCAL”)
  • =PFX(A1;”TIME”) ==> EST Time
  • =PFX(A1;”TIMELOCAL”)
  • =PFX(A1;”NAME”)

Download

Download from GitHub
Download from Microsoft CodePlex (OLD)

Scceenshot

German Edition of Excel 2016

German Edition of Excel 2013

Click here to show related blog posts.