Jump to content


Photo

UK House prices: News & Views


5138 replies to this topic

#21 Ologhai Jones

Ologhai Jones

    Tri-Centurion

  • Members
  • PipPipPip
  • 638 posts
  • Gender:Male

Posted 27 August 2008 - 04:13 PM

QUOTE (ziknik @ Aug 27 2008, 04:28 PM) <{POST_SNAPBACK}>


Thanks for the link, but I do already have that. It's just that I didn't bother with it as it's quarterly data.

I could just do a bit of averaging (or something), but I had the vague nagging doubt that quarterly data isn't just monthly data added up for three months. I can't back this up with any maths you understand, but it did occur to me that just 'playing jazz' with the quarterly data might produce misleading results...

Perhaps someone else can make soothing noises about doing this... or just tell me the best way to produce good monthly figures from quarterly data, and, hence, a new chart! smile.gif

#22 Ziknik

Ziknik

    Tri-Millennium Guru

  • Members2
  • PipPipPipPipPip
  • 3,791 posts

Posted 27 August 2008 - 04:53 PM

QUOTE (Ologhai Jones @ Aug 27 2008, 05:13 PM) <{POST_SNAPBACK}>
Thanks for the link, but I do already have that. It's just that I didn't bother with it as it's quarterly data.

I could just do a bit of averaging (or something), but I had the vague nagging doubt that quarterly data isn't just monthly data added up for three months. I can't back this up with any maths you understand, but it did occur to me that just 'playing jazz' with the quarterly data might produce misleading results...

Perhaps someone else can make soothing noises about doing this... or just tell me the best way to produce good monthly figures from quarterly data, and, hence, a new chart! smile.gif


Save a copy before you start.

1. Copy and paste the data from the linked spreadsheet in to your spreadsheet. Date (quarters) and Price
2. Press CTRL and H
3. Type ‘Q1 ‘ in the first box and ‘01/01/’ into the second box. Then click ‘Replace All’ (note, there is a space after Q1)
4. Do the same for the other quarters
5. Right click the chart and select ‘Chart Type’. Change to ‘XY (scatter)’ if it isn’t already selected
6. Now add the new data line
7. Right click the new data line and select ‘Format Data Series’. On the patterns tab, you can match the line type to the other nationwide line so they both look the same.

The Nationwide data will look like it is one continuous line switching from quarters to months (but it will be shown twice on your key)

Come back to me if this wasn’t clear


#23 Ologhai Jones

Ologhai Jones

    Tri-Centurion

  • Members
  • PipPipPip
  • 638 posts
  • Gender:Male

Posted 27 August 2008 - 05:10 PM

QUOTE (ziknik @ Aug 27 2008, 05:53 PM) <{POST_SNAPBACK}>
Save a copy before you start.

1. Copy and paste the data from the linked spreadsheet in to your spreadsheet. Date (quarters) and Price
2. Press CTRL and H
3. Type ‘Q1 ‘ in the first box and ‘01/01/’ into the second box. Then click ‘Replace All’ (note, there is a space after Q1)
4. Do the same for the other quarters
5. Right click the chart and select ‘Chart Type’. Change to ‘XY (scatter)’ if it isn’t already selected
6. Now add the new data line
7. Right click the new data line and select ‘Format Data Series’. On the patterns tab, you can match the line type to the other nationwide line so they both look the same.

The Nationwide data will look like it is one continuous line switching from quarters to months (but it will be shown twice on your key)

Come back to me if this wasn’t clear


*starts to gibber*


#24 Concrete Jungle

Concrete Jungle

    Tri-Centurion

  • Administrators
  • PipPipPip
  • 765 posts
  • Gender:Male
  • Location:UK

Posted 27 August 2008 - 08:55 PM

It has gone eerily quiet on the government house price saving masterplan. I wonder what the fools may be scheming over next?


#25 Ziknik

Ziknik

    Tri-Millennium Guru

  • Members2
  • PipPipPipPipPip
  • 3,791 posts

Posted 27 August 2008 - 09:03 PM

QUOTE (Concrete Jungle @ Aug 27 2008, 09:55 PM) <{POST_SNAPBACK}>
It has gone eerily quiet on the government house price saving masterplan. I wonder what the fools may be scheming over next?


The Liberals have come up with a plan of their own.

http://news.bbc.co.u...ess/7583934.stm

** to buy empty properties and developers' land-banks to increase the amount of social housing.

