Pod Insights The Property Academy Podcast House price data: Which to use & when (For the nerds)⎥Ep. 2070 About this episode In this episode, we discuss the 3 main types of house price data — and reveal when to use each one (and which to avoid like the plague). You’ll learn:The difference between median price, average value, and house price indexWhy the data you see on Instagram might be totally misleadingAnd how to get suburb-level insights without needing a spreadsheetWant to know what’s really happening with property prices in your area? Use our Market Mover Calculator to track how much values have changed. For more from Opes Partners:Sign up for the weekly Private Property newsletterInstagramTikTok
Transcript 0:08 Speaker 00 Hello and welcome along to the Property Academy Podcast by Opes Partners. I'm your host, Seb Knight.
0:12 Speaker 01 And I'm Andrew Nichol.
0:12 Speaker 00 And this is a show that helps Kiwi investors go from zero to five properties. So you can be financially free, even when you don't know which data to look at. Now, stick around for the next 15 minutes because you're going to learn the three types of data you can use in property investment and when you should actually use them. The worst data to use, like the one to avoid if you can, and where to get all of this data from for free. Now, just a word of warning, woo woo woo, that's your warning sign. We are going to get real nerdy in this episode, but we'll try it out and we'll see if you like it. And if you do, we'll do more of them. Now, Andrew, why are we even talking about this?
0:50 Speaker 01 Well, I was talking to a doctor recently and we were looking at how much average houses had gone up in value in Meremah, which is in Wellington. And she said, but my mate said, when we look at data, we should only look at the Ryan's House Price Index. And I thought, you know what? I need to check this with Ed. We should do a show about it.
1:10 Speaker 00 So this is where a little bit of knowledge can be a dangerous thing. It's a bit like a couple of episodes ago, we talked about the Dunning Kruger effect, where you, you learn a little bit about a topic and all of a sudden you, you think you're an expert, then you learn a little bit more and you realise, uh, maybe I don't know as much as I did.
1:26 Speaker 01 Isn't that you with everything?
1:28 Speaker 00 Oh, come on, Andrew, don't tell our little secrets. Now, the House Price Index, the Ryan's House Price Index is the kind of gold standard of data if we're looking to see if house prices are going up or down. But that specific piece of data or data set, it doesn't go down to the suburb level. It's not created for that. So I can look at any council area in Wellington, whether it's Lower Hut to Upper Hut, Wellington City, and I can get the Ryan's House Price Index for that. But it doesn't go down to the suburb level like Meremah in Wellington City or Johnsonville, also in Wellington. But before we even get into the actual data, the first thing that you've got to realise
2:11 Speaker 00 when we, when we are talking about different data sets is that first principle is we've got to use the right tool for the job. It's a little bit like a Phillips screwdriver. Like, I love, I love me a Phillips screwdriver. I love a socket wrench. Now, a Phillips screwdriver is great when you're working with screws, but you wouldn't use it to hammer in a nail because it's not the right tool for the job. And that is exactly the same when it comes to data. So there will be times where I'm like, Ryan's house price index is exactly what you use when you're looking at house price changes. And that is generally true, but there are some times where it's actually not the right tool for the job. So when we are looking at house price changes, house price is going up or down, there are three types of data we could look at.
2:54 Speaker 00 We could look at the house price index, and I'm going to talk a little bit more about that in a second. We've got average house values and whether the average house value is going up or down. And then we've got median sales prices, and these are all calculated in very, very different ways. But if you're nerdy, this is very important for you. So let's kick it off with the house price index. There are actually three companies that release this data in New Zealand. We've got the Real Estate Institute of New Zealand called RINs, or some people call it RINs. We've also got CoreLogic and then QV. And this is the right tool to use, the right screwdriver or hammer to use when you're trying to see whether property prices are going up or down, and especially if we are looking
3:38 Speaker 00 at council level, regional level or national level. So it would be totally appropriate to look at New Plymouth District Council and whether property values in that area are going up or down. It'd be totally appropriate for the Taranaki region, perfectly appropriate for the national level, but it wouldn't be appropriate right down at the suburb level. And the other thing that's really important when we talk about the RINs house price index is that it is not expressed in property prices. So often when we talk about indexes, a bit like consumer price index, CPI, which is a measure of inflation, these are numbers like 1274, 1356.
4:17 Speaker 00 It's not expressed in the average property is $600,000. Because Ryan's data is not trying to tell you what the average property value is. It's trying to show you how all property values are going up or down. And so that's something that catches a lot of people out. Now, it's very important to understand how this is calculated. So the way that the Ryan's House Price Index works and CoreLogic and QV calculate their numbers in slightly different ways. But this is how it works for Ryan's, which I tend to use. What they'll do is say Auckland properties are currently selling 10% above their CV, their capital value or GV. Okay, well, next month, if properties are selling, the average property is selling 9% above CV.
5:03 Speaker 00 Ah, well, property prices have gone down. If instead they went up to 11% above CV, well, property prices are going up. So what matters is how are property prices moving compared to their estimated value? Now, you can get estimated values from different ways, but in this case, Ryan's uses the CV. Now, that's a lot of nudie stuff in there. And actually, if you want to dig into it, like into a lot of detail. When the Real Estate Institute of New Zealand created this index, they went to the Reserve Bank and said, hey, help us make this index. You can get their entire paper of how they calculated and why they've chosen this method for free on the internet. But if we're thinking less about how was the data created and well, what do I do with it as a property investor, Andrew?
5:48 Speaker 00 How does somebody get this data for free in their area?
5:52 Speaker 01 So we can't actually provide the individual index because that's.
5:56 Speaker 00 Copyrighted.
5:57 Speaker 01 Yeah, that's copyrighted information. But what we did do is rather than give a spreadsheet, we've released a new tool called the Market Mover Calculator. Now, this runs off the Ryan's House Price Index. So what you can do is you can put in your area, your start date, and it shows you how property prices have changed over that period of time. And I've seen lots of people use this tool recently to kind of get a gauge of how their properties have performed compared to the market. So a lot of us have had properties that we've bought and then the values have come down over the last couple of years. So it's quite nice to know, okay, that sucks, but that is pretty normal in this market. And sometimes it won't be, but it's nice to actually know, well, how am I performing compared to the market?
6:43 Speaker 00 The other time you can look out for the Reinz House Price Index, or any house price index, is when you're looking at a graph online. Most of them should say what the data is based on. Now, if it says Reinz House Price Index, which is R E I N Z, House Price Index, or HPI, or if it says CoreLogic HVI, which is Home Value Index, those are both high-quality data sets. And I would be pretty comfortable saying this is a good representation about how house prices are moving right now. But there is other data we should look at. So the second one I want to talk about is average value. And this is provided mainly from CoreLogic.
7:25 Speaker 00 Now, average value is really, really good when you're wanting to see, A, what people are paying for properties, or what a property might cost you in an area. And it's also really good for seeing how a property value is changing within a suburb as opposed to a council area or a wider region. The way this is calculated, and as we get further in this podcast, you're going to realise why this is so good. So I live in Orakee in Auckland. And what CoreLogic will do is they'll say, well, do you know what? Not many properties are selling in my suburb every single month. So it's pretty hard to get a gauge of whether house prices are going up or down. But what we can do, because we've got all of these algorithms
8:09 Speaker 00 and we're smart people at CoreLogic, we can estimate the value of every single property in the suburb. And then we can track the average of those estimates over time. And that is why I use this when I'm looking at capital growth for suburbs. Now, of course, I'd use the House Price Index if I could, but it's not available for individual suburbs. And so I use the right tool for the job. Now, Andrew, there are some weaknesses with this data, though. What are they?
8:37 Speaker 01 Yeah, the big one is that if we're thinking about how house prices have gone up, did the actual value for that suburb go up because house prices went up? Or were there old houses that had been ripped down and then new builds have been built there? And as a result, you've got more expensive properties in the pool.
8:54 Speaker 00 Yeah, and of course, the other big thing is these are estimated values of properties, not
8:59 Speaker 01 Actual sales.
9:00 Speaker 00 Not actual sales. But coming back to your question about, well, is it fake capital growth? Because some properties have been pulled down and rebuilt. I think that's a legitimate question. What I'd always say, though, is data is never going to be 100% perfect. That's why we want to understand how it's calculated, so we know how much to read into it. The other mindset that you should have is don't let great be the enemy of the good, which is sometimes having some amount of data plus our intuition is better than just guessing. And what you don't want to do, I suppose another cliche is to say, don't throw the baby out with the bathwater, which is basically to say, use good data or use data that's 80% good,
9:43 Speaker 00 rather than using no data and just be guessing. And so I would use this, and I do use it, when we're looking at suburbs. The other time you'd use average value is when we're looking at what happened to two groups of properties. So we've done a bit of analysis, Andrew, where we said, okay, we want to know whether new properties or existing properties go up in value faster. Or I did another piece of analysis for the New Zealand Herald about how much does the amount of land impact capital growth? Well, in that case, there's no formal house price index, which is really robust. But what I can do is go to CoreLogic and they'll say, well, we can look at the estimated value of these two groups of properties and track it over time.
10:28 Speaker 00 Well, that's going to be good enough to help us answer that question. So that's when I'd use average value.
10:33 Speaker 01 And is that just because if you were going to work on specific properties, that might only sell every, say, 10 years and so it's really hard to get good data otherwise?
10:42 Speaker 00 Yeah, what you wouldn't want to do is say, okay, let me see all of the new builds that sold in 2008. And then let's only look at those same new builds that sold again in 2018, 10 years later. Well, those new builds that sold might not be representative of all of the new builds that were built in 2008, because we're only looking at small sample sizes. So that's why you'd want to look at average value and be using these average of the E-valuer. So the E-valuation or estimated value, you'd do it because you want it to be more robust, which is better than what the last one is. But just before we get into that, the way you get this average suburb value data for free is we give it away for free in area analyzer.
11:25 Speaker 00 You can use our area analyzer tool and go and use it. And the reason I'm plugging our website a little bit in this podcast is we're probably the only people that give this information away for free. If I knew where else you could get this information for free, I'd also be plugging other websites. But Andrew, what is the last type of data?
11:42 Speaker 01 Well, this is the one that gets ed hot under the collar and that's median sale price. And the reason it gets ed worked up is because this is the one that you'll see every developer or every real estate agent put online and basically suggest that house prices are always going up. What it works on is it shows you sale prices for any given month. But the problem is you might have a whole lot of properties sold in February that are cheaper than the ones sold in March and now it looks like house prices are going up. That's not the case. It's just that more valuable properties have sold in March.
12:15 Speaker 00 Yeah. So the median sale price, what this will do is they'll say, what are all of those properties that sold in February? Okay, the median of those 100 properties or however many in your area, the median of that is 800,000. Okay. Now we're in March. Okay. What were all of the properties that sold in March? Okay, I've got those now. What's the median of that? Okay, the median of that was 850,000. So month to month, the median sale price went from 800 to 850,000 dollars. And you might look at that, woo-hoo!
12:48 Speaker 01 Good time to buy.
12:49 Speaker 00 House price is up fifty thousand dollars in a single month. Well, did they really go up fifty thousand dollars in a single month? Or twenty thousand dollars or whatever it happens to be? Well, no, it's just that the properties that sold in March are different from the properties that sold in February. And because they're different properties, they're going to have different sale prices. And because of that, you're going to get a lot of up and down. So that's why I always say median sale price, it just jumps around all the time. And so I've, I've called this trash data in the past. And it definitely is trash data. When you're trying to track month to month or general price trends about whether properties are going up or down.
13:34 Speaker 00 Now, having said that, it does have a very specific place. So median sale price data can be good when you're trying to answer the question, what are people paying for properties? Cause that does tell you, okay, well, what did the average person pay for a property in a specific month? The other time where you can use it, but I would be very careful about it. And whenever I use it on, on YouTube, I'm always like, I'm using median sale prices. It's because it's the only thing available. So be careful about the conclusions you draw. It can be useful when we are looking at particular scenarios that require a lot of slicing and dicing of data.
14:14 Speaker 00 So what I mean by that is if you are a real estate agent, or if you are like us and we pay money to get the data, you can log into the Ryan's Statistics Portal and you can pretty much look at median sale prices for anything. You could say, okay, I only want to look at properties with three bedrooms and two bathrooms. What happened there? Or I only want to look at properties that are townhouses or units that have four bedrooms and one bathroom. What was the median sale price of those? So you can get really, really specific in a way that isn't generally available. So if you're looking to slice and dice that data down, that's when it can be useful. But you've got to be really careful with it when you're saying, okay, are property prices going up or down? Now you can get most of that data again for free.
14:58 Speaker 00 Both on our website, interest.co.nz, they also release a lot of the median sale price data for most of the regions, not down to the individual council level, but down to the regional level. So you can get some of it on their website as well. But just before we wrap up, why are we talking about this? Well, hopefully it gives you a sense of what to look for when you're reading a graph on stuff.co.nz or you're on one roof and you see a graph and you're like, well, what was the data source and is that good data or not? So hopefully that gives you a bit of confidence. But hopefully that also lets you know that when we're talking about data on this podcast, we're not shooting from the hip. You know, there's a reason why we might use a different data source and why it might not always be the Ryan's House price index. But what we will do is always use the best
15:43 Speaker 00 available data for the task at hand. And that word available is very, very important because not all data is created equally, but we've got to use the tools that we have available. But you should always ask that question. Well, how is this data collected and can I really trust it? Just make sure that you're not making great the enemy of the good. So over the last 15 minutes, you've learned the three types of data you can use in property investment and when to use them. The worst data to use, the one to avoid if you can, median sale price data, and where to get all of this data for free. Right, let's wrap it up there, but please don't forget to rate, review and subscribe to the podcast. Really does have a scary message out to more people.
16:30 Speaker 00 Thanks for listening to the Proper Academy Podcast. I'm your host, Tim Bicknight. And I'm Andrew Nicoll. We're going to be back here tomorrow with even more daily strategies, tactics and insights to help you get the most out of the new property market. Until next time.
Previous The 7 worst properties to buy in 2025⎥Ep. 2069 Next We investigate NZ's housing oversupply crisis⎥Ep. 2071 Page updated November 15, 2026 · transcript and summary are machine-generated