More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Magic Formula Stock Screen (Earnings Yield + ROC)

    1

    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

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Magic Formula Stock Screen (Earnings Yield + ROC)

    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.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Trading & Investing.

    User supplies the screener data. Not investment advice.

    How to use

    1. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    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

    Listed23 days ago

    What's inside

    Frequently Asked Questions

    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.

    This skill uses the open SKILL.md standard. Use it through an MCP-compatible agent connected to Agensi, and check the compatibility information on this page for confirmed agents and required capabilities.

    Connect your AI agent to Agensi through MCP, then ask it to use Magic Formula Stock Screen (Earnings Yield + ROC) on your task. Your agent loads the latest approved version each time. Paid skills require a purchase or active subscription. Skill files are not available for download; your licence does not allow you to save, copy or export any part of a skill.

    New in Trading & Investing