TaxBullUK capital gains tax

HMRC exchange rates for July 2018

145 currencies, as HMRC published them for 1 to 31 July 2018. Each figure is the number of units you get for one pound.

Divide, do not multiply

Sterling is the foreign amount divided by the rate in this table. Multiplying instead is wrong by the square of the rate, which on a typical dollar figure is more than half as much again.

HMRC do not prescribe which exchange rate you use. CG78310 expects a reasonable and consistent method, and the monthly rate is the method this calculator applies to every trade. What CG78310 does settle is the date: sterling worth is taken at the date of the acquisition or disposal (Bentley v Pike, Capcount Trading v Evans). A broker's own rate and a market feed are neither published nor consistent, so this site never reads one.

Every rate HMRC published for July 2018

Units of each currency per £1, for 1 to 31 July 2018. Sorted by currency code.
Code Currency Units per £1 Period covered
AED Dirham 4.8396 1 to 31 July 2018
ALL Lek 143.38 1 to 31 July 2018
AMD Dram 635.1 1 to 31 July 2018
AOA Readj Kwanza 324.93 1 to 31 July 2018
ARS Peso 36.59 1 to 31 July 2018
AUD Dollar 1.7867 1 to 31 July 2018
AWG Florin 2.3585 1 to 31 July 2018
AZN New Manat 2.2419 1 to 31 July 2018
BAM Marka 2.2257 1 to 31 July 2018
BBD Dollar 2.6352 1 to 31 July 2018
BDT Taka 111.2 1 to 31 July 2018
BGN Lev 2.2257 1 to 31 July 2018
BHD Dinar 0.4979 1 to 31 July 2018
BIF Franc 2,339.82 1 to 31 July 2018
BMD Dollar (US) 1.3176 1 to 31 July 2018
BND Dollar 1.7894 1 to 31 July 2018
BOB Boliviano 9.1046 1 to 31 July 2018
BRL Real 4.9419 1 to 31 July 2018
BSD Dollar 1.3176 1 to 31 July 2018
BTN Ngultrum 89.7 1 to 31 July 2018
BWP Pula 13.66 1 to 31 July 2018
BYN Rouble 2.6391 1 to 31 July 2018
BZD Dollar 2.6335 1 to 31 July 2018
CAD Dollar 1.7515 1 to 31 July 2018
CDF Congo Fr 2,129.22 1 to 31 July 2018
CHF Franc 1.3108 1 to 31 July 2018
CLP Peso 843.66 1 to 31 July 2018
CNY Yuan 8.5255 1 to 31 July 2018
COP Peso 3,850.13 1 to 31 July 2018
CRC Colon 747.54 1 to 31 July 2018
CUP Peso 1.3176 1 to 31 July 2018
CVE Escudo 125.83 1 to 31 July 2018
CZK Koruna 29.41 1 to 31 July 2018
DJF Franc 234.16 1 to 31 July 2018
DKK Krone 8.4819 1 to 31 July 2018
DOP Peso 65.37 1 to 31 July 2018
DZD Dinar 155.06 1 to 31 July 2018
ECS Dollar 1.3176 1 to 31 July 2018
EGP Pound 23.56 1 to 31 July 2018
ERN Nakfa 19.76 1 to 31 July 2018
ETB Birr 36.09 1 to 31 July 2018
EUR Euro 1.138 1 to 31 July 2018
FJD Dollar 2.7461 1 to 31 July 2018
GEL Lari 3.2413 1 to 31 July 2018
GHS Cedi 6.2245 1 to 31 July 2018
GMD Dalasi 62.94 1 to 31 July 2018
GNF Franc 11,892.6 1 to 31 July 2018
GTQ Quetzal 9.8598 1 to 31 July 2018
GYD Dollar 275.13 1 to 31 July 2018
HKD Dollar 10.34 1 to 31 July 2018
HNL Lempira 31.57 1 to 31 July 2018
HRK Kuna 8.3993 1 to 31 July 2018
HTG Gourde 87.57 1 to 31 July 2018
HUF Forint 368.12 1 to 31 July 2018
IDR Rupiah 18,356.06 1 to 31 July 2018
ILS Shekel 4.779 1 to 31 July 2018
INR Rupee 89.7 1 to 31 July 2018
IQD Dinar 1,565.95 1 to 31 July 2018
ISK Krona 143.82 1 to 31 July 2018
JMD Dollar 173.24 1 to 31 July 2018
JOD Dinar 0.9358 1 to 31 July 2018
JPY Yen 145.06 1 to 31 July 2018
KES Schilling 133.01 1 to 31 July 2018
KGS Som 90 1 to 31 July 2018
KHR Riel 5,349.42 1 to 31 July 2018
KMF Franc 559.84 1 to 31 July 2018
KRW Won 1,456.13 1 to 31 July 2018
KWD Dinar 0.3989 1 to 31 July 2018
KYD Dollar 1.0804 1 to 31 July 2018
KZT Tenge 448.96 1 to 31 July 2018
LAK Kip 11,090.83 1 to 31 July 2018
LBP Pound 1,992.2 1 to 31 July 2018
LKR Rupee 210.78 1 to 31 July 2018
LRD Dollar 1.3176 1 to 31 July 2018
LSL Loti 18 1 to 31 July 2018
LYD Dinar 1.7919 1 to 31 July 2018
MAD Dirham 12.58 1 to 31 July 2018
MDL Leu 22.25 1 to 31 July 2018
MGA Malagasy Ariary 4,461.36 1 to 31 July 2018
MKD Denar 70.06 1 to 31 July 2018
MMK Kyat 1,813.2 1 to 31 July 2018
MNT Tugrik 3,205.7 1 to 31 July 2018
MOP Pataca 10.65 1 to 31 July 2018
MRO not held 470.77 1 to 31 July 2018
MUR Rupee 46.28 1 to 31 July 2018
MVR Rufiyaa 20.3 1 to 31 July 2018
MWK Kwacha 956.36 1 to 31 July 2018
MXN Mexican Peso 26.88 1 to 31 July 2018
MYR Ringgit 5.2776 1 to 31 July 2018
MZN Metical 78.02 1 to 31 July 2018
NGN Naira 473.67 1 to 31 July 2018
NIO Gold Cordoba 41.5 1 to 31 July 2018
NOK Norwegian Krone 10.76 1 to 31 July 2018
NPR Rupee 143.53 1 to 31 July 2018
NZD Dollar 1.9183 1 to 31 July 2018
OMR Rial 0.5073 1 to 31 July 2018
PAB Balboa 1.3176 1 to 31 July 2018
PEN New Sol 4.3276 1 to 31 July 2018
PGK Kina 4.3014 1 to 31 July 2018
PHP Peso 70.42 1 to 31 July 2018
PKR Rupee 159.75 1 to 31 July 2018
PLN Zloty 4.9137 1 to 31 July 2018
PYG Guarani 7,514.89 1 to 31 July 2018
QAR Riyal 4.7974 1 to 31 July 2018
RON New Leu 5.3189 1 to 31 July 2018
RSD Dinar 134.36 1 to 31 July 2018
RUB Rouble 83.83 1 to 31 July 2018
RWF Franc 1,151.57 1 to 31 July 2018
SAR Riyal 4.9416 1 to 31 July 2018
SBD Dollar 10.39 1 to 31 July 2018
SCR Rupee 18.19 1 to 31 July 2018
SDG Pound 23.8 1 to 31 July 2018
SEK Krona 11.71 1 to 31 July 2018
SGD Dollar 1.7894 1 to 31 July 2018
SLL Leone 10,626.39 1 to 31 July 2018
SOS Schilling 764.2 1 to 31 July 2018
SRD Dollar 9.8398 1 to 31 July 2018
STD Dobra 27,906.6 1 to 31 July 2018
SVC Colon 11.53 1 to 31 July 2018
SZL Lilangeni 18 1 to 31 July 2018
THB Baht 43.17 1 to 31 July 2018
TMT New Manat 4.6116 1 to 31 July 2018
TND Dinar 3.4323 1 to 31 July 2018
TOP Pa'anga (AUS) 1.7867 1 to 31 July 2018
TRY Turkish Lira 6.2497 1 to 31 July 2018
TTD Dollar 8.8959 1 to 31 July 2018
TWD Dollar 39.74 1 to 31 July 2018
TZS Schilling 2,997.52 1 to 31 July 2018
UAH Hryvnia 34.9 1 to 31 July 2018
UGX Schilling 5,104.86 1 to 31 July 2018
USD Dollar 1.3176 1 to 31 July 2018
UYU Peso 41.78 1 to 31 July 2018
UZS Sum 10,387.89 1 to 31 July 2018
VEF Bolivar Fuerte 52,713.58 1 to 31 July 2018
VND Dong 30,130.1 1 to 31 July 2018
VUV Vatu 145.41 1 to 31 July 2018
WST Tala 3.3655 1 to 31 July 2018
XAF CFA Franc 746.45 1 to 31 July 2018
XCD E Caribbean Dollar 3.5575 1 to 31 July 2018
XOF CFA Franc 746.45 1 to 31 July 2018
XPF CFP Franc 135.79 1 to 31 July 2018
YER Rial 329.74 1 to 31 July 2018
ZAR Rand 18 1 to 31 July 2018
ZMW Kwacha 13.27 1 to 31 July 2018
ZWL Dollar 476.83 1 to 31 July 2018

Rates are shown exactly as published and are not rounded, because the calculator divides by the same figure. A currency with no name against it is one this server holds only by code.

Where this month came from

Months before January 2021 come from HMRC's own XML archive, which is what the gov.uk collection links to for monthly rates up to December 2020. This is the file for July 2018:

http://www.hmrc.gov.uk/softwaredevelopers/rates/exrates-monthly-0718.XML

The same file is also served with a lower case extension, at http://www.hmrc.gov.uk/softwaredevelopers/rates/exrates-monthly-0718.xml, and HMRC's own index is inconsistent about which. The host is case sensitive, so both spellings are tried. The file carries a Period attribute and a rate is kept only when that attribute names the month asked for, because a wrong month URL still answers 200 with a complete and valid looking file.

The collection that lists both is Exchange rates for customs and VAT on gov.uk. Nothing here is taken from a mirror. A rate comes from HMRC or it does not come at all.

Using this month on a return

Work out the tax from your broker CSV →

Upload a broker export and every foreign trade in it is converted at the HMRC rate for its own month, with the month named in the report. The guide explains the matching rules that decide which cost a disposal takes.