Stock Average Calculator

Weighted average buy price, unrealized P&L and break-even across multiple purchase lots, plus shares needed to reach a target average

Inputs

Purchase Lots (3/10)
QtyPrice (₹)
1@
2@
3@

Check the live price on NSE India or BSE India.

Plan Another Purchase
Total amount invested₹95,500
225 shares across 3 lots
Average buy price₹424.44
Total shares225
Total invested₹95,500.00
Current value₹99,000.00
Unrealized P&L₹3,500.00
Unrealized P&L %+3.66%
Average after buying 100 more₹429.23
Shares to buy for ₹430.00 average125
Invested 96%Gain 4%
Gain+3.7%
Invested 96%
Gain 4%

Get the best of Fermor, free

Join to get financial tips, calculator updates, and insights in your inbox.

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
The default lots in the calculator above.
LotQuantityPriceAmount
Buy 1100Rs 450.00Rs 45,000
Buy 250Rs 380.00Rs 19,000
Buy 375Rs 420.00Rs 31,500
Total / average225Rs 424.44Rs 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.

Shares are rounded up to whole shares. Charges not included.
Target averageShares to buy at Rs 980Extra costTotal invested
Rs 1,15059Rs 57,820Rs 2,97,820
Rs 1,100167Rs 1,63,660Rs 4,03,660
Rs 1,050429Rs 4,20,420Rs 6,60,420
Rs 1,0002,000Rs 19,60,000Rs 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.

Averaging down, no second buy and averaging up on 100 shares bought at Rs 500.
ScenarioFirst buySecond buyAverageEffect
Averaging down100 @ Rs 500100 @ Rs 400Rs 450Break-even falls by Rs 50
No second buy100 @ Rs 500NoneRs 500Break-even unchanged
Averaging up100 @ Rs 500100 @ Rs 600Rs 550Break-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.

Averaging down after a correction: 200 shares at Rs 1,200 and 300 shares at Rs 980.
TransactionQtyPriceAmount
Buy 1 (January)200Rs 1,200Rs 2,40,000
Buy 2 (March, price Rs 980)300Rs 980Rs 2,94,000
Total / average500Rs 1,068Rs 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.

Open calculator

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.

Rise needed = 1 / (1 - fall) - 1.
Fall from your priceRise 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.

Sales on or after 23 July 2024, before surcharge and cess. Check the Income Tax Department site for current rates.
Equity shares (listed)HeldTax rate
Short-term gainUp to 12 months20%
Long-term gainOver 12 months12.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.

Open calculator

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.

With the default lots, D2 is 95,500, D3 is 225 and D4 is 424.44.
CellContentFormula
B2:B4Quantity of each lotEnter 100, 50, 75
C2:C4Price of each lotEnter 450, 380, 420
D2Total invested=SUMPRODUCT(B2:B4,C2:C4)
D3Total shares=SUM(B2:B4)
D4Average buy price=D2/D3
D5Unrealized 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.

  1. Add purchase lots: enter quantity and price for each buy. Use up to 10 lots, or clear the examples and add your own.
  2. Enter the current price: the result panel then shows current value and unrealized P&L.
  3. Plan a purchase: enter shares and a price to see your new average. Leave the price blank to use the current price.
  4. 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

What is a stock average calculator?

A stock average calculator finds your weighted average buy price when you bought the same stock at different prices. It divides the total amount invested by the total shares held. It also shows your unrealized profit or loss and the price at which you break even.

How is the average share price calculated?

Average price = sum of (quantity x price) for every lot / total shares. For 100 shares at Rs 450, 50 at Rs 380 and 75 at Rs 420, you invested Rs 95,500 in 225 shares. The average is Rs 424.44.

What does averaging down mean?

Averaging down means buying more shares after the price has fallen, which lowers your average cost. Buy 100 shares at Rs 500, then 100 more at Rs 400, and your average becomes Rs 450. Your break-even price drops by Rs 50.

How many shares do I need to buy to reach a target average?

Shares needed = (target x shares held - amount invested) / (buy price - target). With 200 shares bought at Rs 1,200 and the price at Rs 980, you need 167 more shares to reach an average of Rs 1,100. The target must sit between your average and the buy price.

Can I lower my average by buying at a higher price?

No. Buying above your current average always raises it, and buying below always lowers it. To reach a target average below your current one, you must buy at a price below that target.

When should I average down on a stock?

Average down only if the business is intact and the fall comes from market-wide selling or a temporary event. Do not add if earnings, margins or debt are getting structurally worse. Decide the maximum you will hold in the stock before you buy more.

