It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager).
Stock Quote Add-In For Excel 20 Introduction The Stock Quote Add-In For Excel 2016/2013 is a small add-in based on the fantastic Excel-DNA library to retrieve stock data from Yahoo using the PSQ function.
Turn screen updating off to speed up your macro code.
You won't be able to see what the macro is doing, but it will run faster.
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: Screenshots German Edition of Excel 2016: German Edition of Excel 2013: This add-in is based on a previous version I wrote for Excel 2007 and Excel 2010.
As mentioned in a previous installment, the “bitness” of the server must match the instance of Excel, that is, 32- and 64-bit versions of Excel demand 32- and 64-bit COM servers, respectively.