HomeLibraryServicesCase studiesBlogAbout
consultance.ai
Book a discovery call →

Services

  • AI consulting
  • AI implementation
  • AI agents
  • Workflow automation
  • RAG systems
  • Voice AI
  • Custom AI development
  • All services

Library

  • AI build library
  • Finance AI automation
  • AiToEarn content agent
  • Fincept Terminal
  • ERPNext
  • SEO + GEO Claude skill
  • Claude for Legal
  • Free Claude Code proxy

Resources

  • Case studies
  • Blog
  • Industries
  • Locations
  • Guide: AI for property management
  • Guide: AI for marketing agencies
  • Guide: AI agents vs Zapier
  • AI glossary
  • vs traditional consulting

Company

  • About
  • Book a call
  • Contact
  • Privacy
  • Terms

© 2026 consultance.ai · AI, implemented.

audit → build → deploy

← Libraryconsultance.ai
Book a build call
Finance and data

Equity Research Desk That Replaces FactSet

A FactSet alternative for equity analysts: run comps, build a DCF, read 10-Ks, and write the research note inside Claude on live market data and real SEC filings, for the price of a Claude seat.

Free — runs in your own ClaudeMedium setup · 4 steps8 ready-to-run prompts
Set it up free — takes 3 minutes ↓Or have us wire it in →
Step 1 · setup
Three minutes, four steps, nothing to install by hand

Claude sets it up for you. You just paste.

Never used Claude? It is free and takes 30 seconds to open. Copy the instruction below, paste it into Claude, and it reads this page and walks you through everything, one question at a time.

  1. 1

    Tell Claude how to talk to you

    One tap. It changes how much Claude explains, and how slowly it goes. You can change it any time.

  2. 2

    Copy your setup instruction

    A short instruction plus a link to this page lands on your clipboard. First copy asks for your email once. That unlocks every button across the whole library.

  3. 3

    Open Claude in a new tab

    Free account, no card, 30 seconds. This tab stays open so you can come back.

    Open claude.ai ↗
  4. 4

    Paste, send, and answer one question

    Claude reads this page, asks one question about your work, then guides you step by step until your first output is right. If anything looks wrong, tell Claude what you see, and it fixes it with you.

▸Prefer the full prompt instead of the link? (optional)
Click to copy
I am comfortable copy-pasting and following instructions, but I am not a developer.
There is nothing to install for this one and no commands to type: it all happens inside Claude. If any instruction below implies a Terminal, translate it into the equivalent click path for me instead.
- Plain English. Define jargon the first time it appears.
- One step at a time, then wait for me to confirm before the next one.
- Tell me what success looks like at each step, and diagnose any error before moving on.

Follow the instructions below with those rules applied.

I want to INSTALL the real data stack so Claude runs a sell-side-grade equity research desk on live market data, instead of pasting numbers in by hand. Walk me through the full install, step by step, and do not skip the technical parts. I would rather spend 30 minutes installing the real thing than get a watered down version. Treat me like an equity analyst or FP&A lead who has never used a Terminal, and define every command before I run it.

Three paths. Recommend Path 1 (full delivery). Fall back only if I get stuck.

## Path 1 (RECOMMENDED, full delivery) — OpenBB live data inside Claude Desktop via MCP

This puts live market-data tools directly inside Claude Desktop. Once installed, Claude pulls quotes, fundamentals, and comps itself. This is the FactSet killer, the real deliverable, not a shortcut.

Walk me through ONE step at a time, waiting for me to confirm each:

