What Is Stock Averaging?
Stock averaging is buying more of the same stock at different prices, so your cost per share becomes a blend of every purchase. That blended cost is total money invested divided by total shares held. It is your break-even price and the base for your unrealized profit or loss.
Anyone who has bought a stock twice is already averaging. The question is whether the second buy followed a plan or a hope.
The average sets your unrealized profit or loss at any price. It is a tracking number, though, and it does not decide your tax.
How Is the Average Share Price Calculated?
The average share price is the sum of quantity times price for every lot, divided by the total quantity.
Average price = SUM(quantity x price) / SUM(quantity) Lot 1: 100 shares @ Rs 450 = Rs 45,000 Lot 2: 50 shares @ Rs 380 = Rs 19,000 Lot 3: 75 shares @ Rs 420 = Rs 31,500 Invested = Rs 95,500 Shares = 225 Average = 95,500 / 225 = Rs 424.44
| Lot | Quantity | Price | Amount |
|---|---|---|---|
| Buy 1 | 100 | Rs 450.00 | Rs 45,000 |
| Buy 2 | 50 | Rs 380.00 | Rs 19,000 |
| Buy 3 | 75 | Rs 420.00 | Rs 31,500 |
| Total / average | 225 | Rs 424.44 | Rs 95,500 |
At Rs 440 the 225 shares are worth Rs 99,000, so the unrealized gain is Rs 3,500, or 3.66%. Order of purchase does not change the result.
How Many Shares Do You Need to Buy to Reach a Target Average?
Divide the gap between your target and your current cost by the gap between the buy price and the target.
Shares to buy = (target x shares held - amount invested) / (buy price - target) The buy price must be below the target to lower the average, and above the target to raise it.
Take 200 shares bought at Rs 1,200 (Rs 2,40,000 invested), with the price now at Rs 980. The table shows what each target costs.
| Target average | Shares to buy at Rs 980 | Extra cost | Total invested |
|---|---|---|---|
| Rs 1,150 | 59 | Rs 57,820 | Rs 2,97,820 |
| Rs 1,100 | 167 | Rs 1,63,660 | Rs 4,03,660 |
| Rs 1,050 | 429 | Rs 4,20,420 | Rs 6,60,420 |
| Rs 1,000 | 2,000 | Rs 19,60,000 | Rs 22,00,000 |
Each step toward the buy price costs far more than the last. Getting from Rs 1,050 to Rs 1,000 takes 1,571 more shares.
What Is the Difference Between Averaging Down and Averaging Up?
Averaging down means buying after a fall, which lowers your average. Averaging up means buying after a rise, which raises it.
| Scenario | First buy | Second buy | Average | Effect |
|---|---|---|---|---|
| Averaging down | 100 @ Rs 500 | 100 @ Rs 400 | Rs 450 | Break-even falls by Rs 50 |
| No second buy | 100 @ Rs 500 | None | Rs 500 | Break-even unchanged |
| Averaging up | 100 @ Rs 500 | 100 @ Rs 600 | Rs 550 | Break-even rises by Rs 50 |
Averaging up is common in trend-following, where you add to winners. Averaging down suits a fall driven by the market, not the company.
Worked Example: Averaging Down After a Correction
Buying 300 more shares at Rs 980 cuts the average on 200 shares bought at Rs 1,200 to Rs 1,068.
| Transaction | Qty | Price | Amount |
|---|---|---|---|
| Buy 1 (January) | 200 | Rs 1,200 | Rs 2,40,000 |
| Buy 2 (March, price Rs 980) | 300 | Rs 980 | Rs 2,94,000 |
| Total / average | 500 | Rs 1,068 | Rs 5,34,000 |
If the stock recovers to Rs 1,100, the gain is (1,100 minus 1,068) times 500, which is Rs 16,000. Without the second buy you would still be down Rs 20,000.
From Rs 980, the stock must rise 22.45% to reach Rs 1,200 but only 8.98% to reach Rs 1,068. Measure the true annualised return with the XIRR Calculator.
XIRR Calculator
Measure your return across several purchase and sale dates, not just the average price.
When Does Averaging Down Make Sense?
Averaging down makes sense when the business is unchanged and the fall comes from market-wide selling or a temporary event.
- Add when: earnings and cash flow are stable, and your reason for buying still holds.
- Do not add when: earnings fall for several quarters, debt grows faster than revenue, or the sector faces structural change.
- Set a limit first: decide the largest share of your portfolio this stock may take before you add.
Averaging down lowers your break-even but raises your exposure to one company. It does not lower risk.
How Much Must a Stock Rise to Recover From a Fall?
The rise needed to recover is always larger than the fall, and it grows quickly as the fall deepens.
| Fall from your price | Rise needed to break even |
|---|---|
| 10% | 11.11% |
| 20% | 25.00% |
| 30% | 42.86% |
| 40% | 66.67% |
| 50% | 100.00% |
| 60% | 150.00% |
A lower average shrinks the rise you need. That is the case for averaging down, and the cost of it is a bigger position.
To turn a holding period into a yearly return, use the CAGR Calculator.
What Is ATP (Average Traded Price)?
ATP is the volume-weighted average price of every trade in a stock during a session: total value traded divided by total volume traded.
It describes the market on one day, not your own purchases. Your average buy price is a separate number.
Volume-weighted prices also matter in takeovers. Under the SEBI takeover regulations, an open offer price is the highest of several parameters, one being the 60-trading-day volume-weighted average market price.
FIFO vs Average Cost: Which One Decides Your Tax?
First-in-first-out decides your tax, and the average cost is only for tracking. For demat shares, income tax reporting instructions match sold shares to the oldest purchase lots.
Say you sell 100 of the default 225 shares at Rs 440. FIFO uses the Rs 450 lot and shows a loss of Rs 1,000. The average method uses Rs 424.44 and shows a gain of Rs 1,556.
| Equity shares (listed) | Held | Tax rate |
|---|---|---|
| Short-term gain | Up to 12 months | 20% |
| Long-term gain | Over 12 months | 12.5% above Rs 1.25 lakh a year |
Shares bought before 1 February 2018 get a grandfathered cost, which can cut the taxable gain. Work out the tax with the Capital Gains Calculator.
Capital Gains Calculator
Work out short-term and long-term tax on a sale, lot by lot.
How Does F&O Averaging Differ From Equity Averaging?
F&O averaging uses the same formula, but leverage makes the same move far riskier than in cash equity.
For futures, enter contracts as quantity and the entry price as price. The result is your average entry.
Adding to a losing futures position increases leveraged exposure, so a further fall hurts more. This page does not model margin, expiry or options premium decay.
How Do You Get Your Lots From a Broker?
Copy the quantity and price of each buy from your broker trade history or holdings statement, and enter each one as a lot.
The calculator works with any broker and is not connected to an account. If a split, bonus or demerger happened, adjust older lots first. A 1:1 bonus doubles the quantity and halves the price.
To include charges, add brokerage, STT and stamp duty to each lot price. Compare your result with a benchmark in the Investment Comparison Calculator.
How Do You Calculate the Average Price in Excel?
Use SUMPRODUCT to multiply each quantity by its price, then divide by the total quantity.
| Cell | Content | Formula |
|---|---|---|
| B2:B4 | Quantity of each lot | Enter 100, 50, 75 |
| C2:C4 | Price of each lot | Enter 450, 380, 420 |
| D2 | Total invested | =SUMPRODUCT(B2:B4,C2:C4) |
| D3 | Total shares | =SUM(B2:B4) |
| D4 | Average buy price | =D2/D3 |
| D5 | Unrealized P&L at price P | =(P-D4)*D3 |
Add a row for every new buy and extend the ranges. The sheet should match this calculator exactly.
How to Use This Stock Average Calculator
The calculator takes your purchase lots, a current price and two optional planning inputs.
- Add purchase lots: enter quantity and price for each buy. Use up to 10 lots, or clear the examples and add your own.
- Enter the current price: the result panel then shows current value and unrealized P&L.
- Plan a purchase: enter shares and a price to see your new average. Leave the price blank to use the current price.
- Set a target average: the calculator shows how many shares you need to buy to reach it.
Your entries are saved in this browser, so the page shows your last calculation next time. The currency selector changes the symbol shown.
Frequently Asked Questions
Disclaimer: All calculations on this page are indicative only. The average buy price and unrealized P&L are arithmetic outputs of the figures you enter. They do not include brokerage, STT, exchange fees, GST or other charges, and they do not decide your capital gains tax. This calculator is for educational and planning purposes and does not constitute financial advice. Consult a SEBI-registered investment adviser or a Chartered Accountant before making investment or tax decisions.