Sin ánimo de mancillar su maravilloso hilo @camacho113, como es un virtuoso del excel les comparto lo que acabo de leer en Twitter: Microsoft va a liberar una nueva función STOCKHISTORY
Easily pulling stock prices into Excel has been one of the most requested features on UserVoice. The Stocks data type began this journey by enabling refreshable quotes for stocks, bonds, funds, and currency pairs. We know that this wasn’t enough to complete the goals you have for analyzing your portfolio in Excel. Getting the history of a financial instrument over time is crucial information you need. We are thrilled to be able to bring this functionality into Excel
Para usuarios de Office 365, de momento liberandolo al 50% adscritos al anillo beta. Yo estoy en el alpha, intentaré ver si tengo actualización.