Skip to content
ruly

Stock analysis spreadsheet or dedicated tool: an honest comparison

Spreadsheet, stock screener, Notion template or a dedicated tool such as ruly to analyze your stocks: what each does well, where it falls short, and when a spreadsheet is enough.

A spreadsheet is enough for a handful of stocks if you like formulas. A stock screener filters thousands of companies on market data but keeps no trace of your reasoning. A Notion template stores notes but scores nothing on its own. A dedicated tool applies your own criteria to every stock and keeps your decisions next to the figures.

What are the options to analyze and track your stocks?

Four kinds of tools cover most needs. Each one is good at something different.

OptionWhat it does wellWhere it falls short
SpreadsheetTotal freedom: any criterion, any formula, at no extra costEverything is built and checked by hand. Formulas break, copies multiply, and an update overwrites last year’s figures
Stock screenerFilters thousands of listed companies in seconds, on figures loaded automaticallyThe criteria are limited to the fields it offers, with its own definitions. Your thesis and your decisions live elsewhere
Notion templateFree-form pages for thesis, notes and links, in tables you can sortThresholds and scores need workarounds with formulas, and a page edited later loses what you thought at the time
rulyYour own criteria and thresholds applied to each sheet, a verdict per criterion, a weighted score, thesis and decision on the same sheetYou type each figure yourself, from the annual report or the source you already use. Dated versions are part of the paid plan

When is a spreadsheet enough?

A spreadsheet does the job when these four conditions are met:

  1. You follow fewer than about ten companies.
  2. Your criteria and thresholds rarely change.
  3. You are comfortable writing formulas, and checking them.
  4. You do not need to find what you thought a year ago, or you save a copy of the file at each update.

If all four are true, keep your spreadsheet. A dedicated tool would add little.

When does a dedicated tool become worth it?

When one of these situations comes up:

  1. The same criteria must apply identically to many companies, without copying formulas from one tab to the next.
  2. You adjust a threshold and want older analyses to keep the rule of their date.
  3. You want your thesis, your risks and your decision next to the figures, not in another file.
  4. You work on a computer and a phone, and want the same sheets on both.

What does a screener add to a checklist?

A screener narrows the field: out of thousands of stocks, it keeps the few dozen that pass a few filters. A checklist then examines each remaining company in detail, with your own thresholds, including criteria that no screener measures, such as a competitive advantage. Use the screener to find candidates, then the checklist to examine them one by one.

Worked example: Company A in a spreadsheet and in a dedicated tool

Company A is fictitious. You have followed it for two years with a checklist of eight criteria, including ROIC with a minimum threshold of 12%. In year 1, its ROIC was 13%: criterion met. In year 2, you raise the threshold to 15%.

In a spreadsheet where conditional formatting reads the threshold from a single cell, the year 1 row turns red too: 13% now looks like a failure, although it met your rule at the time. Unless you saved a copy of the file before the change, last year’s analysis is gone.

In ruly, a frozen version keeps a copy of the strategy as it was on that day. The year 1 version still shows 13% as a criterion met. Versions frozen before and after the change appear in separate tables, one per version of the criteria. The features page shows the table of versions and the score curve.

How do you move from a spreadsheet to a dedicated tool?

  1. List the columns of your spreadsheet: each one that contains a figure becomes a criterion.
  2. Write the rule of each criterion: minimum, maximum, range, yes or no.
  3. Start with a weight of 1 everywhere.
  4. Enter the latest figures for each company, from the most recent annual report.
  5. Copy your current thesis and decision into each sheet.

Keep the old spreadsheet as it is: it remains the record of your past analyses.

Frequently asked questions

Is a dedicated tool worth it if my spreadsheet works?

If the four conditions above are met, no. Switching tools takes time, and a spreadsheet you know well is better than a tool you do not use.

Is a Notion template enough to analyze stocks?

For notes, yes: thesis, risks, links to reports and meeting notes fit well in free-form pages. For thresholds, verdicts and a score, you have to build the formulas yourself, as in a spreadsheet, and keep a copy of each page if you want to find what you thought at the time.

Where do the figures in ruly come from?

From you: you enter them from the annual report or from the source you already use. The app applies your strategy to them as you type, and the glossary of indicators explains each formula and where to find it.

Can I start for free?

Yes. The free plan has no time limit and asks for no credit card. It covers a limited number of sheets, every preset strategy and your own strategies. Frozen versions are part of the paid plan.

Start free

Build your strategy, score each stock against your own criteria and note your decision next to the figures.

Free for up to 3 sheets, with no time limit. An email address is all you need, and your sheets stay private.

Read next