Register
Login:
Share:
Email Facebook Twitter




RBS Share Chat - RSS Feed

Royal Bank of Scotland Share Chat (RBS)



Share Price: 342.80Bid: 342.70Ask: 342.90Change: -3.70 (-1.07%)Faller - Royal Bank Scot
Spread: 0.20Spread as %: 0.06%Open: 350.90High: 350.90Low: 341.90Yesterday’s Close: 346.50


Share Discussion for Royal Bank Scot (RBS)


Thread ViewThread View
Please Login or Register to post messages
Posts per page:


MY21
Posts: 9,621
Off Topic
Opinion:No Opinion
Price:361.40
Times
26 Sep '14
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.
 
TheTraveller
Posts: 507
Off Topic
Opinion:No Opinion
Price:364.40
Mo2047
25 Sep '14
You will receive an email from MOND????@HOTMAIL WITH ATTACHMENT, SHOUL DBE EASY TO FOLLOW
MY21
Posts: 9,621
Off Topic
Opinion:No Opinion
Price:362.10
Citizens IPO
25 Sep '14
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.
Mo2047
Posts: 2,302
Off Topic
Opinion:No Opinion
Price:362.10
positive news
24 Sep '14
Mo2047
Posts: 2,302
Off Topic
Opinion:No Opinion
Price:361.20
the travellor
24 Sep '14
thanks that would be great
TheTraveller
Posts: 507
Off Topic
Opinion:No Opinion
Price:358.40
MO
24 Sep '14
If you want I can email you the shhet that I use as well
Mo2047
Posts: 2,302
Off Topic
Opinion:No Opinion
Price:359.20
neephead
24 Sep '14
i just created that email address and once i recieve your attachment will delete the email address thanks fella
Mo2047
Posts: 2,302
Off Topic
Opinion:No Opinion
Price:359.40
neep head many thanks
24 Sep '14
can you email it to my spam email address as a attachment shaz2047@yahoo.co.uk appcriciate it
NeepHead
Posts: 1,617
Off Topic
Opinion:No Opinion
Price:357.20
MO2047
24 Sep '14
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.
NeepHead
Posts: 1,617
Off Topic
Opinion:No Opinion
Price:356.00
MO2047
24 Sep '14
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.

DATE SHARES SHARES OWNED BUY SELL SHAREPRICE VALUE FEES STAMP PAID OUT RECEIVED
RBS 4,000 336.95830 £13,386.40 £25.00 £66.93 £13,478.33 £-
01/06/2014 2500 2,500 1 0 323.50000 £8,087.50 £12.50 £40.44 £8,140.44 £-
25/09/2014 1500 1,500 1 0 353.26000 £5,298.90 £12.50 £26.49 £5,337.89 £-
0 0 0 0.00000 £- £- £- £- £-
0 0 0 0.00000 £- £- £- £- £-
0 0 0 0.00000 £- £- £- £- £-
0 0 0 0.00000 £- £- £- £- £-
0 0 0 0.00000 £- £- £- £- £-
0 0 0 0.00000 £- £- £- £- £-
0 0 0 0.00000 £- £- £- £- £-
0 0 0 0.00000 £- £- £- £- £-
Totals: 4,000 0 0 0.00000 £13,386.40 £25.00 £66.93 £13,478.33 £-





Sign up for Live Prices


Home  |  Contact Us  |  About Us  |  Careers  |  Advertise with Us  |  Sitemap  |  Terms & Conditions  |  Cookies  |  Privacy


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.