Fundamental Analysis Screening Trading Strategy
Screen and analyze stocks using fundamental metrics with Sourcetable AI. Automatically calculate P/E ratios, earnings growth, cash flow, and financial health indicators without complex formulas.
Andrew Grosser
February 24, 2026 • 15 min read
Introduction
January 2023: You're screening 4,200 US equities for deep value. P/E below 12, P/B below 1.5, debt/equity under 0.5, ROE above 12%. Excel filters crash at 2,000 rows. You're looking at hundreds of stocks, trying to find the ones with solid fundamentals. Price-to-earnings ratios, debt-to-equity, revenue growth, cash flow—the list never ends. In Excel, this means pulling data from multiple sources, building complex formulas for dozens of metrics, and manually updating everything when new earnings reports drop. One wrong cell reference and your entire screening model falls apart.
Fundamental analysis screening is the systematic evaluation of stocks based on financial health, profitability, growth potential, and valuation metrics. Portfolio managers use it to identify undervalued companies with strong balance sheets. Traders rely on it to find stocks with earnings momentum. Analysts build entire investment theses around fundamental indicators like return on equity, free cash flow yield, and earnings per share growth sign up free.
Why Sourcetable Beats Excel for Fundamental Analysis Screening
Excel forces you into a rigid structure where every metric needs its own formula. Want to calculate price-to-book ratios? You're writing =MarketCap/BookValue across hundreds of rows. Need to screen for debt-to-equity below 0.5? That's another column with conditional formatting. Add earnings growth rates, dividend yields, and operating margins, and you're managing a sprawling workbook where one data update means recalculating everything manually.
The real problem hits when you want to combine multiple screening criteria. Finding stocks with P/E ratios under 20, revenue growth above 10%, positive free cash flow, and insider buying requires nested IF statements or complex filter functions. You're spending more time debugging formulas than analyzing opportunities. When quarterly earnings arrive, you're manually updating dozens of cells and hoping nothing breaks.
Sourcetable's AI understands fundamental analysis terminology and financial relationships. Ask 'Which stocks have improving profit margins and decreasing debt?' and the AI automatically calculates margin trends, analyzes debt trajectories, and presents results in seconds. It recognizes that profit margin means net income divided by revenue, and that 'improving' requires comparing current to historical values. You're not writing formulas—you're having a conversation about financial health.
The platform handles data updates automatically. When you refresh your financial data feed, Sourcetable recalculates all ratios, updates screening results, and flags changes in stock rankings. The AI maintains context across your entire analysis, so you can ask follow-up questions like 'Show me the cash flow trends for the top 10 results' without rebuilding queries. It's fundamental analysis at the speed of thought, not the speed of spreadsheet formulas.
Portfolio managers particularly value how Sourcetable handles multi-factor screening. Traditional Excel models require separate worksheets for value metrics, growth indicators, quality factors, and momentum signals. Sourcetable lets you combine all dimensions in natural language: 'Find undervalued companies with strong balance sheets and positive earnings surprises.' The AI knows what constitutes 'undervalued' (low P/E, P/B, or P/S ratios), 'strong balance sheets' (low debt, high current ratio), and 'positive earnings surprises' (actual EPS exceeding estimates).
Benefits of Fundamental Analysis Screening with Sourcetable
Fundamental screening separates investment-grade companies from speculative plays. Value investors use it to find stocks trading below intrinsic value. Growth investors identify companies with accelerating earnings and expanding margins. Quality-focused managers screen for consistent profitability and strong competitive positions. Sourcetable makes all these approaches accessible without spreadsheet expertise.
AI-Powered Ratio Calculations
Sourcetable automatically calculates every fundamental ratio from raw financial data. Upload income statements and balance sheets, then ask 'Calculate P/E ratios for all companies' or 'Show me return on equity trends.' The AI knows that P/E equals market cap divided by net income, that ROE requires net income divided by shareholder equity, and that trends require comparing multiple periods. You get instant results without writing a single formula.
The platform handles complex ratios like enterprise value to EBITDA, price-to-free cash flow, and debt-adjusted returns. Ask 'Which stocks have the lowest EV/EBITDA multiples?' and Sourcetable calculates enterprise value (market cap plus debt minus cash), extracts EBITDA from financial statements, computes the ratio, and ranks results. Traditional Excel requires five separate formula columns and careful cell referencing to achieve the same outcome.
- EV/EBITDA: Enterprise Value / EBITDA strips out capital structure and depreciation differences; below 8x = potentially undervalued, above 15x = premium valuation. Calculate: EV = market cap + net debt - cash; January 2023 median S&P 500 EV/EBITDA = 11.2x.
- Price/Book Ratio: Market cap / book value of equity; below 1.0x means the market values the company at less than its net assets—historically these stocks have outperformed by 4–7% annually, though value traps are common.
- Return on Invested Capital (ROIC): NOPAT / (Debt + Equity - Excess Cash); companies with ROIC consistently above WACC compound value over time; ROIC > 15% and P/E < 15x is the classic Buffett-style value screen.
- Free Cash Flow Yield: FCF / Market Cap; above 8% suggests undervaluation relative to cash generation; more reliable than earnings yield because FCF can't be manipulated through accruals—focus on 3-year average FCF to smooth lumpy capital expenditures.
Multi-Factor Screening in Natural Language
Combine dozens of screening criteria without complex formulas. Say 'Find stocks with P/E under 15, debt-to-equity below 0.5, ROE above 12%, and positive free cash flow growth' and Sourcetable applies all filters simultaneously. The AI understands logical operators, numerical thresholds, and growth calculations. Results appear in seconds with all supporting data visible.
You can layer qualitative and quantitative factors together. Ask 'Show technology stocks with improving gross margins and insider buying' and the AI filters by sector, calculates margin trends from quarterly data, and incorporates insider transaction information. In Excel, this requires multiple worksheets, pivot tables, and manual cross-referencing. Sourcetable handles everything in one conversational query.
- Quality Screen: Gross margin > 40%, operating margin > 15%, interest coverage > 5x, current ratio > 2; these filters isolate businesses with pricing power and financial safety—typically finds 3–5% of initial universe.
- Piotroski F-Score: 9-point scoring system combining profitability (ROA, cash flow, ROA change), leverage (debt change, current ratio change, share issuance), and efficiency (gross margin change, asset turnover change); score of 7–9 = strong, 0–2 = weak.
- Magic Formula (Greenblatt): Rank all stocks by earnings yield (EBIT/EV) + ROIC; buy top 20–30 stocks equally weighted, rebalance annually; backtested 30.8% vs 12.4% for S&P 500 over 1988–2004, though returns have moderated post-publication.
- Net-Net Stocks: Net current asset value (NCAV) = current assets - total liabilities; stocks trading below NCAV are liquidation plays—Graham's original formula required stock price at 67% of NCAV. Only 20–40 US stocks qualify at any given time.
Automatic Trend Analysis
Fundamental screening isn't just about current values—trends reveal momentum and deterioration. Sourcetable automatically analyzes multi-period data when you ask questions about growth or improvement. Request 'Companies with accelerating revenue growth' and the AI compares growth rates across quarters, identifying where the rate of increase is expanding. This requires complex nested formulas in traditional spreadsheets.
The platform recognizes financial statement relationships. When analyzing cash flow trends, it understands connections between operating cash flow, capital expenditures, and free cash flow. Ask 'Which companies are generating more cash while reducing capex intensity?' and Sourcetable calculates free cash flow trends and capex-to-revenue ratios simultaneously, flagging companies meeting both criteria.
- Earnings Trend Quality: Linear regression R² on 8-quarter EPS history; R² above 0.85 = consistent growth, below 0.40 = erratic earnings—erratic earners deserve lower multiples regardless of current valuation ratios.
- Revenue Growth Acceleration: Comparing last 4-quarter revenue growth to trailing 8-quarter growth; acceleration from 8% to 12% is a positive signal; deceleration from 20% to 14% (even if still high) is a negative signal for growth stocks.
- Margin Trend: Gross margin expansion of 50+ bps annually signals pricing power or efficiency improvement; gross margin compression is typically a leading indicator of future earnings disappointments, often 2–3 quarters before analyst consensus catches up.
- Balance Sheet Trend: Increasing cash + declining debt = financial health improving; increasing debt + declining cash = potential stress ahead. Track net debt/EBITDA trend over 8 quarters—deterioration from 1.5x to 2.8x preceded 60% of high-yield credit events in historical analysis.
Instant Peer Comparisons
Context matters in fundamental analysis. A 25 P/E ratio might be expensive for utilities but cheap for software companies. Sourcetable enables instant peer group comparisons: 'How does Apple's ROE compare to other mega-cap tech stocks?' or 'Show me which retail companies have the strongest balance sheets.' The AI segments data by industry, calculates relative metrics, and highlights outliers.
You can create custom peer groups and compare across any dimension. Ask 'Compare the top 5 stocks by market cap in each sector on profitability metrics' and Sourcetable segments by sector, identifies leaders by size, calculates profit margins and ROE for each, and presents side-by-side comparisons. Building this analysis in Excel requires pivot tables, multiple worksheets, and manual formula construction across segmented data.
Visual Financial Analysis
Numbers tell part of the story—visualizations reveal patterns. Sourcetable automatically generates charts when useful. Ask 'Show me the relationship between P/E ratios and earnings growth' and you get a scatter plot with regression analysis. Request 'Chart ROE trends for my top screening results' and the AI creates time series comparisons showing which companies are improving versus declining.
The platform creates dashboards on demand. Say 'Build a dashboard showing valuation, profitability, and growth metrics for these 20 stocks' and Sourcetable generates a multi-panel view with key ratios, trend indicators, and comparative rankings. You can refine visualizations conversationally: 'Highlight stocks with P/E below sector average' or 'Color-code by debt levels.' No chart wizard, no manual formatting—just natural language instructions.
How Fundamental Analysis Screening Works in Sourcetable
Sourcetable transforms raw financial data into actionable investment insights through conversational AI. The process eliminates spreadsheet formula work while maintaining analytical rigor. Here's how portfolio managers and analysts use the platform for fundamental screening.
Step 1: Import Financial Data
Start by uploading financial statements or connecting to data providers. Sourcetable accepts CSV files, Excel workbooks, and direct connections to financial data services. Upload income statements, balance sheets, and cash flow statements for your stock universe. The AI automatically recognizes financial data structures—it knows revenue appears as 'Total Revenue,' 'Net Sales,' or 'Sales' depending on your data source.
You can import market data alongside financial statements. Include current stock prices, shares outstanding, and market capitalizations. Sourcetable links ticker symbols across datasets automatically, so price data connects to the correct financial statements without manual VLOOKUP formulas. If you're screening 500 stocks, just upload your data files and the AI handles all relationships.
- Start by uploading financial statements or connecting to data providers.
- You can import market data alongside financial statements.
Step 2: Define Screening Criteria in Plain English
Instead of building formula-based filters, describe what you're looking for. Type 'Show me all stocks with P/E ratios below 15 and ROE above 15%' and Sourcetable calculates both metrics from your financial data, applies the thresholds, and returns matching stocks. The AI understands that P/E requires dividing market cap by net income, and ROE needs net income divided by shareholder equity.
You can screen on any combination of fundamental factors. Try 'Find companies with debt-to-equity under 0.5, operating margins above 10%, and positive free cash flow' or 'Which stocks have growing earnings per share and declining share counts?' Sourcetable interprets each criterion, performs necessary calculations, and applies filters simultaneously. Results appear with all supporting metrics visible.
Step 3: Refine Results with Follow-Up Questions
Screening is iterative. After seeing initial results, you'll want to dig deeper. Ask 'Of these results, which have the highest revenue growth?' or 'Show me only the ones with insider buying in the last quarter.' Sourcetable maintains context from your previous query, so it applies new filters to your existing result set rather than starting over.
The AI handles complex refinements conversationally. Say 'Remove any stocks with negative cash flow' or 'Add a column showing price-to-book ratios' and Sourcetable adjusts your results immediately. You can request 'Sort by dividend yield descending' or 'Highlight companies that beat earnings estimates.' Each instruction modifies your analysis without requiring formula rewrites or filter reconstructions.
- "ll want to dig deeper. Ask "
- "Show me only the ones with insider buying in the last quarter."
- "Remove any stocks with negative cash flow"
- "Add a column showing price-to-book ratios"
Step 4: Analyze Trends and Relationships
Move beyond static snapshots to dynamic trend analysis. Ask 'Show me revenue growth rates over the last 8 quarters for these companies' and Sourcetable calculates quarter-over-quarter and year-over-year growth from your multi-period data. Request 'Which stocks have improving profit margins?' and the AI compares recent margins to historical averages, flagging upward trends.
You can explore relationships between metrics. Try 'Is there a correlation between R&D spending and revenue growth in my results?' and Sourcetable performs regression analysis, generates scatter plots, and reports correlation coefficients. Ask 'Show me how ROE has changed as debt levels increased' and you get time series comparisons revealing leverage impacts. These analyses require advanced Excel skills and multiple formula types—Sourcetable delivers them conversationally.
Step 5: Create Comparative Rankings
Fundamental screening often produces too many candidates. Rankings help prioritize. Say 'Rank these stocks by a combination of value and quality metrics' and Sourcetable creates composite scores weighting P/E ratios, ROE, debt levels, and other factors. You can specify weights: 'Give 40% weight to valuation, 30% to profitability, and 30% to growth' and the AI builds custom rankings.
The platform enables sector-relative rankings. Ask 'Rank each stock against its industry peers on profitability' and Sourcetable segments your data by sector, calculates percentile rankings within each group, and shows where each company stands relative to competitors. This reveals which stocks are sector leaders versus laggards—critical context for fundamental analysis.
Step 6: Export and Share Results
Once you've identified promising stocks, export your screening results. Sourcetable generates Excel files, CSV exports, or shareable links with all calculated metrics included. Your screening criteria, custom calculations, and rankings transfer to standard spreadsheet formats for further analysis or presentation to investment committees.
You can schedule automated screening updates. Set Sourcetable to re-run your fundamental screens when new financial data arrives, then receive alerts when stocks newly qualify or drop out of your criteria. This turns one-time analysis into ongoing surveillance without manual spreadsheet updates or formula maintenance.
Real-World Use Cases for Fundamental Analysis Screening
Fundamental screening serves different investment approaches and portfolio management needs. Here's how traders, analysts, and portfolio managers apply Sourcetable's AI-powered screening to real investment decisions.
Value Investing: Finding Undervalued Quality Companies
A portfolio manager running a value strategy needs to identify stocks trading below intrinsic value with solid fundamentals. She starts by uploading financial data for 800 publicly traded companies along with current market prices. In Sourcetable, she asks: 'Show me stocks with P/E below 12, P/B below 1.5, debt-to-equity under 0.6, and positive free cash flow.' The AI instantly screens all 800 companies, calculating each ratio and applying thresholds.
The initial screen returns 47 candidates. She refines further: 'Of these, which have ROE above 10% and consistent profitability over 5 years?' Sourcetable analyzes historical earnings, calculates ROE for each period, and filters to companies meeting both criteria. The list narrows to 18 stocks. She then asks 'Show me earnings stability—standard deviation of annual EPS' and Sourcetable calculates volatility metrics, helping her identify the most consistent performers.
To understand valuation context, she requests 'Compare these stocks' P/E ratios to their 5-year historical averages.' The AI calculates historical P/E ranges and shows which stocks are trading at below-average valuations relative to their own history. This reveals companies that are genuinely cheap, not just low P/E due to deteriorating business quality. The entire analysis—from 800 stocks to a focused list of undervalued quality companies—takes minutes instead of days of Excel work.
Growth Screening: Identifying Momentum Opportunities
A quantitative trader focuses on growth stocks with accelerating fundamentals. He uploads quarterly financial data spanning three years for his trading universe. His screening question: 'Find stocks where revenue growth is accelerating and operating margins are expanding.' Sourcetable calculates quarter-over-quarter revenue growth rates, identifies where the rate of growth is increasing, and simultaneously analyzes margin trends.
The results show 63 companies with both characteristics. He adds: 'Which of these have positive earnings surprises in the last two quarters?' The AI incorporates earnings estimate data, compares actual to expected EPS, and filters to companies consistently beating expectations. The list narrows to 28 stocks. He then requests 'Show me price momentum—stocks up more than 15% in the last quarter' to identify where fundamental momentum aligns with price momentum.
To assess sustainability, he asks 'Calculate the relationship between revenue growth and free cash flow growth for these stocks.' Sourcetable performs correlation analysis and generates scatter plots showing which companies are converting revenue growth into actual cash generation versus those growing through accounting gains. This helps him avoid growth traps where revenue increases but cash flow stagnates. The AI-powered approach combines multiple data dimensions that would require complex Excel models with dozens of formula columns.
Quality Screening: Building Defensive Portfolios
An institutional analyst needs to build a defensive portfolio of high-quality companies with strong balance sheets and consistent profitability. She uploads 10 years of financial data for large-cap stocks. Her initial query: 'Show me companies with ROE above 15%, ROIC above 12%, and debt-to-equity below 0.5 consistently over the last 5 years.' Sourcetable analyzes multi-year data, calculates returns on equity and invested capital for each period, and identifies companies meeting all criteria in every year.
The screen returns 34 companies. She refines: 'Which have maintained or grown dividends every year for the last decade?' The AI examines dividend payment history and filters to companies with uninterrupted dividend growth. She then asks 'Show me free cash flow payout ratios—are dividends covered by cash generation?' Sourcetable calculates FCF payout ratios, revealing which companies have sustainable dividend policies versus those paying out more than they generate.
To assess competitive positioning, she requests 'Compare gross margins and operating margins to industry averages for each stock.' Sourcetable segments by industry, calculates peer group averages, and shows which companies operate with superior profitability. She follows with 'Show me working capital efficiency—cash conversion cycles for these companies' and the AI calculates days sales outstanding, days inventory outstanding, and days payable outstanding to reveal operational efficiency. The result is a curated list of genuinely high-quality companies backed by comprehensive fundamental analysis.
Behavioral Finance: Incorporating Sentiment and Insider Activity
A hedge fund analyst combines fundamental screening with behavioral finance signals. He starts with traditional value metrics: 'Find stocks with P/E below sector median and positive free cash flow yield.' Sourcetable performs sector-relative screening and returns 89 candidates. He then layers in behavioral signals: 'Which of these have insider buying in the last 90 days?' The AI incorporates insider transaction data and filters to companies where executives and directors are purchasing shares.
The list narrows to 23 stocks where fundamentals look attractive and insiders are backing up the thesis with their own money. He adds sentiment analysis: 'Show me analyst rating changes—which stocks have been upgraded recently?' Sourcetable incorporates analyst recommendation data and highlights companies receiving positive rating revisions. This reveals situations where fundamental value is being recognized by both insiders and Wall Street analysts.
To identify potential catalysts, he asks 'Which companies have earnings announcements in the next two weeks?' and 'Show me historical earnings surprise patterns for these stocks.' Sourcetable identifies upcoming events and calculates how often each company has beaten estimates historically. This helps him prioritize positions where strong fundamentals, insider confidence, and positive sentiment align with near-term catalysts. The behavioral finance overlay transforms basic fundamental screening into a multi-dimensional investment strategy.
Frequently Asked Questions
If your question is not covered here, you can contact our team.
Contact UsWhat is the Piotroski F-Score and how does it work?
How does the Altman Z-Score predict financial distress?
What return on equity threshold distinguishes high-quality from mediocre businesses?
How do free cash flow screens outperform EPS-based screens?
What debt metrics best predict future stock underperformance?
How do you build a composite fundamental score for stock ranking?
What role does revenue growth quality play in fundamental screening?
