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|| Up to 30 days||30 y||||5 symbols/query, |
| Yahoo Finance||Stocks, Indices, ETFs, Futures, Options, Currencies, Crypto||Global||varies||1 week||48 y||||None|
The video below (click to play) is a continuous loop of a 10-second recording of a spreadsheet with feeds coming in simultaneously from three different providers. The update interval is set to 1 second. The seen colors are an optional Deriscope visual indication of the direction of any changes occurred in the displayed data: Green for upticks, red for downticks and yellow for non-numeric changes.
You may download the spreadsheet produced with the above steps here.
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