MarketXLS Blog

Junk Bond ETF Tracker Excel - track HYG, JNK, USHY, ANGL, and live BAA-Treasury credit spreads in one dashboard. Free template for advisors and self-directed investors monitoring high yield as a recession signal in June 2026.

Merger arbitrage spread tracker excel - a professional-grade, dashboard-style workbook that monitors live deal spreads, annualized IRR, scenario P&L, and probability-weighted returns across active M&A deals using MarketXLS live data.

Dividend Kings screener Excel - track and analyze 28 US stocks with 50+ consecutive years of dividend increases. Live MarketXLS formulas for yield, payout, streak, valuation, and a Father's Day 2026 quality scorecard.

S&P 500 concentration dashboard Excel - track top 10 weight, sector dominance, and SPY vs RSP with a premium June 2026 template that exposes how concentrated the benchmark really is.

CPI inflation tracker Excel - map the May 2026 CPI release, Fed cut probability, TIPS breakevens, and sector reactions into one MarketXLS-powered workbook ahead of the June 17-18 FOMC meeting.

Net Debt to EBITDA screener Excel - a dashboard-style template that ranks 27 US large-caps on balance sheet quality, runs seven leverage scenarios, and stress-tests interest coverage against rate shocks.

Earnings momentum screener Excel template ranks 25 large-cap stocks heading into Q2 2026 earnings by EPS YoY, revenue YoY, last surprise %, and 30-day estimate revision. Built with live MarketXLS formulas.

PEG Ratio Screener Excel for June 2026 - dashboard-style workbook with KPI tiles, conditional formatting, scenario analysis, and a live MarketXLS template that screens 25 mega-cap stocks for Growth-At-Reasonable-Price setups.

ROIC screener Excel - rank 25 large-cap stocks by Return on Invested Capital, tier them into Elite, High Quality, Solid, and Below Cost of Capital buckets, and build a quality-weighted basket inside Excel.

Risk-On Risk-Off Dashboard Excel - track 8 intermarket ratios, score the market regime, and rotate cyclical vs defensive sleeves with a premium June 2026 template powered by live MarketXLS formulas.

Quad witching tracker excel template for the June 20, 2026 expiration, with live max pain, IV rank, put/call ratios, and risk-sized strategy setups across the 12 highest-OI names.

Mid-Cap Quality Screener Excel - filter 27 Russell Midcap names on ROE, ROIC, FCF margin, and leverage with a premium June 2026 dashboard, scenario screens, sector heatmap, and three weighting methods.

All weather portfolio dashboard excel - track Ray Dalio's classic 30/40/15/7.5/7.5 allocation across stocks, long bonds, intermediate bonds, gold, and commodities with live MarketXLS formulas, drift monitoring, and a regime scenario engine.

Buffett Indicator Dashboard Excel - track market cap to GDP, run mean-reversion scenarios, and stress-test long-term equity returns with a premium June 2026 template.

Apple WWDC stock tracker excel - a 25-name June 2026 watchlist covering Apple, its silicon and memory suppliers, foundries, AI infrastructure providers, and equipment makers, with live MarketXLS formulas, scenario modeling, options structures, and position sizing, all ahead of the June 8 keynote.

Wheel strategy screener excel - a premium dashboard for ranking 22 wheel-friendly large caps by IV rank, volatility risk premium, short put credit, annualized ROIC, and margin of safety in a single 11-sheet workbook.