HMRC exchange rates for January 2018
145 currencies, as HMRC published them for 1 to 31 January 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 January 2018
| Code | Currency | Units per £1 | Period covered |
|---|---|---|---|
| AED | Dirham | 4.9239 | 1 to 31 January 2018 |
| ALL | Lek | 150.06 | 1 to 31 January 2018 |
| AMD | Dram | 645.55 | 1 to 31 January 2018 |
| AOA | Readj Kwanza | 222.43 | 1 to 31 January 2018 |
| ARS | Peso | 23.81 | 1 to 31 January 2018 |
| AUD | Dollar | 1.7489 | 1 to 31 January 2018 |
| AWG | Florin | 2.3997 | 1 to 31 January 2018 |
| AZN | New Manat | 2.265 | 1 to 31 January 2018 |
| BAM | Marka | 2.2066 | 1 to 31 January 2018 |
| BBD | Dollar | 2.6812 | 1 to 31 January 2018 |
| BDT | Taka | 111.5 | 1 to 31 January 2018 |
| BGN | Lev | 2.2067 | 1 to 31 January 2018 |
| BHD | Dinar | 0.5054 | 1 to 31 January 2018 |
| BIF | Franc | 2,354.47 | 1 to 31 January 2018 |
| BMD | Dollar (US) | 1.3406 | 1 to 31 January 2018 |
| BND | Dollar | 1.8031 | 1 to 31 January 2018 |
| BOB | Boliviano | 9.2636 | 1 to 31 January 2018 |
| BRL | Real | 4.4137 | 1 to 31 January 2018 |
| BSD | Dollar | 1.3406 | 1 to 31 January 2018 |
| BTN | Ngultrum | 85.91 | 1 to 31 January 2018 |
| BWP | Pula | 13.37 | 1 to 31 January 2018 |
| BYN | Rouble | 2.6913 | 1 to 31 January 2018 |
| BZD | Dollar | 2.6795 | 1 to 31 January 2018 |
| CAD | Dollar | 1.7231 | 1 to 31 January 2018 |
| CDF | Congo Fr | 2,138.94 | 1 to 31 January 2018 |
| CHF | Franc | 1.32 | 1 to 31 January 2018 |
| CLP | Peso | 832.28 | 1 to 31 January 2018 |
| CNY | Yuan | 8.8212 | 1 to 31 January 2018 |
| COP | Peso | 3,964.53 | 1 to 31 January 2018 |
| CRC | Colon | 758.97 | 1 to 31 January 2018 |
| CUP | Peso | 1.3406 | 1 to 31 January 2018 |
| CVE | Escudo | 125.17 | 1 to 31 January 2018 |
| CZK | Koruna | 28.94 | 1 to 31 January 2018 |
| DJF | Franc | 238.25 | 1 to 31 January 2018 |
| DKK | Krone | 8.399 | 1 to 31 January 2018 |
| DOP | Peso | 64.85 | 1 to 31 January 2018 |
| DZD | Dinar | 154.39 | 1 to 31 January 2018 |
| ECS | Dollar | 1.3406 | 1 to 31 January 2018 |
| EGP | Pound | 23.96 | 1 to 31 January 2018 |
| ERN | Nakfa | 20.1 | 1 to 31 January 2018 |
| ETB | Birr | 36.62 | 1 to 31 January 2018 |
| EUR | Euro | 1.1282 | 1 to 31 January 2018 |
| FJD | Dollar | 2.7556 | 1 to 31 January 2018 |
| GEL | Lari | 3.4051 | 1 to 31 January 2018 |
| GHS | Cedi | 6.0327 | 1 to 31 January 2018 |
| GMD | Dalasi | 63.88 | 1 to 31 January 2018 |
| GNF | Franc | 12,104.35 | 1 to 31 January 2018 |
| GTQ | Quetzal | 9.8421 | 1 to 31 January 2018 |
| GYD | Dollar | 278.07 | 1 to 31 January 2018 |
| HKD | Dollar | 10.48 | 1 to 31 January 2018 |
| HNL | Lempira | 31.57 | 1 to 31 January 2018 |
| HRK | Kuna | 8.5111 | 1 to 31 January 2018 |
| HTG | Gourde | 85.99 | 1 to 31 January 2018 |
| HUF | Forint | 353.09 | 1 to 31 January 2018 |
| IDR | Rupiah | 18,202.13 | 1 to 31 January 2018 |
| ILS | Shekel | 4.6853 | 1 to 31 January 2018 |
| INR | Rupee | 85.91 | 1 to 31 January 2018 |
| IQD | Dinar | 1,585.93 | 1 to 31 January 2018 |
| ISK | Krona | 141.07 | 1 to 31 January 2018 |
| JMD | Dollar | 167.4 | 1 to 31 January 2018 |
| JOD | Dinar | 0.9505 | 1 to 31 January 2018 |
| JPY | Yen | 151.89 | 1 to 31 January 2018 |
| KES | Schilling | 138.14 | 1 to 31 January 2018 |
| KGS | Som | 93.46 | 1 to 31 January 2018 |
| KHR | Riel | 5,405.33 | 1 to 31 January 2018 |
| KMF | Franc | 555.04 | 1 to 31 January 2018 |
| KRW | Won | 1,449.19 | 1 to 31 January 2018 |
| KWD | Dinar | 0.4049 | 1 to 31 January 2018 |
| KYD | Dollar | 1.0993 | 1 to 31 January 2018 |
| KZT | Tenge | 450.28 | 1 to 31 January 2018 |
| LAK | Kip | 11,157.88 | 1 to 31 January 2018 |
| LBP | Pound | 2,027.85 | 1 to 31 January 2018 |
| LKR | Rupee | 205.24 | 1 to 31 January 2018 |
| LRD | Dollar | 1.3406 | 1 to 31 January 2018 |
| LSL | Loti | 16.91 | 1 to 31 January 2018 |
| LYD | Dinar | 1.8232 | 1 to 31 January 2018 |
| MAD | Dirham | 12.61 | 1 to 31 January 2018 |
| MDL | Leu | 23.02 | 1 to 31 January 2018 |
| MGA | Malagasy Ariary | 4,340.22 | 1 to 31 January 2018 |
| MKD | Denar | 69.47 | 1 to 31 January 2018 |
| MMK | Kyat | 1,827.51 | 1 to 31 January 2018 |
| MNT | Tugrik | 3,251.64 | 1 to 31 January 2018 |
| MOP | Pataca | 10.8 | 1 to 31 January 2018 |
| MRO | not held | 475.06 | 1 to 31 January 2018 |
| MUR | Rupee | 44.97 | 1 to 31 January 2018 |
| MVR | Rufiyaa | 20.64 | 1 to 31 January 2018 |
| MWK | Kwacha | 972.47 | 1 to 31 January 2018 |
| MXN | Mexican Peso | 25.78 | 1 to 31 January 2018 |
| MYR | Ringgit | 5.4616 | 1 to 31 January 2018 |
| MZN | Metical | 78.94 | 1 to 31 January 2018 |
| NGN | Naira | 482.61 | 1 to 31 January 2018 |
| NIO | Gold Cordoba | 41.21 | 1 to 31 January 2018 |
| NOK | Norwegian Krone | 11.23 | 1 to 31 January 2018 |
| NPR | Rupee | 137.46 | 1 to 31 January 2018 |
| NZD | Dollar | 1.9234 | 1 to 31 January 2018 |
| OMR | Rial | 0.5161 | 1 to 31 January 2018 |
| PAB | Balboa | 1.3406 | 1 to 31 January 2018 |
| PEN | New Sol | 4.3865 | 1 to 31 January 2018 |
| PGK | Kina | 4.3135 | 1 to 31 January 2018 |
| PHP | Peso | 67.42 | 1 to 31 January 2018 |
| PKR | Rupee | 148 | 1 to 31 January 2018 |
| PLN | Zloty | 4.7384 | 1 to 31 January 2018 |
| PYG | Guarani | 7,554.26 | 1 to 31 January 2018 |
| QAR | Riyal | 4.8812 | 1 to 31 January 2018 |
| RON | New Leu | 5.2195 | 1 to 31 January 2018 |
| RSD | Dinar | 134.57 | 1 to 31 January 2018 |
| RUB | Rouble | 78.64 | 1 to 31 January 2018 |
| RWF | Franc | 1,143.69 | 1 to 31 January 2018 |
| SAR | Riyal | 5.0274 | 1 to 31 January 2018 |
| SBD | Dollar | 10.41 | 1 to 31 January 2018 |
| SCR | Rupee | 18.25 | 1 to 31 January 2018 |
| SDG | Pound | 8.9262 | 1 to 31 January 2018 |
| SEK | Krona | 11.22 | 1 to 31 January 2018 |
| SGD | Dollar | 1.8031 | 1 to 31 January 2018 |
| SLL | Leone | 10,279.11 | 1 to 31 January 2018 |
| SOS | Schilling | 797.66 | 1 to 31 January 2018 |
| SRD | Dollar | 9.9983 | 1 to 31 January 2018 |
| STD | Dobra | 27,911.46 | 1 to 31 January 2018 |
| SVC | Colon | 11.72 | 1 to 31 January 2018 |
| SZL | Lilangeni | 16.91 | 1 to 31 January 2018 |
| THB | Baht | 43.87 | 1 to 31 January 2018 |
| TMT | New Manat | 4.7055 | 1 to 31 January 2018 |
| TND | Dinar | 3.3252 | 1 to 31 January 2018 |
| TOP | Pa'anga (AUS) | 1.7489 | 1 to 31 January 2018 |
| TRY | Turkish Lira | 5.1241 | 1 to 31 January 2018 |
| TTD | Dollar | 9.077 | 1 to 31 January 2018 |
| TWD | Dollar | 40.2 | 1 to 31 January 2018 |
| TZS | Schilling | 3,008.99 | 1 to 31 January 2018 |
| UAH | Hryvnia | 37.32 | 1 to 31 January 2018 |
| UGX | Schilling | 4,846.29 | 1 to 31 January 2018 |
| USD | Dollar | 1.3406 | 1 to 31 January 2018 |
| UYU | Peso | 38.5 | 1 to 31 January 2018 |
| UZS | Sum | 10,861.1 | 1 to 31 January 2018 |
| VEF | Bolivar Fuerte | 13.51 | 1 to 31 January 2018 |
| VND | Dong | 30,449.92 | 1 to 31 January 2018 |
| VUV | Vatu | 146.99 | 1 to 31 January 2018 |
| WST | Tala | 3.3871 | 1 to 31 January 2018 |
| XAF | CFA Franc | 740.06 | 1 to 31 January 2018 |
| XCD | E Caribbean Dollar | 3.6196 | 1 to 31 January 2018 |
| XOF | CFA Franc | 740.06 | 1 to 31 January 2018 |
| XPF | CFP Franc | 134.63 | 1 to 31 January 2018 |
| YER | Rial | 335.5 | 1 to 31 January 2018 |
| ZAR | Rand | 16.91 | 1 to 31 January 2018 |
| ZMW | Kwacha | 13.1 | 1 to 31 January 2018 |
| ZWL | Dollar | 485.16 | 1 to 31 January 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 January 2018:
http://www.hmrc.gov.uk/softwaredevelopers/rates/exrates-monthly-0118.XML
The same file is also served with a lower case extension, at http://www.hmrc.gov.uk/softwaredevelopers/rates/exrates-monthly-0118.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
- A trade made in January 2018 converts at the rate on this page. A trade made in another month uses that month's page, on the buy and on the sale alike.
- If the rate for a currency is not on this page, HMRC did not publish one for it that month, or this server has not loaded it. The calculator names the currency and the month and refuses rather than borrowing another currency's rate.
- A pence quoted London price is not a foreign currency. Pence are converted by dividing by 100, and that happens before any of this.
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.