Guide
How to organize your equity research
To organize equity research, treat it as a database: one row per stock with a few fields you keep current, one notebook per stock for the writing, and every quote and number linked to the source it came from. The usual mess is a folder of spreadsheets, a few documents, and bookmarks that no longer connect to anything. Five fields carry most of the weight: a stage, a conviction, a target price, a next review date, and a catalyst. Write-ups for themes sit beside the per-stock notebooks, and a board shows where each idea stands. Brief Equity is built this way: a research library with your own columns beside market metrics, a notebook behind every row, capture from the source with a link back, and a knowledge graph of how it all connects.
By The Brief Equity Team · Published · Updated
Why scattered research quietly fails
Scattered research fails slowly. A spreadsheet of prices here, a doc of notes there, a filing saved to Downloads, a fund idea in a chat. None of it is linked, so when you revisit a name you rebuild context from scratch. The work exists; you just can't find or connect it when it matters most.
The cost isn't the storage, it's the reassembly. Every time you come back to an idea you spend twenty minutes remembering what you already concluded and where you read it. Multiply that across a portfolio and a research process turns into archaeology.
A system that actually holds up
- Give every company one row in a table and one notebook behind it.
- Track a few fields per stock and keep them current: where the idea stands, how strongly you hold it, and when you will look again.
- Attach the source to every quote and number, so each can be traced to the filing or call it came from.
- Write standalone pieces for themes or sectors that span more than one stock.
- Keep it all in one place so revisiting a name doesn't mean reassembling it.
This is a database in the plain sense: the same few questions answered for every stock, in columns you can sort and filter. The writing still happens in notes. The table is what lets you find the note again and see which ideas have gone stale.
What to track for every stock
| Field | The question it answers | Why it earns its place |
|---|---|---|
| Stage | Is this idea being watched, researched, owned, or passed on? | Turns a long list into a pipeline you can sort |
| Conviction | How strongly do I hold this view? | Separates a hunch from a thesis you would act on |
| Target price | What do I think it is worth? | Gives the view a number to check against the price |
| Next review | When do I look at this again? | Keeps an old thesis from sitting unexamined |
| Catalyst | What event would change the story? | Tells you what to watch for |
Five is enough to start. Every field you add is one you have to keep current, and a column nobody updates misleads, because it still looks like information. Add a sixth when you catch yourself wanting to sort by it.
Market figures such as the P/E or the market cap belong beside these, but they are not yours to maintain. In a spreadsheet a formula can fetch them; in a research tool they are filled in for you.
Keep the source attached
A note without its source is an opinion you cannot check later. Each time you write down a quote or a figure, record where it came from: the filing, the call, the date. When the thesis is questioned six months on, you can go back to the passage itself instead of your memory of it.
By hand this means pasting a link and a date beside every excerpt, and it is the step that gets skipped when you are reading fast. A tool that captures from the source does it for you: select the passage, save it, and the note carries a link back to the exact spot.
Three ways to structure your research
| Structure | Organizes by | Best when |
|---|---|---|
| By ticker | One notebook per company | You follow specific names closely |
| By theme | A write-up per idea or sector | Your thesis spans several stocks |
| By stage | A board of where each idea sits | You manage a pipeline of ideas |
These aren't mutually exclusive. Most people want all three: a per-company home for the detail, thematic write-ups for the ideas that cut across names, and a pipeline view to see what's moving from a watch to a buy.
The organizing tool that helps most is the one that also shows connection, so you can see that three of the names you're studying share a customer, or that a fund you follow just bought one of them.
Organizing research in Brief Equity
Brief Equity keeps research as a database you shape. The library is a table of the stocks you research, with your own columns beside market metrics and a notebook behind every row. Briefs hold write-ups for themes, a board lays the same stocks out in lanes, and a knowledge graph draws how your lists, stocks, notes, and funds connect.
Columns come in 7 types (text, number, select, multi-select, date, files, and links), with presets such as Price Target, Catalyst, and Risk Level. Filter by any column, sort by one, and pick which choice field makes the lanes on the board, such as Stage or Conviction. Any market metric, such as the P/E or the market cap, can sit beside your own columns and fills itself in.
Sources stay attached without the pasting. Select a passage in a transcript or press release and it saves into the stock's notebook as a callout with a link back to where it came from. A block of cells from the financial statements saves as a table, and a chart saves as an image.
The graph is where the connections become visible. Watchlists are color-coded and tickers are shaded by the day's move, and you can scope to a watchlist, show only tickers that have research, or focus a fund to see where its holdings overlap yours. It turns a pile of separate files into something you can navigate.
Keep reading
Related in Brief Equity
Workspace
Build your research database
A research database you shape: your columns, stages, and tags, a notebook for every stock, and capture from the source with a link back.
ExploreKnowledge graph
See how it all connects
Your watchlists, tickers, briefs, notes, and the funds you follow, rendered as one force-directed graph.
ExploreGuide
How to take notes on your stock research
How to take investment notes that stay tied to their evidence: a notebook per stock, passages and figures captured from the source with a back-link to where they came from.
Read guideGuide
Is there a Notion or Obsidian for stock research?
A research database built for investing next to Notion, Obsidian, and a spreadsheet: what it adds, and the setup it saves you.
Read guide
Best-of roundups
Frequently asked questions
- How do I organize all my stock research in one place?
- Give each company one row in a table and one notebook behind it, track a few fields per stock, write standalone pieces for themes that span several names, and keep the source attached to every quote and number. With all of it in a single workspace, revisiting an idea doesn't start from scratch.
- What should I track for each stock I research?
- Start with five fields: a stage, a conviction, a target price, a next review date, and a catalyst. They tell you where an idea stands, how strongly you hold it, what you think it is worth, when to look again, and what would change your mind.
- What's wrong with using spreadsheets and docs?
- Nothing, until they multiply. The problem isn't any single file, it's that they don't connect: a price sheet, a notes doc, and a saved filing have no link between them, so context has to be rebuilt every time you come back.
- How do I keep ideas and notes connected?
- Link them explicitly. A note that references a ticker, a fund, or another note should carry that link, so the relationship is visible later. Brief Equity's knowledge graph renders those links as one connected view of your research.
- Is there a workspace built for equity research specifically?
- Yes. Brief Equity pairs a research library (your own columns, a notebook per stock, briefs, and a board) with a knowledge graph of your tickers, notes, and funds. It's scoped to investing, so it knows what a ticker or a fund is rather than treating everything as generic text. General tools such as Notion and Obsidian can be bent to the same job, but you build and maintain the structure yourself.