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
Related Blog Posts
Click here to show related blog posts.