- Home
- Widgets
Free live rate widgets
Build your widget
Preview
Copy the code
Accept the terms of use first to copy the code.
The widget opens at a fixed height, so your page does not shift. A width of at least 300 pixels is recommended; the rate strip spans the full width of the page. The link under the code credits the source; please keep it.
How to add the widget to your site
- Above, pick the widget type, currency, language and colour theme; the preview changes at once.
- Accept the terms of use and copy the code with «Copy». The script code is recommended; if your site does not allow scripts, use the «iframe only» code.
- Paste the code where the widget should appear on your page and publish the page.
Where to paste it, by platform
- WordPress: in a post or page, add a «Custom HTML» block with «+» and paste the code. Some WordPress.com plans do not accept script or iframe code; check that your plan allows custom code.
- Blogger: for the sidebar, Layout, «Add a Gadget», «HTML/JavaScript»; inside a post, the editor's HTML view.
- Wix: in the «Add» menu choose «Embed Code» and «Embed HTML», then paste the code. Wix wraps code in its own frame, so the «iframe only» code works more smoothly.
- Tilda: add the HTML code block (T123) and paste the code into it.
- Your own HTML page: put the code where the widget should sit. With several widgets on one page, the script line is needed once.
Good to know
- Freshness: the widget takes the rates from our server each time it opens; rates refresh every few minutes in business hours. The archive widget shows yearly averages and updates daily.
- Speed: the widget opens in its own frame and loads lazily; it does not slow your page and sets no cookies.
- Size and colour: the width follows its box, at least 300 pixels recommended; the height is fixed. Pick one of four colour themes.
- Link: the TurkishLiraRates link under the code credits the widget's source and must stay visible as a condition of free use. The other terms are in the «Terms of use» section of this page.
Archive data for Google Sheets and Excel
Pull the dollar, euro, pound, gram of gold and gram of silver archives into your own spreadsheet. Paste the formula into a cell and the sheet fetches the current data each time it opens. For Excel or your own code, use the CSV link.
Step by step in Google Sheets
- Open a new sheet (sheets.new) or an empty tab in your own spreadsheet.
- Take one of the formulas below with «Copy», paste it into an empty cell and press Enter.
- The first time, Google asks you to «Allow access»; click it. The data fills the cells down and to the right.
- If your spreadsheet uses a Turkish or Russian locale, replace the commas between the arguments with semicolons (;).
Excel: on the «Data» tab choose «From Web», paste the CSV link and press «Load»; «Refresh All» updates it. Numbers use a dot as the decimal separator.
| Archive | Google Sheets formula | CSV |
|---|---|---|
| Dollar · yearly | =IMPORTDATA("https://turkishlirarates.com/data/v1/archive/usd/yearly.csv", ",", "en_US") | usd-yearly.csv |
| Dollar · monthly | =IMPORTDATA("https://turkishlirarates.com/data/v1/archive/usd/monthly.csv", ",", "en_US") | usd-monthly.csv |
| Euro · yearly | =IMPORTDATA("https://turkishlirarates.com/data/v1/archive/eur/yearly.csv", ",", "en_US") | eur-yearly.csv |
| Euro · monthly | =IMPORTDATA("https://turkishlirarates.com/data/v1/archive/eur/monthly.csv", ",", "en_US") | eur-monthly.csv |
| Pound · yearly | =IMPORTDATA("https://turkishlirarates.com/data/v1/archive/gbp/yearly.csv", ",", "en_US") | gbp-yearly.csv |
| Pound · monthly | =IMPORTDATA("https://turkishlirarates.com/data/v1/archive/gbp/monthly.csv", ",", "en_US") | gbp-monthly.csv |
| Gram of gold · yearly | =IMPORTDATA("https://turkishlirarates.com/data/v1/archive/gold/yearly.csv", ",", "en_US") | gold-yearly.csv |
| Gram of gold · monthly | =IMPORTDATA("https://turkishlirarates.com/data/v1/archive/gold/monthly.csv", ",", "en_US") | gold-monthly.csv |
| Gram of silver · yearly | =IMPORTDATA("https://turkishlirarates.com/data/v1/archive/silver/yearly.csv", ",", "en_US") | silver-yearly.csv |
| Gram of silver · monthly | =IMPORTDATA("https://turkishlirarates.com/data/v1/archive/silver/monthly.csv", ",", "en_US") | silver-monthly.csv |
On first use Google Sheets asks you to click «Allow access». Free to use; keep the source lines at the bottom of the data (TurkishLiraRates and the data source). Gold and silver values are computed from the World Bank monthly ounce averages (CC BY licence) and the CBRT dollar rate; currency rates are CBRT indicative buying rates. Bank rates are not shared.
Today's CBRT bulletin (tcmb.csv) and the live free-market prices (rates.json) can be pulled the same way. Addresses and samples of the free exchange rate API →
What the columns mean
- year, month: the year or the month (YYYY-MM).
- first, last with first_date, last_date: the rate and date of the period's first and last CBRT bulletin.
- low, high, average: the period's lowest, highest and average CBRT buying rate.
- change_pct: the change within the period, in percent.
- gram_avg_try, gram_try: the lira value of a gram of gold or silver (pure metal, not a jeweller's price); gram_first_month_try and gram_last_month_try are the year's first and last month.
- ounce_avg_usd, ounce_usd: the ounce price in dollars; usd_try_avg, usd_try: the average CBRT dollar buying rate.
- months, ounce_source, month_running: the months in the year, the source of the ounce data (world_bank or hyperliquid) and whether the month is still running.
As an image: for forums, e-mail and Telegram
Where no code runs (forums, e-mail signatures, Telegram channels, Facebook groups), show the current prices as an image: it refreshes every five minutes and a click leads to our page.

<a href="https://turkishlirarates.com/en/gold/"><img src="https://turkishlirarates.com/i/v1/gold-en-light.png" width="440" height="150" alt="Gram, quarter and full gold coin prices in Turkey: TurkishLiraRates"></a>Price converter for listings
Shows a price on an estate agent's, tour or hotel site in the visitor's money: next to a listing priced in euros, its lira, pound or ruble amount appears. Rates are the free market's mid rate, the CBRT rate for currencies the market does not quote.
Preview
€185,000 ≈ TRY 10,274,808 · £155,107 · RUB 16,933,473
<span data-tlr-price="185000" data-from="EUR" data-to="TRY,GBP,RUB" data-lang="en"></span>
<script async src="https://turkishlirarates.com/w/p1.js"></script>
<!-- Once per page: the source link -->
<a href="https://turkishlirarates.com/">Rates: TurkishLiraRates</a>- Put one span next to each price; the script is needed once per page and fetches the rates once.
- Show the source link once per page; do not add a link next to every price.
- The result is approximate: the mid rate between buying and selling, not a deal rate.
Terms of use
- The widget is free. Its source line and the TurkishLiraRates link must stay visible: do not remove or hide them, and do not present the widget as your own price list.
- The widget shows TCMB reference rates, our free-market average (for each price a trimmed mean of at least 4 independent exchange offices and jewellers, not one business's prices) and a gold and silver archive computed from World Bank data only; bank rates are not included.
- Prices are for information only: they are not a deal price, not any business's binding price list and not financial advice. If you run an exchange office or a jewellery shop and want to show your own prices, write to us.
- We may change the widget's data, contents and look without notice.
- We may switch the widget off on a site that does not follow these terms.
- The widget sets no cookies; we only record which site it runs on (domain name) and how many times it was clicked through to our site.
- For questions or suggestions, write to us through the contact page.