Introduction to Deriscope – Part 5: Live Feeds
Deriscope enables you to receive in Excel live feeds from several different providers.
These feeds include real time or almost real time prices of financial securities (stocks, ETFs, indices, currencies, cryptocurrencies, futures and options), bid/offer quotes and sizes, time series of historical prices and statistical indicators, company financial data and market news.
Below is a table that summarizes the relative strengths and weaknesses of the supported providers. Click on the provider's name for a detailed guide on how to access data in Excel from that provider.
|Provider||Securities||Domain||Time Delay||1 Min Time Series||Daily Time Series||Extra||Free Version Limits|
| Alpha Vantage||Stocks, Indices, Currencies, Crypto||Global||1 min||1 day||20 y||Statistical Indicators||1 symbol/query, |
| Barchart||Stocks, Indices, ETFs, Futures, Options, Currencies, Crypto||Global||15 min||1 month||6 months in free version||||25 symbols/query, |
No Indices, ETFs, Futures, Options
| IEX||US Stocks, US ETFs||US||No||1 day||5 y||Bids, Asks, Earnings, News||None|
|World Trading Data||Stocks, Indices, ETFs, Currencies||Global||varies||No||30 y||||5 symbols/query, |
| Yahoo Finance||Stocks, Indices, ETFs, Futures, Options, Currencies, Crypto||Global||varies||1 week||48 y||||None|
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