Sign in

TT buying rate, SGD

Exchange rates. Rupees, daily.

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

Macro Lab · LK.EXT.FX.SGD.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 1 Jan 2007 – 15 Oct 2026
  • Last checked 15 Oct 2026

Checks: 30 recorded for this series, listed below.

Show more

Details

Name in the warehouse
TT buying rate, SGD
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 3196 days both have, 3175 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 97.15; the same figure from the other source reads 105.1. Compared with LK.EXT.FX_DAILY_TT.SGD.BUY.D.

    Two agencies: 105.11 and 97.15, difference 7.96.

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

    LK.EXT.FX_DAILY_TT.SGD.BUY.D: value 105.1100 vs Data Library 97.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 121.5; the same figure from the other source reads 129.5. Compared with LK.EXT.FX_DAILY_TT.SGD.BUY.D.

    Two agencies: 129.539 and 121.47, difference 8.069.

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

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

  • Error in the source3 Dec 2018

    This series reads 128.6; the same figure from the other source reads 125.6. Compared with LK.EXT.FX_DAILY_TT.SGD.BUY.D.

    Two agencies: 125.615 and 128.62, difference −3.005.

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

    LK.EXT.FX_DAILY_TT.SGD.BUY.D: value 125.6152 vs Data Library 128.6200. File reads 125.6152 where both its own neighbouring days (128.66-128.88) and the Library's value for the SAME date (128.62) sit at ~128.7 - the file's single-day figure is the outlier. Source data-entry error.

  • Error in the source6 Sep 2023

    This series reads 563.8; the same figure from the other source reads 230.4. Compared with LK.EXT.FX_DAILY_TT.SGD.BUY.D.

    Two agencies: 230.448 and 563.78, difference −333.332.

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

    LK.EXT.FX_DAILY_TT.SGD.BUY.D: value 230.4485 vs Data Library 563.7800. Here the FILE is right and the Library is wrong: the file reads 230.4485, matching its own neighbouring days (230.7-231.4) and the Library's own neighbouring days (230.5-230.8) almost exactly, while the Library's value for this one date is 563.78 - implausible for SGD/LKR at this time and inconsistent with the Library's own days either side. A Data Library data-quality issue on this date, not a fault in this loader's reading of the file.

  • Rounding19 Sep 2017

    This series reads 111.7; the same figure from the other source reads 111.7. Compared with LK.EXT.FX_DAILY_TT.SGD.BUY.D.

    Two agencies: 111.67 and 111.68, difference −0.01.

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

    LK.EXT.FX_DAILY_TT.SGD.BUY.D: value 111.6700 vs Data Library 111.6800. File 111.67 vs Library 111.68 - a one-cent rounding-level difference, not an error.

  • Rounding26 Apr 2018

    This series reads 116.5; the same figure from the other source reads 116.6. Compared with LK.EXT.FX_DAILY_TT.SGD.BUY.D.

    Two agencies: 116.59 and 116.49, difference 0.1.

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

    LK.EXT.FX_DAILY_TT.SGD.BUY.D: value 116.5895 vs Data Library 116.4900. Every currency differs from the Data Library by under 0.2 LKR on this date - the file records 4 decimal places (e.g. USD/BUY 155.5247) where the Library's copy has 2 (155.43); a precision/rounding difference between two CBSL publications of the same TT rate, not an error.

  • Disagrees with itself7 May 2010

    Checked against another source.

    Successor diff: 80.31 and 80.2, difference 0.11.

    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 itself15 Jun 2010

    Checked against another source.

    Successor diff: 80.35 and 80.38, 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 itself19 Jul 2010

    Checked against another source.

    Successor diff: 82.61 and 80.85, difference 1.76.

    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: 84.8 and 84.73, difference 0.07.

    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 itself22 Nov 2010

    Checked against another source.

    Successor diff: 85.4 and 85.22, difference 0.18.

    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 itself20 Jan 2011

    Checked against another source.

    Successor diff: 84.95 and 84.94, 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 Nov 2011

    Checked against another source.

    Successor diff: 86.02 and 86.06, difference −0.04.

    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 Jan 2012

    Checked against another source.

    Successor diff: 88.65 and 89.17, difference −0.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 itself9 Feb 2012

    Checked against another source.

    Successor diff: 90.22 and 90.46, difference −0.24.

    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: 101.47 and 101.29, difference 0.18.

    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 itself6 Feb 2014

    Checked against another source.

    Successor diff: 101.41 and 101.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.

  • Disagrees with itself7 Apr 2014

    Checked against another source.

    Successor diff: 102.07 and 102.06, 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 Jun 2014

    Checked against another source.

    Successor diff: 102.53 and 102.52, 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 Apr 2015

    Checked against another source.

    Successor diff: 99.91 and 99.9, 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 itself21 Jul 2015

    Checked against another source.

    Successor diff: 95.93 and 96.02, difference −0.09.

    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: 100.12 and 99.97, difference 0.15.

    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: 100.64 and 101.35, difference −0.71.

    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 itself8 Jun 2016

    Checked against another source.

    Successor diff: 105.73 and 105.72, 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 itself4 Jan 2017

    Checked against another source.

    Successor diff: 101.66 and 101.65, 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 itself8 Feb 2018

    Checked against another source.

    Successor diff: 114.86 and 114.67, difference 0.19.

    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 itself26 Apr 2018

    Checked against another source.

    Successor diff: 116.59 and 116.49, difference 0.1.

    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 information

    This series and the same figure from another source differ over the period they share. Compared with LK.EXT.FX_MONTHLY.SGD.EOM.M.

    Two agencies: , difference −0.579.

    SGD: IF_End_of_the_Month file vs the Data Library's daily TT mid on the last business day on record each month. 43 of 237 months differ by more than 0.5 LKR, mean diff -0.579, worst -10.316 in 2022-04.

    SGD: IF_End_of_the_Month_Exchange_Rates.xlsx (CBSL's IMF/IFS reporting rate) vs the Data Library's daily commercial-bank TT mid on the last business day on record each month.

  • For information

    This series and the same figure from another source differ over the period they share. Compared with LK.EXT.FX_MONTHLY.SGD.AVG.M.

    Two agencies: , difference −1.424.

    SGD: IF_Monthly_Average file vs mean of the Data Library's daily TT mid, by calendar month. 27 of 237 months differ by more than 0.5 LKR, mean diff -1.424, worst -5.771 in 2022-04.

    SGD: IF_Monthly_Average_Exchange_Rates.xlsx (CBSL's IMF/IFS reporting rate) vs the mean of the Data Library's daily commercial-bank TT mid over the same calendar month. Reported, not merged.

  • For information6 Sep 2023

    The source table has an error, corrected when it was read.

    Source error: 563.78.

    LK.EXT.FX.SGD.BUY.D: 563.78 dropped (230.73 the day before, 230.55 the day after)

Errors and rounding first. 24 more checks.