Jason Posted January 12, 2007 Report Share Posted January 12, 2007 (edited) Here's the historic interest rates: http://www.bankofengland.co.uk/mfsd/iadb/R...p?Travel=NIxIRx In the attached spreadsheet you can work out the average interest rates over any time frame, this also takes into account the duration of that rate, so a long period of no changes is taken into account: Have a play around..: Historic_Interest_Rates_Combined_With_Inflation.zip Historic_Interest_Rates_Combined_With_Inflation.zip Edited March 6, 2009 by Jason Quote Link to post Share on other sites
Guest donall Posted January 12, 2007 Report Share Posted January 12, 2007 Cheers = makes good viewing Quote Link to post Share on other sites
Jason Posted January 14, 2007 Author Report Share Posted January 14, 2007 Ok, updated the spreadsheet to include rates all the way back to 1922 (see attachment in header). Also has some inflation figures. Thanks to Charlie the Tramp for adding in additional information! Quote Link to post Share on other sites
Guest Charlie The Tramp Posted January 14, 2007 Report Share Posted January 14, 2007 (edited) Just some clarification, in the second column is the inflation rate for that year. As an example if the suffix M says 12 that means that £1 that year is equivalent to £12 today. Here is the excel file with IRs back to 1694 and inflation inserted back to 1750. Edited May 14, 2007 by Jason Quote Link to post Share on other sites
Jason Posted January 15, 2007 Author Report Share Posted January 15, 2007 Ok, updated attachment. Added simple average for comparison. Quote Link to post Share on other sites
sirbob Posted January 30, 2007 Report Share Posted January 30, 2007 A most useful data set. Thank you for sharing it. A question: I have been trying to work out the cumulative compounded interest since mid-1935, using the time period applying to each rate change. Do you have any ideas as to how I could do this, please? Quote Link to post Share on other sites
Jason Posted February 18, 2007 Author Report Share Posted February 18, 2007 A most useful data set. Thank you for sharing it.A question: I have been trying to work out the cumulative compounded interest since mid-1935, using the time period applying to each rate change. Do you have any ideas as to how I could do this, please? That would be quite easy to do, just add your figure in down near the year 1935, and copy the formula up multiplying it against the interest rate divided by 365 for the daily interest rate (or if your smart work out how many days in that year, which will take into account leap years) times the number of days that rate was applicable. Quote Link to post Share on other sites
sirbob Posted February 21, 2007 Report Share Posted February 21, 2007 Thanks, Jason. I will do that. Quote Link to post Share on other sites
Guest Charlie The Tramp Posted May 13, 2007 Report Share Posted May 13, 2007 Jason have you updated the file to include the last rate hike ? Quote Link to post Share on other sites
Jason Posted May 13, 2007 Author Report Share Posted May 13, 2007 Done! Quote Link to post Share on other sites
Guest Charlie The Tramp Posted May 13, 2007 Report Share Posted May 13, 2007 Done! A further favour could you update the file in post #4. I tried on my download but am not familiar with playing with excel as I have a very old version. Quote Link to post Share on other sites
Jason Posted May 14, 2007 Author Report Share Posted May 14, 2007 Updated, but merged with the original document and inserted in first post. Couldn't attach to your post for some reason. Quote Link to post Share on other sites
Guest Charlie The Tramp Posted July 30, 2007 Report Share Posted July 30, 2007 Is a further update now required Jason to take in the latest hikes ? Quote Link to post Share on other sites
Jason Posted July 31, 2007 Author Report Share Posted July 31, 2007 Done. Hopefully, I'll have to update it again on Thursday. Quote Link to post Share on other sites
Guest Charlie The Tramp Posted July 31, 2007 Report Share Posted July 31, 2007 Done. Hopefully, I'll have to update it again on Thursday. Thanks Jason I will now be able to email it to my Clientele who have been pushing me for a few weeks. You would be surprised who is interested in this file. Quote Link to post Share on other sites
Jason Posted December 11, 2007 Author Report Share Posted December 11, 2007 Updated for the latest rate adjustment. Quote Link to post Share on other sites
Jason Posted February 7, 2008 Author Report Share Posted February 7, 2008 Interest rates reduced to 5.25% on 7th Feb 08. Attachment on first post updated. Quote Link to post Share on other sites
Guest Charlie The Tramp Posted February 7, 2008 Report Share Posted February 7, 2008 Interest rates reduced to 5.25% on 7th Feb 08. Attachment on first post updated. Thanks Jason. Quote Link to post Share on other sites
Jason Posted May 9, 2008 Author Report Share Posted May 9, 2008 Interest rates reduced to 5.00% on 10th Apr 08. Attachment on first post updated. Quote Link to post Share on other sites
The Home Alliance Posted August 19, 2008 Report Share Posted August 19, 2008 http://213.225.136.206/statistics/rates/baserate.pdf this link doesnt work Quote Link to post Share on other sites
Jason Posted September 7, 2008 Author Report Share Posted September 7, 2008 http://213.225.136.206/statistics/rates/baserate.pdfthis link doesnt work I've corrected the link: http://www.bankofengland.co.uk/mfsd/iadb/R...p?Travel=NIxIRx Quote Link to post Share on other sites
Jason Posted December 5, 2008 Author Report Share Posted December 5, 2008 Spreadsheet updated on front page to show latest interest rate cuts. Quote Link to post Share on other sites
Jason Posted January 18, 2009 Author Report Share Posted January 18, 2009 Updated with base rate change to 1.5% on 8th Jan 09. Quote Link to post Share on other sites
TheDarkKnight Posted February 10, 2009 Report Share Posted February 10, 2009 Updated with base rate change to 1.5% on 8th Jan 09. This looks like a great set of data, but being new here, I'm a little confused as to the terminology. What does columns showing data such as "2.9%-M-1.0" as for example in November 2003 mean? I take it M represents the inflation adjusted value of sterling at the time - ie in November 2003 a pound is worth the same as it is now? What does the 2.9% represent, is this the average mortgage rates margin over base rate? Are average mortgage rates shown as fixeds or SVR? If fixed what length of fixed? Many Thanks Jason, The Dark Knight Quote Link to post Share on other sites
Jason Posted February 15, 2009 Author Report Share Posted February 15, 2009 Spreadsheet updated for 1% rates on 5th Feb 09. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.