STRASMORE/EXPLORE 2,170 QUERIES

One margin account through four events: equity, requirement, and SMA

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-19, from What Is a Special Memorandum Account (SMA)?.

as of table 5×8read in context →
One margin account through four events: equity, requirement, and SMA — 5 rows by 8 columns, computed from US exchange, SIP and OPRA data.
eventmarket_valuedebit_balanceequityreg_t_requirementmargin_excesssmabuying_power
Start40000200002000020000000
Deposit 5k cash400001500025000200005000500010000
Stock gains 8k480001500033000240009000900018000
Stock gives 8k back400001500025000200005000900018000
Buy 12k on margin52000270002500026000-100030006000
Rows × columns
5 × 8
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for One margin account through four events: equity, requirement, and SMA, derived from the stored result.
ColumnTypeRangeNotes
event text 5 distinct values
market_value number 40,000 to 52,000
debit_balance number 15,000 to 27,000
equity number 20,000 to 33,000
reg_t_requirement number 20,000 to 26,000
margin_excess number -1,000 to 9,000
sma number 0 to 9,000
buying_power number 0 to 18,000

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

the exact SQL behind every number 
WITH ledger AS (
    SELECT 1 AS step, 'Start' AS event, 40000 AS market_value, 20000 AS debit_balance, 0 AS sma_entry
    UNION ALL
    SELECT 2, 'Deposit 5k cash', 40000, 15000, 5000
    UNION ALL
    SELECT 3, 'Stock gains 8k', 48000, 15000, 4000
    UNION ALL
    SELECT 4, 'Stock gives 8k back', 40000, 15000, 0
    UNION ALL
    SELECT 5, 'Buy 12k on margin', 52000, 27000, -6000
)
SELECT
    event,
    market_value,
    debit_balance,
    market_value - debit_balance                        AS equity,
    0.50 * market_value                                 AS reg_t_requirement,
    market_value - debit_balance - 0.50 * market_value  AS margin_excess,
    SUM(sma_entry) OVER (ORDER BY step)                 AS sma,
    2 * SUM(sma_entry) OVER (ORDER BY step)             AS buying_power
FROM ledger
ORDER BY step

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

Related queries
Symbols closing the month below $5 and below $1, past two years series 24×3 → Symbol count and average daily range, by price bucket ranking 6×3 → Average daily range of recent listings, by age since listing ranking 5×3 → One fixed short AAPL call strike: requirement as a percent of the share price, April to June 2026 series 62×4 → SPY daily moves and drawdown, February to April 2020 series 45×4 → SPY realized volatility and worst session, by calendar year ranking 20×4 → See all 2,170 queries →