Main site > MoneySavingExpert.com Forums > Essential Money > Savings & Investments > What's the average FTSE level? (Page 1)

IMPORTANT! This is MoneySavingExpert's open forum - anyone can post

Please exercise caution & report any spam, illegal, offensive, racist, libellous post to forumteam@moneysavingexpert.com

  • Be nice to all MoneySavers
  • All the best tips go in the MoneySavingExpert weekly email

    Plus all the new guides, deals & loopholes

  • No spam/referral links
or Login with Facebook
What's the average FTSE level?
Closed Thread
Views: 4,072
Thread Tools Search this Thread Display Modes
# 1
Looter
Old 21-10-2008, 11:16 PM
MoneySaving Convert
 
Join Date: Nov 2005
Posts: 118
Default What's the average FTSE level?

In 2003 I invested in the NS&I Guaranteed Equity Bond which will sadly track the FTSE 100 on a daily basis from 24 May 2008 until 24 Nov 2008. Can anyone tell me what the average level of the FTSE was from 24 May 2008 to present, or can anyone tell me how to work it out? My starting level in 2003 was 4374.5 and receive 95% of any growth (if any).

Thanks in advance.

Looter
Looter is offline
Report Post
# 2
ExBanker
Old 22-10-2008, 1:10 AM
MoneySaving Convert
 
Join Date: Oct 2008
Posts: 89
Default

You would need to add up all daily closure figures since your required date, and divide by the number of days the market was open for, in order to obtain an average closing figure!

You don't need to work out the average anyway, a gauranteed equity bond simply tracks growth for the time period you took it out until the maturity date. If it has reached a higher level then you get a payout according to its growth. If it hasn;t grown you only get your initial deposit back! The Ftse 100 is actually lower now than when you put it out at 4229.73 as of yesterday. So unless it grows to above 4374.5 by 24 Nov 2008 you wont get anything more than your deposit back
ExBanker is offline
Report Post
# 3
innovate
Old 22-10-2008, 1:14 AM
PPR
Deliciously Dedicated Diehard MoneySaving Devotee
 
Join Date: Jun 2005
Location: On this planet
Posts: 15,707
Default

Try a Finance site, e.g. http://uk.finance.yahoo.com/q/bc?s=^FTSE&t=1y
innovate is offline
Report Post
The Following User Says Thank You to innovate For This Useful Post: Show me >>
# 4
sabretoothtigger
Old 22-10-2008, 4:24 AM
Fantastically Fervent MoneySaving Super Fan
 
Join Date: Feb 2008
Location: Listen very carefully, I shall say 'zis only once
Posts: 9,874
Send a message via ICQ to sabretoothtigger Send a message via AIM to sabretoothtigger Send a message via Yahoo to sabretoothtigger
Default

Ok you've been slightly unlucky with the timing but I think a tracker must rate over this bond.
I thought some of these bonds gave 25% as a minimum:confused:

Quote:
The returns on NS&I Guaranteed Equity Bonds are linked to the performance of the FTSE 100 index over a set term. If the FTSE 100 index grows over the term, you will benefit from that growth. And if it falls, you will still get back 100% of your original investment – guaranteed.
Please note that the FTSE 100 index measures share prices only, so you will not benefit from dividends. This means that you may not get as high a return as you would with a direct stock market investment. The returns on our Guaranteed Equity Bonds are subject to averaging and are liable to UK Income Tax on maturity. Although your capital is fully guaranteed, inflation may reduce the true value of your money over the investment term.
http://www.nsandi.com/products/geb/index.jsp


They will measure closing day ftse figures and average that like you say.

