short_quote_example

Name: short_quote_example
Creator: Strasmore
Published: 2026-09-13
License: https://www.strasmore.com/terms/

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-13, from how-to-find-short-positions-in-german-stocks.

as of 2026-09-13 ranking 5×2read in context →

short_quote_example — 5 rows by 2 columns, computed 2026-09-13 from US exchange, SIP and OPRA data.
position_owner	net_short_pct
Holder A	0.6
Holder B	0.8
Holder C	1.1
Holder D	2
Short-Quote (sum)	4.5

Rows × columns: 5 × 2
Computed: 2026-09-13
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 short_quote_example, derived from the stored result.
Column	Type	Range	Notes
`position_owner`	text	5 distinct values (Holder A, Holder B, Holder C…)
`net_short_pct`	number	0.6 to 4.5	percent

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 2026-09-13, and the query below is what returned them.

the exact SQL behind every number

SELECT
    position_owner,
    net_short_pct
FROM
(
    SELECT 'Holder A' AS position_owner, 0.6 AS net_short_pct, 1 AS sort_key
    UNION ALL SELECT 'Holder B', 0.8, 2
    UNION ALL SELECT 'Holder C', 1.1, 3
    UNION ALL SELECT 'Holder D', 2.0, 4
    UNION ALL SELECT 'Short-Quote (sum)', round(0.6 + 0.8 + 1.1 + 2.0, 2), 5
)
ORDER BY sort_key

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.