- In short
- Writes the official daily rates published by the Central Bank of the Republic of Türkiye into your worksheet as a table, for the currencies and date range you choose. Forex buying, forex selling, banknote buying and banknote selling sit in the same table, as do direct, inverse and cross rates. The output carries the rate date, the source and when it was last published.
What it is for
Exchange Rates brings the official daily rates published by the Central Bank of the Republic of Türkiye into Excel. You pick source currencies on one side and target currencies on the other, and every combination you choose lands in a single table.
The Excel problem it solves
Rate data usually reaches Excel by hand or by copying values one at a time from a website. With a few currencies and a few months of history, that becomes slow work and an easy place to make a typing mistake.
When to use it
For finance teams closing a month with one agreed set of rates, accountants converting export and import invoices at the rate of the day, and analysts working with a historical rate series.
Example scenarios
- Pulling USD/TRY, EUR/TRY and GBP/TRY over the same date range into one table for the month-end report.
- Converting export invoices to Turkish lira at the TCMB forex selling rate of the invoice date.
- Working out a cross rate that does not involve the lira, such as EUR/USD, from the published TRY rates.
Modes
- Latest published rate
- Historical rates over a date range
- Multiple currencies on both sides
- Direct, inverse and cross rates
- Forex buying / forex selling
- Banknote buying / banknote selling
What it needs
This tool does not need any data selected first. You choose the source and target currencies, the rate types you want and the date range, then point at the cell where the table should start.
How to use it
- Open Exchange Rates from the Finance group on the XLMind ribbon.
- Pick source currencies on one side and target currencies on the other; both sides accept more than one.
- Tick the rate types you want: forex buying, forex selling, banknote buying, banknote selling.
- Choose between the latest published rate and a date range.
- Point at the cell where the table should start and create it.
What it produces
A table is written from the cell you pick: each row carries the rate date, the currency pair and the value of every rate type you asked for. The output also states the source of the data and when it was last updated.
Effect on your data and undo
The table is written only to the area you point at, and the rest of your workbook stays as it is. Only the published rate data is downloaded; the contents of your workbook are never sent anywhere.
How it differs from similar tools
Instead of looking rates up and copying them one by one, it turns every currency combination you picked and the whole date range into a single table, with the rate types side by side in the same rows.
Good to know
The data is the official rate published daily by TCMB, not an intraday market price. No row is produced for weekends and public holidays, when no rate is published. Some currencies are published per 100 units in the bulletin; XLMind reads that unit and converts the value to a single unit.
Limitations
The scope is the currencies carried by the TCMB bulletin and the dates it was published on. An internet connection is needed to download the data.
Also
Pairs that do not involve the lira are worked out as cross rates from the published TRY rates, and inverse pairs are written into the table the same way.
Frequently asked questions
- Are the rates updated in real time?
- No. The source is the official daily rate bulletin published by TCMB. The table shows the date each rate belongs to and when it was last updated.
- Which rate types can I get?
- Forex buying, forex selling, banknote buying and banknote selling. You can ask for more than one in the same table.
- Can it work out rates that do not involve the lira, such as EUR/USD?
- Yes. Cross rates are calculated from the published TRY rates, and inverse rates are produced the same way.
- Can I get rates for past dates?
- Yes. When you choose a date range, one row is written for every publication day in that range.
- Is my workbook sent anywhere?
- No. Only the published rate data is downloaded; the contents of your workbook are never sent anywhere.
Works well with
- As a complement, use Stock Market
- As a complement, use Commodities
- To build the date range first, use Create Date Range
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.