Close Menu
NCIJ Network NCIJ Network
    What's Hot

    I’m recommending this 14-inch HP laptop to almost everyone in 2026 – even with the RAM crisis

    July 27, 2026

    Beelzebub Raises $3.4 Million for Hacker-Trapping Platform

    July 27, 2026

    Uphold reduces global headcount by 17% amid enterprise pivot

    July 27, 2026
    Facebook X (Twitter) Instagram
    Trending
    • I’m recommending this 14-inch HP laptop to almost everyone in 2026 – even with the RAM crisis
    • Beelzebub Raises $3.4 Million for Hacker-Trapping Platform
    • Uphold reduces global headcount by 17% amid enterprise pivot
    • Scientists reveal what sparkling water really does to your teeth
    • Australia’s ‘largest untapped’ conventional gas resource gets significant project status
    • Five things to know as data centers spread across rural America 
    • The Fight for International Justice Continues
    • Wildfire now nine miles away from French city of Bordeaux, mayor warns
    • About
      • Our Team
      • Editorial Policy
      • Editorial Independence
      • International Support
    • Trust & Standards
      • AI Usage Policy
      • Conflict of Interest Policy
      • Corrections Policy
      • Ethics Policy
      • Fact-Checking Policy
      • Source Protection
    • Get Involved
      • Guide for Sources
      • Support Independent Journalism
    • Legal
      • Cookie Policy
      • Privacy Policy
      • Terms of Use
    Facebook X (Twitter) Instagram
    NCIJ Network NCIJ Network
    Monday, July 27
    • Home
    • World
    • Ai
    • Business
    • Politics
    • Health
    • Crypto
    • Science
    • Technology
    • Cybersecurity
    • Defense & Security
    • Economy
    • Energy
    • Europe
    • More
      • Fact Check
      • Investigations
      • Opinion & Analysis
      • Environment
    NCIJ Network NCIJ Network
    Home»Artificial Intelligence

    Designing Skill-Driven Financial Analysis Agents with Claude, Python, MCP Connectors, and Automated Deliverables

    NCIJ NETWNCIJ NETWORKBy NCIJ NETWNCIJ NETWORKJuly 27, 2026 Artificial Intelligence No Comments11 Mins Read
    Share
    Facebook Twitter LinkedIn Pinterest Email

    In this tutorial, we build an advanced workflow around Anthropic’s financial-services repository and reproduce its skill-driven architecture in pure Python. We begin by installing the required libraries, cloning the repository, and programmatically mapping its agents, vertical plugins, partner integrations, managed-agent cookbooks, and financial analysis skills. We then parse the repository’s SKILL.md files into a searchable registry and construct a reusable SkillAgent that injects selected financial playbooks into the Anthropic Messages API while supporting an iterative tool-use loop for Python calculations and file generation. Using this architecture, we execute a synthetic discounted cash flow valuation, generate a WACC and terminal-growth sensitivity heatmap, perform comparable-company analysis with formatted Excel output, draft a private-equity investment committee memo, and inspect a managed-agent deployment specification without sending a live deployment request.

    import subprocess, sys, os, io, re, json, glob, textwrap, contextlib, pathlib
    def sh(cmd):
       print(f"$ {cmd}")
       r = subprocess.run(cmd, shell=True, capture_output=True, text=True)
       if r.returncode != 0:
           print(r.stderr[-1500:])
       return r
    sh(f"{sys.executable} -m pip install -q anthropic pandas openpyxl pyyaml matplotlib")
    import pandas as pd
    import yaml
    import matplotlib.pyplot as plt
    REPO_URL = "https://github.com/anthropics/financial-services.git"
    REPO_DIR = "financial-services"
    if not os.path.isdir(REPO_DIR):
       sh(f"git clone --depth 1 {REPO_URL} {REPO_DIR}")
    else:
       print("Repo already cloned — skipping.")
    def get_api_key():
       try:
           from google.colab import userdata
           k = userdata.get("ANTHROPIC_API_KEY")
           if k:
               return k
       except Exception:
           pass
       if os.environ.get("ANTHROPIC_API_KEY"):
           return os.environ["ANTHROPIC_API_KEY"]
       from getpass import getpass
       return getpass("Enter your Anthropic API key: ")
    os.environ["ANTHROPIC_API_KEY"] = get_api_key()
    import anthropic
    client = anthropic.Anthropic()
    MODEL = "claude-sonnet-4-6"
    print("SDK ready. Model:", MODEL)
    

    We install the required Python libraries, clone Anthropic’s financial-services repository, and prepare the Google Colab runtime for execution. We retrieve the Anthropic API key from Colab secrets, environment variables, or a secure interactive prompt. We then initialize the official Anthropic SDK and select the Claude model that powers the financial-analysis workflows.

    def repo_map(root=REPO_DIR):
       rows = []
       for kind, pattern in [
           ("agent",   f"{root}/plugins/agent-plugins/*"),
           ("vertical",f"{root}/plugins/vertical-plugins/*"),
           ("partner", f"{root}/plugins/partner-built/*"),
           ("cookbook",f"{root}/managed-agent-cookbooks/*"),
       ]:
           for p in sorted(glob.glob(pattern)):
               if not os.path.isdir(p):
                   continue
               skills   = glob.glob(f"{p}/**/SKILL.md", recursive=True)
               commands = glob.glob(f"{p}/commands/*.md")
               rows.append({"type": kind, "name": os.path.basename(p),
                            "skills": len(skills), "commands": len(commands)})
       return pd.DataFrame(rows)
    print("n=== REPO MAP ===")
    repo_df = repo_map()
    print(repo_df.to_string(index=False))
    mcp_files = glob.glob(f"{REPO_DIR}/plugins/**/.mcp.json", recursive=True)
    for f in mcp_files[:1]:
       print(f"n=== MCP CONNECTORS ({f}) ===")
       try:
           cfg = json.load(open(f))
           for name, srv in cfg.get("mcpServers", cfg).items():
               print(f"  {name:<14} -> {srv.get('url', srv)}")
       except Exception as e:
           print("  (could not parse:", e, ")")
    FRONTMATTER = re.compile(r"^---s*n(.*?)n---s*n", re.S)
    class Skill:
       def __init__(self, path):
           self.path = path
           raw = open(path, encoding="utf-8", errors="replace").read()
           m = FRONTMATTER.match(raw)
           meta = {}
           if m:
               try:
                   meta = yaml.safe_load(m.group(1)) or {}
               except Exception:
                   meta = {}
           self.name = str(meta.get("name") or pathlib.Path(path).parent.name)
           self.description = str(meta.get("description", ""))[:300]
           self.body = raw[m.end():] if m else raw
       def __repr__(self):
           return f""
    class SkillRegistry:
       def __init__(self, root=REPO_DIR):
           paths  = sorted(glob.glob(f"{root}/plugins/vertical-plugins/**/SKILL.md", recursive=True))
           paths += sorted(glob.glob(f"{root}/plugins/**/SKILL.md", recursive=True))
           self.skills = {}
           for p in paths:
               s = Skill(p)
               self.skills.setdefault(s.name.lower(), s)
       def find(self, query):
           q = query.lower()
           hits = [s for k, s in self.skills.items() if q in k]
           if not hits:
               hits = [s for s in self.skills.values() if q in s.description.lower()]
           return hits
       def get(self, query):
           hits = self.find(query)
           if not hits:
               raise KeyError(f"No skill matching '{query}'. "
                              f"Available: {sorted(self.skills)[:40]}")
           return hits[0]
    registry = SkillRegistry()
    print(f"nLoaded {len(registry.skills)} unique skills.")
    print("Sample:", sorted(registry.skills)[:12], "...")
    

    We inspect the repository structure and identify its agent plugins, vertical plugins, partner integrations, managed-agent cookbooks, and available commands. We locate MCP configuration files and display the external financial data connectors defined in the repository. We then parse each SKILL.md file, extract its YAML metadata and methodology, and register every unique skill for searchable access.

    os.makedirs("outputs", exist_ok=True)
    TOOLS = [
       {
           "name": "run_python",
           "description": ("Execute Python code and return stdout. pandas as pd "
                           "and numpy as np are pre-imported. Use print() to "
                           "return results. State persists across calls."),
           "input_schema": {
               "type": "object",
               "properties": {"code": {"type": "string"}},
               "required": ["code"],
           },
       },
       {
           "name": "save_file",
           "description": "Save text content to outputs/.",
           "input_schema": {
               "type": "object",
               "properties": {"filename": {"type": "string"},
                              "content":  {"type": "string"}},
               "required": ["filename", "content"],
           },
       },
    ]
    _PY_NS = {}
    def _tool_run_python(code):
       import numpy as np
       _PY_NS.setdefault("pd", pd); _PY_NS.setdefault("np", np)
       buf = io.StringIO()
       try:
           with contextlib.redirect_stdout(buf):
               exec(code, _PY_NS)
           out = buf.getvalue()
           return out[:6000] if out else "(no stdout — use print())"
       except Exception as e:
           return f"ERROR: {type(e).__name__}: {e}"
    def _tool_save_file(filename, content):
       safe = os.path.basename(filename)
       path = os.path.join("outputs", safe)
       open(path, "w", encoding="utf-8").write(content)
       return f"Saved {path} ({len(content)} chars)"
    DISPATCH = {"run_python": lambda i: _tool_run_python(i["code"]),
               "save_file":  lambda i: _tool_save_file(i["filename"], i["content"])}
    BASE_SYSTEM = """You are a financial analyst assistant operating with the
    skill playbooks provided below (from Anthropic's financial-services repo).
    Follow the skill's methodology, conventions, and output format closely.
    Use the run_python tool for all numerical work — never do arithmetic in
    your head. Use save_file for final deliverables. All work is a DRAFT for
    human review; do not present it as investment advice."""
    class SkillAgent:
       """Minimal reproduction of Cowork's skill-firing: chosen skills are
       concatenated into the system prompt; the agent then runs a standard
       tool-use loop against the Messages API until the model stops."""
       def __init__(self, skill_queries, max_skill_chars=12000, verbose=True):
           self.skills = [registry.get(q) for q in skill_queries]
           blocks = []
           for s in self.skills:
               blocks.append(f"nn===== SKILL: {s.name} =====n"
                             f"{s.description}n{s.body[:max_skill_chars]}")
           self.system = BASE_SYSTEM + "".join(blocks)
           self.verbose = verbose
       def run(self, prompt, max_turns=12):
           messages = [{"role": "user", "content": prompt}]
           for turn in range(max_turns):
               resp = client.messages.create(
                   model=MODEL, max_tokens=8000,
                   system=self.system, tools=TOOLS, messages=messages)
               messages.append({"role": "assistant", "content": resp.content})
               if resp.stop_reason != "tool_use":
                   final = "".join(b.text for b in resp.content
                                   if b.type == "text")
                   return final, messages
               results = []
               for block in resp.content:
                   if block.type == "tool_use":
                       if self.verbose:
                           print(f"  [turn {turn}] tool: {block.name}")
                       out = DISPATCH[block.name](block.input)
                       results.append({"type": "tool_result",
                                       "tool_use_id": block.id,
                                       "content": str(out)})
               messages.append({"role": "user", "content": results})
           return "(hit max_turns)", messages
    

    We define tools that allow Claude to execute Python calculations and save generated deliverables inside the Colab environment. We build a persistent Python namespace so numerical models, tables, and intermediate variables remain available across multiple agent turns. We then create the SkillAgent class, inject selected financial playbooks into its system prompt, and manage the Anthropic Messages API tool-use loop.

    SAMPLE_CO = """
    Target: 'Meridian Software' (synthetic). FY2025 actuals, $mm:
    Revenue 850 (grew 18% y/y) | EBITDA margin 27% | D&A 4% of rev
    CapEx 5% of rev | NWC change 1% of rev growth | Tax rate 24%
    Net debt 320 | Diluted shares 92mm
    Assumptions: revenue growth fades 18% -> 6% linearly over 5 yrs,
    EBITDA margin expands 100bps total, WACC 9.5%, terminal growth 2.5%.
    """
    print("n" + "="*76 + "nDEMO A — DCF (dcf-model skill)n" + "="*76)
    try:
       dcf_agent = SkillAgent(["dcf"])
       dcf_answer, _ = dcf_agent.run(
           "Run a 5-year unlevered DCF per the skill playbook on this company:n"
           + SAMPLE_CO +
           "nCompute enterprise value, equity value, and implied share price "
           "with run_python. Then print a WACC (8.5%-10.5%, 50bp steps) x "
           "terminal growth (1.5%-3.5%, 50bp steps) sensitivity grid of implied "
           "share price as a JSON object under the marker SENS_JSON:, and give "
           "a concise summary.")
       print("n--- DCF RESULT ---n", dcf_answer[:3000])
       m = re.search(r"SENS_JSON:s*({.*})", dcf_answer, re.S)
       if m:
           grid = json.loads(m.group(1))
           sens = pd.DataFrame(grid)
           sens = sens.apply(pd.to_numeric, errors="coerce")
           fig, ax = plt.subplots(figsize=(7, 4))
           im = ax.imshow(sens.values, cmap="RdYlGn", aspect="auto")
           ax.set_xticks(range(len(sens.columns)), sens.columns)
           ax.set_yticks(range(len(sens.index)), sens.index)
           ax.set_xlabel("Terminal growth"); ax.set_ylabel("WACC")
           ax.set_title("Implied share price sensitivity ($)")
           for i in range(sens.shape[0]):
               for j in range(sens.shape[1]):
                   v = sens.values[i, j]
                   if pd.notna(v):
                       ax.text(j, i, f"{v:,.0f}", ha="center", va="center",
                               fontsize=8)
           fig.colorbar(im); plt.tight_layout(); plt.show()
    except Exception as e:
       print("Demo A skipped:", e)
    

    We provide synthetic operating assumptions and instruct the DCF skill agent to construct a five-year unlevered cash-flow valuation. We use the Python execution tool to calculate enterprise value, equity value, implied share price, and a two-dimensional sensitivity matrix. We then extract the structured sensitivity results and visualize the relationship between WACC, terminal growth, and implied valuation through a heatmap.

    PEERS = """
    Synthetic peer set ($mm except per-share):
    Ticker  Price  Shares  NetDebt  Rev_NTM  EBITDA_NTM  EPS_NTM
    ALFA    64.2   210     450      2900     820         3.10
    BRVO    28.7   540     -120     4100     980         1.45
    CHRL    112.5  95      760      1850     610         5.60
    DLTA    41.9   330     210      2600     700         2.05
    """
    print("n" + "="*76 + "nDEMO B — COMPS (comps-analysis skill) -> Exceln" + "="*76)
    try:
       comps_agent = SkillAgent(["comps"])
       comps_answer, _ = comps_agent.run(
           "Per the comps skill, compute EV, EV/Revenue, EV/EBITDA and P/E "
           "(all NTM) for these peers with run_python:n" + PEERS +
           "nThen print the full comps table plus min/25th/median/75th/max "
           "summary stats as JSON under the marker COMPS_JSON: with keys "
           "'table' (list of row dicts) and 'stats' (dict of dicts).")
       print("n--- COMPS NARRATIVE ---n", comps_answer[:1500])
       m = re.search(r"COMPS_JSON:s*({.*})", comps_answer, re.S)
       if m:
           payload = json.loads(m.group(1))
           table = pd.DataFrame(payload["table"])
           stats = pd.DataFrame(payload["stats"])
           xlsx = "outputs/comps_analysis.xlsx"
           with pd.ExcelWriter(xlsx, engine="openpyxl") as xl:
               table.to_excel(xl, sheet_name="Comps", index=False)
               stats.to_excel(xl, sheet_name="Summary Stats")
           from openpyxl import load_workbook
           from openpyxl.styles import Font, PatternFill
           wb = load_workbook(xlsx)
           for ws in wb.worksheets:
               for cell in ws[1]:
                   cell.font = Font(bold=True, color="FFFFFF")
                   cell.fill = PatternFill("solid", start_color="1F4E79")
               for col in ws.columns:
                   w = max(len(str(c.value)) for c in col if c.value is not None)
                   ws.column_dimensions[col[0].column_letter].width = w + 3
           wb.save(xlsx)
           print("Wrote", xlsx)
           print(table.to_string(index=False))
    except Exception as e:
       print("Demo B skipped:", e)
    

    We supply a synthetic peer set and calculate enterprise value, EV-to-revenue, EV-to-EBITDA, and price-to-earnings multiples. We convert the agent’s structured JSON response into detailed comparable-company and summary-statistics DataFrames. We then export the analysis to a multi-sheet Excel workbook and apply professional header formatting and automatic column sizing.

    print("n" + "="*76 + "nDEMO C — IC MEMO (ic-memo skill)n" + "="*76)
    try:
       ic_agent = SkillAgent(["ic-memo"])
       ic_answer, _ = ic_agent.run(
           "Draft a first-round IC memo per the skill for a hypothetical "
           "buyout of Meridian Software (see facts below). Base the valuation "
           "framing on ~11x EV/EBITDA entry, 45% leverage, 5-yr hold. Use "
           "run_python for any quick math (e.g., rough MOIC/IRR math) and "
           "save the memo with save_file as ic_memo_meridian.md.n" + SAMPLE_CO)
       print("n--- IC MEMO (first 1500 chars of reply) ---n", ic_answer[:1500])
       memo_path = "outputs/ic_memo_meridian.md"
       if os.path.exists(memo_path):
           print(f"nMemo saved -> {memo_path} "
                 f"({os.path.getsize(memo_path)} bytes)")
    except Exception as e:
       print("Demo C skipped:", e)
    print("n" + "="*76 + "nPART 7 — MANAGED AGENT COOKBOOK (dry run)n" + "="*76)
    yamls = sorted(glob.glob(f"{REPO_DIR}/managed-agent-cookbooks/*/agent.yaml")) 
         + sorted(glob.glob(f"{REPO_DIR}/managed-agent-cookbooks/*/*.yaml"))
    if yamls:
       path = yamls[0]
       print("Inspecting:", path)
       try:
           spec = yaml.safe_load(open(path))
           print(json.dumps(spec, indent=2, default=str)[:2500])
           print("nDeploy flow: resolve file refs -> upload skills -> create "
                 "leaf-worker subagents -> POST orchestrator to /v1/agents "
                 "(see scripts/orchestrate.py for the handoff_request event loop).")
       except Exception as e:
           print("Could not parse yaml:", e)
    else:
       print("No cookbook yaml found on this branch — see "
             "managed-agent-cookbooks/ READMEs on GitHub.")
    print("n" + "="*76)
    print("DONE. Artifacts in ./outputs/:", os.listdir("outputs"))
    print("""
    Where to go next:
    * Swap SAMPLE_CO / PEERS for real data via the repo's MCP connectors
      (Daloopa, FactSet, S&P, Morningstar, PitchBook...) — subscriptions apply.
    * Load other skills: SkillAgent(["lbo"]), ["merger"], ["earnings"],
      ["rebalance"], ["tlh"], ["kyc"] ... — see `sorted(registry.skills)`.
    * Stack skills: SkillAgent(["comps", "dcf"]) for a football-field workflow.
    * For production, install as a Cowork plugin or deploy via Managed Agents
      instead of this Colab loop — same skills, governed runtime.
    All outputs are drafts for qualified human review — not investment advice.
    """)
    

    We apply the investment-committee memo skill to a hypothetical software buyout and calculate supporting return metrics with Python. We save the resulting memo as a Markdown deliverable and verify that the generated file exists in the output directory. We then inspect a managed-agent cookbook, display the deployment specification, and conclude by reviewing the generated artifacts and possible production extensions.

    By completing this tutorial, we implement a practical Colab-based approximation of Anthropic’s financial-services skill and agent framework while preserving the repository’s methodology-driven approach to financial analysis. We combine structured skill discovery, dynamic system-prompt construction, persistent Python execution, API-based tool orchestration, and automated deliverable generation in a single reusable workflow. We also demonstrate how the same agent architecture supports multiple finance use cases, including DCF valuation, trading-comps analysis, sensitivity testing, Excel reporting, and investment committee memo preparation. From here, we extend the system by loading additional skills, combining multiple valuation playbooks, connecting to licensed financial data providers via MCP integrations, and replacing the tutorial sandbox with a governed production runtime in Claude Code, Cowork, or Managed Agents.


    Check out the Full Code here. Also, feel free to follow us on Twitter and don’t forget to join our 150k+ML SubReddit and Subscribe to our Newsletter. Wait! are you on telegram? now you can join us on telegram as well.

    Need to partner with us for promoting your GitHub Repo OR Hugging Face Page OR Product Release OR Webinar etc.? Connect with us


    Sana Hassan, a consulting intern at Marktechpost and dual-degree student at IIT Madras, is passionate about applying technology and AI to address real-world challenges. With a keen interest in solving practical problems, he brings a fresh perspective to the intersection of AI and real-life solutions.

    Agents Analysis Automated Claude Connectors Deliverables Designing Financial MCP Python SkillDriven
    NCIJ NETWNCIJ NETWORK
    • Website

    Keep Reading

    Perplexity Releases pplx, a Single-Binary CLI That Puts Its Search API in the Terminal for Coding Agents

    Shadow AI agents are multiplying. Here’s how to find and secure them.

    America’s AI Investment Boom Is Reshaping the Economy

    Coinbase CEO Touts AI Agents Driving Crypto Adoption

    How AI is shortening drug discovery timelines in China

    Black Forest Labs Releases FLUX 3: A Multimodal Flow Model for Image, Video, Audio and Robot Action Prediction

    Add A Comment
    Leave A Reply Cancel Reply

    Editors Picks

    I’m recommending this 14-inch HP laptop to almost everyone in 2026 – even with the RAM crisis

    July 27, 2026

    Beelzebub Raises $3.4 Million for Hacker-Trapping Platform

    July 27, 2026

    Uphold reduces global headcount by 17% amid enterprise pivot

    July 27, 2026

    Scientists reveal what sparkling water really does to your teeth

    July 27, 2026
    Latest Posts

    The Western Myth of Russian Greatness – Foreign Policy

    July 21, 2026

    Defence stocks rally as John Healey appointed chancellor; UK borrows less than expected in June – business live | Business

    July 21, 2026

    You Pay for Internet Service in Empty Buildings on Alaska’s Adak Island — ProPublica

    July 21, 2026

    Subscribe to News

    Get the latest sports news from NewsSite about world, sports and politics.

    NCIJ Network is an independent digital news platform delivering trusted investigative journalism, European and global news, in-depth analysis, and fact-based reporting with accuracy, transparency, and integrity.

    Facebook X (Twitter) Instagram Pinterest YouTube

    I’m recommending this 14-inch HP laptop to almost everyone in 2026 – even with the RAM crisis

    July 27, 2026

    Beelzebub Raises $3.4 Million for Hacker-Trapping Platform

    July 27, 2026

    Uphold reduces global headcount by 17% amid enterprise pivot

    July 27, 2026

    Subscribe to Updates

    Get the latest creative news from FooBar about art, design and business.

    Type above and press Enter to search. Press Esc to cancel.