Before I Posted that I copied it back to Excel and it worked OK but now, since I posted it, it doesn't work as expected. Sorry! There are eleven columns headed as follows: DATE SHARES SHARES OWNED BUY SELL SHAREPRICE VALUE FEES STAMP
PAID OUT RECEIVED
If you start with that in Line 1 then leave Line 2 clear (I will tell you about that later) In A3 enter the date of your first purchase In B3 enter the number of shares you bought In C3 create a formula =B3, this will copy B3 In D3 enter 1 to indicate it as a 'BUY' In F3 enter the net share price you bought at. In G3 create formula =IF(D3,C3*F3,0)/100 In H3 enter the fee paid In I3 enter the Stamp Duty paid In J3 create formula =D3*(G3+H3+I3) When you have done all this you should have a line of figures that tell you all you need to record about that transaction. Repeat it for Line 4, ie: copy the formula in C3 and enter it in C4. It should read =B4, and so on. Before you enter any transaction in Line 4 copy the line and enter it down to, say, Line 9. In Line 10 create formula totals for C10, G10, H10, I10, J10 (=sum(C3:C9) When you have totals showing in each of these go to Line 2 C2 and create formula =C10 Repeat this for G10, H10, I10, and J10. In F2 create formula =(J2-K2)/C2*100. That should do it. Now go to A4 and enter today's date, in B4 enter the number of shares you are thinking of buying, and in C4 enter 1. In F4 enter the current price. In F2 you will get the average SP. This all sounds quite difficult but it is really very simple if you take a little time to it. See how you get on and come back to me if you need to. GL! PS: I have a page like this for every share I have dealt in over the past few years. I should say that I have further columns that tell me my gains and losses also dividends received, etc., and they all feed to a summary page that shows them all with totals. I'll be happy to expand if asked.
Try this. If you copy the following onto an Excel page it should work for you. It hasn't copied as formally as it appears on my Excel page so you may have to tweak some of the columns, etc., to ensure they are centred, etc.
Start with 01/06/2014 change the date to your first date. Then change the 2500 to your first share number. Then change the share price to what you paid. These are the only entries you need to make (unless others prove to be different, eg: the FEES) In the 25/9/2014 line just enter the number of shares you might buy and the SHARE PRICE. All the other figures will enter automatically and the average SHARE Price will show as the top figure in the column.
There is no calculator as such. To get the average you need to do a calculation. Say you purchased 1000 shares previously at £5each your total cost would be £5000 average cost per share would be £5 which you calculate by dividing the total cost by the number of shares you hold. You are now considering buying a futher 1000 shares but the cost of buying those shares has dropped to £3.50. You would then own 2000 shares at a total cost of £8500.the average cost has now dropped to £4.25. To arrive at the£4.25 divide your total outlay £8500 by the number of shares you now own 2000 and you will get an average cost of£4.25. Don't forget to include dealing costs and stamp duty to get a more accurate position as to whether you are up or down.
RBS under pressure to cut Citizens IPO: "Royal Bank of Scotland is facing pressure from investors to lower the price of shares it plans to sell in the initial public offering of Citizens Financial, its US consumer and commercial banking unit, two people familiar with the deal said. The listing which is expected to price later on Tuesday, is part of the British bank’s plan for a gradual exit from its US retail business. The bank has said it plans to sell 140m shares for between $23 to $25, raising as much as $3.5bn.
Investors said they were wary of Citizens’ ability to meet the financial targets laid out by the management." (Financial Times)
Datafeed and UK data supplied by NBTrader and Digital Look.
While London South East do their best to maintain the high quality of the information displayed on this site,
we cannot be held responsible for any loss due to incorrect information found here. All information is provided free of charge, 'as-is', and you use it at your own risk.
The contents of all 'Chat' messages should not be construed as advice and represent the opinions of the authors, not those of London South East Limited, or its affiliates.
London South East does not authorise or approve this content, and reserves the right to remove items at its discretion.