Skip to main content
PLANNING№ 06 / 064 capabilitiesShipping

Back Testing

Drop in a historical trade list (CSV) and we replay it against the live rate map plus a 7-day fallback. Output is a per-trade P&L grid, monthly aggregation, and cumulative ComposedChart. IFRS-9 disclaimer included.

To test a forward, option and TARF mix before you trade it rather than after, use the Hedge Simulator.

Inside the module
  • 01.CSV upload. 4 required + 2 optional columns, 1,000-row limit
  • 02.Bulk rate-map with 7-day fallback resolver
  • 03.Achieved rate against the market's monthly range, pair by pair
00Live preview

Replay your trades. Audit the result.

Drop a CSV of historical FX transactions and we score each one against the live market spot benchmark. Total P&L, best and worst months, your achieved rate against the market's monthly range for each pair, and an audit-ready export. IFRS 9 disclaimer included.

Back Testing

Upload historical FX transactions to analyse performance against market spot rates.

BackUpload New File
2025-10-02 → 2026-03-30·82 transactionsEUR/USDGBP/USD
Export to PDFIFRS 7 PDFExport Results CSV
Compare against
LowHighMid
The midpoint of the day’s range: (high + low) ÷ 2. Not the closing rate.
All pairsEUR/USDGBP/USD

Budget rates

One rate for all yearsA rate per year
EUR/USD1.1500
GBP/USD1.3200

Leave a pair blank for no budget. Choose “A rate per year” to set a different rate for each year.

Save and apply

Achieved Rate vs Spot Benchmark

EUR/USD

1.2201.1101.000
BUDGET1.1500
Oct 2024Apr 2025Oct 2025
Market range (high-low)Market midpointAchieved Rate

GBP/USD

1.4101.2951.180
BUDGET1.3200
Oct 2024Apr 2025Oct 2025
Market range (high-low)Market midpointAchieved Rate

Monthly average achieved rate against the market’s own monthly range: the shaded band is high to low across every session in the period, and the dashed line its midpoint. The earlier months, before your first trade, show the market only, a comparable period you had not yet hedged in. Every pair is on its own scale, so read each panel on its own rather than against the others.

All 2 pairsTotals: pick a pair above to see just that pair.

Your Performance vs Spot

+£71,512.40

82 transactions over 6 months · 2 skipped (no spot rate)

Best Month

Feb 2026

+£21,690.40

Worst Month

Nov 2025

-£4,108.35

Your Performance vs Budget

+£325,840.53

82 transactions against your budget rates

All 2 pairsFX P&L by year: budget rates are set above the Achieved Rate chart. Pick a pair above to see just that pair.

FX P&L by Year: vs Budget and vs Average Spot

YearPairDirectionTxnsVolumeAvg AchievedBudget RateFX P&L vs BudgetAvg Spot (year)FX P&L vs SpotOutcome
2025EUR/USDSell EUR · Buy USD24£4.86M1.16521.1500+£64,236.521.1618+£14,222.76Favourable
2025GBP/USDSell GBP · Buy USD16£3.24M1.33181.3200+£28,963.641.3243+£18,349.32Favourable
2026EUR/USDSell EUR · Buy USD26£5.37M1.17831.1500+£132,148.701.1748+£15,998.47Favourable
2026GBP/USDSell GBP · Buy USD16£3.41M1.35891.3200+£100,491.671.3562+£6,788.82Favourable
Detailed analysisbenchmark schedules, policy comparison, IFRS 7 disclosure, data qualityHide

vs Spot Benchmark Schedule

Monthly (month average)

Dealing the same notionals at the monthly (month average) benchmark instead would have left you £28,307.75 worse off across 82 transactions.

Green means dealing on this schedule would have beaten the rates you achieved; red means your own rates were better.

PairMarket rangeAvg AchievedPeriodsTxnsBenchmark P&L vs Yours
EUR/USD1.1470 · 1.1685 · 1.19001.1721650-£18,436.20
GBP/USD1.3010 · 1.3395 · 1.37801.3457632-£9,871.55

Mid-market dayOne deal per month at the average of the month’s daily midpoints (dollar-cost-averaged) applied to the full monthly notional.

Hedge Effectiveness: IFRS 7 Disclosure

What this measures

How closely the rates you achieved stayed with the first benchmarked rate of each calendar year, compared with how far the market moved away from it. Around 100% reads like a straight forward hedge; around 0% means the movement stayed with you. Measured only on the trades in this upload.

Cumulative dollar-offset: 97.7% Within 80-125% band (diagnostic band 80-125%)

§24: Effect of hedge accounting

PeriodTxnsHedged item ΔHedging instr. ΔIneffectiveness (P&L)Cumulative offsetIn band
202540-£182,416.30+£178,903.85-£3,512.4598.1%Yes
202642+£96,184.70-£94,690.10+£1,494.6098.4%Yes
All periods82-£86,231.60+£84,213.75-£2,017.8597.7%Yes

Cash-flow hedge reserve movements are recycled to profit or loss as the hedged forecast transactions settle.

01How it works

From input to outcome, in four steps.

Each card lights up in turn. The full cycle takes twelve seconds, about how long it takes a dealer to walk a client through the same flow.
01

Load data

Trades, rates, and forecasts stream into the platform.

02

Compute

Charts, KPIs, and aggregations recalculate live.

03

Review

Visualise the result alongside the underlying data.

04

Export

CSV or PDF for the audit file or the board pack.

024 capabilities

What's inside

The capabilities that ship with Back Testing, every one of them tested end-to-end before it lands on your desk.
  • 01CSV upload. 4 required + 2 optional columns, 1,000-row limit
  • 02Bulk rate-map with 7-day fallback resolver
  • 03Achieved rate against the market's monthly range, pair by pair
  • 04IFRS 9 disclaimer + audit-ready export
04Talk to the desk

See Back Testing on real treasury data.

Twenty minutes, no setup required. Bring your own book and we'll walk through Back Testing live, alongside the rest of HedgePoint.
Walkthrough plan20 MIN
  1. 01Your book, our chrome. We mount your trades behind HedgePoint.
  2. 02Live walkthrough. Back Testing in context with the rest.
  3. 03Q&A + integration map. Where it slots into your stack today.