Are you looking for a stock average calculator Excel file? If yes, then you are in the right place. In this article, we added an Excel calculator link. Which works like a stock average calculator but in Excel.
Our team of experts built this so people can use this Excel calculator according to their needs. We also show you how to create your own Excel calculator to get the average share price.
Click Here to Acces our Excel Calculator Sheet
How to Calculate the Average Price per Share in Excel
In the below image of the stock average Excel calculator, you can see there are four input fields.
- Number of shares purchased for Stock 1: In this field, you have to indicate how many shares you bought in your first share purchase.
- Number of shares purchased for Stock 2: Then, in this field, investors have to fill up the stock quantities they bought in their second stock purchase.
- Price per share for Stock 1: Here, you have to put the amount of one share that you paid while buying your first stocks.
- Price per share for Stock 2: Similarly, here, you only have to put the price of one share that you paid while buying your second stock.
You just have to fill in your data in these fields accordingly to see the accurate results.
How can you access our Excel Share Price Calculator?
To access our Excel sheet, you have to click on the link below that we provided.
Link: Excel Share Price Calculator
After clicking on this link, you can see our sheet initially. Then, if you want access to that sheet, here are the steps that you have to follow:
- Step: After opening the sheet through the given link, you’ll see a “view only” button, as shown in the above image.
- Step: You have to click the “view only” button.
- Step: After that, you’ll see the “request edit access” button.
- Step: Just click the “request edit access” button, and we’ll receive your request.
- Step: You just have to wait a few minutes, and our team will grant you access to those sheets.
A Complete Guide on How to Make an Excel Stock Price Calculator
If you don’t want to use the sheet that we are providing in this article, then you can also make your own Excel sheet to make your customized stock average calculator.
You just have to follow the below steps to make your own stock calculator in Excel or a spreadsheet.
Open Excel or a spreadsheet on your laptop, computer, Mac, or desktop. After opening the sheet, you have to name the cells as shown below.
| Cells | Cells Name |
|---|---|
| A1 | Input Type |
| B1 | Stock Quantity |
| C1 | Input Type |
| D1 | Price |
| B5 | Results |
| A7 | Amount Invested in the First Stock |
| A8 | Amount Invested in the Second Stock |
| A9 | Total Stock Quantity |
| A10 | Total Invested Amount |
| A11 | Average Stock Price |
| B7 | Empty Space for “Amount Invested in the First Stock” Result |
| B8 | Empty Space for “Amount Invested in the Second Stock” Result |
| B9 | Empty Space for “Total Stock Quantity” Result |
| B10 | Empty Space for “Total Invested Amount” Result |
| B11 | Empty Space for “Average Stock Price” Result |
What formulas do you have to use to make a stock average price calculator Excel?
After naming all the results as shown in the above table, you have to use some formula to show the proper results. You don’t have to put formulas in each cell. You just have to formula in those cells, where you leave “empty spaces” to show results.
Below, we have listed all the formulas you have to use in the particular cells.
| Cells | Formulas |
|---|---|
| B7 | “=B2*D2” |
| B8 | “=B3*D3” |
| B9 | “=SUM(B2:B3)” |
| B10 | “=SUM(B7:B8)” |
| B11 | “=B10/B9” |
You just have to put the exact same formulas after naming the cells, as we wrote in the above table. After doing all these, you have your own calculator in Excel. You can also read this article to learn about how to calculate share average price for smart investing
Conclusion
In this article, we talk about how you can create your own stock average price calculator in Excel. Along with that, we also provide you with the Excel calculator link that we created to help you.
If you need any further help, then please do contact us, or you can also comment down below.