Code:
Date,Open Price,Close Price,High Price,Low Price,Volume
27-May-2008,6117.30,6058.50,6141.70,6048.70,0
28-May-2008,6068.10,6069.60,6122.20,6052.50,0
29-May-2008,6091.00,6068.10,6130.50,6041.10,0
30-May-2008,6074.10,6053.50,6111.60,6044.70,0
02-Jun-2008,6059.00,6007.60,6060.80,5978.40,0
03-Jun-2008,5997.20,6057.70,6059.00,5993.30,0
04-Jun-2008,6024.90,5970.10,6030.20,5933.30,0
05-Jun-2008,5969.60,5995.30,6005.10,5941.00,0
06-Jun-2008,6020.80,5906.80,6074.50,5906.50,0
09-Jun-2008,5902.90,5877.60,5938.50,5869.60,0
10-Jun-2008,5869.80,5827.30,5873.20,5813.40,0
11-Jun-2008,5847.40,5723.30,5859.40,5708.30,0
12-Jun-2008,5725.50,5790.50,5797.80,5719.80,0
13-Jun-2008,5793.70,5802.80,5818.30,5719.50,0
16-Jun-2008,5817.20,5794.60,5832.60,5759.60,0
17-Jun-2008,5799.70,5861.90,5930.30,5799.70,0
18-Jun-2008,5846.80,5756.90,5846.80,5735.40,0
19-Jun-2008,5752.20,5708.40,5786.40,5707.20,0
20-Jun-2008,5708.80,5620.80,5731.90,5597.00,0
23-Jun-2008,5623.50,5667.20,5679.20,5603.20,0
24-Jun-2008,5671.70,5634.70,5693.80,5581.60,0
25-Jun-2008,5644.30,5666.10,5669.60,5636.50,0
26-Jun-2008,5648.40,5518.20,5648.40,5518.20,0
27-Jun-2008,5507.00,5529.90,5555.20,5470.90,0
30-Jun-2008,5527.00,5625.90,5625.90,5520.20,0
01-Jul-2008,5600.20,5479.90,5601.50,5466.30,0
02-Jul-2008,5480.70,5426.30,5566.80,5426.30,0
03-Jul-2008,5400.00,5476.60,5490.60,5358.50,0
04-Jul-2008,5464.40,5412.80,5490.20,5394.00,0
07-Jul-2008,5439.00,5512.70,5516.40,5400.10,0
08-Jul-2008,5446.40,5440.50,5487.60,5358.70,0
09-Jul-2008,5465.10,5529.60,5538.20,5465.10,0
10-Jul-2008,5498.10,5406.80,5498.10,5392.60,0
11-Jul-2008,5420.50,5261.60,5461.80,5261.60,0
14-Jul-2008,5304.00,5300.40,5373.20,5293.00,0
15-Jul-2008,5279.70,5171.90,5279.70,5119.00,0
16-Jul-2008,5178.60,5150.60,5210.10,5071.10,0
17-Jul-2008,5176.60,5286.30,5320.50,5176.60,0
18-Jul-2008,5254.80,5376.40,5376.40,5216.60,0
21-Jul-2008,5375.70,5404.30,5445.80,5334.60,0
22-Jul-2008,5383.90,5364.10,5383.90,5282.80,0
23-Jul-2008,5404.40,5449.90,5467.20,5381.90,0
24-Jul-2008,5458.70,5362.30,5463.70,5345.10,0
25-Jul-2008,5336.30,5352.60,5375.20,5291.40,0
28-Jul-2008,5355.20,5312.60,5365.80,5308.40,0
29-Jul-2008,5297.80,5319.20,5354.60,5261.40,0
30-Jul-2008,5346.00,5420.70,5435.90,5346.00,0
31-Jul-2008,5440.70,5411.90,5456.10,5371.30,0
01-Aug-2008,5398.30,5354.70,5409.30,5321.30,0
04-Aug-2008,5351.40,5320.20,5414.70,5310.30,0
05-Aug-2008,5318.80,5454.50,5454.50,5299.70,0
06-Aug-2008,5470.50,5486.10,5498.60,5440.10,0
07-Aug-2008,5480.60,5477.50,5539.30,5450.90,0
08-Aug-2008,5456.60,5489.20,5507.20,5410.80,0
11-Aug-2008,5494.90,5541.80,5541.80,5477.70,0
12-Aug-2008,5528.80,5534.50,5569.20,5491.30,0
13-Aug-2008,5517.10,5448.60,5517.80,5437.10,0
14-Aug-2008,5524.50,5497.40,5539.60,5445.60,0
15-Aug-2008,5508.10,5454.80,5538.80,5432.20,0
18-Aug-2008,5449.20,5450.20,5498.70,5425.30,0
19-Aug-2008,5417.10,5320.40,5417.10,5317.10,0
20-Aug-2008,5338.60,5371.80,5384.20,5325.80,0
21-Aug-2008,5360.10,5370.20,5408.00,5311.40,0
22-Aug-2008,5371.10,5505.60,5505.60,5368.00,0
26-Aug-2008,5463.10,5470.70,5493.00,5369.30,0
27-Aug-2008,5469.80,5528.10,5540.80,5434.70,0
28-Aug-2008,5522.10,5601.20,5634.00,5496.90,0
29-Aug-2008,5615.40,5636.60,5649.10,5587.40,0
01-Sep-2008,5621.50,5602.80,5621.50,5573.80,0
02-Sep-2008,5599.90,5620.70,5646.50,5574.90,0
03-Sep-2008,5593.80,5499.70,5593.80,5492.10,0
04-Sep-2008,5503.20,5362.10,5541.70,5362.10,0
05-Sep-2008,5349.80,5240.70,5359.30,5227.60,0
08-Sep-2008,5304.40,5446.30,5447.60,5304.40,0
09-Sep-2008,5455.20,5415.60,5524.80,5386.90,0
10-Sep-2008,5396.30,5366.20,5419.50,5327.80,0
11-Sep-2008,5362.10,5318.40,5377.90,5258.10,0
12-Sep-2008,5347.30,5416.70,5416.70,5320.70,0
15-Sep-2008,5377.80,5204.20,5377.80,5124.90,0
16-Sep-2008,5149.20,5025.60,5149.20,4961.20,0
17-Sep-2008,5038.00,4912.40,5124.40,4903.30,0
18-Sep-2008,4920.60,4880.00,5015.90,4860.70,0
19-Sep-2008,4884.60,5311.30,5351.20,4857.10,0
22-Sep-2008,5311.33,5236.26,5339.25,5236.26,0
23-Sep-2008,5232.09,5136.12,5232.09,5076.32,0
24-Sep-2008,5149.17,5095.57,5167.36,5087.30,0
25-Sep-2008,5088.86,5197.02,5211.64,5060.74,0
26-Sep-2008,5166.89,5088.47,5166.89,5057.33,0
29-Sep-2008,5063.32,4818.77,5063.32,4818.77,0
30-Sep-2008,4784.53,4902.45,4953.40,4671.02,0
01-Oct-2008,4941.49,4959.59,5012.24,4891.46,0
02-Oct-2008,4963.47,4870.34,5052.00,4862.11,0
03-Oct-2008,4866.98,4980.25,5003.90,4832.10,0
06-Oct-2008,4944.71,4589.19,4944.71,4549.66,0
07-Oct-2008,4606.72,4605.22,4745.01,4517.47,0
08-Oct-2008,4529.64,4366.69,4654.18,4245.29,0
09-Oct-2008,4399.56,4313.80,4512.45,4274.40,0
10-Oct-2008,4311.03,3932.06,4311.03,3873.99,0
13-Oct-2008,3943.97,4256.90,4256.90,3943.97,0
14-Oct-2008,4301.53,4394.21,4534.35,4256.90,0
15-Oct-2008,4385.79,4079.59,4394.21,4051.98,0
16-Oct-2008,4043.01,3861.39,4063.56,3808.11,0
17-Oct-2008,3909.55,4063.01,4077.58,3861.29,0
20-Oct-2008,4095.17,4282.67,4282.67,4069.71,0
21-Oct-2008,4310.44,4229.73,4347.69,4212.37,0
http://www.digitallook.com

