Skip to main content

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.

Start free trial10-day free trial · No card to start
All guides →

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

  1. Give every company one row in a table and one notebook behind it.
  2. 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.
  3. Attach the source to every quote and number, so each can be traced to the filing or call it came from.
  4. Write standalone pieces for themes or sectors that span more than one stock.
  5. 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

FieldThe question it answersWhy it earns its place
StageIs this idea being watched, researched, owned, or passed on?Turns a long list into a pipeline you can sort
ConvictionHow strongly do I hold this view?Separates a hunch from a thesis you would act on
Target priceWhat do I think it is worth?Gives the view a number to check against the price
Next reviewWhen do I look at this again?Keeps an old thesis from sitting unexamined
CatalystWhat 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

StructureOrganizes byBest when
By tickerOne notebook per companyYou follow specific names closely
By themeA write-up per idea or sectorYour thesis spans several stocks
By stageA board of where each idea sitsYou 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.

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.

Build your research system.

Start free trial10-day free trial · No card to start