Excel Real-Time Stock Feeds

I keep a substantial Excel 2021 workbook that tracks hundreds of tickers, blending technical and fundamental data. Michael Saunders’ Stock Connector add-in works, but its quotes are delayed and that makes my intraday models unreliable. I’m looking for a straightforward replacement that brings true real-time data straight into the existing sheets.

The feed must cover NYSE and NASDAQ symbols as well as Russell, S&P and Dow constituents plus a few preferred shares. Both price/volume fields (open, high, low, last, bid/ask, volume) and key fundamentals (market cap, EPS, dividend, etc.) have to refresh automatically—ideally every few seconds, certainly no slower than once per minute.

I’m flexible on the provider; Alpha Vantage, IEX Cloud and Yahoo Finance aren’t carved in stone and I’m happy to license another API if it delivers reliable streaming. What matters is that the new connection slips into my current workbook with minimal disruption, either by mirroring the Stock Connector function syntax or by giving me an easy, clearly documented migration path.

Scope
• Integrate a real-time market-data API with Excel 2021 via VBA, Power Query or a lightweight add-in.
• Map incoming fields to my existing columns so dashboards, pivot tables and charts remain intact.
• Allow simultaneous refresh of at least 200 tickers without freezing Excel.
• Package the solution so I can move it to another PC (instructions, commented code, any required DLLs or COM objects).

Acceptance Criteria
1. Quotes and fundamentals update within the same minute they appear on the exchange feed.
2. No broken formulas after migration.
3. Clear documentation covering setup, API key management and routine maintenance.

If you’ve already connected Excel to streaming market data and know how to dodge API throttling, I’d love to see your approach.