TT selling rate, JPY
Exchange rates. Rupees, daily.
Compare
Data source: Central Bank of Sri Lanka, CBSL exchange rate lookups
Macro Lab · LK.EXT.FX.JPY.SELL.D · CC BY 4.0
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: 16 recorded for this series, listed below.
Show more
Details
- Name in the warehouse
- TT selling 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, 3187 agree.
Source documents
No file is recorded for these values.
Vintages
9 vintages, the latest published 15 Oct 2026.
Related series
- TT selling rate, GBPRs 446.1515 Oct 2026
- TT selling rate, AUDRs 235.7315 Oct 2026
- TT selling rate, EURRs 378.3615 Oct 2026
- TT selling rate, CADRs 237.3915 Oct 2026
- Republished by:
LK.EXT.FX_DAILY_TT.JPY.SELL.D
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.2; the same figure from the other source reads 1.45. Compared with
LK.EXT.FX_DAILY_TT.JPY.SELL.D.Two agencies: 1.445 and 1.2, difference 0.245.
LK.EXT.FX_DAILY_TT.JPY.SELL.D: IF_Buying_Selling file vs the Data Library
LK.EXT.FX_DAILY_TT.JPY.SELL.D: value 1.4453 vs Data Library 1.2000. 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.51; the same figure from the other source reads 1.71. Compared with
LK.EXT.FX_DAILY_TT.JPY.SELL.D.Two agencies: 1.713 and 1.51, difference 0.203.
LK.EXT.FX_DAILY_TT.JPY.SELL.D: IF_Buying_Selling file vs the Data Library
LK.EXT.FX_DAILY_TT.JPY.SELL.D: value 1.7127 vs Data Library 1.5100. USD/BUY 180.08 here vs ~167.0 the day before and after). A single bad row in the source file.
- Disagrees with itself7 May 2010
Checked against another source.
Successor diff: 1.26 and 1.25, 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 itself11 May 2010
Checked against another source.
Successor diff: 1.25 and 1.24, 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 itself19 Jul 2010
Checked against another source.
Successor diff: 1.29 and 1.32, 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 itself16 Nov 2010
Checked against another source.
Successor diff: 1.36 and 1.37, 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 itself25 Mar 2011
Checked against another source.
Successor diff: 2,785.91 and 1.39, difference 2,784.52.
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 Nov 2011
Checked against another source.
Successor diff: 1.51 and 1.5, 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 itself23 Dec 2013
Checked against another source.
Successor diff: 1.28 and 1.27, 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 itself10 Jan 2014
Checked against another source.
Successor diff: 1.27 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 itself16 Dec 2015
Checked against another source.
Successor diff: 1.2 and 1.21, 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.3 and 1.31, 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.
- For information25 May 2007
Checked against another source.
Placeholder zero: 0.
LK.EXT.FX.JPY.SELL.D: 0 in a series that cannot be 0 (exchange rate), dropped
- For information18 Jun 2007
Checked against another source.
Placeholder zero: 0.
LK.EXT.FX.JPY.SELL.D: 0 in a series that cannot be 0 (exchange rate), dropped
- For information5 Dec 2007
Checked against another source.
Placeholder zero: 0.
LK.EXT.FX.JPY.SELL.D: 0 in a series that cannot be 0 (exchange rate), dropped
- For information29 Aug 2006
The source table has an error, corrected when it was read.
Source error: 0.09.
LK.EXT.FX.JPY.SELL.D: 0.09 dropped (0.89 the day before and the day after)