EQUERY

Ask for a number, get a spreadsheet.

Every panel in the terminal answers one question well. Equery is for the question nobody built a panel for. You write a few lines, it pulls from anything the terminal can already reach, and you can do arithmetic on the way out.

Type SCPT in the command line to open it.

Equery, running

1 min 35 sec · live data · no sound

How a script is put together

Three ideas

Every Equery script is the same shape. You fetch something, you give it a name, and you say how to draw it. Anything in between is yours.

1
Fetch

fetch asks the terminal for data it already knows how to get. You name what you want and any settings it takes.
```
fetch("/screener/movers", type: "gainers", limit: 20)
```
2
Name it

let gives the answer a name so the next line can use it. Scripts read top to bottom and nothing runs twice.
```
let movers = fetch("/screener/movers", type: "gainers", limit: 20)
```
3
Draw it

Finish with table, chart or text. That is what appears in the panel, and a table is what the export button turns into a spreadsheet.
```
table(movers.rows, title: "Today's biggest gainers")
```

Two you can copy

Both run as written

Today’s biggest gainers

Two lines. The first asks, the second draws.

let movers = fetch("/screener/movers", type: "gainers", limit: 20)
table(movers.rows, title: "Today's biggest gainers")

Returns 20 rows: ticker, name, last, the move in dollars and the move in percent. Two hundred names are ranked to find them.

A column no feed sells you

pluck takes one field out of a list, and sma works out a moving average from it. The average is calculated here, from the closes, and sits beside them as another column.

let bars = fetch("/market/bars", symbol: "AAPL", interval: "1d", start: "2026-01-01")
let close = pluck(bars, "close")

table(
  columns(close: close, sma20: sma(close, 20)),
  title: "AAPL against its 20-day average"
)

The first nineteen rows come back empty, on purpose. A 20-day average has nothing to say until it has twenty days, and a shorter average in those rows would look exactly like a real one.

Out to a spreadsheet

Any table Equery draws exports to Excel from the button in the panel header, in the order you are looking at it. Numbers arrive as numbers, so they add up and chart without cleaning first, and text stays text rather than being guessed at.

Equery Excel

One button, no clean-up in between.

Scripts save into your layout and reopen with it, so a question you work out once is there tomorrow.