MarketXLS Blog

Russell 2000 reconstitution tracker Excel for the June 2026 rebalance, with a live MarketXLS screener that flags likely adds, deletes, and promotions so you can model index arbitrage flows before reconstitution day.

Altman Z-Score screener excel - rank 20 large caps by bankruptcy risk, stress-test each name under recession scenarios, and download a dashboard-style MarketXLS template free.

Short interest screener excel template that ranks squeeze candidates by short percentage, days to cover, float size, and momentum, with live MarketXLS formulas you can plug into your own watchlist.

Cash Conversion Screener Excel May 2026 ranks 30 large-cap names by OCF/Net Income, FCF/Net Income, and ROIC inside a dashboard-style Excel template with KPI tiles, sector heatmaps, and live MarketXLS formulas.

13F filings tracker excel - build a live Q1 2026 hedge fund holdings dashboard in Excel using MarketXLS formulas, with consensus picks and sector allocation.

Magnificent 7 valuation dashboard Excel - track PE, forward PE, PEG, EV/EBITDA, and S&P 500 concentration risk for NVDA, MSFT, AAPL, GOOGL, AMZN, META, and TSLA in one dashboard-style template.

Research and development screener Excel - rank companies by R&D-to-revenue intensity, gross margin, ROIC, and growth, with live MarketXLS formulas pulling fundamentals straight into a single dashboard.

Rule of 40 screener excel - download a premium May 2026 dashboard that scores 20 SaaS and cloud names on revenue growth plus profit margin, with KPI tiles, scenario stress tests, and live MarketXLS formulas.

NVIDIA earnings preview Excel - a free template for the Q1 FY2027 report, with live consensus EPS and revenue, a beat/miss scenario engine, AI chip peer comparison, and an options pre-earnings playbook powered by MarketXLS formulas.

Stagflation portfolio dashboard excel helps advisors and self-directed investors build a defensive tilt with a real asset sleeve, scenario analysis, and live MarketXLS macro data in one premium workbook.

Insider buying screener Excel - build a live, alignment-focused watchlist that ranks stocks by insider ownership, valuation, quality, and momentum, using verified MarketXLS formulas.

Stock spreadsheet - a seven-sheet MarketXLS workbook that turns Excel into a live watchlist, valuation lens, dividend income tracker, technical snapshot, sector rollup, and benchmark comparison around one editable ticker list.

Stock screener in excel - a complete dashboard that ranks a twelve-ticker watchlist by P/E, dividend yield, beta, ROE, operating margin, and market cap, with scenario thresholds, scoring, and educational sizing in one workbook.

Iron condor screener excel - a premium dashboard for ranking 25 liquid optionable underlyings by IV rank, volatility risk premium, expected move, and projected credit, with strike selection, scenario analysis, and position sizing in one file.

ETF data in Google Sheets is workable for prices, but AUM, expense ratio, top holdings, inception date, and option chains live outside GOOGLEFINANCE. This guide shows how FundXLS and the MarketXLS Google Sheets add-on close every gap, with verified formulas, a sample workbook, and a live template.