HMRC exchange rates for March 2018
145 currencies, as HMRC published them for 1 to 31 March 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 March 2018
| Code | Currency | Units per £1 | Period covered |
|---|---|---|---|
| AED | Dirham | 5.1345 | 1 to 31 March 2018 |
| ALL | Lek | 149.71 | 1 to 31 March 2018 |
| AMD | Dram | 671.61 | 1 to 31 March 2018 |
| AOA | Readj Kwanza | 293.35 | 1 to 31 March 2018 |
| ARS | Peso | 27.79 | 1 to 31 March 2018 |
| AUD | Dollar | 1.782 | 1 to 31 March 2018 |
| AWG | Florin | 2.5022 | 1 to 31 March 2018 |
| AZN | New Manat | 2.3599 | 1 to 31 March 2018 |
| BAM | Marka | 2.2192 | 1 to 31 March 2018 |
| BBD | Dollar | 2.7957 | 1 to 31 March 2018 |
| BDT | Taka | 116.65 | 1 to 31 March 2018 |
| BGN | Lev | 2.2193 | 1 to 31 March 2018 |
| BHD | Dinar | 0.527 | 1 to 31 March 2018 |
| BIF | Franc | 2,459.59 | 1 to 31 March 2018 |
| BMD | Dollar (US) | 1.3979 | 1 to 31 March 2018 |
| BND | Dollar | 1.8454 | 1 to 31 March 2018 |
| BOB | Boliviano | 9.6592 | 1 to 31 March 2018 |
| BRL | Real | 4.5523 | 1 to 31 March 2018 |
| BSD | Dollar | 1.3979 | 1 to 31 March 2018 |
| BTN | Ngultrum | 90.5 | 1 to 31 March 2018 |
| BWP | Pula | 13.26 | 1 to 31 March 2018 |
| BYN | Rouble | 2.7349 | 1 to 31 March 2018 |
| BZD | Dollar | 2.794 | 1 to 31 March 2018 |
| CAD | Dollar | 1.7702 | 1 to 31 March 2018 |
| CDF | Congo Fr | 2,243.56 | 1 to 31 March 2018 |
| CHF | Franc | 1.3097 | 1 to 31 March 2018 |
| CLP | Peso | 831.13 | 1 to 31 March 2018 |
| CNY | Yuan | 8.8682 | 1 to 31 March 2018 |
| COP | Peso | 4,016.74 | 1 to 31 March 2018 |
| CRC | Colon | 796.17 | 1 to 31 March 2018 |
| CUP | Peso | 1.3979 | 1 to 31 March 2018 |
| CVE | Escudo | 125.45 | 1 to 31 March 2018 |
| CZK | Koruna | 28.74 | 1 to 31 March 2018 |
| DJF | Franc | 248.42 | 1 to 31 March 2018 |
| DKK | Krone | 8.4505 | 1 to 31 March 2018 |
| DOP | Peso | 68.71 | 1 to 31 March 2018 |
| DZD | Dinar | 159.42 | 1 to 31 March 2018 |
| ECS | Dollar | 1.3979 | 1 to 31 March 2018 |
| EGP | Pound | 24.74 | 1 to 31 March 2018 |
| ERN | Nakfa | 20.96 | 1 to 31 March 2018 |
| ETB | Birr | 38.24 | 1 to 31 March 2018 |
| EUR | Euro | 1.1347 | 1 to 31 March 2018 |
| FJD | Dollar | 2.8075 | 1 to 31 March 2018 |
| GEL | Lari | 3.4429 | 1 to 31 March 2018 |
| GHS | Cedi | 6.2435 | 1 to 31 March 2018 |
| GMD | Dalasi | 66.74 | 1 to 31 March 2018 |
| GNF | Franc | 12,619.17 | 1 to 31 March 2018 |
| GTQ | Quetzal | 10.29 | 1 to 31 March 2018 |
| GYD | Dollar | 289.3 | 1 to 31 March 2018 |
| HKD | Dollar | 10.93 | 1 to 31 March 2018 |
| HNL | Lempira | 32.94 | 1 to 31 March 2018 |
| HRK | Kuna | 8.4447 | 1 to 31 March 2018 |
| HTG | Gourde | 89.92 | 1 to 31 March 2018 |
| HUF | Forint | 354.47 | 1 to 31 March 2018 |
| IDR | Rupiah | 19,036.05 | 1 to 31 March 2018 |
| ILS | Shekel | 4.8764 | 1 to 31 March 2018 |
| INR | Rupee | 90.5 | 1 to 31 March 2018 |
| IQD | Dinar | 1,655.06 | 1 to 31 March 2018 |
| ISK | Krona | 140.57 | 1 to 31 March 2018 |
| JMD | Dollar | 175.98 | 1 to 31 March 2018 |
| JOD | Dinar | 0.9911 | 1 to 31 March 2018 |
| JPY | Yen | 150.43 | 1 to 31 March 2018 |
| KES | Schilling | 141.74 | 1 to 31 March 2018 |
| KGS | Som | 95.21 | 1 to 31 March 2018 |
| KHR | Riel | 5,606.81 | 1 to 31 March 2018 |
| KMF | Franc | 558.22 | 1 to 31 March 2018 |
| KRW | Won | 1,504.16 | 1 to 31 March 2018 |
| KWD | Dinar | 0.4192 | 1 to 31 March 2018 |
| KYD | Dollar | 1.1462 | 1 to 31 March 2018 |
| KZT | Tenge | 446.57 | 1 to 31 March 2018 |
| LAK | Kip | 11,602.22 | 1 to 31 March 2018 |
| LBP | Pound | 2,115.65 | 1 to 31 March 2018 |
| LKR | Rupee | 216.98 | 1 to 31 March 2018 |
| LRD | Dollar | 1.3979 | 1 to 31 March 2018 |
| LSL | Loti | 16.27 | 1 to 31 March 2018 |
| LYD | Dinar | 1.8592 | 1 to 31 March 2018 |
| MAD | Dirham | 12.86 | 1 to 31 March 2018 |
| MDL | Leu | 23.28 | 1 to 31 March 2018 |
| MGA | Malagasy Ariary | 4,389.27 | 1 to 31 March 2018 |
| MKD | Denar | 69.86 | 1 to 31 March 2018 |
| MMK | Kyat | 1,860.61 | 1 to 31 March 2018 |
| MNT | Tugrik | 3,350.66 | 1 to 31 March 2018 |
| MOP | Pataca | 11.26 | 1 to 31 March 2018 |
| MRO | not held | 492.95 | 1 to 31 March 2018 |
| MUR | Rupee | 45.77 | 1 to 31 March 2018 |
| MVR | Rufiyaa | 21.59 | 1 to 31 March 2018 |
| MWK | Kwacha | 1,015.08 | 1 to 31 March 2018 |
| MXN | Mexican Peso | 26.05 | 1 to 31 March 2018 |
| MYR | Ringgit | 5.46 | 1 to 31 March 2018 |
| MZN | Metical | 85.48 | 1 to 31 March 2018 |
| NGN | Naira | 503.22 | 1 to 31 March 2018 |
| NIO | Gold Cordoba | 43.34 | 1 to 31 March 2018 |
| NOK | Norwegian Krone | 10.96 | 1 to 31 March 2018 |
| NPR | Rupee | 144.8 | 1 to 31 March 2018 |
| NZD | Dollar | 1.9044 | 1 to 31 March 2018 |
| OMR | Rial | 0.5382 | 1 to 31 March 2018 |
| PAB | Balboa | 1.3979 | 1 to 31 March 2018 |
| PEN | New Sol | 4.5388 | 1 to 31 March 2018 |
| PGK | Kina | 4.5339 | 1 to 31 March 2018 |
| PHP | Peso | 72.84 | 1 to 31 March 2018 |
| PKR | Rupee | 154.51 | 1 to 31 March 2018 |
| PLN | Zloty | 4.7275 | 1 to 31 March 2018 |
| PYG | Guarani | 7,805.8 | 1 to 31 March 2018 |
| QAR | Riyal | 5.0896 | 1 to 31 March 2018 |
| RON | New Leu | 5.2881 | 1 to 31 March 2018 |
| RSD | Dinar | 133.88 | 1 to 31 March 2018 |
| RUB | Rouble | 79.09 | 1 to 31 March 2018 |
| RWF | Franc | 1,198.66 | 1 to 31 March 2018 |
| SAR | Riyal | 5.2424 | 1 to 31 March 2018 |
| SBD | Dollar | 10.85 | 1 to 31 March 2018 |
| SCR | Rupee | 19.32 | 1 to 31 March 2018 |
| SDG | Pound | 25.29 | 1 to 31 March 2018 |
| SEK | Krona | 11.31 | 1 to 31 March 2018 |
| SGD | Dollar | 1.8454 | 1 to 31 March 2018 |
| SLL | Leone | 10,770.5 | 1 to 31 March 2018 |
| SOS | Schilling | 814.95 | 1 to 31 March 2018 |
| SRD | Dollar | 10.43 | 1 to 31 March 2018 |
| STD | Dobra | 27,943.2 | 1 to 31 March 2018 |
| SVC | Colon | 12.23 | 1 to 31 March 2018 |
| SZL | Lilangeni | 16.27 | 1 to 31 March 2018 |
| THB | Baht | 44.02 | 1 to 31 March 2018 |
| TMT | New Manat | 4.9065 | 1 to 31 March 2018 |
| TND | Dinar | 3.3575 | 1 to 31 March 2018 |
| TOP | Pa'anga (AUS) | 1.782 | 1 to 31 March 2018 |
| TRY | Turkish Lira | 5.2924 | 1 to 31 March 2018 |
| TTD | Dollar | 9.4397 | 1 to 31 March 2018 |
| TWD | Dollar | 40.82 | 1 to 31 March 2018 |
| TZS | Schilling | 3,149.37 | 1 to 31 March 2018 |
| UAH | Hryvnia | 37.73 | 1 to 31 March 2018 |
| UGX | Schilling | 5,088.2 | 1 to 31 March 2018 |
| USD | Dollar | 1.3979 | 1 to 31 March 2018 |
| UYU | Peso | 39.79 | 1 to 31 March 2018 |
| UZS | Sum | 11,438.31 | 1 to 31 March 2018 |
| VEF | Bolivar Fuerte | 34,915.01 | 1 to 31 March 2018 |
| VND | Dong | 31,755.91 | 1 to 31 March 2018 |
| VUV | Vatu | 149.67 | 1 to 31 March 2018 |
| WST | Tala | 3.4558 | 1 to 31 March 2018 |
| XAF | CFA Franc | 744.29 | 1 to 31 March 2018 |
| XCD | E Caribbean Dollar | 3.7742 | 1 to 31 March 2018 |
| XOF | CFA Franc | 744.29 | 1 to 31 March 2018 |
| XPF | CFP Franc | 135.4 | 1 to 31 March 2018 |
| YER | Rial | 349.88 | 1 to 31 March 2018 |
| ZAR | Rand | 16.27 | 1 to 31 March 2018 |
| ZMW | Kwacha | 13.73 | 1 to 31 March 2018 |
| ZWL | Dollar | 505.88 | 1 to 31 March 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 March 2018:
http://www.hmrc.gov.uk/softwaredevelopers/rates/exrates-monthly-0318.XML
The same file is also served with a lower case extension, at http://www.hmrc.gov.uk/softwaredevelopers/rates/exrates-monthly-0318.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 March 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.