--- title: "HKMA Exchange Rate History: Download Hong Kong Dollar Rates 1981 to 2026 as CSV, Excel or API" description: "Daily Hong Kong Monetary Authority exchange rates for 17 currencies from 2 January 1981, assembled as one CSV per year, with Excel, Google Sheets, Python and API examples and reference points to check your load." canonical: https://allratestoday.com/blog/hkma-exchange-rate-history-download/ source: AllRatesToday (https://allratestoday.com/) — Markdown mirror of the page above; index of all pages at https://allratestoday.com/llms.txt generated: 2026-11-12T08:08:57.527Z --- The Hong Kong Monetary Authority (HKMA) has daily Hong Kong dollar exchange rates back to 1981, but getting forty-five years of them into a spreadsheet means paging through an API or stitching bulletin tables. This guide points to the series already assembled and shows how to use it. ## What the HKMA itself provides The figures are Table 6.1 of the Monthly Statistical Bulletin, "Exchange rates and the effective exchange rate indices". The bulletin is released mainly in two batches, on the 3rd and 6th business days of each month, so the series is daily in detail but arrives monthly: on 11 November 2026 the newest daily record was 31 October 2026. The HKMA open API serves the same data as Hong Kong dollars per unit of foreign currency for 17 currencies, plus effective exchange rate indices. For a rate on the day itself, Hong Kong has a second official series: the [Hong Kong Association of Banks daily table](https://allratestoday.com/central-bank-rates-api/hkab/), set at the opening of business. ## The assembled series: one CSV per year The [central-bank-exchange-rates](https://github.com/AllRates-Today/central-bank-exchange-rates/tree/main/data/hkma) repository holds the HKMA table under `data/hkma/`: `latest.json` for the newest table, `daily/` for one JSON file per date, and `history/` with one CSV per year from 1981 to 2026. ``` https://raw.githubusercontent.com/AllRates-Today/central-bank-exchange-rates/main/data/hkma/history/2025.csv date,base,quote,type,value 2025-01-02,AUD,HKD,reference,4.8295 ... ``` Each row is Hong Kong dollars per one unit of the `base` currency on that date. The series runs from 2 January 1981 and holds about 207,000 rows across 13,458 dates. Licence: **CC BY-NC 4.0**, so free for research, study and internal non-commercial use with attribution; commercial systems use the API below. ## Excel Data > Get Data > From Web, paste the raw URL above, and Power Query loads it as a table. Filter `base` to the currencies you need and pivot on `date`. Refresh re-reads the file. ## Google Sheets ``` =QUERY(IMPORTDATA("https://raw.githubusercontent.com/AllRates-Today/central-bank-exchange-rates/main/data/hkma/history/2026.csv"), "select Col1, Col5 where Col2 = 'USD'", 1) ``` That returns the date and the US dollar rate for every day of 2026 in the series. Wrap it in `VLOOKUP` to pick the rate for a transaction date. ## Python ``` import pandas as pd base = "https://raw.githubusercontent.com/AllRates-Today/central-bank-exchange-rates/main/data/hkma/history/{}.csv" df = pd.concat(pd.read_csv(base.format(y), parse_dates=["date"]) for y in range(2024, 2027)) wide = df.pivot(index="date", columns="base", values="value") print(wide.loc["2025-12-31", ["USD", "EUR", "GBP", "CNY"]]) # USD 7.7840, EUR 9.1370, GBP 10.4730, CNY 1.1144 print(wide["USD"]["2025-04-01":"2026-03-31"].mean()) # 7.8059, year of assessment 2025/26 print(wide["EUR"].asof("2026-06-28")) # a Sunday: the last table before it ``` `asof` is the call that matters for finance work: for a date with no table it returns the last one before it. ## One date, as an API call ``` # the latest HKMA table curl "https://allratestoday.com/api/open/central-bank/hkma" # a past date or a range, with a key curl -H "Authorization: Bearer YOUR_API_KEY" \ "https://allratestoday.com/api/v1/central-bank/hkma/2025-12-31" curl -H "Authorization: Bearer YOUR_API_KEY" \ "https://allratestoday.com/api/v1/central-bank/hkma/history?symbol=EUR&from=2026-01-01&to=2026-10-31" ``` The dated response includes `requested_date` and `rate_date`, so a fallback to an earlier table is explicit in the data. Add `?format=csv`, `xml` or `xlsx` to any table endpoint. Dated tables and history are on paid plans; a history request is counted as one call per currency per month of data. ## Reference points for checking your load | Date | USD | EUR | GBP | CNY | SGD | | --- | --- | --- | --- | --- | --- | | 31 Dec 2024 | 7.7640 | 8.0780 | 9.7420 | 1.0601 | 5.7095 | | 30 Jun 2025 | 7.8515 | 9.2185 | 10.7800 | 1.0968 | 6.1680 | | 31 Dec 2025 | 7.7840 | 9.1370 | 10.4730 | 1.1144 | 6.0585 | | 31 Mar 2026 | 7.8390 | 8.9950 | 10.3500 | 1.1343 | 6.0765 | | 30 Sep 2026 | 7.8470 | 8.9070 | 10.4025 | 1.1703 | 6.1455 | The US dollar column should sit between 7.75 and 7.85 on every date after October 1983, the band of the Linked Exchange Rate System. A value outside it means a column is mapped to the wrong currency. ## What people use the history for - **Profits tax:** an average or year-end rate to convert foreign-currency accounts. See [the profits tax guide](https://allratestoday.com/blog/hong-kong-profits-tax-return-exchange-rate-foreign-currency/). - **Salaries tax:** the rate on the day a bonus or share award was received. See [the salaries tax guide](https://allratestoday.com/blog/hong-kong-salaries-tax-foreign-income-exchange-rate/). - **Closing:** period-end revaluation under HKAS 21. See [the closing rates page](https://allratestoday.com/blog/exchange-rate-31-december-2025-hong-kong-hkas-21-closing-rates/). - **Audit:** recomputing a sample of converted transactions against an official table. ## FAQ ### How far back does HKMA exchange rate history go? The HKMA daily series starts on 2 January 1981. It covers 17 currencies against the Hong Kong dollar. ### How often does the HKMA publish exchange rates? The figures are daily but are released monthly with the Monthly Statistical Bulletin, mainly on the 3rd and 6th business days of each month. ### Where can I get a Hong Kong exchange rate for today? The Hong Kong Association of Banks sets an official daily table at the opening of business. It is available through the AllRatesToday API alongside the HKMA series. ### Can I download HKMA exchange rates as CSV or Excel? Yes. The assembled series is one CSV per year from 1981 to 2026, and the API returns any table as CSV, XML or Excel. ## Official tables and live rates on one key Mid-market rates every 60 seconds and the official tables of [123 central banks and 6 tax authorities](https://allratestoday.com/central-bank-rates-api/institutions/), as JSON, CSV, XML or Excel. Paid plans from €4.99 a month. [See plans](https://allratestoday.com/pricing/) ## Related Articles - [Exchange rate API for Hong Kong: HKAB, HKMA, bank boards and live HKD](https://allratestoday.com/exchange-rate-api-hong-kong/) - [HKAB exchange rates today: the official daily table](https://allratestoday.com/central-bank-rates-api/hkab/) - [HKMA exchange rates: the table and endpoints](https://allratestoday.com/central-bank-rates-api/hkma/) - [Salaries tax: converting foreign income to Hong Kong dollars](https://allratestoday.com/blog/hong-kong-salaries-tax-foreign-income-exchange-rate/) - [Profits tax return: exchange rate for foreign-currency accounts](https://allratestoday.com/blog/hong-kong-profits-tax-return-exchange-rate-foreign-currency/) - [Stamp duty on foreign-currency consideration](https://allratestoday.com/blog/hong-kong-stamp-duty-foreign-currency-exchange-rate/) - [Where Hong Kong law names the HKAB rate](https://allratestoday.com/blog/hkab-exchange-rate-hong-kong-law-dutiable-goods-cash-declaration/) - [Closing rates for 31 December 2025 and 31 March 2026](https://allratestoday.com/blog/exchange-rate-31-december-2025-hong-kong-hkas-21-closing-rates/)