YahooXL  

Microsoft Excel add-in which retrieves data from Yahoo Finance

• retrieves quote snapshots
• Requires .NET Desktop Runtime 8.0
• Dependencies: YahooQuotesApi, ExcelDna, NodaTime, Reactive Extensions.

Runtime

• Copy "YahooXL-AddIn64-packed.xll" (64 bit) or "YahooXL-AddIn-packed.xll" (32 bit) from GitHub Releases to a folder.
• Double-click the file to start Excel with YahooXL loaded.
• Open a blank spreadsheet.
• Type in a cell: =YahooQuote()
• Type in a cell: =YahooQuote("TSLA", "RegularMarketPrice")

Installation

• Download "YahooXL-AddIn64-packed.xll" (64 bit) or "YahooXL-AddIn-packed.xll" (32 bit) from GitHub Releases to a folder.
• In Excel, with a sheet open, press Alt+t i to display the list of Excel Add-ins.
• Select "Browse" to add the YahooXL add-in to the list.

Note

It may be necessary to relax Excel security settings. In order to avoid security warnings, set the add-in location as trusted.