HKMA Exchange Rate History: Download Hong Kong Dollar Rates 1981 to 2026 as CSV, Excel or API

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, set at the opening of business.

The assembled series: one CSV per year

The central-bank-exchange-rates 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

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.
• Salaries tax: the rate on the day a bonus or share award was received. See the salaries tax guide.
• Closing: period-end revaluation under HKAS 21. See the closing rates page.
• 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.