MarketXLS Blog

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.

Covered call ETF screener excel - a premium dashboard for ranking 14 buy-write ETFs by distribution yield, NAV decay, 12-month total return, beta, volatility, AUM, and after-tax yield, with scenario analysis, allocation sizing, and a correlation matrix in one workbook.

Copper stocks screener excel for June 2026 - track 12 copper-linked equities, run price scenarios, and benchmark valuation across pure-play and diversified miners with live MarketXLS formulas.

Midstream stocks dashboard excel - a premium, dashboard-style template that tracks pipeline and MLP distribution yield, DCF coverage, leverage, and EV/EBITDA across a 14-name portfolio, with live MarketXLS formulas.

Bank Stress Test Tracker Excel for CCAR 2026: build a Capital Plan Dashboard that monitors the 10 largest U.S. banks, their CET1 buffers, and dividend and buyback scenarios as Fed stress test results land in late June.

Live option chain data in Google Sheets is the most common request from spreadsheet-based options traders, and also one of the few data sets the GOOGLEFINANCE function does not natively support. This guide walks through what GOOGLEFINANCE can and cannot do, and shows how to build a true live option chain in Excel using MarketXLS.

Magic Formula screener excel - a premium dashboard-style template that ranks a 30-stock universe on Return on Capital and Earnings Yield, with KPI tiles, scenario blends, a top-10 watchlist, and live MarketXLS formulas.

Beverage stocks tracker excel helps advisors and self-directed investors monitor summer 2026 beverage demand, dividend support, margins, and valuation across the major non-alcoholic and alcoholic beverage names in one workbook.

Mid-year portfolio rebalancing dashboard excel - a premium, dashboard-style template that turns your holdings, cost basis, and target weights into a one-screen drift heatmap, trade list, sector exposure view, and tax-aware routing aid, with live MarketXLS formulas.

Yield trap screener excel template that flags dangerous high-dividend stocks using six red-flag tests and a composite Trap Risk Score (0-100).

Small cap value screener Excel - download a premium Russell 2000 valuation dashboard with PE, P/B, EV/EBITDA filters, a quality overlay, scenario analysis, and built-in allocation sizer for May 2026.

Refinery Stocks Screener Excel - track the 8 US refiners (VLO, MPC, PSX, DINO, DK, PBF, CVI, PARR) through summer 2026 driving season with a crack spread sensitivity model, dividend calendar, and live MarketXLS formulas.

Options spreadsheet built in Excel that tracks implied volatility, IV rank, put-call ratios, Greeks and strategy selection across a watchlist, with live MarketXLS formulas powering every cell.

Yield on cost dashboard excel - a premium, dashboard-style template that tracks the dividend yield each of your invested dollars produces today, across a multi-position portfolio, with live MarketXLS formulas.

ETF data in Excel, pulled live with MarketXLS formulas for price, AUM, expense ratio, yield, returns, and a composite Cost-Quality Score across 25 well-known funds as of late May 2026.

PCE inflation tracker Excel - map the Fed's preferred inflation gauge, super-core trend, and inflation-hedge sectors into one MarketXLS-powered workbook ahead of the May 30, 2026 release.