MarketXLS Blog

Floating rate ETF screener excel - rank BKLN, SRLN, FLOT, USFR, TFLO and CLO funds by yield, beta, and a rising-rate income score in one Excel dashboard. Free template for advisors and self-directed investors positioning for a Fed that is signaling rate hikes in June 2026.

Unusual options activity API MCP feeds the same ranked flow scans, volume/open-interest, and put-call data to your AI assistant and your Excel sheet from one licensed source.

ChatGPT stock analysis is fast for narrative but cannot show the live source number behind each claim. Pair the same AI research checklist with MarketXLS formulas in Excel so every figure is auditable and refreshable. Six-sheet template plus static sample included.

Options data in ChatGPT with MarketXLS lets you ask an AI for a live option chain, Greeks, and put-call ratios and get the same numbers in Excel.

Real-time options API MCP connects streaming option chains, Greeks, and put-call data to both your AI assistant and your Excel sheet from one licensed source.

Shareholder yield screener excel - a premium, dashboard-style template that ranks 24 large caps by total cash returned through dividends, buybacks, and debt paydown, with KPI tiles, charts, conditional formatting, and live MarketXLS formulas.

For option traders and finance professionals, the gap between an AI that fetches raw data and an AI that executes proven financial primitives is the gap between guesswork and an answer you can stand behind.

MCP server options market data lets an AI assistant and Excel pull the same live option chains, Greeks, and put-call ratios from one licensed source.

Pairs trading dashboard Excel template tracks the price ratio, rolling z-score, hedge ratio, and correlation for a long-short pair, with KPI tiles, a screener, and scenario analysis built around live MarketXLS formulas.

Reinsurance stocks tracker Excel - monitor RNR, EG, ACGL, AXS, RGA, WTM, ESGR, and BRK.B through the 2026 Atlantic hurricane season with a MarketXLS dashboard built for catastrophe-exposed insurers.

VIX term structure dashboard Excel - build a premium June 2026 template with five-tenor volatility curve, regime classifier, roll-yield scenarios, and a single-name IV comparison matrix.

TIPS breakeven inflation tracker Excel - turn the spread between nominal Treasuries and TIPS into a live 5Y, 10Y, and 5Y5Y forward breakeven dashboard built for the Fed pause regime.

Obesity drug stocks dashboard excel - track LLY, NVO, and the late-stage GLP-1 pipeline with KPI tiles, market share scenarios, a screener, and portfolio sizing built on live MarketXLS formulas.

Aerospace stocks dashboard Excel template for Paris Air Show 2026: track 17 commercial OEMs, engine makers, defense primes, and aftermarket names with live MarketXLS formulas, scenario analysis, and bucket allocation tooling.

Power grid stocks dashboard Excel: a professional-grade June 2026 template that tracks IPPs, regulated utilities, grid equipment makers, and transmission EPC names against an AI electricity demand score, with KPI tiles, scenario analysis, and conditional-formatted heatmaps.

HVAC stocks screener Excel for summer 2026 - 10 cooling-demand tickers with live MarketXLS formulas, scenario analysis, and a downloadable template.