- Home
- Skills
- Trading & Investing
- Magic Formula Stock Screen (Earnings Yield + ROC)
More screenshots
Works with the AI Agents you already use
Magic Formula Stock Screen (Earnings Yield + ROC)
Greenblatt-style ranking of any screener export on EBIT/EV and return on capital, with India/US universe rules, Ind AS 116 consistency, quality overlay and an Excel buy list.
$5
Magic Formula Stock Screen (Earnings Yield + ROC)
Example session with this skill installed
Run the Magic Formula on this Screener.in export of 1,200 NSE stocks, minimum ₹1,000 cr market cap, with the Piotroski overlay.
- Read your context and instructions
- Compiled the magic formula stock
Top 30 ranked list with EY, ROC and combined rank, sector concentration warning, exclusions with reasons, and a live-formula Excel workbook.
Connects securely to your tools. The creator never sees your data.
About this skill
Joel Greenblatt's The Little Book That Beats the Market ranks companies on two numbers — how cheap (earnings yield) and how good (return on capital) — and buys the best combined rank. This skill runs it on a user-supplied universe. Methodology reference only; no affiliation.
A CSV/Excel screener export (e.g., Screener.in, Tickertape, Finviz, Koyfin) or pasted list with: name, market cap, EBIT (TTM), total debt, cash, minority interest, preference capital, net working capital (current assets − cash − (current liabilities − short-term debt)), net fixed assets (net PP&E incl. CWIP; exclude goodwill), sector.
- Minimum market cap: India ₹1,000 cr (or ₹500 cr for a small-cap variant); US $100m–$1bn as the user prefers
- Exclude: banks, NBFCs, insurers, utilities (regulated returns), and holding companies
- Exclude: companies with negative EBIT, a qualified latest audit opinion, promoter pledge > 25% (India), or ADRs (US)
- Use EBIT, not net income, and EV, not market cap, so debt and tax differences don't distort
Buy the top 20–30, 5–7 positions every 2–3 months; hold each ~1 year; rebalance annually. Mention tax timing: in India, listed-equity gains held over 12 months are long-term; in the US the 1-year line separates short- and long-term gains.
User supplies the screener data. Not investment advice.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 23 days ago
Permissions
No special permissions declared or detected