Screen Stocks by Investment Thesis
Screen the S&P 500 for companies with >75% recurring revenue that would also benefit from escalating US-China tensions over Taiwan. Each company is evaluated via web research for subscription revenue mix and geopolitical exposure.
| Metric | Value |
|---|---|
| Rows processed | 502 |
| Rows passing | 63 (12.5%) |
| Total cost | $17.15 |
| Time | 15.5 minutes |
Add FutureSearch to Claude Code if you haven't already:
claude mcp add futuresearch --scope project --transport http https://mcp.futuresearch.ai/mcp
With your S&P 500 CSV in the working directory, tell Claude:
Screen this S&P 500 dataset to find companies with high-quality recurring revenue
business models that would also benefit from escalating US-China tensions over Taiwan.
Recurring revenue >75%: Subscription services, long-term contracts, maintenance
agreements, royalty streams. Not one-time product sales or project-based work.
Taiwan tensions beneficiary: CHIPS Act beneficiaries, defense contractors,
cybersecurity, reshoring plays, alternative supply chain providers. Exclude
companies dependent on Taiwan manufacturing or with significant China revenue at risk.
Claude calls FutureSearch's classify MCP tool, which runs a two-pass pipeline: a fast first pass triages all rows, then a careful second pass re-evaluates borderline cases:
Tool: futuresearch_classify
├─ task: "Find companies with high-quality recurring revenue business models..."
├─ input_csv: "/Users/you/sp500.csv"
└─ categories: ["yes", "no"]
→ Submitted: 502 rows for classification.
Session: https://futuresearch.ai/sessions/374a9a36-55e7-4b7c-92e8-6d396b40071b
Task ID: fc3d...
Tool: futuresearch_progress
├─ task_id: "fc3d..."
→ Running: 0/502 complete, 502 running (30s elapsed)
...
Tool: futuresearch_progress
→ Completed: 502/502 (0 failed) in 930s.
Tool: futuresearch_results
├─ task_id: "fc3d..."
├─ output_path: "/Users/you/thesis_screen.csv"
→ Saved 63 rows to /Users/you/thesis_screen.csv
Add the FutureSearch connector if you haven't already. Then upload your S&P 500 CSV and ask Claude:
Screen to find companies with high-quality recurring revenue business models (>75% recurring) that would also benefit from escalating US-China tensions over Taiwan. Include CHIPS Act beneficiaries, defense contractors, cybersecurity, reshoring plays. Exclude companies dependent on Taiwan manufacturing or with significant China revenue at risk.
Results take about 15.5 minutes.
Go to futuresearch.ai/app, upload your S&P 500 CSV, and enter:
Screen to find companies with high-quality recurring revenue business models (>75% recurring) that would also benefit from escalating US-China tensions over Taiwan. Include CHIPS Act beneficiaries, defense contractors, cybersecurity, reshoring plays. Exclude companies dependent on Taiwan manufacturing or with significant China revenue at risk.
Screening is binary classification: use classify() with categories=["yes", "no"] and only passing rows are returned.
pip install futuresearch
export FUTURESEARCH_API_KEY=your_key_here # Get one at futuresearch.ai/app/api-key
import asyncio
import pandas as pd
from futuresearch import create_session
from futuresearch.ops import classify
stocks = pd.read_csv("sp500.csv")
async def main():
async with create_session(name="Stock Screening: Investment Thesis") as session:
result = await classify(
session=session,
task="""
Find companies with high-quality recurring revenue business models
that would also benefit from escalating US-China tensions over Taiwan.
Recurring revenue >75%: Subscription services, long-term contracts,
maintenance agreements, royalty streams.
Taiwan tensions beneficiary: CHIPS Act beneficiaries, defense contractors,
cybersecurity, reshoring plays, alternative supply chain providers.
""",
categories=["yes", "no"],
input=stocks,
)
return result.data
results = asyncio.run(main())
Results
63 of 502 companies passed (12.5%).
| Sector | Passing |
|---|---|
| Information Technology | 13 |
| Utilities | 13 |
| Financials | 12 |
| Industrials | 11 |
Sample passing companies:
| Ticker | Company | Sector |
|---|---|---|
| LLY | Eli Lilly | Health Care |
| PLTR | Palantir Technologies | Information Technology |
| NOW | ServiceNow | Information Technology |
| PANW | Palo Alto Networks | Information Technology |
| CRWD | CrowdStrike | Information Technology |
| GD | General Dynamics | Industrials |
| NOC | Northrop Grumman | Industrials |
Each result includes research explaining the decision. For ServiceNow: "97% of revenue from subscriptions. Critical enabler of cybersecurity and digital transformation for US federal government infrastructure."