STRASMORE/EXPLORE 2,272 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,272 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Futures Tick Size and Tick Value Explained
Worked P&L examples: ticks moved x tick value x contracts (hypothetical)table · 2026-09-16 · 7×5 Outright tick size and tick value per contract, CME specifications, September 2026ranking · 2026-09-16 · 10×4Preview: 10 ranked values, smallest first. Calendar spread tick versus outright tick, dollars per contract, CME specifications, September 2026ranking · 2026-09-16 · 10×4Preview: 10 ranked values, smallest first.
Worked P&L examples: ticks moved x tick value x contracts (hypothetical)

Worked P&L examples: ticks moved x tick value x contracts (hypothetical)

most recentas of table 7×5read in context →
Worked P&L examples: ticks moved x tick value x contracts (hypothetical) — 7 rows by 5 columns, computed from US exchange, SIP and OPRA data.
exampleticks_movedtick_value_usdcontractspnl_usd
ES up 4.50 points, 1 contract1812.51225
ES up 4.50 points, 3 contracts1812.53675
MES up 4.50 points, 1 contract181.25122.5
CL down 0.85 per barrel, long 1 contract-85101-850
MCL down 0.85 per barrel, long 1 contract-8511-85
ZN up 8/32 (110-16 to 110-24), 1 contract1615.6251250
ZB down 12/32 (118-00 to 117-20), long 1 contract-1231.251-375
the exact SQL behind every number
SELECT
    example,
    ticks_moved,
    tick_value_usd,
    contracts,
    ticks_moved * tick_value_usd * contracts AS pnl_usd
FROM
(
    SELECT 1 AS id, 'ES up 4.50 points, 1 contract' AS example, 18 AS ticks_moved, 12.50 AS tick_value_usd, 1 AS contracts
    UNION ALL SELECT 2, 'ES up 4.50 points, 3 contracts', 18, 12.50, 3
    UNION ALL SELECT 3, 'MES up 4.50 points, 1 contract', 18, 1.25, 1
    UNION ALL SELECT 4, 'CL down 0.85 per barrel, long 1 contract', -85, 10.00, 1
    UNION ALL SELECT 5, 'MCL down 0.85 per barrel, long 1 contract', -85, 1.00, 1
    UNION ALL SELECT 6, 'ZN up 8/32 (110-16 to 110-24), 1 contract', 16, 15.625, 1
    UNION ALL SELECT 7, 'ZB down 12/32 (118-00 to 117-20), long 1 contract', -12, 31.25, 1
) AS examples
ORDER BY id
$