Type the Excel formula for a day’s mark-to-market on one long futures contract, with today’s settlement price in B2, yesterday’s in B1 and the contract size in B3.
Type the Excel formula for a day’s mark-to-market on one long futures contract, with today’s settlement price in B2, yesterday’s in B1 and the contract size in B3.
Answer
=(B2-B1)*B3
(2,662 − 2,650) × 100 = 1,200. Today minus yesterday, times size; a short position is the negative of this.
OpenStax Principles of Finance §20.2–20.3 — forward-FX shape, reference only; OpenStax Introduction to Business §16.6 (CC BY 4.0); m-x.ca product overview — S&P/TSX 60 and CORRA futures listed, CDCC as counterparty; BAX is CDOR-era, CDOR ceased 28 June 2024 (verified-facts §2.9 J04, CORRECTED 2026-09-17); original company and figures