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

PMStockQuote-Screenshot-About.jpg

PMStockQuote-Screenshot-Update.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:

Blog with Stock Quote Add-In posts:
http://www.parago.de/category/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 Oct 7 at 12:07 PM by jbaurle, version 12