Register
Login:
Share:
Email Facebook Twitter




RBS Share Chat - RSS Feed

Royal Bank of Scotland Share Chat (RBS)



Share Price: 352.10Bid: 351.90Ask: 352.20Change: -7.20 (-2.00%)Faller - Royal Bank Scot
Spread: 0.30Spread as %: 0.09%Open: 355.50High: 356.20Low: 350.00Yesterday’s Close: 359.30


Share Discussion for Royal Bank Scot (RBS)


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


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 £-
HALFMIST
Posts: 313
Answer
Opinion:No Opinion
Price:353.10
Mo2047 Average price calculation
24 Sep '14
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.
mailman
Posts: 2,000
Off Topic
Opinion:No Opinion
Price:355.90
All
24 Sep '14
Morning all...

What a difference 4 days make, last Fridays 14p rise to a high at around 373 is now 20p lower at around 353... So far today..

But as most know that is RBS for you as volatility is the name of the game....

See what it ends up at the end of today...
MY21
Posts: 9,600
Off Topic
Opinion:No Opinion
Price:357.90
FT Report
23 Sep '14
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)
Mo2047
Posts: 2,302
Off Topic
Opinion:No Opinion
Price:357.90
coutts sale
23 Sep '14
When will the sale for couttes take place
Mo2047
Posts: 2,302
Off Topic
Opinion:No Opinion
Price:357.90
guys
23 Sep '14
is there a average down calculator I can use before I purchase any more rbs shares. Want to work out what my actual average will be
mailman
Posts: 2,000
Off Topic
Opinion:No Opinion
Price:357.90
QE
23 Sep '14
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..

Good luck
QueenElvis
Posts: 8,207
Off Topic
Opinion:No Opinion
Price:357.90
View Thread (2)
RE: IoW
23 Sep '14
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.
mailman
Posts: 2,000
Off Topic
Opinion:No Opinion
Price:357.90
HALFMIST
23 Sep '14
Hi.. it was an interesting programme...

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...

GL





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.