Yahoo Finance Live Feeds in Excel after their API Discontinuation in November 2017
Important Note: Live Feeds are now part of the XL Feeds Excel Add-In. Visit the XL Feeds web site for details. Some or all of the information below may still apply on the new Add-In.
On the fateful Wednesday of November 1st, 2017 Yahoo decided to stop their – until then – free service of delivering real time market data as a text stream through a special URL. For hundreds of businesses and individuals who had relied for years on Yahoo's benevolent free service, this single action meant only one thing: Instant death!
If all you want is a very quick and uncomplicated way (three mouse clicks!) to simply get live feeds in your spreadsheet, check out the 30 seconds videos below:
Getting easily live stock prices in Excel
Getting easily live forex rates in Excel
Getting historical data in Excel
Update as of January 2020: Deriscope has now a new dedicated ribbon that greatly simplifies the live feeds user interface.
For details, visit the Introduction to Deriscope Live Feeds.
You may continue reading the rest of the article here. It will reveal how you may use the almost free Deriscope AddIn to access real time feeds from Yahoo Finance in Excel.
Feel free to contact me if you want to share any thoughts with regard to this product or if you want to request any particular features. Contact info and social media links are available at my web site https://www.deriscope.com