1. **Install a Python toolchain.** In Terminal run `python3 --version` (need 3.10 or 3.11). If missing, install from python.org. Then install `uv` (a fast Python runner): `curl -LsSf https://astral.sh/uv/install.sh | sh` (macOS/Linux) or the documented Windows command. Define: Terminal = the command window (macOS: Spotlight → "Terminal"; Windows: "PowerShell").
2. **Install the OpenBB MCP server:** `pip install openbb-mcp-server` (this pulls the OpenBB Platform too). Explain: this is the bridge that lets Claude call live financial data.
3. **Add free data-provider keys** in OpenBB (`~/.openbb_platform/user_settings.json`) — tell me which free providers (e.g. FMP, Polygon free tier) cover quotes + fundamentals and how to paste each key.
4. **Wire it into Claude Desktop.** Settings → Developer → Edit Config (`claude_desktop_config.json`; macOS `~/Library/Application Support/Claude/`). Add this block, save, fully restart Claude Desktop:
   ```json
   {
     "mcpServers": {
       "openbb-mcp": {
         "command": "uvx",
         "args": ["--from", "openbb-mcp-server", "--with", "openbb", "openbb-mcp", "--transport", "stdio"]
       }
     }
   }
   ```
5. **Confirm:** after restart, Claude Desktop shows an "openbb-mcp" tool source. Have Claude pull one live quote to prove the connection before any analysis.
6. Pin **Opus 5**, create a private Project "Equity Research", run prompt 01, pick data source (A) LIVE, run 02 to 08.

Reference: OpenBB MCP docs `docs.openbb.co/odp/python/extensions/interface/openbb-mcp`; Claude Desktop local MCP guide `support.claude.com/en/articles/10949351`.

## Path 2 (ADVANCED) — FinRobot autonomous research pipeline

FinRobot is a separate open-source Python agent platform that runs the research pipeline itself (DCF, projections, peer comp, report gen). It calls an LLM API on its own; it is NOT an MCP tool inside Claude. Offer only if I want the heavier automated pipeline:

1. Requires **Python 3.10 or 3.11** (NOT 3.12). Confirm my version.
2. `git clone https://github.com/AI4Finance-Foundation/FinRobot.git`, `cd FinRobot`, `pip install -U finrobot` (or `pip install -e .`).
3. Config: rename `OAI_CONFIG_LIST_sample` → `OAI_CONFIG_LIST` (add LLM API key); rename `config_api_keys_sample` → `config_api_keys` (add Finnhub + FinancialModelingPrep + SEC-API keys; partial works with a subset).
4. Honest note: power-user pipeline, separate from Claude. Most readers stop at Path 1.

## Path 3 (QUICK START, 5 minutes, zero install) — Alpha Vantage + EDGAR by paste

To run the prompts TODAY before installing:
1. Prove the feed: open `https://www.alphavantage.co/query?function=GLOBAL_QUOTE&symbol=IBM&apikey=demo`; confirm a live quote.
2. Free Alpha Vantage key at `alphavantage.co/support/#api-key` (free tier 25 calls/day, 5/min). Add the Alpha Vantage MCP app in Claude, OR paste pulls when a prompt asks.
3. SEC EDGAR (free, no key): 10-K/10-Q/8-K at `data.sec.gov/api/xbrl/...` with a User-Agent header; full-text search at `efts.sec.gov`.
4. Pin Opus 5, private Project, run prompt 01, pick the live or paste source.

## Path B — my firm's licensed data
If my firm licenses FactSet or S&P Capital IQ, enable the connector via **Claude for Financial Services** (Enterprise admin step), then run the same prompts with data source (D). Data stays under firm controls.

## Rules for walking me through this
- One step at a time. Tell me exactly what to type or click. Define every term once: Terminal, Python, pip, uv, uvx, MCP server, MCP config, API key, CIK, 10-K, comp set, DCF, WACC, terminal growth, `<review_gate>`, `{{TOKEN}}`.
- Do NOT water it down to avoid the Terminal. Delivery beats ease. If a step fails, debug with me (Python version, valid config JSON, fully quit/reopen Claude Desktop). Drop to Path 3 only if I explicitly want no-install.
- Never tell me a connection is "not possible." Give me the next diagnostic step.
- A named human analyst signs every research note. Claude builds and ties sources; a person signs.

First message: ask me "Path 1 (install OpenBB live data into Claude, ~30 min, the real desk) or Path 3 (5-minute no-install quick start)? And what is your operating system?" Then start step 1.

When the connection returns live data AND prompts 01 to 03 run on a real ticker, switch into "desk mode" and help me lock my coverage list and note format.
Step 2 · run it on your data

Step 1 set it up. These 8 prompts do the work.

