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

Stock Quote Add-In For Excel 2016 and 2013

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 Microsoft CodePlex Site

Scceenshot

German Edition of Excel 2016

German Edition of Excel 2013

Click here to show related blog posts.