A free Excel dashboard for S&P 500 Dividend Aristocrats (25+ years of dividend increases): yield, payout ratio, streak length, sector comparison, and reinvested-income projection.
Stock Analysis
MarketXLS Blog
Expert insights on stock market analysis, investment strategies, and Excel techniques for smarter investing.
Explore our 94 blog series
Browse articles by topic, arranged in reading order.
- Stock data in Excel · 6 articlesExcel Stock Plugin: Compare Stock Data Add-ins for Excel
- Dividends and income · 11 articlesDividend Tracker Spreadsheet: Google Sheets and Excel
- Options in Excel · 12 articlesOption Greeks in Excel: Delta, Gamma, Theta and Vega
- ETFs and funds · 6 articlesCompare ETFs: Costs, Holdings and Live ETF Data in Excel
- Portfolio analytics in Excel · 12 articlesPortfolio Optimization Excel: Efficient Frontier and Solver
- Valuation and screening in Excel · 7 articlesDCF Model Excel: Discounted Cash Flow and Terminal Value
- Google Sheets · 12 articlesGoogle Sheets Stock Price: Stocks, Funds and Options
- AI assistants · 9 articlesStock Data in Claude: Live Prices Through the MarketXLS MCP
- Market dashboards in Excel · 10 articlesEarnings Data in Excel: EPS, Estimates and Season Trackers
- Investing guides · 5 articlesTrading Conferences and Resources for Options Traders
- India · 8 articlesIndian Stock Prices in Excel: Live NSE and BSE Data
- Product updates · 12 articlesMarketXLS Release Notes: Versions 9.1 to 9.4
Show all 94 series
- Stock data in Excel · 4 articlesYahoo Finance API Alternative: Licensed Data for Excel
- Options in Excel · 8 articlesOptions Profit Calculator Excel: P&L, Breakeven and Payoff
- Options in Excel · 7 articlesOptions Trading Spreadsheet: Templates, Logs and Journals
- Options in Excel · 6 articlesSPXW Options: Weekly SPX Options and SPX vs SPY
- Options in Excel · 5 articles0DTE Options: Zero-Day SPY and SPX Options with Live Data
- Options in Excel · 4 articlesOption Expiration Calendar: Monthly and Weekly Expirations
- ETFs and funds · 9 articlesMutual Fund Comparison: Compare and Track Funds in Excel
- Stock data in Excel · 5 articlesThinkorswim RTD Excel: Broker Data Feeds and Integrations
- Stock data in Excel · 4 articlesFutures Prices in Excel: Futures, Commodities and Crypto
- AI assistants · 10 articlesChatGPT Stock Analysis: AI Equity Research with Live Data
- Options in Excel · 7 articlesOption Pricing Explained: Premium, Intrinsic and Time Value
- Options in Excel · 7 articlesCall Option Calculator: Long Calls and LEAPS in Excel
- Options in Excel · 10 articlesSelling Options for Income: Puts, Calls and Excel Trackers
- Options in Excel · 6 articlesWheel Strategy Spreadsheet: Puts to Covered Calls in Excel
- Options in Excel · 6 articlesVertical Spread Options: Debit Spreads in Excel
- Options in Excel · 8 articlesCredit Spread Calculator Excel: Bull Put and Bear Call
- Options in Excel · 6 articlesCalendar Spread Calculator Excel: Calendars and Diagonals
- Options in Excel · 11 articlesStrangle Option Strategy: Straddles and Guts in Excel
- Options in Excel · 5 articlesIron Condor Strategy: Condors and Butterflies in Excel
- Options in Excel · 9 articlesCollar Option Strategy: Protective Puts and Collars in Excel
- Options in Excel · 8 articlesVolume vs Open Interest: Options Volume and Unusual Activity
- Dividends and income · 11 articlesDividend Stock Screener Excel: Yield, Payout and Safety
- ETFs and funds · 9 articlesETF Portfolio Analysis: Build and Hedge in Excel
- Portfolio analytics in Excel · 5 articlesSharpe Ratio of a Portfolio: Sortino and Drawdown in Excel
- Portfolio analytics in Excel · 4 articlesPortfolio Beta Calculator: Stock Beta and Hedging in Excel
- Portfolio analytics in Excel · 5 articlesCorrelation Matrix in Excel: Correlation and Pairs Trading
- Valuation and screening in Excel · 9 articlesFundamental Analysis of Stocks in Excel: Ratios and Research
- Valuation and screening in Excel · 5 articlesPiotroski F-Score Excel: Plus Altman Z and Beneish M Scores
- Valuation and screening in Excel · 7 articlesMagic Formula Investing in Excel and Classic Value Screens
- Valuation and screening in Excel · 6 articlesWarren Buffett Portfolio: Berkshire and 13F Trackers
- Valuation and screening in Excel · 12 articlesTrading Indicators: RSI, MACD, Bollinger, VWAP in Excel
- AI assistants · 7 articlesOptions Data in ChatGPT and Claude: Live Option Chains
- Options in Excel · 6 articlesRatio Spread Options: Ratio Spreads and Backspreads in Excel
- Options in Excel · 4 articlesConversion Arbitrage: Put-Call Parity Trades in Excel
- Stock data in Excel · 7 articlesExcel Stock Price: Live Quotes and Prices on Any Date
- Stock data in Excel · 5 articlesExcel STOCKHISTORY: Its Limits and Years of Daily Prices
- Stock data in Excel · 8 articlesYCharts Alternatives: Bloomberg, FactSet, Koyfin Compared
- Stock data in Excel · 5 articlesStock Portfolio Tracker Excel: Build a Live Tracker
- Google Sheets · 5 articlesGoogle Finance Alternative: Live Market Data in Sheets
- AI assistants · 9 articlesBest MCP Servers for Financial Data: Compare and Connect
- Options in Excel · 10 articlesOption Data in Excel: Live Chains, Prices and History
- Options in Excel · 11 articlesOption Pricing in Excel: Black-Scholes and Binomial Models
- Options in Excel · 8 articlesCovered Call Spreadsheet: Track, Screen and Roll in Excel
- Options in Excel · 11 articlesOptions Trading for Beginners: Terms, Symbols and Moneyness
- ETFs and funds · 4 articlesBest Performing ETFs: Top Funds, Value, Gold and Bitcoin
- AI assistants · 8 articlesOptions Data MCP Server: Live Chains and Greeks for AI
- Options in Excel · 12 articlesOptions Trading Strategies in Excel: Pick a Strategy
- Options in Excel · 9 articlesImplied Volatility in Excel: IV Rank, Surfaces and VIX
- Options in Excel · 6 articlesOptions Trading Brokers: Compare Platforms, Trade from Excel
- Dividends and income · 5 articlesBlue Chip Dividend Stocks: Aristocrats and Kings in Excel
- ETFs and funds · 6 articlesETF Screener Excel: Filter ETFs and Pull Live ETF Data
- Portfolio analytics in Excel · 8 articlesPortfolio Risk Management in Excel: VaR and Monte Carlo
- Portfolio analytics in Excel · 5 articlesPortfolio Rebalancing in Excel: Allocation Targets and Drift
- Portfolio analytics in Excel · 4 articlesPortfolio Wealth Management: Retirement Planning in Excel
- Portfolio analytics in Excel · 6 articlesFactor Investing in Excel: Carhart and Multi-Factor Screens
- Portfolio analytics in Excel · 6 articlesFinancial Calculators in Excel: CAGR, TVM and Stock Splits
- Valuation and screening in Excel · 8 articlesStock Valuation Calculator Excel: Multiples and Comps
- Market dashboards in Excel · 6 articlesStock Market Valuation in Excel: CAPE and Buffett Indicator
- Valuation and screening in Excel · 5 articlesROIC Screener Excel: Quality Compounders and Rule of 40
- Valuation and screening in Excel · 5 articlesOperating Margin Screener Excel: Margins and Pricing Power
- Valuation and screening in Excel · 9 articlesFree Cash Flow Yield Screener Excel: FCF and Buyback Yield
- Valuation and screening in Excel · 6 articlesBalance Sheet Screener Excel: Net Debt and Interest Coverage
- Valuation and screening in Excel · 6 articlesCustom Stock Screener in Excel: Build Screens with Live Data
- Valuation and screening in Excel · 4 articlesSmall Cap Stocks in Excel: Value, Mid-Cap, Russell Screens
- Valuation and screening in Excel · 9 articlesTechnical Indicators in Excel: Live Indicators and Screens
- Valuation and screening in Excel · 10 articlesPenny Stock Screener in Excel: Volume, Volatility, Sectors
- Market dashboards in Excel · 9 articlesBank Earnings Tracker in Excel: Banks, NIM and Lenders
- Market dashboards in Excel · 9 articlesTech Earnings Tracker in Excel: Mag 7, Chips and Software
- Market dashboards in Excel · 7 articlesAI Infrastructure Stocks in Excel: Capex, Chips and Power
- Market dashboards in Excel · 7 articlesConsumer Earnings Tracker in Excel: Retail, Staples, Travel
- Market dashboards in Excel · 5 articlesHealthcare and Insurance Stocks: Earnings and Hurricane Risk
- Market dashboards in Excel · 6 articlesIndustrials Earnings Tracker in Excel: Transports to REITs
- Market dashboards in Excel · 10 articlesEnergy Stocks in Excel: Oil Sensitivity, ETFs and Earnings
- Market dashboards in Excel · 7 articlesInflation Hedge Portfolio in Excel: Gold and Safe Havens
- Market dashboards in Excel · 7 articlesCPI Inflation Tracker in Excel: Inflation and Fed Dashboards
- Market dashboards in Excel · 4 articlesYield Curve in Excel: Treasury Spreads and T-Bill Ladders
- Market dashboards in Excel · 8 articlesSector Rotation Model Excel: Relative Strength and Breadth
- Investing guides · 7 articlesSector Analysis in Excel: One Primer per Sector
- Investing guides · 7 articlesThematic Stock Screeners in Excel: Defense, GLP-1 and ESG
- Investing guides · 7 articlesHow to Buy Stocks Online: Shares, SPACs and Foreign Stocks
- India · 5 articlesZerodha Excel Integration: Kite, Angel One and Dashboards
- India · 6 articlesNSE Option Chain Excel: Nifty Options, Greeks and PCR
Categories:
Berkshire Hathaway portfolio tracker Excel - track Warren Buffett's publicly disclosed equity holdings with live MarketXLS prices, ROE, debt-to-equity, dividend yield and a quality score, all in one Excel workbook for May 2026.
Stock Analysis
Forward earnings yield dashboard excel - download a premium Q2 2026 valuation screener that compares forward earnings yield against the 10-year Treasury, with KPI tiles, sector heatmaps, scenario analysis, and live MarketXLS formulas.
Stock Analysis
Jobs report tracker excel dashboard built with MarketXLS - track unemployment rate, NFP, JOLTS, initial claims, wages, and rate-curve reactions live for the May 2026 jobs print.
Investment Strategies
Sell in May strategy Excel template helps you compare a classic seasonal rotation against a defensive sleeve, hedges, and a stay-invested baseline using live MarketXLS formulas for May through October 2026.
Investment Strategies
Buyback yield screener excel - rank Q1 2026 repurchase leaders by buyback yield, total shareholder yield, and share-count change with live MarketXLS formulas.
Investment Strategies
REIT earnings tracker Excel for Q1 2026 - watch occupancy, FFO proxy, dividend coverage, and leverage across data center, industrial, residential, retail, healthcare, storage, tower, and gaming REITs in one live dashboard.
Investment Strategies
AI capex tracker excel helps you monitor hyperscaler and AI infrastructure spending against revenue, free cash flow, and operating margins through one Q1 2026 workbook with live MarketXLS formulas.
Stock Analysis
An Excel tracker that scores AMZN, TSLA, HD, LOW, MCD, SBUX, NKE, and BKNG on valuation, yield, trend, margins, and beta through Q1 2026 earnings, with dates and scenarios.
Stock Analysis
A healthcare earnings tracker in Excel helps you compare pharma, managed care, medical devices, and life sciences names across one Q1 2026 workbook with live MarketXLS formulas.
Stock Analysis
Industrials earnings tracker excel built in MarketXLS - a Q1 2026 watchlist that scores 24 industrial bellwethers on tariff exposure, fundamentals, and analyst sentiment.
Stock Analysis
An Excel earnings quality screener for Q1 2026: score companies on EPS, operating margin, ROE, leverage, valuation, and trend with MarketXLS formulas.
Stock Analysis
Compare defensive and cyclical sector ETFs on trend, RSI, beta, and yield in one MarketXLS Excel dashboard built for a Q2 2026 Fed pause.
Portfolio Management
Tariff impact tracker excel helps investors compare import sensitivity, pricing power, domestic sourcing, and live market data during 2026 trade volatility.
Portfolio Management
A free Excel tracker for eight consumer staples stocks (PG, KO, PEP, WMT, COST, CL, KMB, KR) comparing margins, yield, valuation, and trend during Q1 2026 earnings.
Stock Analysis
Compare Q1 2026 energy earnings for XOM, CVX, COP, EOG, SLB, and MPC in Excel with MarketXLS formulas for valuation, margins, leverage, and trend.
Stock Analysis
The Professional Investment Platform Inside Excel
Live market data, stock screening, options analytics and portfolio management inside Excel.