Sign in

TT buying rate, JPY

Exchange rates. Rupees, daily.

Data source: Central Bank of Sri Lanka, CBSL exchange rate lookups

Macro Lab · LK.EXT.FX.JPY.BUY.D · CC BY 4.0

Download
CSVPeriod, value and the source's status flag JSONThe values with the metadata and source

About this series

  • Source Central Bank of Sri Lanka, compiled by Macro Lab
  • Unit Rupees
  • Date range 3 Jan 2005 – 15 Oct 2026
  • Last checked 15 Oct 2026

Checks: 6 recorded for this series, listed below.

Show more

Details

Name in the warehouse
TT buying rate, JPY
Read from
CBSL exchange rate lookups (Central Bank of Sri Lanka)
Source page
https://www.cbsl.gov.lk/en/rates-and-indicators/exchange-rates/daily-buy-and-sell-exchange-rates
Notes
CBSL Data Library (wizard export) From 2016-10-06, days the Data Library does not have are taken from CBSL's exchange rate lookup pages (159 so far). On the 3197 days both have, 3193 agree.

Source documents

No file is recorded for these values.

Vintages

9 vintages, the latest published 15 Oct 2026.

Related series

Source discrepancies

What the warehouse found when it checked this series: the same figure from two agencies, splice overlaps, published rates against ones recalculated from the index, and outliers.

  • Error in the source6 Oct 2015

    This series reads 1.15; the same figure from the other source reads 1.39. Compared with LK.EXT.FX_DAILY_TT.JPY.BUY.D.

    Two agencies: 1.391 and 1.15, difference 0.241.

    LK.EXT.FX_DAILY_TT.JPY.BUY.D: IF_Buying_Selling file vs the Data Library

    LK.EXT.FX_DAILY_TT.JPY.BUY.D: value 1.3905 vs Data Library 1.1500. Whole-day anomaly in the source file: every daily-TT currency (buy and sell) jumps on this one day while every neighbouring day matches the Data Library exactly (e.g. USD/BUY 144.53 here vs 138.9x the day before and after, in both the file and the Library) - re-verified series by series. A single bad row in IF_Buying_Selling_Exchange_Rates...xlsx, not a parsing issue.

  • Error in the source1 Oct 2018

    This series reads 1.46; the same figure from the other source reads 1.65. Compared with LK.EXT.FX_DAILY_TT.JPY.BUY.D.

    Two agencies: 1.654 and 1.46, difference 0.194.

    LK.EXT.FX_DAILY_TT.JPY.BUY.D: IF_Buying_Selling file vs the Data Library

    LK.EXT.FX_DAILY_TT.JPY.BUY.D: value 1.6536 vs Data Library 1.4600. USD/BUY 180.08 here vs ~167.0 the day before and after). A single bad row in the source file.

  • Disagrees with itself19 Jul 2010

    Checked against another source.

    Successor diff: 1.32 and 1.29, difference 0.03.

    CBSL's exchange rate lookup pages against the Data Library

    CBSL's exchange rate lookup and the Data Library disagree on 13-18 days per currency between 2010 and April 2018, by a few cents to a few rupees (USD sell 2011-02-28: 91.67 in the lookup, 111.67 in the library). Most look like slips on one side or the other; which side is right is not established for each day.

  • Disagrees with itself23 Dec 2013

    Checked against another source.

    Successor diff: 1.24 and 1.23, difference 0.01.

    CBSL's exchange rate lookup pages against the Data Library

    CBSL's exchange rate lookup and the Data Library disagree on 13-18 days per currency between 2010 and April 2018, by a few cents to a few rupees (USD sell 2011-02-28: 91.67 in the lookup, 111.67 in the library). Most look like slips on one side or the other; which side is right is not established for each day.

  • Disagrees with itself29 Feb 2016

    Checked against another source.

    Successor diff: 1.25 and 1.26, difference −0.01.

    CBSL's exchange rate lookup pages against the Data Library

    CBSL's exchange rate lookup and the Data Library disagree on 13-18 days per currency between 2010 and April 2018, by a few cents to a few rupees (USD sell 2011-02-28: 91.67 in the lookup, 111.67 in the library). Most look like slips on one side or the other; which side is right is not established for each day.

  • Disagrees with itself7 Oct 2016

    Checked against another source.

    Successor diff: 1.39 and 1.4, difference −0.01.

    CBSL's exchange rate lookup pages against the Data Library

    CBSL's exchange rate lookup and the Data Library disagree on 13-18 days per currency between 2010 and April 2018, by a few cents to a few rupees (USD sell 2011-02-28: 91.67 in the lookup, 111.67 in the library). Most look like slips on one side or the other; which side is right is not established for each day.

Errors first. 3 more checks where the source disagrees with itself.