SANJAYA
Preparing the page.
Loading the latest available data and source context.
SANJAYA
Loading the latest available data and source context.
What Sanjaya does, where every number comes from, and what the current approximations are. This page is meant to be readable by journalists, researchers, and policy analysts who need to understand the limits before citing anything here.
Sanjaya aggregates public Indian petroleum pricing data into a single daily view. It shows, at each of the four metros, what every rupee of the pump price pays for: refinery transfer price, dealer commission, central excise, and state VAT. It then overlays those components on nine years of history alongside Brent crude so that policy shocks and price stickiness become visible.
Sanjaya is independent. It is not commissioned by, endorsed by, or funded by any oil marketing company, ministry, or government body.
PPAC DailyPriceMSHSD_Metro PDF. Four metros, petrol + diesel, full daily history from 16 June 2017.
PPAC table — Basic Excise Duty, Special Additional Excise Duty, Road and Infrastructure Cess, Agriculture Infrastructure and Development Cess. Historical rates require the PPAC XLS archive (pending backfill).
PPAC table of per-state formulas. 37 states/UTs × petrol + diesel = 74 rows. Raw formula preserved verbatim alongside structured percent + floor + cess components.
Effective-dated history from 1 April 2004. Pre-2013 rates are flat Rs/KL; post-2013 are hybrid formulas of the form 'Rs X/KL + Y% of Product Billable Price'. Both forms are parsed structurally.
ECB euro foreign-exchange reference rates XML; USD/INR derived from the EUR cross-rates. RBI/FBIL is the authoritative Indian source but is JS-rendered and login-gated for historical; the ECB cross-rate tracks FBIL within one basis point on any given day.
Official EIA spot prices: the Daily Prices page for the freshest close plus the EIA dnav history pages for recent backfill, with FRED DCOILBRENTEU filling the long history. Used as a directional proxy for the Indian Basket crude because PPAC gates its historical Indian Basket download behind a login.
Hand-curated list of nine events: daily-pricing start, two COVID excise hikes, 2021 Diwali cut, Russia/Ukraine invasion, 2022 excise cuts, 2022 windfall tax, 2024 pre-election cut, 2026 Hormuz tensions.
For each (city, product) on the latest available date, Sanjaya computes the five-component breakdown as follows.
The Brent intelligence page is designed as a 24-hour reading tool, not a black-box trading model. A nontechnical visitor should read it as: what is the next trading-session Brent range, which external forces are driving that range, and what those forces mean for India's import exposure.
Sanjaya does not forecast pump-price action or OMC margin pass-through. Those are policy-gated decisions in India, not clean market-clearing model outputs. Retail prices, taxes, and margins remain useful historical facts elsewhere on the site, but they are not treated as Brent-read targets.
The current model is benchmark-calibrated, not black-box. It first runs simple price models and an adaptive error-weighted ensemble across recent rolling one-session history, selects by a skill score that combines MAE, RMSE, interval calibration, and direction hit rate, and calibrates the displayed dollar band from the selected model's actual residuals. It then scores Brent momentum, WTI confirmation, EIA weekly crude stocks, and quantified real-world news as a capped live overlay. FX is displayed beside the call because USD/INR changes India's landed-cost interpretation, but FX does not set the Brent direction score.
This is not the best mathematical model possible. It is the strongest honest public version currently supported by Sanjaya's public data: small enough to audit, empirically benchmarked, and useful before a fully calibrated feature model exists. A more advanced model should beat this baseline on out-of-sample error, directional accuracy, and interval calibration before replacing it.
The useful citation is therefore the model state and the evidence rows together: range, score, source health, top drivers, and the stated caveat. Do not cite the exact dollar endpoints as a guaranteed 24-hour forecast.
The current build uses the following simplifications. These will be tightened in future releases and are flagged in the data files via the raw_formula field.
A GitHub Actions workflow runs daily at 02:30 UTC (08:00 IST) and scrapes the PPAC daily PDF, ECB FX feed, official EIA Daily Prices spot close, and the FRED Brent history series. A second workflow runs every Sunday at 03:00 UTC and refreshes the weekly tables: state VAT, central excise, dealer commission. Any new data lands in the repository as a commit, which triggers a Vercel rebuild; the static pages you are viewing are typically updated within 10 minutes of PPAC publication.
The complete dataset is in the GitHub repository under /data. Every file is plain JSON or JSONL, typed in TypeScript, and kept small enough for direct clone. Git history is the audit trail: every scrape is a commit, every row has a scrape timestamp.
If you are a journalist, researcher, or policy analyst: fork the repo, cite Sanjaya as the intermediary, and cite PPAC as the primary source. If you find an error, raise a GitHub issue with the specific row and the expected value.
For specific topical reads that build on this methodology: