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 feepay localDCC 0.035DCC 0.055DCC 0.075(fee also)
0.0000.00200.03500.05500.07500.0550
0.0150.01700.03500.05500.07500.0708
0.0300.03210.03500.05500.07500.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