Stock Quote Add-In For Excel 2013

Introduction

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.

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

PMStockQuoteExcelAddIn.jpg

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:

Installer for MSN-like Stock Quotes Add-In For Excel 2007 / 2010:
http://www.parago.de/2009/01/update-installer-for-msn-like-stock-quotes-add-in-for-excel-2007/

Blog with Stock Quote Add-In posts:
http://www.parago.de/tag/excel/

Stock Quote Add-In For Excel 2007 (CodeProject)
http://www.codeproject.com/Articles/67082/Stock-Quote-Add-In-For-Excel-2007

Creating A MSN-like Stock Quotes Add-In For Excel 2007 Using User-Defined Functions And Ribbons (PDF)
http://content.parago.de/articles/Excel2007StockQuotesAddIn/CreatingAMSNlikeStockQuotesAddInForExcel2007UsingUserDefinedFunctionsAndRibbons.pdf

Last edited Nov 30 at 2:09 PM by jbaurle, version 18