sgb-advisor

A tool to analyse Sovereign Gold Bonds and compare their yields.

Sovereign Gold Bond is a security issued by the RBI on behalf of the Government of India. It is linked to the price of gold.

This tool tries to use publically available data and ✨maths✨ to advise you on which SGB among all of them is trading at it's lowest "fair value".

This does not recommend anything. Calculations, data or something else can be wrong. Do your own research before investing your money anywhere.

Demo: Output will being sent in this public Telegram channel at 11:00 AM IST every weekday!

Tools used:

1. Playwright for getting SGB prices from NSE and the price of gold from IBJA.

2. pyxirr to calculate XIRR

Running the app

You can use any of the 3 methods given below

1. You can use plain pip or something like uv to build and run the project.

   # Highly recommend creating a venv using `python -m venv .venv` and then activating it (https://docs.python.org/3/library/venv.html#how-venvs-work) first.
   pip install -r requirements.txt
   # Setup env before this
   python app.py

   (or)

   pip install uv
   # Creates venv automatically
   uv sync
   # Setup env before this
   python app.py

2. Docker

   sudo docker buildx build -t vishalnandagopal/sgb-advisor:latest -f Dockerfile .
   # Setup env before this
   sudo docker run --env-file .env vishalnandagopal/sgb-advisor:latest

3. Github actions

   • An action is already setup here.
   • Clone the repo, enable the action (if disabled), setup the required secrets and envs.
   • Change the timings of the cron job in the same file as per your requirements.

Environment variables

Place the required env variables in a .env file.

# How to notify the user. Accepted values are "telegram", "email" or "both"
SGB_MODE=telegram

# Get token from BotFather on Telegram
SGB_TELEGRAM_BOT_TOKEN=xxxxxxxxxx:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
# Can be one or many users/channels
SGB_TELEGRAM_CHAT_IDS=xxxxxxxxx,xxxxxxx,@sgb_advisor

# No one need to set any of these if you only want to send a message through telegram
SGB_AWS_ACCESS_KEY=xxx
SGB_AWS_SECRET_ACCESS_KEY=xxx
SGB_AWS_SES_SENDER_EMAIL=SGB Advisor <[email protected]>
SGB_AWS_SES_RECIPIENT=[email protected]
SGB_AWS_REGION=us-east-1

Sending results to someone

1. Telegram (recommended)

   If you have a telegram account, you can create a bot in a few seconds, making it very easy to notify you of the results of every run.

   The bot can send results to multiple telegram accounts (both users and channels) at once.

   1. Get an API key from BotFather on Telegram ("bot token").

   2. Get the chat ID of the user(s) you want to send the output to. It is the unique identifier for the target chat (integer in this case) or username of the target channel (@channelusername in this case). Output can be sent to multiple users (place comma-separated chat IDs). Errors are only sent to the first chat-id.

   If you don't know your chat ID, get it by sending a message to @JsonDumpBot. The ["chat"]["id"] in response is your chat ID.

2. Email (AWS SES only)

   Sending results to an email address using Amazon SES is supported.

   1. Get API keys from AWS console and place it in an .env file as per the above format.

   The email address you want to send from be verified in AWS console. Even the recipient of the email must be verified if you are a new user and in AWS SES Sandbox.

License

GNU GPLv3

TODO

• Similar tool for finding arbritages in ETFs tracking the same index.

Disclaimers

This tries to use publically available data and maths to advise you on which SGB among all of them is trading at it's lowest "fair value".

This is just a tool to maximize XIRR on interest payments, and to find possible arbritages between gold price IRL and the prices SGBs are trading at.

This does not recommend anything. Calculations, data or something else can be wrong. Do your own research

Assumptions Made

• The price of Gold when the SGB matures will be the same as it is today. While this may sound dumb, any increase in the price of gold should lead to a somewhat similar increase in redemption prices of all SGBs. You way think that gold can fall or increase in between, but that will affect all gold investments, not just SGB

• You are interested in gold and have finalized on SGB as a product, and are just confused among different SGBs.

Copyright (C) 2025 Vishal N ([email protected])