Close

Stock Screener in Excel

Stock Screener in Excel
  • Stock Screener in Excel : Screen markets by  10 years key fundamentals 
  •  Build complex filter criteria  with an unlimited number of filter conditions, combined by logical operators
  • Search through financial statements
  • Tree-like or Text-based filter editing style
  •  Filter by comparing fields , indicators in history
  • Copy and paste screened stocks to excel sheet
  • Get 10 history of a key ratio, attribute for any stock
  • Save your screen formulas as text in Excel sheets
  • Choose columns to show or hide to copy paste in Excel
  • Screener formula histories stored in memory to revert to one if needed with a single click

Download our S&P return screener for free


List of Indicators : MarketXLS Stock Screener in Excel
FinancialsKey Ratios (Profitability) Expressed as Margin % of SalesProfitabilityKey Ratios (Growth) Revenue %, Operating Income %, Net Income % and EPS %Cash Flow RatiosBalance Sheet Items (in %)Liquidity/Financial HealthKey Ratios (Efficiency)
Revenue USD Mil
Gross Margin %
Operating Income USD Mil
Operating Margin %
Net Income USD Mil
Earnings Per Share USD
Dividends USD
Payout Ratio %
Shares Mil
Book Value Per Share USD
Operating Cash Flow USD Mil
Cap Spending USD Mil
Free Cash Flow USD Mil
Free Cash Flow Per Share USD
Working Capital USD Mil
Triangular Moving Average
Weighted Moving Average
Revenue
COGS
Gross Margin
SG&A
R&D
Other
Operating Margin
Net Int Inc & Other
EBT Margin
Tax Rate %
Net Margin %
Asset Turnover (Average)
Return on Assets %
Financial Leverage (Average)
Return on Equity %
Return on Invested Capital %
Interest Coverage
Year over Year
3-Year Average
5-Year Average
10-Year Average
Operating Cash Flow Growth % YOY
Free Cash Flow Growth % YOY
Cap Ex as a % of Sales
Free Cash Flow/Sales %
Free Cash Flow/Net Income
Cash & Short-Term Investments
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
Net PP&E
Intangibles
Other Long-Term Assets
Total Assets
Accounts Payable
Short-Term Debt
Taxes Payable
Accrued Liabilities
Other Short-Term Liabilities
Total Current Liabilities
Long-Term Debt
Other Long-Term Liabilities
Total Liabilities
Total Stockholders’ Equity
Total Liabilities & Equity
Current Ratio
Quick Ratio
Financial Leverage
Debt/Equity
Days Sales Outstanding
Days Inventory
Payables Period
Cash Conversion Cycle
Receivables Turnover
Inventory Turnover
Fixed Assets Turnover
Asset Turnover
S&P 500 returns Stock Screener in Excel

Browse through the whole index by returns of all stocks. Following return KPIs are available…

7 Day Returns
15 Day Returns
1 Month Returns
3 Month Returns
6 Month Returns
1 Year Returns
3 Year Returns

Export all the underlying data in the screener chart to Excel with a click. And create your own screener, charts etc in Excel. Following image shows it working

Stock Screener in Excel


See Next Feature


Supercharge your stock research with MarketXLS.

Questions? Email support@marketxls.com

See our introductory pricing