Thursday, September 22, 2011

Watch Valuation the Hard Way

You want to sell a watch but you're not sure what to ask for it. Too high - it may not sell; too low - you lose out. If you have the time, here's a scientific way to figure a market value.

First go to your country's eBay and do a search for the same model as your watch. Then, staying in that search, click on the checkbox that says "completed listing only" or words to that effect. Now start writing down all the prices where the watch actually sold (at auction, not buy-it-now). You might like to weed out prices for watches that are not your actual model or are not in a similar condition as yours. But a little diversity can be beneficial, for example when there are only a few watches of your exact model, dial color, etc. Something like 20 prices should do it, more if you have the patience. Less than 6 prices would only give you a rough idea.

Now you select some price ranges, somewhere between 10 and 20% of the total range of the prices that you found. For example, if the "spread" (max minus min) is 600-100 = $500 and you found a good few sold items then your ranges could be 500/10 = $50, i.e. 100 to 149, 150 to 199, and so on up to 600-649 (just in case a watch was actually $600, if not - the last range would be 550-599).

Next you count up the prices that fall within each range and list them with an "X" for each watch found:
You can see that the 'X's form a horizontal bar chart which shows quite clearly that the range with the most sales is the $400-449 range. The other ranges indicate either worse or better condition, if the market***  is to be believed. So, if you consider your watch to be in average condition, a selling price in the $400-449 range would give you a reasonable chance of a sale. The higher ranges would be appropriate for a better condition and vice-versa. The shape of this particular  bar chart tells you more about the model of watch. The majority of the 'X's are at the higher end of the total price, indicating a sought-after model for whatever reason - quality, name, rarity, etc.

***Remember, "the market" in this example is eBay in the country or countries where you intend to sell. If instead you had researched prices obtained by Retailers in the open market, prices would be higher and less realizable in a different market.

Here's some results from a search for Luminox "Navy Seals". About 20 results were found, of which 6 were rejected for various reasons - like, one item was a Luminox box but no watch.

Column A shows the prices found on eBay, sold recently, and searched for as Luminox "Navy Seals". The average of the 14 prices is shown in row 16. At $119, this value falls into price range 3 (100-129) but the chart shows that the average is quite a bit higher than price range 2 (70-99) which has the highest count. This is because the chart values are "skewed" toward the lower end of the total price range, indicating a much less well-regarded watch than our other example above, The chart is telling you that, for a watch in average condition, a selling price selected from price range 2 would have a better chance of selling. It is also implying that simply taking the average of the prices as the sole criterion for your sales price would have put you too high. Worse, had you been selling an expensive, high quality watch, your price could have been 10-20% too low.

Row 17 shows a price of $110 as the "median" a word much-loved by statisticians and much avoided by the rest of us. However, this median value is a lot closer to price range 2 than the average is, so there must be something to it. Having said that, the median is not easy to figure out unless you use a spreadsheet function like in the above. Simplistically, it's a value which is in the "middle" of an ascending range of prices. With the 14 prices as shown above, it lies somewhere between the 7th and 8th price, i.e. the median value is between $95 and $125, QED.

In conclusion, it's worth at least picking some ranges and filling in the 'X's. Picking the longest bar gets you closer to establish a good criterion by which you can judge and price your own watch for the market. Simply figuring the average from the prices can throw you off quite a bit, either way. Doing a spread-sheet is fun for geeks but is quite un-necessary.

Best regards, xpatUSA

Saturday, September 17, 2011 Web Site Updated

In the beginning, there was simple HTML which stands for HyperText Markup Language. Couldn't do a lot with it but it was nice to be able to include "hyper" links to related documents or to be able to link to other places within a long document. The ability to link to pictures stored elsewhere was especially welcome as means of creating an illustrated document without having to learn how to "embed" pictures or drawings in it.

Following on from those good old days, HTML has developed beyond all recognition to the point of being almost unintelligible. Not to mention the emergence of XHMTL with it's Draconian rules and it's incestuous relationship to XML, XSL. There also appeared scripting languages such as JavaScript, which allow a page to be messed with once your Browser of choice has downloaded it and displayed it on your screen.

One good development was something called CSS which allowed you to write up your subject and then to apply rules separately on how it should look. It was also a pleasure to discover that HTML5 has appeared and sounded the death knell for XHTML in all it's horrible varieties.

Meanwhile, like the good techie that I am, I had developed my website into a paragon of scripting such that you couldn't even view my pages properly without having JavaScript enabled in your browser. That meant that every bit of content showed by JavaScript in my pages had to be repeated as plain old HTML with "NOSCRIPT" tags around it - double the pain for no gain.

"Enough already" as they say. I've just changed to HTML5 for my collection pages. Completely separate CSS files now say how they look. Any scripting is used only for minor functions, like "back to the top" links which have little effect if they don't work.

I also took the opportunity to show the collection in thumb-nail format with each thumb-nail being a clickable link to a page showing bigger pics and more information. Previous visitors will notice a simpler horizontal navigation bar up top instead of at the side. Makes room for more watches!!

So, click here and see how it looks now.

Best regards, xpatUSA