Stock Average Calculator
Stock Average Calculator - Free Online Average Down & Cost Price Tool
Calculate your average buy price, total investment and break-even for any stock, ETF or crypto in seconds.
What Is a Stock Average Calculator?
A stock average calculator is a free online tool that finds the weighted average price you paid for a share when you buy the same stock more than once at different prices. Instead of working it out by hand or building an Excel sheet, you enter the quantity and price of each purchase. The calculator then returns your average cost per share, total quantity, total invested amount and break-even price in one click. It is also known as a share average calculator, stock avg calculator, average price calculator or average down calculator, and it is a simple way to understand the real numbers behind your portfolio.
Why Your Average Stock Price Matters
Your average price is your true cost basis. It decides when you reach break-even, how much profit or loss you hold, what your percentage return is and how much tax you may owe after selling. Many brokers show an average price inside their app, but a separate average stock price calculator lets you test scenarios before you place an order. You can see how buying 10, 50 or 100 more shares at a lower price changes your average, and decide whether the trade fits your plan and your risk limit.
How to Use the Stock Average Calculator
- Enter the number of shares and the buy price of your first purchase.
- Add a new row for every extra purchase of the same stock.
- Add brokerage and charges if you want the most accurate cost per share.
- Click Calculate to see the new average price, total shares and total cost.
- Compare the result with the current market price to check profit, loss or break-even.
No download, app or registration is needed. The tool runs in your browser on mobile, tablet or desktop and does not store your portfolio data.
Stock Average Formula With Example
The formula uses a weighted average, because each purchase has a different quantity:
Average Price = (Q1xP1 + Q2xP2 + ... + QnxPn) / (Q1 + Q2 + ... + Qn)
Here Q is the quantity bought and P is the price per share. Suppose you buy 10 shares at Rs 500 and later 20 shares at Rs 400. Your total cost is Rs 5,000 + Rs 8,000 = Rs 13,000 for 30 shares, so your average price is Rs 433.33. The stock only needs to rise to Rs 433.33 for you to break even, instead of the original Rs 500. That is the main idea behind averaging down.
Averaging Down vs Averaging Up
Averaging down means buying more shares as the price falls, which lowers your average cost and brings your break-even closer. Averaging up means adding to a winning position at a higher price, which raises your average but follows the trend. Both strategies can work when the company is strong. Averaging down on a business with weakening fundamentals can turn a small loss into a large one. Use a cap on position size, decide your exit in advance and think about a stop-loss. A common risk guideline, the 7% rule, suggests reviewing or selling a position that falls about 7 to 8 percent below your buy price.
How to Calculate Average Stock Price in Excel or Google Sheets
If you track trades in a spreadsheet, put the quantity in column A and the price in column B. Then use this formula:
=SUMPRODUCT(A2:A10,B2:B10)/SUM(A2:A10)
This returns the weighted average price per share. To add brokerage, put the charges in column C and use =(SUMPRODUCT(A2:A10,B2:B10)+SUM(C2:C10))/SUM(A2:A10). A spreadsheet works well for a template, but an online calculator is faster when you only need a quick answer before placing an order.
Works With Every Broker and Trading App
The maths does not depend on where you trade, so this tool works with any platform. Investors in India use it alongside Zerodha Kite, Groww, Upstox, Angel One, 5paisa, Fyers, ICICI Direct, Kotak Securities, HDFC Securities, Dhan and INDmoney. Investors abroad use it with Robinhood, Charles Schwab, Fidelity, Vanguard, Wealthsimple, HSBC and many others. Check the average price your broker shows against the calculator result to confirm your cost, especially after splits, bonus issues or multiple orders on different days.
Use It for Any Country and Currency
The calculator is currency-neutral, so you can use it for INR, USD, GBP, EUR, AUD, CAD, NPR, PKR, MYR, PHP, SGD or any other currency. It is popular for NSE and BSE shares in India, US markets such as NYSE and Nasdaq, the UK, Canada, Australia, Nepal (NEPSE), Pakistan (PSX), Malaysia, Singapore, the Philippines, Kenya, Nigeria, South Africa and the Gulf. Enter your prices in your own currency and keep it the same for all rows.
Stocks, ETFs, Crypto, Penny Stocks and F&O
You can average the cost of ordinary shares, ETFs, mutual fund units, penny stocks and crypto assets such as Bitcoin, Ethereum and XRP. It also helps with dollar-cost averaging (DCA) and monthly SIP investing, where each instalment buys at a different price. For option and F&O traders, it can combine lots bought at different premiums into one average entry price. Keep in mind that leveraged and derivative positions carry a higher risk than normal share investing.
Check Break-Even, Profit, Loss and Return
After you know your average price, the other numbers follow from it:
- Investment value = shares x average price
- Current value = shares x current market price
- Profit or loss = (selling price - average price) x shares
- Return % = profit / total invested x 100
For long-term investing, compare your return over the holding period with an annual rate. A 20% gain over two years is a very different result from a 20% gain in one year. This simple view helps you judge growth, plan targets and decide when to sell.
Key Features of This Stock Average Calculator
- 100% free with no signup, download or app
- Supports unlimited purchase rows for stocks, ETFs and crypto
- Shows average price, total quantity, total cost and break-even
- Works in any currency and any stock market
- Fast, mobile-friendly and private
Tips to Use Averaging Wisely
Recalculate your average after every purchase and include brokerage and taxes so your cost is accurate. Never average down only to avoid booking a loss. First check why the price fell and whether the business is still sound. Spread your money across sectors, keep position sizes small enough to survive a bad outcome, and invest only money you can leave untouched for years. This calculator is for education and planning and is not financial advice. Consult a registered advisor before making investment decisions.
Frequently Asked Questions (FAQ)
- Enter the quantity and buy price for each purchase of the same stock, add more rows for additional buys, then click Calculate. The tool shows your average price per share, total quantity and total invested amount.
- Input your existing holding (shares and average price), then add the new purchase (shares and price). The calculator merges both and returns the new weighted average price instantly.
- Multiply shares by price for every buy, add all the results, then divide by the total number of shares. On a basic calculator: (Q1xP1 + Q2xP2) / (Q1 + Q2).
- Find the total cost of all purchases, then divide it by total shares owned. Example: 10 shares at 100 and 20 shares at 80 gives (1,000 + 1,600) / 30 = 86.67 per share.
- Enter your current shares and average price, then enter the lower price and the number of shares you plan to buy. The calculator shows your new, lower average cost and the price the stock must reach for you to break even.
- Average cost per stock = total amount invested (including brokerage and charges) / total number of shares held.
- The 7% rule is a risk-management guideline popularised by William O'Neil. It suggests selling a stock if it falls about 7-8% below your purchase price to limit losses. It is a guideline, not a guarantee.
- Add up the cost of every purchase (quantity x price) and divide by the total quantity. This weighted average gives your true average buy price.
- Average cost = (Q1xP1 + Q2xP2 + ... + QnxPn) / (Q1 + Q2 + ... + Qn), where Q is quantity bought and P is price per share.
- It is an online tool that works out the weighted average price you paid for a stock across multiple purchases, so you know your real cost basis and break-even point.
- A simple average is the sum of values divided by the count of values. For stocks, use the weighted average instead, because each purchase has a different quantity.
- Common formulas: Investment value = shares x price; Profit/Loss = (selling price - average price) x shares; Return % = (profit / total invested) x 100.
- List quantities in column A and prices in column B, then use =SUMPRODUCT(A2:A10,B2:B10)/SUM(A2:A10). This returns the weighted average price per share.
- Multiply the number of shares by the current market price for your current value. Compare it with your total invested amount to see profit or loss.
- A 70/30 portfolio means 70% in stocks and 30% in bonds. Buffett is more publicly associated with a 90/10 suggestion (90% S&P 500 index fund, 10% short-term government bonds). Allocation should match your own risk tolerance.
- In the US, Federal Reserve data indicates the wealthiest 10% of households own roughly 90% of directly and indirectly held stocks. Ownership is highly concentrated in most countries.
- Divide the total money spent on all purchases by the total shares owned. Or enter each buy into our free stock average calculator and get the result in one click.