STRASMORE/EXPLORE 2,214 QUERIES

margin_call_lines

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-09-12, from fed-call-vs-house-call.

as of table 3×5read in context →
margin_call_lines — 3 rows by 5 columns, computed from US exchange, SIP and OPRA data.
call_typerequirement_pcttrigger_pricemarket_value_at_triggerequity_at_trigger
Fed call (50% initial)501002000010000
House call (30% maintenance)3071.43142864286
Exchange call (25% maintenance)2566.67133333333
Rows × columns
3 × 5
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 margin_call_lines, derived from the stored result.
ColumnTypeRangeNotes
call_type text 3 distinct values
requirement_pct number 25 to 50 percent
trigger_price number 66.67 to 100 US dollars
market_value_at_trigger number 13,333 to 20,000
equity_at_trigger number 3,333 to 10,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 
SELECT
    call_type,
    requirement_pct,
    round(10000 / (1 - requirement_pct / 100) / 200, 2) AS trigger_price,
    round(10000 / (1 - requirement_pct / 100))          AS market_value_at_trigger,
    round(10000 / (1 - requirement_pct / 100) - 10000)  AS equity_at_trigger
FROM
(
    SELECT 'Fed call (50% initial)' AS call_type, 50 AS requirement_pct
    UNION ALL
    SELECT 'House call (30% maintenance)', 30
    UNION ALL
    SELECT 'Exchange call (25% maintenance)', 25
)
ORDER BY trigger_price DESC

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.

More from this analysisfed-call-vs-house-call
close_at_65 table 2×7 → The 2s10s spread, every print of the half table 124×2 → The 2s10s spread, every print of the half table 124×2 → Every half-year since 1976: the 2y and 10y change, the twist between them, and the half's lowest 2s10s print table 100×7 → SPY at one-minute resolution, 2:00–3:30 pm ET on May 6, 2010 table 90×4 → Executed volume by price level: the traded ladder (KO, 30 minutes) table 63×3 → See all 2,214 queries →