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 PDFs (saved from the SBI servers) are available in the pdf_files/ folder. Direct link to each day's PDF is also published along with the data for quick verification.
Note: The SBI explicitly mentions that only the rates published for ₹10-20 lakh transaction range are to be considered as reference rates. The reference rates do NOT change based on your transaction value, which could be ₹100 or ₹1 Cr.
Updatation: The project has been updated to utilize Gemini for image-based SBI ratekeeping , as Anthropic's solution is constrained by daily usage limits, typically restricting the number of prompts or tokens available per day.
- 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.
- Sahil Gupta for the repo.
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