What does FX Spreads, DCC Traps and Residency Days conclude, in numbers, about “Dynamic Currency Conversion at the Till”?
Answer: Chapter 4 computes DCC: paying in the local currency costs 0.0020 to 0.0321 extra, DCC 0.0350 to 0.0866, and the DCC markup is at least 648 times the value of the exchange-rate risk it removes.
Scope of the numbers: Its exchange rates, fees and itineraries are illustrative models; all calculations are generated by its programs; the book is not tax, immigration, legal or investment advice. Marked boxes separate published evidence, runnable Python calculations (16 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. printed values that match the answer: 0.0020, 0.0321, 0.0350, 0.0866
| issuer fee | pay local | DCC 0.035 | DCC 0.055 | DCC 0.075 | (fee also) |
| 0.000 | 0.0020 | 0.0350 | 0.0550 | 0.0750 | 0.0550 |
| 0.015 | 0.0170 | 0.0350 | 0.0550 | 0.0750 | 0.0708 |
| 0.030 | 0.0321 | 0.0350 | 0.0550 | 0.0750 | 0.0866 |
| DCC beats paying local only if f > m and the fee is waived |
Show the full program
# Chapter 4. p07: Dynamic currency conversion at the till. A purchase
# abroad, priced locally. Paying in the local currency costs the card
# network's markup 0.002 plus the issuer's foreign fee f. Paying in the
# home currency (DCC) costs the merchant's markup m; some issuers charge
# f on DCC payments as well, because the merchant is abroad. Extra cost
# over the mid rate, as a fraction of the price. No sampling.
NET = 0.002
def local(f):
return (1 + NET) * (1 + f) - 1
def dcc(m, f, fee_too):
return (1 + m) * (1 + (f if fee_too else 0.0)) - 1
if __name__ == "__main__":
print(" issuer fee pay local DCC 0.035 DCC 0.055 DCC 0.075"
" (fee also)")
for f in (0.0, 0.015, 0.03):
print(" {:10.3f} {:9.4f} {:9.4f} {:9.4f} {:9.4f}"
" {:9.4f}".format(f, local(f), dcc(0.035, f, False),
dcc(0.055, f, False), dcc(0.075, f, False),
dcc(0.055, f, True)))
print(" DCC beats paying local only if f > m and the fee is waived")Single source and citation
Fan, Y. (2026). Multicurrency FX Spread Microstructure, Dynamic Currency Conversion Traps and Tax-Residency Day-Counting Thresholds (Version 1.0.0), Chapter 4: Dynamic Currency Conversion at the Till. 5D Library. DOI pending
DOI pending · monograph page goes live after publication · 5DL-B-108 · v1.0.0 · CC-BY-NC-ND-4.0
BibTeX
@book{fan2026108,
author = {Fan, Yafu},
title = {Multicurrency FX Spread Microstructure, Dynamic Currency Conversion Traps and Tax-Residency Day-Counting Thresholds},
year = {2026},
publisher = {5D Library},
edition = {1.0.0},
note = {DOI pending}
}Other chapter answers in this book
- Chapter 1 · Why the Airport Booth's Spread Is So Wide
- Chapter 2 · The Weekend Markup on Multicurrency Cards
- Chapter 3 · How Much to Take Out of the ATM: The Economic Order Quantity
- Chapter 5 · Counting Days: 183, Rolling Windows and a Weighted Formula
- Chapter 6 · Planning a Year as a Knapsack
- Chapter 7 · The Rites of Zhou on Contracts and the Money Office, Tang Flying Cash and the Forward Discount
- Chapter 8 · Practice: A Year's Friction Budget and a Day Ledger