Stock Quote Add-In For Excel 2013

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 like quote, name, date and time for the passed stock symbol. See the following formula samples:

• =PSQ(A1;"PRICE") or just =PSQ(A1)
• =PSQ(A1;"DATE")
• =PSQ(A1;"TIME")
• =PSQ(A1;"NAME")

Screenshots





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