Question about Heritage Auction Archives

Longacre

Does anyone know if there is any way to sort and convert the auction archives into an Excel file? For example, if I want to make a graph of the price trends for the past 6 years of the 1841-O $10 in AU-55, is there an easy way to do it automatically, rather than printing the entire 1841-O listing and manually inputting the information into a spreadsheet (and then graphing it)? Can anyone help? Thanks.

morgannut2

A computer person told me it was more trouble than its worth. And I found that I had to manually check each 1893S Morgan anyway (the one I was checking) because such a large number had "NET" grades that you could only asertain by looking at each sale---very, very slow.

RYK

Even if you could do it, it would not be meaningful for your example (41-O $10 in 55). There may be original ones, shiny dipped ones, ones that will be over-graded, and ones that will be undergraded. Actually, for AU-55, there may not be more than a couple of transactions.

For a coin that trades frequently, like a 16-D Merc dime in G-4 or an 09-S VDB 1c in MS-64, it would be helpful. For a scarce and thinly traded coin, like your example, it probably will not be.

kranky

It's doable but painful. Once you get the web page with the data you want, save it to your computer. Then open the saved web page in Excel. You will need to remove the hyperlinks (see this page) and monkey around with it, but you could eventually get there.

WACoinGuy

Too thinly traded. I just took a quick look at their archives and they have 18 examples of an 1841-O Eagle at auction, only one of which is an AU-55: link. And that one sold 10 years ago...

Longacre

Thanks for the responses so far. I just used that coin as an example of what I wanted to do in Excel. I wasn't trying to imply that that was the coin I wanted to chart (I just picked it out of thin air; it probably was a bad example). I am mainly interested in the process. Thanks and sorry for the confusion.

RYK

Amongst the New Orleans $10's, the only ones that trade frequently enough to verify any trend in pricing MIGHT be the 43-O, 47-O, 51-O, 53-O, and 54-O (LD), the most common.

Gonfunko

If you have XP, IE has an option next to a notebook-looking thing on the taskbar that allows you to edit webpages using Publisher, Word, Excel, etc. I'm not sure how it would work, but it might be worth a shot.