Interest rate data

rosshind

Hi. I'm calculating the repayments I intend to make for my first mortgage. I'll be getting an interest only one and making my own investments.

In order to make the information in my spread sheet as accurate as possible I need to make projections to do with interest rates, stock market return and average house prices.

Does anyone know where I can get good, acurate data on historical UK interest rates, average house prices and average stock market return? I will use these as a starting point for my projections.

Preferably going back 100 years or more in all cases?

Thanks in advance

Debt_Free_Chick

interest rates - best bet is The Bank of England website

For stock market returns - I would have suggested LSE or FTSE, but a quick look doesn't yield much. However this site claims to have the FTSE All Share index performance for each year back to 1800!

Average house prices - the Office of the Deputy Prime Minister seem to have some useful resouces.

Or the Halifax house price index

HTH

Chrismaths

If you are trying to forecast interest rates and house prices, why are you using back data? They have little predictive power. The most important factors in house prices are economic factors such as unemployment and interest rates - one way to get this in one metric is housing cost relative to income (ie percentage of net income spent on mortgage payments).

The best predictor of future interest rates is the yield curve - how much is a 10-year bond yielding to redemption? Currently the yield 'curve' is as flat as a pancake - so using today's interest rates is probably your best bet. Or to take interest rate risk out of the equation, take out a fix...