What does Cross-Border Settlement Friction and Conversion Batches conclude, in numbers, about “Closing the Loop: the Monthly Batch Table, the Conversion Batch Calculator and a Pre-Registered Test”?
Answer: Chapter 8 gives the monthly batch table, the Conversion Batch Calculator and a pre-registered test (34 pairs of entity-currency months). Marked boxes separate published evidence, runnable Python calculations (19 programs), classical sources and the author's hypotheses.
Scope of the numbers: All fees, rates, volatilities, amounts and group structures are illustrative; all calculations are generated by the book's programs; the book is not individual legal, tax or financial advice. Marked boxes separate published evidence, runnable Python calculations (19 programs), classical sources and the author's hypotheses.
Data table
The numbers below are printed verbatim by the chapter's Python program and can be reproduced by running it. standard-library Python onlyprinted values that match the answer: 34
| z 0.975 | 1.9600, z 0.80 = 0.8416 |
| friction test | 32 paired months (normal approximation) |
| simulated power with 32 pairs | 0.785 |
| simulated power with 34 pairs | 0.814 |
| simulated power with 36 pairs | 0.823 |
| risk check | 50 months give a 95 % band of +-0.20 on s / sigma |
| so the registered band for s / sigma is 0.80 to 1.20 | |
| with 6 entity-currency lines, 9 calendar months cover both |
Show the full program
# Chapter 8. p82: how many paired months a pre-registered test needs.
# Outcome 1 (friction): per entity-currency, alternate months between
# the old rule and the batch table; the paired difference in friction
# (fees + spread + funding, bp of volume) has an assumed SD of 6 bp and
# the smallest difference worth detecting is 3 bp (both illustrative).
# n = ((z_a + z_b) * sd / delta)^2 with a two-sided 5 % test and 80 %
# power; a seeded simulation of the paired t statistic checks the power.
# Outcome 2 (risk): the realised SD of monthly FX P&L should lie within
# 20 % of sigma * Q * sqrt(10); s / sigma has SD about 1 / sqrt(2(n-1)).
import math
import random
import statistics
rng = random.Random(20261113)
SD_D, DELTA = 6.0, 3.0
nd = statistics.NormalDist()
za, zb = nd.inv_cdf(0.975), nd.inv_cdf(0.80)
n = math.ceil(((za + zb) * SD_D / DELTA) ** 2)
print("z 0.975 = %.4f, z 0.80 = %.4f" % (za, zb))
print("friction test: %d paired months (normal approximation)" % n)
# 2.04 below: two-sided 5 % t critical value, about 31 degrees of freedom
for m in (n, n + 2, n + 4):
hits = 0
for _ in range(4000):
d = [rng.gauss(DELTA, SD_D) for _ in range(m)]
t = statistics.fmean(d) / (statistics.stdev(d) / math.sqrt(m))
hits += 1 if abs(t) > 2.04 else 0 # step
print(" simulated power with %d pairs: %.3f" % (m, hits / 4000.0))
k = 2
while 1.96 / math.sqrt(2 * (k - 1)) > 0.20:
k += 1
print("risk check: %d months give a 95 %% band of +-0.20 on s / sigma"
% k)
print(" so the registered band for s / sigma is 0.80 to 1.20")
print("with 6 entity-currency lines, %d calendar months cover both"
% math.ceil(max(n + 4, k) / 6.0))Single source and citation
Fan, Y. (2026). Cross-Border Settlement Frictions and Compliant Treasury Scheduling: Minimum-Loss Network Flows over Multi-Currency Channel Fees and Conversion Slippage (Version 1.0.0), Chapter 8: Closing the Loop: the Monthly Batch Table, the Conversion Batch Calculator and a Pre-Registered Test. 5D Library. DOI pending
DOI pending · monograph page goes live after publication · 5DL-B-280 · v1.0.0 · CC-BY-NC-ND-4.0
BibTeX
@book{fan2026280,
author = {Fan, Yafu},
title = {Cross-Border Settlement Frictions and Compliant Treasury Scheduling: Minimum-Loss Network Flows over Multi-Currency Channel Fees and Conversion Slippage},
year = {2026},
publisher = {5D Library},
edition = {1.0.0},
note = {DOI pending}
}Other chapter answers in this book
- Chapter 1 · Each Receipt or in Batches: One Month's Ledger of Conversion Friction
- Chapter 2 · The Price of Waiting: How Exchange-Rate Risk Pushes the Square Root towards a Cube Root
- Chapter 3 · A Network of Currency Channels: Minimum-Loss Flows and the Shadow Price of Money
- Chapter 4 · Offset Before You Transfer: Multilateral Netting and the Fewest Payments
- Chapter 5 · A Month's Conversion Calendar: Dynamic Programming, Minimum Charges and Volume Tiers
- Chapter 6 · Robustness: Wrong Parameters, Fat-Tailed Rates and a Written Loss Budget
- Chapter 7 · Eastern and Western Sources Examined: the Quanfu Office Gathers and Releases, Fibonacci Chains the Rates