Welcome, Guest
Username: Password: Remember me

TOPIC:

An analysis of DNW's QSA data from 1991 5 years 4 months ago #61458

  • djb
  • djb's Avatar Topic Author
  • Offline
  • Administrator
  • Administrator
  • Posts: 31662
  • Thank you received: 4519
Rory,

I would like to look at that. I have started to separate the regiment from the QSA naming but this is going take quite a while to complete accurately.
Dr David Biggins

Please Log in or Create an account to join the conversation.

An analysis of DNW's QSA data from 1991 5 years 4 months ago #61459

  • djb
  • djb's Avatar Topic Author
  • Offline
  • Administrator
  • Administrator
  • Posts: 31662
  • Thank you received: 4519
The most common number of clasps per QSA is 3.

Dr David Biggins
Attachments:

Please Log in or Create an account to join the conversation.

An analysis of DNW's QSA data from 1991 5 years 4 months ago #61460

  • djb
  • djb's Avatar Topic Author
  • Offline
  • Administrator
  • Administrator
  • Posts: 31662
  • Thank you received: 4519
A look at QSAs (singles and groups) containing a Defence clasp.



This shows that the average cost of DoL QSAs has slightly declined in the last 5 years, that DoK QSAs has slightly increased and that DoM QSAs has shown a sharp rise.

As examples, the 4 DoM single QSAs sold this year hammered at £1,600, £1,700 and 2 at £3,000 giving a mean actual cost of £ 2,790.

Defence clasps by frequency:

Dr David Biggins
Attachments:
The following user(s) said Thank You: dunnboer

Please Log in or Create an account to join the conversation.

An analysis of DNW's QSA data from 1991 5 years 4 months ago #61463

  • SWB
  • SWB's Avatar
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 1837
  • Thank you received: 451
Very interesting David, so the median price of QSAs is falling at DNW - that would back "market sentiment". Is the £204 figure inclusive of premium etc?

This data could be dangerous - especially where the sample is so small, such as Defence medals. I could see hopeful sellers taking the 2018 mean as a guide for the medal they are selling..

When I was doing Findamedal.com some years ago I wrote a number scripts in VBA to unpick dealer's lists to load the data into a database. Fiddly, but usually successful until they became inconsistent. DNW should be ok as they faithfully reproduce the naming on the medal - typos excepted.
Researcher & Collector
The Register of the Anglo-Boer Wars 1899-1902
theangloboerwars.blogspot.co.uk/
www.facebook.com/boerwarregister

Please Log in or Create an account to join the conversation.

An analysis of DNW's QSA data from 1991 5 years 4 months ago #61467

  • djb
  • djb's Avatar Topic Author
  • Offline
  • Administrator
  • Administrator
  • Posts: 31662
  • Thank you received: 4519
Meurig,

Yes, the values include commission at the appropriate rate.

Data can always be mis-used. This is not a prediction of the future but a record of the past. If sellers do choose the auction route, they will need to aware of the many factors that affect returns.

It will be interesting to dis-assemble the naming and see how many patterns emerge. Looking at the regiment, there are 4 patterns so far and I would imagine there will be more.

Kind regards
David
Dr David Biggins

Please Log in or Create an account to join the conversation.

An analysis of DNW's QSA data from 1991 5 years 4 months ago #61475

  • Frank Kelley
  • Frank Kelley's Avatar
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 6739
  • Thank you received: 954
I think it is rather pleasing that a regimental collector can still go out and buy a medal, often for somewhat less, even at retail, than the average price, from this particular saleroom.


djb wrote: The next plot shows the mean and median prices for QSAs (as singles and in groups) since 1991,



The mean is the average price for all QSAs sold in the year. One of the shortcomings of the mean is that it is very susceptible to outliers (for example, very expensive groups containing a QSA). For this reason, the median or middle value when prices are ranked from cheapest to most expensive can give a 'better' average for QSA prices in a year. That the median is lower than the mean shows that the price distribution has a positive skew and that there are many expensive QSAs in the tail of the distribution to the right of the centre of the distribution.

It is interesting to note how the median value has only increased gradually over time. This year's results have been affected by the number of individual, colonial and IY, QSAa offered for sale. But this year is also not yet complete.

In case you are wondering what caused the peaks in the means, 2015 saw the sale of the VC group to 3105 Dvr. F. G. Bradley, 69th Bty. R.F.A. and 2012 the VC group to 2332 Serjt. W. B. Traynor, W. York Regt. The Magersfontein Victoria Cross group to Sergeant J. D. F. Shaul, Highland Light Infantry, was sold in 2006.

This analysis suggests the current, average price for a QSA (single or group) is £ 204, R 3600, Au $ 355, Can $ 350 or US $ 260.

Please Log in or Create an account to join the conversation.

Moderators: djb
Time to create page: 0.622 seconds
Powered by Kunena Forum