the vault

The 8 prompts

Grab the whole pack as one file, or tap any prompt below to copy it on its own. Placeholders that look like {{THIS}} get swapped for your own numbers — and if you ran Step 1, Claude fills them in for you.

One .md file · all 8 prompts, numbered, in order · nothing left out.
Click to copy
<role>
You are an equity research desk in one: a sell-side analyst who builds the model, a buy-side PM who pressure-tests the thesis, a forensic accountant who reads the filing, and a risk officer who signs nothing off blindly. You replace the terminal, not the analyst's judgment.
</role>

<task>
Before any analysis, set up the desk. Ask me to confirm each block, present lettered options, and WAIT.

1. WHAT ARE WE DOING?
   (A) Single-name deep dive (one ticker, full model + note)
   (B) Comp set / screen across a sector
   (C) Earnings reaction (read the print, update the model)
   (D) Quick valuation sanity check

2. WHERE DOES YOUR DATA LIVE? This decides how every later prompt runs.
   (A) LIVE CONNECTION (recommended): connect Claude to Alpha Vantage (quotes, fundamentals) and SEC EDGAR (filings). Both free. See "Connect the data" below.
   (B) Upload files into this Claude Project (10-Ks, exports, prior models)
   (C) Paste raw numbers or a filing excerpt
   (D) A governed connector my firm already runs (FactSet/CapIQ via Claude for Financial Services, LSEG, Moody's MCP)
   (E) A mix

3. CONTEXT — ticker(s) {{TICKER}}, sector {{SECTOR}}, valuation method {{METHOD}}, audience (PM / IC / client) {{AUDIENCE}}.

4. OUTPUT BAR — confirm: every figure ties to a pulled source (API field, filing line, or my upload), every assumption is labeled, and a human signs the note before it ships.
</task>

<output_format>Confirm the four answers in one block, then: "Desk live. If you picked (A), connect the data now, then run prompt 02." Do not analyze yet.</output_format>

<review_gate>Stop. Wait for my answers and, if (A), confirmation the connection returns data.</review_gate>
Click to copy
<role>You are a Morgan Stanley research associate building a clean comparable-companies table.</role>

<task>For {{TICKER}} in {{SECTOR}}, pull the comp set: market cap, EV, revenue, EBITDA, EV/EBITDA, P/E, revenue growth, margins. Use the data source from prompt 01 (Alpha Vantage OVERVIEW for each comp if live-connected).</task>

<output_format>Comp table, one row per company, every cell tagged with its source (API field or filing line). Flag any cell you could not source.</output_format>

<constraints>Use the data source from prompt 01. Never fill a cell from memory; if the pull failed, mark it MISSING and tell me which symbol to re-pull. No invented multiples.</constraints>

<review_gate>Analyst confirms the comp set membership and the sourced figures before prompt 03.</review_gate>
Click to copy
<role>You are a Lazard analyst building the model the desk will defend.</role>

<task>Build a DCF for {{TICKER}}: project revenue, margins, and FCF for 5 years from the filing history (EDGAR), apply WACC and terminal growth I confirm, and output enterprise and equity value with a sensitivity table.</task>

<output_format>Assumptions block (each tagged sourced vs ASSUMPTION), the projection, the valuation bridge, and a WACC x growth sensitivity grid.</output_format>

<constraints>Use the data source from prompt 01. Historicals must tie to EDGAR lines. Every forward assumption is labeled ASSUMPTION with the rationale. No hardcoded outputs.</constraints>

<review_gate>Analyst signs off on assumptions before the model informs a note.</review_gate>
Click to copy
<role>You are a forensic accountant reading the filing for what management buried.</role>

<task>From the EDGAR filing for {{TICKER}}, surface: revenue recognition changes, segment shifts, rising receivables vs revenue, debt maturities, share-count dilution, and any new risk-factor language vs the prior year.</task>

<output_format>Findings list, each with the exact filing line/section, severity (red/amber/note), and what to check next.</output_format>

<constraints>Use the data source from prompt 01 (EDGAR). Cite the filing section for every finding. Flag, never speculate without the line.</constraints>

<review_gate>Analyst reviews red flags before they enter the note.</review_gate>
Click to copy
<role>You are a PitchBook power user screening for the setups that matter.</role>

<task>Across the comp set or a sector list, screen on the criteria I give ({{METHOD}}, e.g. EV/EBITDA below peers + revenue growth above peers). Then run bull / base / bear scenarios on {{TICKER}} with the valuation impact of each.</task>

<output_format>Ranked screen output (sourced), then a 3-scenario table with the driver and the valuation delta per scenario.</output_format>

<constraints>Use the data source from prompt 01. Every screen value is sourced. Scenarios state their one key driver.</constraints>

<review_gate>PM confirms the scenario drivers before the note.</review_gate>
Click to copy
<role>You are a buy-side analyst reacting to the print in real time.</role>

<task>For {{TICKER}}'s latest results (EDGAR 8-K / press release + the quote reaction from Alpha Vantage), summarize beat/miss vs the model, the three things that moved the stock, and what to change in the model.</task>

<output_format>Beat/miss table (actual vs your model), 3 stock-movers, model-change list with the line to update.</output_format>

<constraints>Use the data source from prompt 01. Tie the reaction to the actual quote move. No narrative without a number.</constraints>

<review_gate>Analyst owns the model changes before they post.</review_gate>
Click to copy
<role>You are writing the note a PM reads in 90 seconds and an IC defends for an hour.</role>

<task>From the model, filing read, and scenarios, write the note for {{AUDIENCE}}: rating + price target, the thesis in three points, the valuation, the key risks, and the one chart that proves it.</task>

<output_format>1-page note: rating/PT, thesis (3), valuation summary, risks, the chart spec. Every figure cites its source from the prior prompts.</output_format>

<constraints>Use only what the prior prompts sourced. No new claims here. If the thesis needs a number you do not have, say so.</constraints>

<review_gate>NAMED human analyst signs the note. It does not reach a PM, IC, or client without that signature.</review_gate>
Click to copy
<role>You are the desk's compliance check: every number must trace to a source.</role>

<task>Scan the model and note. For every figure, confirm it ties to an Alpha Vantage field, an EDGAR filing line, or my upload. List any figure that does not tie. A single untied number blocks the note.</task>

<output_format>Pass/fail per figure, then a BLOCK list of untied numbers. GO only if the BLOCK list is empty.</output_format>

<constraints>Use the data source from prompt 01. No figure passes on trust. Untied = blocked.</constraints>

<review_gate>This auditor informs the human; the human still signs.</review_gate>
Built on open source
OpenBB + FinRobot (open-source data + agent stack, full install guide included) ↗

The code is public and free. The setup instruction above installs and wires it for you. You never need to open this link.

Got the prompts. Want them wired into your actual stack? We map that on a free AI audit.

Book the free audit

$12,000 to $25,000 a seat for FactSet, or the same research for a Claude seat.

Analysts pay $12K to $25K a seat for FactSet, S&P CapIQ, or PitchBook. This is a sell-side-grade research desk inside Claude on live market data and real SEC filings — comp set, DCF, 10-K read, bull/base/bear, and the research note, every figure tied to a pulled source, built around a verified free data connection.

Path A · free

You just did it

The setup rail and every prompt above are free and stay free. The cost is your time, and the risk of wiring it wrong on live data.

Back to the prompts ↑
Path B · done with you

We wire it into your business

We deliver a private research desk: the 10 prompts loaded into your Claude tenant, the live data connection wired (Alpha Vantage or your firm's licensed FactSet/CapIQ via Claude connectors), EDGAR reads set up for your coverage list, your house model and note format built in, and a source-tie audit gate so nothing untied ever ships — then handed over so you own it. You get terminal-grade research without the terminal bill.

Book a build call →
data safety

Before you use live numbers

  • • Run last quarter's numbers first. Live data is not a test bed.
  • • Nothing here uploads to us. It runs in your own Claude account, on your own machine.
  • • A named human reviews and signs every output before it reaches a board, lender, or client.
  • • Wiring the open-source piece to real systems? Keep keys out of public code and add access control first — or have us do that part.
the fine print

Credit the original author

Prompt set and build authored by consultance.ai. FactSet, S&P Capital IQ, and PitchBook are referenced as the incumbent being replaced, no affiliation implied. Alpha Vantage and SEC EDGAR are free third-party data sources used under their own terms. Your analysis stays in your own Claude tenant; we never see it. This is not investment advice; a named human analyst signs every research note before it is published.

Read this far? You want terminal-grade research without the $25K seat. Let us build the desk — source-tied and signed before anything publishes.

Book a build callBack to the library

Want this wired into your stack instead of running it yourself? That is our AI deal desk and finance automation service.

the newsletter

AI news worth opening.

The AI tools, launches, and shifts that actually matter, in plain English. New library drops the moment they land.

100% freeNo paywall, everUnsubscribe anytime

More like this

Other builds worth a weekend

All repos →
Finance and data

Free Portfolio Quant Research Desk

For family offices and serious individual investors: run a portfolio backtest, tax loss harvesting, and model risk checks on your own holdings, locally, in your own Claude. Replaces the $250k quant seat you would otherwise hire.

Setup guide →
Finance and data

Private Equity Deal Sourcing Playbook

For lower and mid market private equity origination teams: turn one mandate into a ranked, owner verified proprietary deal flow pipeline. Six Claude agents with Exa and Scrapling replace a rented deal sourcing subscription.

Setup guide →
Finance and data

Free Jira Alternative for Deal Teams

For PE deal teams and IC members still tracking a live process on a sprint board: a self hosted deal tracker your Claude can write to, plus 10 prompts that move a workstream only when the document actually lands.

Setup guide →
Get the free kitBook a call

Forward this to whoever owns the workflow.

The person drowning in this every week is the one who'll actually want it.

Forward by email
in one line

What is Equity Research Desk That Replaces FactSet?

Equity Research Desk That Replaces FactSet is a finance and data build in the consultance.ai AI Build Library. A FactSet alternative for equity analysts: run comps, build a DCF, read 10-Ks, and write the research note inside Claude on live market data and real SEC filings, for the price of a Claude seat. It fits Equity analysts, FP&A leads, fund associates, and finance directors who pay $12K to $25K a seat for FactSet, S&P CapIQ, or PitchBook and want terminal-grade research without the terminal bill. Setup difficulty is Medium, with 4 plain-English steps.

What does Equity Research Desk That Replaces FactSet do?

A FactSet alternative for equity analysts: run comps, build a DCF, read 10-Ks, and write the research note inside Claude on live market data and real SEC filings, for the price of a Claude seat.

Who is Equity Research Desk That Replaces FactSet for?

It fits Equity analysts, FP&A leads, fund associates, and finance directors who pay $12K to $25K a seat for FactSet, S&P CapIQ, or PitchBook and want terminal-grade research without the terminal bill.

How hard is Equity Research Desk That Replaces FactSet to set up?

Medium to set up — one guided setup instruction covering 4 plain-English steps, plus 8 ready-to-run prompts on the resource page.

How would consultance.ai build this out?

We would deliver a private research desk: the 10 prompts loaded into your Claude tenant, the live data connection wired (Alpha Vantage or your firm's licensed FactSet/CapIQ via Claude connectors), EDGAR filing reads set up for your coverage list, your house model and note format built in, and a source-tie audit gate so nothing untied ever ships. Done with you, then handed over so you own it.

What are the licensing terms?

Prompt set and build authored by consultance.ai. FactSet, S&P Capital IQ, and PitchBook are referenced as the incumbent being replaced, no affiliation implied. Alpha Vantage and SEC EDGAR are free third-party data sources used under their own terms. Your analysis stays in your own Claude tenant; we never see it. This is not investment advice; a named human analyst signs every research note before it is published.

Want this built into your workflow?

Equity Research Desk That Replaces FactSet is the starting point. On a free AI audit we map where it fits your stack and what consultance.ai would build around it.

This build comes from our AI consulting and AI implementation practice — see the full AI in finance guide and how we work with CFO teams.

Book your free AI audit