Your browser isn't supported
It looks like you're using an old web browser. To get the most out of the site and to ensure guides display correctly, we suggest upgrading your browser now. Download the latest:

Welcome to the MSE Forums

We're home to a fantastic community of MoneySavers but anyone can post. Please exercise caution & report spam, illegal, offensive or libellous posts/messages: click "report" or email forumteam@. Skimlinks & other affiliated links are turned on

Search
  • FIRST POST
    • Looter
    • By Looter 21st Oct 08, 11:16 PM
    • 130Posts
    • 112Thanks
    Looter
    What's the average FTSE level?
    • #1
    • 21st Oct 08, 11:16 PM
    What's the average FTSE level? 21st Oct 08 at 11:16 PM
    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
Page 1
  • ExBanker
    • #2
    • 22nd Oct 08, 1:10 AM
    • #2
    • 22nd Oct 08, 1:10 AM
    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
  • innovate
    • #3
    • 22nd Oct 08, 1:14 AM
    • #3
    • 22nd Oct 08, 1:14 AM
    Try a Finance site, e.g. http://uk.finance.yahoo.com/q/bc?s=^FTSE&t=1y
    • sabretoothtigger
    • By sabretoothtigger 22nd Oct 08, 4:24 AM
    • 9,934 Posts
    • 6,562 Thanks
    sabretoothtigger
    • #4
    • 22nd Oct 08, 4:24 AM
    • #4
    • 22nd Oct 08, 4:24 AM
    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:

    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
    Last edited by sabretoothtigger; 22-10-2008 at 9:53 PM.
    Tokyo residential prices have gone from 4x London in 1990 to London in 2014
    There is no other agency of government which can overrule actions that we take
    by Greenspan, Federal Reserve
    • Looter
    • By Looter 29th Oct 08, 4:26 PM
    • 130 Posts
    • 112 Thanks
    Looter
    • #5
    • 29th Oct 08, 4:26 PM
    • #5
    • 29th Oct 08, 4:26 PM
    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.
Welcome to our new Forum!

Our aim's to save you money quickly and easily. We hope you like it!

Forum Team Contact us

Live Stats

1,551Posts Today

6,195Users online

Martin's Twitter
  • RT @johnrh: @MartinSLewis JC is the only hope for politics in the UK. All you yes voters are totally wrong.

  • Some corbyn supprters are angry I've done a poll and some say focus on something else. Sorry, but you can't pretend this isn't happening.

  • RT @GMB: Does it frustrate you when people use the phrase '110%'? Listen up @susannareid100 (@MartinSLewis doesn't hold back) https://t.co/?

  • Follow Martin