1 minute reading time (296 words)

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 Delay1 Min Time SeriesDaily Time Series​Extra​Free Version Limits
Alpha Vantage ​Stocks, Indices, Currencies, Crypto Global ​1 min​1 day20 yStatistical Indicators1 symbol/query,
5 queries/min
Barchart Stocks, Indices, ETFs, Futures, Options, Currencies, Crypto​Global​15 min​​1 month6 months in free version25 symbols/query,
400 queries/day,
No Indices, ETFs, Futures, Options
IEX​US Stocks, US ETFs​US​No
​​1 day5 yBids, Asks, Earnings, NewsNone
World Trading Data​Stocks, Indices, ETFs, Currencies​Globalvaries​ Up to 30 days30 y5 symbols/query,
250 queries/day
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.  

File Name: IntroductionToDeriscope-5-LiveFeeds
File Size: 23 kb
Download File

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

Beyond Black Scholes: European Options with Discre...
Introduction to Deriscope – Part 4: Spreadsheet