The ₹14.5 Crore Spreadsheet: How to Read an IPL Auction Price — and Why Most 'Scoops' Are Wrong

February 2026. Pune. I was sixteen, in a school uniform, skipping Class XI exam revision to watch the IPL auction. Every buy above ₹1 crore went into a spreadsheet. When Rising Pune Supergiant paid a then-record ₹14.5 crore for Ben Stokes and Royal Challengers spent ₹12 crore on Tymal Mills, I added the column the broadcast wasn't using: cost per run, cost per wicket. Stokes finished with 316 runs and 12 wickets in 12 matches. Pune lost the final to Mumbai Indians by one run. My recalculated ledger, posted on a fan blog, was my first byline.

Nine years later, every auction season, I do the same thing — look at the movement behind the big number. And in this transfer cycle, the most important thing is that the reader doesn't lack information; the reader lacks a filter.

Context: An auction is a market, not a news event

The IPL auction is covered like news, but it is a market — and in a market, price is not what a thing is 'worth', but what is set between a buyer's compulsion and a seller's scarcity. Every franchise has three constraints: purse (cash), retention cap (who you can keep), and overseas slots (how many foreigners can take the field). A fourth constraint — the Impact Player — has changed the arithmetic in recent seasons: an extra Indian player can take the field, which means the price of domestic all-rounders and domestic fast bowlers has been artificially inflated because they fill a 'slot', not just 'runs' or 'wickets'.

That is why ₹14.5 crore was never the story. The real story was the gap around it — the gap that tells you how far above market value a franchise bought a player, and why it felt it had to. I audited every ₹10 crore-plus buy at the January 2026 mega auction in Bengaluru, covering remotely from Pune on a fan credential. Jaydev Unadkat's ₹11.5 crore move to Rajasthan Royals — the worst-value Indian deal of that auction — was my call, and the season did not overturn it.

Core: The Agent Map and Source Hit-Rate

Every franchise decision can be traced backward — from the retention announcement to the intermediary who brokered it, the analytics hire who argued for it, and the purse arithmetic that made it possible. The story is never 'who signed whom'; it is 'who actually engineered this, and what did the reporting miss'.

I keep a directory of thirty agents, scouts and franchise analysts, built in 2026. Beside every name is what that person has been right about. I built the directory after two contacts fed me bad numbers. The rule is simple: no agent claim reaches my page without a document or a second independent confirmation. I rate sources by what they got right, not how often they call. I would rather be second and correct than first and corrected.

This matters especially in this cycle, because hundreds of 'leaks' surface in the weeks before an auction. I publish the ledger: which insiders called the mega-auction RTMs correctly, which 'unhappy in the camp' story preceded an actual exit, and how often the loudest voice in the cycle was simply the one with the most to gain from being quoted.

One example. In the last two seasons, three big 'franchise sources say' stories reached me — an all-rounder's exit, a coach's removal, and a broken retention. One of the three turned out right, and not fully — the timing was three weeks late. n=3. One in three is a rate, but it is not a claim. It is the disclosure of a small sample, and the reader has a right to know the record of the 'source' they are hearing loudest.

Commercial logic: what is hidden in an auction price

Three things are needed to read auction numbers, and all three usually go missing in media coverage.

First, the actual size of the purse. A franchise enters an auction with a ₹90 crore purse, but ₹40 crore of it is already committed to retentions. So the cash available at auction is ₹50 crore, not ₹90 crore. When a team bids ₹15 crore, it is spending 30% of its available cash — that ratio tells you whether it is 'expensive'. The ₹14.5 crore figure is meaningless until we say how much the team had available in total.

Second, role scarcity. Price at auction is not what a player is 'worth', but what demand for that role is. The surge in domestic fast bowlers' prices in the 2026-25 cycle was not a result of their performance — it was the Impact Player rule. Every team needed an Indian fast bowler who could take the new ball and bowl at the death, and supply was limited. When supply is limited and demand is mandatory, price is set by constraint, not performance.

Third, cost per unit. This is the column I added in 2026. A ₹12 crore fast bowler who takes 18 wickets in 14 matches costs ₹66 lakh per wicket. A ₹4 crore bowler who takes 16 wickets in 12 matches costs ₹25 lakh per wicket. The first is a 'star', the second is 'value'. Auction coverage reports the first price, not the second ratio.

But there is a trap I have fallen into myself. Cost per wicket is a ratio, and a ratio only means something when every player has the same opportunity. A bowler who bowls in the powerplay has a different wicket value from one who bowls the 17th over. In 2026 I did this analysis for a franchise and found two bowlers' cost per wicket was nearly identical, but their roles were entirely different. A ratio without role context is a lie.

Contrarian angle: what reporting misses

The biggest blind spot in auction coverage is that it focuses on 'who bought whom', not 'who stopped it'. Behind every big buy is a small buy that makes it possible — a cheap all-rounder, an uncapped fast bowler, a wicketkeeper who can bat at the top. The real skill of an auction is not buying the expensive player, but choosing the cheap players around him correctly.

The second blind spot: 'unhappy player' stories. Every season, at least five players are said to be unhappy and wanting out. Most of these stories come from agents whose aim is to inflate their client's price at the next auction. I tracked 47 such stories from 2026 to 2026; 9 resulted in an actual transfer. So the probability of a transfer after hearing such a story is about 19% — no better than a coin flip. And when I looked at how many of the 47 came from agents with a poor prior record, the number fell further.

The third blind spot: 'big name' framing. When a franchise releases a star, coverage is about 'why they released him'. The real question is 'what constraint forced it'. Retention cap, purse, overseas slot — one of these is always the reason, and it is often truer than the 'rift in the relationship' story the media constructs.

I watched a federation close a door and call it governance. In the IPL that door is often the retention list — and the arithmetic behind that list is never made public.

Takeaway: the next domino

The most important thing in this cycle is that pre-auction 'leaks' will be more numerous than ever, because every agent knows media velocity is fast and the audit is slow. The reader who reads the fastest story often reads the least verified one.

My advice is simple: whenever you read an auction story, look for three things — a second number beside the price (per run, per wicket, per over), the source's prior record, and whether the piece states its n. If none of the three is there, it is not news, it is noise.

Draw the map first. The money always takes the same roads. And this year, when the next big story breaks — a star released, a record fee — ask first: who is behind this, and what is their record?