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
TECHCOMMUNITY.MICROSOFT.COM – 10 Jun 20

Disclaimer STOCKHISTORY is currently available to 50% of Microsoft 365 Subscribers in the Beta level of the Office Insider program. The behavior and signature of this function is subject to change. Releasing this way allows us to get early…
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