MarketXLS Blog

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.

GOOGLEFINANCE cannot return option chains, contract prices, or Greeks. This guide shows what it covers, where it stops, and how the MarketXLS add-on (Google Sheets) and add-in (Excel) return full option chains with one formula.

An Excel template that ranks a 30-stock universe on Greenblatt's Return on Capital and Earnings Yield, with a top-10 watchlist, four blend modes, and 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 in 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 is current dividend per share divided by your original cost. Track it per holding and across a dividend portfolio in a free Excel dashboard.

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.

Stock-based compensation dashboard Excel template - track SBC as a percent of revenue, share dilution, and the GAAP vs adjusted EPS gap across mega-cap tech and AI software names with live MarketXLS formulas.

A free six-sheet Excel FOMC tracker: index and sector ETF dashboard, six rate-decision scenarios, a sector heatmap, a rate-beneficiary watchlist, and a yield-curve sheet.