Used Car vales Database

[RatLad]

Hi all,

I have been working on a database that tracks the value of used 'Performance' cars over the last five years.

The idea behind it was to analyse the value of numerous performance cars to hopefully ascertain which cars are appreciating in value/ hit the bottom of their depreciation curve. For example, in 2009 the average cost of an S1 Elise 111S was £9,000, now the average is more like £10-11K (based on market value).

Obviously, this is a large project and wondered if anyone has come across anything similar as Glass' guide really isn't representative of true market value?

Cheers

[Ballistic]

RatLad said:

Hi all,

I have been working on a database that tracks the value of used 'Performance' cars over the last five years.

The idea behind it was to analyse the value of numerous performance cars to hopefully ascertain which cars are appreciating in value/ hit the bottom of their depreciation curve. For example, in 2009 the average cost of an S1 Elise 111S was £9,000, now the average is more like £10-11K (based on market value).

Obviously, this is a large project and wondered if anyone has come across anything similar as Glass' guide really isn't representative of true market value?

Cheers

How are you defining true market value? The price cars are advertised at or what they are actually selling for? If the later where do you find this kind of information?
I always thought the prices in Glasses/CAP are a guide to what the trade deal at.
Out of interest, what are you proposing to do with this database?

[uncinquesei]

RatLad said:

Glass's guide really isn't representative of true market value?

"Q) How do Glass’s create a valuation?
A) This is a combination of observed market prices and field research conducted and analysed by our team of expert Editors. Over the next year we will process over 1 million auction trade prices and 2.5 million asking prices from independent and franchise dealers."
"Glass's Guide is the highest circulating title in the market, with over 90%
of car dealers subscribing"
As above, it depends what you consider true market value to be. I would aver that Glass's is the best guide in a very subjective area....

[Efbe]

RatLad said:

Hi all,

I have been working on a database that tracks the value of used 'Performance' cars over the last five years.

The idea behind it was to analyse the value of numerous performance cars to hopefully ascertain which cars are appreciating in value/ hit the bottom of their depreciation curve. For example, in 2009 the average cost of an S1 Elise 111S was £9,000, now the average is more like £10-11K (based on market value).

Obviously, this is a large project and wondered if anyone has come across anything similar as Glass' guide really isn't representative of true market value?

Cheers

You may have to ignore quite a few people on this one.

I have seen this done by a lad at work who created some macros from Excel to scan Ebay's completed listings for prices and amalgamate them into some datasheets, plotting car makes, models and values over time.
It didn't work brilliantly due to poor postings on ebay, but he was able to track a few specific models over the course of a year at a monthly interval.

I helped him with some of the VB involved in this, but tbh he should have been getting his data from elsewhere as ebay is not a great place for this!

The difficulty is in creating a database for it, then working out the average selling price. Why it's difficult, is because you have modded cars, concourse cars and cat D cars in there as well, so the type of average you will have to use is complex. I would surest removing the top 10% and bottom 10% of prices then use a modal average on a rounding of the numbers. for example round each cars value to the nearest 1000, then take the most commonly used price (mode average)

What coding are you using to extract the data, where are you storing it, and what sources are you using for your data?