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!)
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.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.