** Mr Cable also called for lenders to go through the full and proper court process to repossess homes.

** A proposal for a new, regulated mortgage rescue plan would allow those who were unable to make repayments on their home loan to stay in their property as tenants.


#26 Ziknik

Ziknik

    Tri-Millennium Guru

  • Members2
  • PipPipPipPipPip
  • 3,791 posts

Posted 28 August 2008 - 06:01 AM

Nationwide data released. -1.9% MoM

edit: Link http://www.nationwid...al/Aug_2008.pdf

#27 Ologhai Jones

Ologhai Jones

    Tri-Centurion

  • Members
  • PipPipPip
  • 638 posts
  • Gender:Male

Posted 28 August 2008 - 08:42 AM

QUOTE (ziknik @ Aug 28 2008, 07:01 AM) <{POST_SNAPBACK}>
Nationwide data released. -1.9% MoM

edit: Link http://www.nationwid...al/Aug_2008.pdf


(£169,316 - £164,654) / £169,316 = 2.75%

blink.gif

#28 Layman

Layman

    Tri-Centurion

  • Members
  • PipPipPip
  • 728 posts
  • Location:UK

Posted 28 August 2008 - 08:54 AM

QUOTE (Ologhai Jones @ Aug 28 2008, 09:42 AM) <{POST_SNAPBACK}>
(£169,316 - £164,654) / £169,316 = 2.75%

blink.gif

That'll be the old "seasonal adjustment" then... rolleyes.gif

#29 Ziknik

Ziknik

    Tri-Millennium Guru

  • Members2
  • PipPipPipPipPip
  • 3,791 posts

Posted 28 August 2008 - 09:31 AM

QUOTE (Ologhai Jones @ Aug 28 2008, 09:42 AM) <{POST_SNAPBACK}>
(£169,316 - £164,654) / £169,316 = 2.75%

blink.gif


I think this is the biggest monthly fall EVER*

*(NSA, on the 1991 – present monthly spreadsheet)

#30 Steve Netwriter

Steve Netwriter

    Tri-Millennium Guru

  • Super Admins
  • PipPipPipPipPip
  • 5,856 posts
  • Gender:Male
  • Location:Christchurch, New Zealand

Posted 28 August 2008 - 09:35 AM

QUOTE (ziknik @ Aug 28 2008, 04:53 AM) <{POST_SNAPBACK}>
Save a copy before you start.

1. Copy and paste the data from the linked spreadsheet in to your spreadsheet. Date (quarters) and Price
2. Press CTRL and H
3. Type ‘Q1 ‘ in the first box and ‘01/01/’ into the second box. Then click ‘Replace All’ (note, there is a space after Q1)
4. Do the same for the other quarters
5. Right click the chart and select ‘Chart Type’. Change to ‘XY (scatter)’ if it isn’t already selected
6. Now add the new data line
7. Right click the new data line and select ‘Format Data Series’. On the patterns tab, you can match the line type to the other nationwide line so they both look the same.

The Nationwide data will look like it is one continuous line switching from quarters to months (but it will be shown twice on your key)

Come back to me if this wasn’t clear


I've put you on speed-dial under "Excel Help desk" biggrin.gif
Obviously I must read the manual.

Fiat: What starts becoming worth less eventually becomes worthless.

Notable Threads Notable Posts

#31 Concrete Jungle

Concrete Jungle

    Tri-Centurion

  • Administrators
  • PipPipPip
  • 765 posts
  • Gender:Male
  • Location:UK

Posted 28 August 2008 - 10:02 AM

The pathetic attempts to put a positive spin on the figures sums up this joke of a government perfectly. I wonder what the bovine excrement being fed to the masses in 12 months will be?


#32 Ologhai Jones

Ologhai Jones

    Tri-Centurion

  • Members
  • PipPipPip
  • 638 posts
  • Gender:Male

Posted 28 August 2008 - 10:03 AM

QUOTE (ziknik @ Aug 28 2008, 10:31 AM) <{POST_SNAPBACK}>
I think this is the biggest monthly fall EVER*

*(NSA, on the 1991 – present monthly spreadsheet)


If we're talking not seasonally adjusted, then this month's 2.75% isn't the biggest drop ever: that's this May's unadjusted 2.78%! laugh.gif

#33 Ziknik

Ziknik

    Tri-Millennium Guru

  • Members2
  • PipPipPipPipPip
  • 3,791 posts

Posted 28 August 2008 - 10:22 AM

