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)
Nice post sums up the programme very well..... There are many different systems we all take our own choice and if we are lucky then we are truly lucky.. Home traders are at a disadvantage to the big boys and their lies the difference.
Regarding IOW.. Went there many years ago castle Carisbrook Castle and Blackgang Chine think some of that has fallen away into the sea now.. And the other places you mentioned also..
Had beautiful weather there last October. Check the Beatles when I'm 64 has a line about holidaying in the IOW and Ticket to Ryde lol. I'm afraid my experience of the Vectis buses (must check how the share price of the parent company is doing) day pass was very unfortunate with a breakdown and road delays in the morning, the automatic door jamming, the driver falling ill on one of the routes resulting in a no show and ended up getting a taxi back to the hotel as some of the bus routes just seem to stop at 6 pm. Visit the batteries, see the Needles and Osborne House where queen vic died. Ryde with one of the longest piers in the UK, fine orchards and vineyards.
Watched the programme about the traders. One of the favourite shares the investment club liked to trade long I presume was ASOS and think the programme ended with it being noted that the price had gone into freefall, the mum who had been up so much on her practice account was down over £3000 in her real account and the other poor soul would have been better off staying at Acorn Antiques. As for the bodybuilder with the biceps, the ultra white teeth and the adoring wife, I think he could have made more as a male supermodel but certainly the programme had a good mix of the characters we meet on the bbs every day except some of the egos were less in evidence lol maybe they were all sailing their yachts at Cowes.
Cannot see RBS falling to 315 .. but one never knows ... the markets have risen to all time highs recently and the tide can change quickly ... just needs that spark of uncertainty or crisis somewhere in the world ... it has been very quiet the past few weeks...
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.