Politicians warned to stay on sidelines as RBS starts search for new Chairman: Andrew Tyrie, Chairman of the Treasury Select Committee and the Parliamentary Banking Standards Commission, has urged politicians to stay out of the decision on the next Chairman of Royal Bank of Scotland.
Biggest U.S. bank IPO since crisis values Citizens at $13 bln
* Shares rise as much as 8 pct
* IPO priced below expected range
* Listing raises up to $3.5 bln for Royal Bank of Scotland (Updates shares, adds stake sale plan)
By Matt Scuffham and Amrutha Gayathri
Sept 24 (Reuters) - Shares of Citizens Financial Group Inc , the U.S. unit of Royal Bank of Scotland Group Plc , rose as much as 8 percent in their market debut, valuing the lender at about $13 billion in the biggest U.S. bank IPO since the financial crisis.
The offering, which raised $3.01 billion for RBS, is also the second biggest in the United States this year after Alibaba Group Holding Ltd's $25 billion IPO last week.
Citizens' shares closed up 7.3 percent at $23.08, underscoring tepid appetite for offerings by financial firms in an otherwise hot U.S. IPO market. Alibaba's stock popped 38 percent on its first day.
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.
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.