QUOTE (Ologhai Jones @ Aug 28 2008, 11:03 AM) <{POST_SNAPBACK}>
If we're talking not seasonally adjusted, then this month's 2.75% isn't the biggest drop ever: that's this May's unadjusted 2.78%! laugh.gif


Green shoots of recovery? laugh.gif

Once the job losses start, May 2008 will look like ‘the-good-old-days’. (Unfortunately, I’ll be unemployed, so I won’t be laughing when it happens).


#34 Concrete Jungle

Concrete Jungle

    Tri-Centurion

  • Administrators
  • PipPipPip
  • 765 posts
  • Gender:Male
  • Location:UK

Posted 28 August 2008 - 10:32 AM

QUOTE
She said that prices, that were still higher than five years ago,


Well such a well thought out argument has reassured me laugh.gif

BBC


#35 Ziknik

Ziknik

    Tri-Millennium Guru

  • Members2
  • PipPipPipPipPip
  • 3,791 posts

Posted 28 August 2008 - 10:49 AM

QUOTE (Concrete Jungle @ Aug 28 2008, 11:32 AM) <{POST_SNAPBACK}>
Well such a well thought out argument has reassured me laugh.gif

BBC


Fionula was on BBC radio earlier.

http://news.bbc.co.u...000/7585465.stm


#36 G0ldfinger

G0ldfinger

    Tri-Millennium Guru

  • Members
  • PipPipPipPipPip
  • 11,512 posts
  • Gender:Male
  • Location:Fort Knox
  • Interests:Hoarding gold.

Posted 28 August 2008 - 10:52 AM

QUOTE (ziknik @ Aug 28 2008, 11:49 AM) <{POST_SNAPBACK}>
Fionula was on BBC radio earlier.
...

What's wrong with her really? Why the spin? 'Crash & burn' is what she should be telling us.

Video on front page Bloomberg now.

Here the Chart from the BBC article:


You can't tax deflation.
“Currency Induced Cost-Push Hyperinflation” vs “Demand-Pull (non-hyper) Inflation.”
The "no income --> no inflation"-thesis is as wrong as the "price control --> inflation control"-thesis.
Don't TRADE gold! You might lose your shirt in the biggest bull run ever. That would be embarassing. © possibly by Swampy
Posted Image
Gold, silver, property, currencies, commodities charts.

#37 Steve Netwriter

Steve Netwriter

    Tri-Millennium Guru

  • Super Admins
  • PipPipPipPipPip
  • 5,856 posts
  • Gender:Male
  • Location:Christchurch, New Zealand

Posted 28 August 2008 - 11:23 AM








http://www.nationwid...al/Aug_2008.pdf

That's quite a rapid movement down !

Fiat: What starts becoming worth less eventually becomes worthless.

Notable Threads Notable Posts

#38 Ziknik

Ziknik

    Tri-Millennium Guru

  • Members2
  • PipPipPipPipPip
  • 3,791 posts

Posted 28 August 2008 - 11:31 AM

QUOTE (G0ldfinger @ Aug 28 2008, 11:52 AM) <{POST_SNAPBACK}>
What's wrong with her really? Why the spin? 'Crash & burn' is what she should be telling us.

Video on front page Bloomberg now.

Here the Chart from the BBC article:



Nationwide and Fionula need to start thinking about their credibility. The more I hear their horse **** the less likely I am to trust them with my money.

There’s a better version of the BBC chart at GHPC

http://forum.globalh...d...st&p=355891


#39 Steve Netwriter

Steve Netwriter

    Tri-Millennium Guru

  • Super Admins
  • PipPipPipPipPip
  • 5,856 posts
  • Gender:Male
  • Location:Christchurch, New Zealand

Posted 28 August 2008 - 11:37 AM

It's OK, "it's only a number" laugh.gif laugh.gif laugh.gif

U.K. House Prices Have Biggest Annual Decline Since 1990, Nationwide Says
http://www.bloomberg...6...&refer=home

Fiat: What starts becoming worth less eventually becomes worthless.

Notable Threads Notable Posts

#40 Steve Netwriter

Steve Netwriter

    Tri-Millennium Guru

  • Super Admins
  • PipPipPipPipPip
  • 5,856 posts
  • Gender:Male
  • Location:Christchurch, New Zealand

Posted 28 August 2008 - 11:41 AM

I see he used my favourite skier laugh.gif




Fiat: What starts becoming worth less eventually becomes worthless.

Notable Threads Notable Posts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users