eBay files in Excel
keets
Posts: 25,351 ✭✭✭✭✭
Does anyone else track auctions? I use excel and track eBay sales of Jefferson Nickels, MS66FS and proof issues PR66 for pre-1950, CAM/DCAM through 1962, DCAM for SMS and PR69DCAM for any dates I still need in my sets, PCGS holdered. I'm not fanatical about it, but I try to keep a watch on the dates that I still need plus any that bidders keep at strong levels so I have an idea of what to look for as I'm rummaging through sets and singles. My files are simple-----date/MM, grade, holder serial #, buyer, sale date and price.
I started doing this in late 2001. Since that time it's rather interesting to note the price increases in the series, especially the mint state coins which is what I really focus on. I try to have at least 10 sales before I bid on a coin and that usually gives me a good average price over at least a years time. Of course, if prices are low I'll snag a coin and delete the files.
Today I was clearing out my eBay watch list, wondercoin and a seller ID of caugusti had quite a few nice dates listed in the past week. That's what prompted this post. I noticed coins which were bought in the last year and sold off quickly, sequential serial numbers, new players in the series and some wild price fluctuations. Some regulars like tim schmitz picked up a few nice coins at bargain basement levels.
Does anyone else watch a segment of the hobby like this??
Al H.
I started doing this in late 2001. Since that time it's rather interesting to note the price increases in the series, especially the mint state coins which is what I really focus on. I try to have at least 10 sales before I bid on a coin and that usually gives me a good average price over at least a years time. Of course, if prices are low I'll snag a coin and delete the files.
Today I was clearing out my eBay watch list, wondercoin and a seller ID of caugusti had quite a few nice dates listed in the past week. That's what prompted this post. I noticed coins which were bought in the last year and sold off quickly, sequential serial numbers, new players in the series and some wild price fluctuations. Some regulars like tim schmitz picked up a few nice coins at bargain basement levels.
Does anyone else watch a segment of the hobby like this??
Al H.
0
Comments
MCDBA MCSA MCP
SQL Server Database Admin
SQLgeek.org
Tom
MCDBA MCSA MCP
SQL Server Database Admin
SQLgeek.org