YahooXL  

Microsoft Excel add-in which retrieves data from Yahoo Finance

• retrieves quote snapshots
• fluent interface
• Dependencies: ExcelDna, YahooQuotesApi, Reactive Extensions, NodaTime

Runtime

• Requires .NET Desktop Runtime 6.0
• 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.
• It may be necessary to relax Excel security settings.
• Open a blank spreadsheet.
• Type in a cell: = YahooQuote()
• Type in a cell: = YahooQuote("TSLA", "RegularMarketPrice")
• Try opening the file "Test.xls", located in the solution directory.

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.