Skip to main content

Local Bullion Prices

backend/mcxeod/bullion.py logs the local (Salem) bullion rates published by Vijay Bullion into {MCXSP_DATA_PATH}/_catalog/bullion.db. Raw feed text is archived under {MCXSP_DATA_PATH}/_raw_bullion/<yyyy>/.

Source​

The site's own plain-HTTP feed http://www.vijaybullion.com/index.php/C_rates/rate_data (tab separated, no login; the site has no robots.txt). Row types: 3 local bullion (stored), 2 MCX rates (ignored), 1 international spot USD/INR (stored, kind='spot'), 4 source timestamp. Local rates are stored exactly as published (the gold bar is shown per gram on the page); nothing is unit-converted. A local SILVER row is stored only when the site lists one - on 2026-10-20 it listed a local GOLD bar only.

Schedule​

BULLION_TIMES (default 09:00,14:00,19:00,23:30 IST) on MCX trading days (MCXWorkingDays, Mon-Fri fallback), one pull (the first time) on non-trading days. Four requests a day. On by default only when APP_ENV=VPS (BULLION_AUTO_SYNC). Failures log, mark logs/margin_status.json red (job bullion) and email if ALERT_EMAIL_TO is set.

Tables​

bullion_rate (PK trade_date, slot, kind, item; bid, ask, high, low, ltp, delivery_date, source_ts, captured_at, raw_ref) and bullion_raw (path, sha256). Re-running a slot replaces its rows.

python -m mcxeod.bullion fetch # one pull now (slot 'manual')
python -m mcxeod.bullion show --days 5
python -m mcxeod.bullion status

Fallback sources and GST (added 2026-10-20)​

Vijay sometimes has no local silver (or gold) row. Every pull therefore also records bullion_quote rows normalised to gold INR/gram, silver INR/kg, each with a GST basis, and logs every attempt in bullion_source_log.

SourceHowGST of the published number
vijayits feed (primary)included (its gold bar is within 0.1% of IBJA x1.03)
ibjaibjarates.com table, always pulled (daily benchmark, latest PM row)excluded ("without 3% GST") -> x1.03 computed
slnbullionunsupported: rates come from a login-configured vendor stream, local rows are blank publicly-
bullionsbullions.co.in Chennai page (robots Crawl-delay 10 s is honoured)not stated -> no GST-inclusive figure
bullionindiaJSON used by its home page (buy rate)not stated
allindiabullionallindiabullion.com Chennai city row ("GST extra")excluded -> x1.03 computed

The fallbacks run in the order above, only while GOLD or SILVER still lacks a GST-inclusive local price after Vijay; a source whose GST basis is unknown is stored but does not end the search. GST-inclusive figures marked "computed" are the published ex-GST rate x1.03, never a number the site printed. One source failing never stops the others.

Reports > Bullion pulls (DEVELOPER and above; app/api/bullion.py, pages/BullionPulls.jsx) shows the latest local price incl. GST, each source's last status, every pull with its source log, and every quote with its deviation from the IBJA benchmark (outliers such as bullionindia's silver, +16% on 2026-10-20, are highlighted). CSV export included.