Excel will take this afaik, its csv and you could average it out or if not I'll do it later to give you some idea of your current return.
Hopefully you will be lucky and the market will just stay even till your close of averaging, to simulate this you add in the remaining days with the last figure



edit:
May 24th - Nov 22nd average ftse was 5315.7

If the ftse was 4040 till 24th of Nov then the overall average would be 5096.6 which I think gives the bond a return of 16.5% or something like 3.3% a year
Quote:
Tokyo residential prices have gone from 4x London in 1990 to ¼ London in 2014
Quote:
Originally Posted by Greenspan, Federal Reserve
There is no other agency of government which can overrule actions that we take

Last edited by sabretoothtigger; 22-10-2008 at 9:53 PM.
sabretoothtigger is offline
Report Post
The Following User Says Thank You to sabretoothtigger For This Useful Post: Show me >>
# 5
Looter
Old 29-10-2008, 4:26 PM
MoneySaving Convert
 
Join Date: Nov 2005
Posts: 118
Default

Thanks for that SBT. I've worked out the average and going to keep on top of it until it matures. It's actually not that bad due to the FTSE being well over 6000 for the first few days, should make around 1k and will settle for that.
Looter is offline
Report Post
Closed Thread

Bookmarks
 
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

 Forum Jump  

Contact Us - MoneySavingExpert.com - Archive - Privacy Statement - Top

Powered by vBulletin® Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

All times are GMT. The time now is 9:25 PM.

 Forum Jump  

Free MoneySaving Email

Top deals: Week of 29 October 2014

Get all this & more in MoneySavingExpert's weekly email full of guides, vouchers and Deals

GET THIS FREE WEEKLY EMAIL Full of deals, guides & it's spam free

Latest News & Blogs

Martin's Twitter Feed

profile

Cheap Travel Money

Find the best online rate for holiday cash with MSE's TravelMoneyMax.

Find the best online rate for your holiday cash with MoneySavingExpert's TravelMoneyMax.

TuneChecker Top Albums

  • VARIOUS ARTISTSBBC RADIO 1'S LIVE LOUNGE 2014
  • TAYLOR SWIFT1989 (DELUXE)
  • ED SHEERANX (DELUXE EDITION)

MSE's Twitter Feed

profile
Always remember anyone can post on the MSE forums, so it can be very different from our opinion.
We use Skimlinks and other affiliated links in some of our boards, for some of our users.