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.
Dividend Investing
MarketXLS Blog
Expert insights on stock market analysis, investment strategies, and Excel techniques for smarter investing.
Featured Series
Categories:
The S&P 500 top 10 weight is about 37.5% (June 2026). A free Excel dashboard to track top 10 weight, sector weights, HHI, and SPY vs RSP.
Investment Strategies
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.
Investment Strategies
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.
Stock Analysis
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.
Stock Analysis
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.
Investment Strategies
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.
Stock Analysis
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.
Investment Strategies
Quad witching tracker excel template for the June 18, 2026 expiration, with live max pain, IV rank, put/call ratios, and risk-sized strategy setups across the 12 highest-OI names.
Options Trading
A free Excel screener that scores 27 Russell Midcap stocks on ROE, ROIC, free cash flow margin, and leverage, with seven preset quality screens and three weighting methods.
Investment Strategies
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.
Portfolio Management
The Buffett Indicator (US market cap / GDP) was about 200% in June 2026. An Excel dashboard to calculate it, chart 30 years of history, and run 10-year reversion scenarios.
Investment Strategies
A free Excel workbook that tracks Apple and 24 supplier and AI-infrastructure stocks around WWDC 2026, with MarketXLS price and valuation formulas, five keynote scenarios, option structures, and position sizing.
Stock Analysis
A free Excel wheel strategy screener that ranks 22 large caps by IV rank, volatility risk premium, short put credit, annualized ROIC, and margin of safety.
Options Trading
Airline stocks screener excel built around the metrics that matter at the start of peak travel season: operating margin, leverage, EBITDA, and segment exposure across Big 3, low-cost, and regional carriers.
Stock Analysis
Screen covered call ETFs in Excel: rank JEPI, JEPQ, QYLD, SPYI and 10 more by yield, NAV decay, total return, and after-tax yield, with scenarios and income sizing.
Options Trading
STOP Wasting Hours on Manual Data Entry & START Making Smarter Investment Decisions
Discover how 2,500+ serious investors are saving 15+ hours every week with real-time market data directly in Excel.
✓ No credit card required • ✓ Cancel anytime