Open Terminal

User Guide

Everything you need to get the most out of Open Terminal — from your first search to writing SQL queries against live SEC financial data.

▶ Watch the tutorial video
Open Terminal is open source. View the code, self-host, or contribute on GitHub.

Start here Getting Started

When you first open the app, you'll see a sidebar on the left with two lists: Tickers and Concepts.

  • Tickers are the companies you want to research (e.g. AAPL, MSFT, TSLA)
  • Concepts are the financial metrics you want to chart (e.g. Revenue, Net Income)

Search and click to select. Your selections persist the next time you visit.

You can switch between light and dark theme using the toggle in the top right.


Tab Financials

This is your main research view. Pick one or more tickers and a financial concept, and a chart appears immediately. You can plot multiple companies on the same chart to compare them side by side.

  • Stock price chart — shows the historical stock price for your selected companies. If you have multiple tickers selected, prices are shown as percentage change so they're easy to compare on the same scale.
  • Fundamentals chart — shows the financial metric you selected (Revenue, Net Income, etc.) over time, pulled directly from SEC filings.
  • Merge — click the Merge button to combine both charts into one, with prices on the left axis and financials on the right. Great for spotting how financial performance relates to stock price.

If the charts feel crowded, use the collapse buttons (▼) to hide the price or fundamentals panel, giving the other more room.

Data tab

Switch to the Data tab (below the charts) to see the exact numbers behind the chart in a table. Each row links directly to the original SEC filing so you can verify the source yourself.

News tab

The News tab shows recent articles for your selected tickers. Each article displays:

  • The headline, publisher, and publication date
  • A description of the article
  • A sentiment score — how the article is likely to affect the stock price, scored from negative to positive
  • Hover over the sentiment score to see a one-sentence explanation of why it received that rating

Tab Formulas

Don't see the metric you need? Build it yourself. The Formulas tab lets you combine existing concepts using simple math.

For example, to calculate Profit Margin:

  1. Type a name: Profit Margin
  2. Type the formula: NetIncomeLoss / Revenues
  3. Click Add

Your new metric appears in the concept list. Select it just like any other concept and it will plot on the chart alongside your other selections. Your formulas are saved and available every time you return.

💡 Built-in variables you can use in any formula: stock_price_avg, market_cap, shares.

Tab Companies

The Companies tab is your starting point when you don't know exactly what you're looking for. Browse thousands of public companies — each card shows a business summary, recent management commentary, and current news with sentiment scores.

Finding companies

  • Type any keyword in the search bar — company name, ticker, or topic (e.g. "electric vehicles", "cloud software", "biotech")
  • Click tag chips to filter by sector or theme
  • Results rank by relevance — exact ticker matches come first

Using your results

Click Use Displayed Tickers to add all the visible companies to your selection at once. Then head to Quadrant to compare them visually, or back to Financials to dig into their numbers.


Tab Quadrant

Plot any two financial metrics against each other — every dot on the chart is a company. This is the fastest way to screen a large group of companies and spot the outliers.

📊 Example: put Net Income on the X axis and Market Cap on the Y axis. Companies that are profitable but have low market caps sit in the bottom right — potentially undervalued.

Color by formula — add a third metric to color the dots, turning the chart into a heat map (e.g. color by revenue growth to see which profitable companies are also growing fast).

Focusing on specific companies

  • Click a dot to highlight a single company
  • Find companies alphabetically in the legend
  • Drag-select a region of dots to box in the ones you want, then choose to keep only those in your active selection

Once you've narrowed it down in Quadrant, head back to Financials to compare just those companies in detail.


Tab Watchlists

Watchlists let you save and track groups of tickers over time.

Creating a watchlist

  • Click + New to create a watchlist, give it a name, and optionally set a start date
  • Or click + Create Watchlist from Selection in the sidebar to instantly save your current tickers

Managing tickers

  • Type tickers directly into the add bar (e.g. AAPL MSFT or AAPL,MSFT,GOOGL) and click Add
  • Click From Sidebar to bulk-add all currently selected tickers
  • Set a Weight for each ticker — positive for long positions, negative for short (doesn't need to sum to any value)
  • Set Alert Above ↑ or Alert Below ↓ price targets to receive an email when a ticker crosses that threshold

Sub-tabs

  • Performance — chart the price performance of your watchlist from any start date. Click Load Chart to display.
  • News — latest news articles with sentiment scores for every ticker in the list
  • Analyst Ratings — current analyst consensus and price targets

Click Use in Sidebar to load all the watchlist's tickers into your active sidebar selection so you can analyze them in Financials or Quadrant.

ℹ️ If you're not logged in, watchlists are saved in your browser only. Log in to sync them across devices.

Tab AI Playground

Not sure where to start, or how to write a formula? Just ask. Type a question in plain English and the AI will build a chart from the financial database for you.

"Show me the top growth stocks in the last five years with at least $50 million in revenue"

The AI returns a chart of matching companies. From there:

  • Click Use Displayed Tickers to add those companies to your panel
  • Click See Data Table to open the full results in the SQL Explorer

The AI remembers your conversation, so you can follow up with refinements like "now filter to only tech companies" or "show the same thing but sorted by market cap".

  • Chat history — all your past conversations are saved in the sidebar on the left. Click any session to resume it, or click + New to start fresh.
  • Model selector — choose which AI model powers the chat. Claude Sonnet 4.5 is the default and recommended option.
🔑 AI features require account access — contact us to enable them on your account.

Tab SQL Explorer

For power users who want precise control. Write any SQL query directly against the financial database. The schema panel on the left shows all available columns — click any column name to insert it into your query.

Press Ctrl+Enter (or Cmd+Enter on Mac) to run a query.

The main table is called financial_data and contains one row per company, per month, per financial concept — so you can filter, aggregate, and join however you like.

Template variables

Use these anywhere in your query — they're substituted automatically when you run it:

VariableReplaced with
{{ selected_tickers }} The tickers currently selected in the sidebar, as a quoted comma list (e.g. 'AAPL','MSFT')
{{ selected_concepts }} The concepts currently selected in the sidebar, as a quoted comma list

Results show in a table below. Click Use Displayed Tickers to add any companies from your query results directly to your selection.


Data Refresh Rates

Data Visiting Account
Financial statements (Revenue, Net Income, etc.) Updated weekly Updated weekly
Stock prices Monthly average Live prices

Financial data is sourced from SEC filings and refreshed weekly. Stock price data depends on your account status — account holders see live prices, while visiting users see monthly averages from the built-in historical archive.


Top Bar

Control What it does
Date range Filters the date range for charts and data across all tabs.
Annual / Quarterly Switch between annual and quarterly financial values.
Log In / Create Account Sign in with Google or email to unlock live stock prices and sync watchlists across devices.
☀️ / 🌙 Toggle light and dark theme.

Tips

Up to 10 tickers for charting More can be selected for Quadrant and Companies.
Search is fuzzy Search by company name, not just ticker symbol.
Selections are saved Tickers and concepts you've chosen persist when you come back.
Hover for sentiment detail News sentiment scores range from strongly negative to strongly positive. Hover over any score to read the reason in one sentence.
Data from SEC filings The same source institutional investors use — directly from SEC public filings.
Save research as a watchlist Use + Create Watchlist from Selection in the sidebar to capture your current tickers in one click.
Concepts section is collapsible Click the toggle at the bottom of the sidebar to hide it and give more vertical space to the ticker list.