off subject mathematical Question

Dec 26, 2008 4 Replies

I know this is not really the place for this question but can and will someone help me. PLEASE



I purchased 1264 Shares at 30cent I purchased 1813 Shares at 37cents I purchased 1813 Shares at 79.5cents



How do I work out my average buy price Thanks and sorry to anyone I have upset Chris


Chris Taylor wrote in news:4954d029$1 @dnews.tpgi.com.au:

Excel tells me you bought 4890 shares for a total of $2,491.35 That averages to approximately $0.509478528/share. Howver, the per share price does not mean much. What counts is how much you paid for each purchase. At least in Quicken NEVER use the per share price. Always use the number of shares purchased and the price oiad for the purchase (with the commission included, sincce that is part of what you needed to pay!)

Chris for both tax purposes and return on investment purposes, you need a different number. You need the total cost. So lets say you real data is this: First purchase cost 379.2 + X ; where X is the brokerage fee Second purchase 670.81 +Y Third purchase 1441.335 + Z

So your total cost is 2491.345 + X + Y + Z and your average per share cost is that number divided by you number of shares which is 4890

Hope this helps

Assuming you mean your average price/share: Quicken - at least the US version of Quicken - will compute that for you. On the Portfolio View (tab) of the Investing Center, customize a view to show "Cost Basis per Share".

First, calculate the amount spent for each of the three purchases by multiplying the quantity by the price. Then add the three results together to get the total amount you spent.

Second, add the three numbers, 1264, 1813, and 1813 together to get the total number of shares you bought.

Finally, to get your average buy price, divide the total amount you spent by the total number of shares you bought.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required