Explanation to Rule 26 of the Income Tax Rules, 1962 advises using telegraphic transfer rates of SBI as reference for calculating foreign income or capital gains. SBI publishes the rates daily on its website, barring Sundays and bank holidays. Unfortunately, there is no official way to access historical data.
Well, worry no more. This project saves the daily SBI forex rates in a CSV file, enabling easy access to historical rates. Rates for each currency are in a separate file; for example, SBI_REFERENCE_RATES_USD.csv has only the USD data.
- The new rates are added daily, automatically
- Fully compatible with Microsoft Excel or Google Sheets
You can easily browse and search the rates on GitHub itself:
OR download the CSV files and use with Excel or Google Sheets
The link to the PDF file (saved from the SBI servers) is also published with each day's data to make it easy to verify. They are also available in the pdf_files/ folder.
Note: The reference rates are on the 2nd page of each PDF.
- Data is only available from Jan 2020 onwards.
- For some reason, SBI doesn't publish the rates file on all working days; no data is available for such days. You can either get the rates from RBI Reference Rate Archive, or from some third-party FX rates vendor such as OANDA.
Typically, the RBI Reference rates have a 20-30 paise difference with the SBI TT Buying rates. This delta is reasonably stable over time. You can find the average difference for a few dates post 2020, take the published RBI rates and adjust them by the standard delta before using.
Credit for data prior to Dec 2022 goes to:
-
Shivam Khandelwal for saving the PDF files of SBI's daily forex rates on GitHub since 2020 at [https://github.com/skbly7/sbi-tt-rates-historical]
-
Forex Rate Card archives of Maneesh K. Singh & Co. 2021 and 2022
-
Internet Archive Wayback Machine