Jump to content
House Price Crash Forum
bdon

Historical Nationwide Data: Charts

Recommended Posts

Hi guys, thought in a moment of spreadsheetyness I'd map out the Nationwide figures (good long dataset). Some things interested me:

eyqtr60ci6mzxlup21bw.png

The graph actually looks much less spikey than I'd first thought - these btw are nominal.

The second graph though is much more interesting - this shows the quarterly change in HPI (or HPC!) throughout the period. The last crash was very sudden! Literally in one quarter things went +ve to -ve and then again and again.

g9eb4tvwhrzy594ct2q3.png

Interesting huh!

Share this post


Link to post
Share on other sites
Hi guys, thought in a moment of spreadsheetyness I'd map out the Nationwide figures (good long dataset). Some things interested me:

Interesting huh!

Er - do you have a life as well? But I agree interesting to observe the trends laid out like that.

Share this post


Link to post
Share on other sites

Hi guys, thought in a moment of spreadsheetyness I'd map out the Nationwide figures (good long dataset). Some things interested me:

It gets more interesting if you calculate an affordability index by dividing house prices by disposable income ( ie median earnings after tax). You then need to add another column for the deviation of this index from the average affordability index. I have the series from 1960 to date on a spreadsheet if you are interested. May I recommend using one figure for each year for ease of reading.

Share this post


Link to post
Share on other sites
Er - do you have a life as well? But I agree interesting to observe the trends laid out like that.

I do somewhere: split between this forum and work (which is generally 20% xl, 20 word, and 60% ppt !)

Share this post


Link to post
Share on other sites

Great stuff - thanks! Nice steady, sequential drop over what looks like a year - and then a couple more years of further lows - but shows that it can happen really fast once it starts. With the internet now that will be even speedier. RB is right - 30% down from 2007 peak by end of 2008.

Share this post


Link to post
Share on other sites
I have the series from 1960 to date on a spreadsheet if you are interested. May I recommend using one figure for each year for ease of reading.

Could you post the numbers in a spreadsheet in the economics section?

Share this post


Link to post
Share on other sites
Could you post the numbers in a spreadsheet in the economics section?

Figs now on economics section. Had to attach file in word format, as could not get excel accepted. Apologies if layout not too good as cols would go out of page range.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

  • Recently Browsing   0 members

    No registered users viewing this page.

  • 293 Brexit, House prices and Summer 2020

    1. 1. Including the effects Brexit, where do you think average UK house prices will be relative to now in June 2020?


      • down 5% +
      • down 2.5%
      • Even
      • up 2.5%
      • up 5%



×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.