Does averaging down reduce risk?

No. It lowers your break-even price but raises your total exposure to one stock. If the price keeps falling, you lose on a larger position. Averaging down in a company with deteriorating fundamentals increases risk rather than reducing it.

What is the break-even price of a stock holding?

The break-even price equals your weighted average buy price. Selling at that price gives zero profit or loss before brokerage, taxes and other charges. To break even after charges, add them to each lot price before you enter it.

How much must a stock rise to recover from a fall?

A fall of 20% needs a rise of 25% to get back to the starting price, and a fall of 50% needs a rise of 100%. The deeper the fall, the larger the rise needed, which is why averaging down can shorten the road back.

What is ATP (Average Traded Price)?

ATP is the volume-weighted average price of all trades in a stock during a session: total value traded divided by total volume traded. It describes the market on that day, not your own purchases. Your average buy price is a different number.

How does the SEBI open offer price relate to volume-weighted price?

For an open offer under the SEBI takeover regulations, the offer price is the highest of several parameters. One of them is the volume-weighted average market price over the 60 trading days before the public announcement.

Does the average buy price decide my capital gains tax?

No. The average is for tracking your position. For demat shares, income tax reporting instructions use first-in-first-out to match sold shares to purchase lots and to measure the holding period. Your broker tax report applies this automatically.

What is the difference between FIFO and average cost?

FIFO sells your oldest lot first, so each sale carries that lot price and holding period. The average cost method gives every share the same blended price. Use average cost to track a position and FIFO to work out tax.

What are the tax rates on equity share gains in India?

For listed equity shares sold on or after 23 July 2024, gains on shares held over 12 months are taxed at 12.5% on the amount above Rs 1.25 lakh in a year. Gains on shares sold within 12 months are taxed at 20%. Rates exclude surcharge and cess.

What is grandfathering for shares bought before 1 February 2018?

For listed equity shares bought before 1 February 2018, the cost of acquisition for long-term gains is the higher of the actual cost and the lower of the 31 January 2018 market value and the sale price. This can raise your cost and cut your taxable gain.

Does this calculator include brokerage and charges?

No. It uses the prices you enter. To include brokerage, STT, stamp duty and GST, add them to the price of each lot, so the price reflects your all-in cost per share.

Can I use this calculator for F&O positions?

You can average the entry price of futures with the same formula by entering contracts as quantity. Margin and leverage change the risk, because a loss on the larger position grows faster than in cash equity. This page does not model margin.

Can I use it for ETFs and mutual fund SIP units?

Yes. For an ETF, enter each purchase as a lot. For a mutual fund SIP, enter units and the NAV on each instalment date as quantity and price. The result is your average cost per unit.

Does it work with Zerodha, Groww and other brokers?

Yes, the calculator works with any broker. Copy the quantity and price of each buy from your trade history or holdings statement, then enter them as lots. It is not connected to any broker account.

How do I calculate unrealized P&L on my holding?

Unrealized P&L = (current price - average buy price) x shares held. With an average of Rs 424.44, a price of Rs 440 and 225 shares, the gain is Rs 3,500, or 3.66% on Rs 95,500 invested.

Why is my broker average different from this calculator?

Brokers can include charges in the average, or adjust it for splits, bonus shares and demergers. If a corporate action occurred, adjust each older lot quantity and price to match before entering it here.

How is averaging down different from rupee cost averaging?

Rupee cost averaging buys a fixed amount at regular intervals whatever the price, as in a SIP. Averaging down is a one-off decision to buy more after a fall. The first is a plan, the second a judgement about one stock.

How many purchase lots can I add?

You can add up to 10 lots. If you have more purchases, combine lots you bought at similar prices into one by adding the quantities and averaging the prices. Your entries are saved in your browser on this device.

How do I calculate the average price in Excel?

Use =SUMPRODUCT(quantities, prices)/SUM(quantities). With quantities in B2:B4 and prices in C2:C4, the formula is =SUMPRODUCT(B2:B4,C2:C4)/SUM(B2:B4). For 100 at Rs 450, 50 at Rs 380 and 75 at Rs 420 it returns 424.44.

What is Fermor?

Fermor is a financial platform built for India. The calculators are the distribution layer: free tools that give real answers to real financial questions. The product being built is an automated financial action system that uses the Account Aggregator framework to connect real financial accounts and close the gap between knowing what you should do with your money and actually doing it.

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.