Can you provide a spreadsheet of the last 3 months of eBay used cue sales?

Paul_#_

AzB Gold Member
Gold Member
See Google Drive link below for 78-MB file of all eBay used cue sales of the last 3 months. It is a file of an eBay listing of each sale, each item’s sale title, each item’s selling price, each item’s shipping charge, and each item’s photo from the sales of the last 3 months.

It would be nice to use that database to make a spreasheet of each used cue sale and each sale item: cue brand, sale price, shipping charge, total sale price, and sale date. Can you do that?

It would be even better to have a copy of each sale-item description: the seller’s sale-item title, seller’s comments, and all the seller’s photographs. This can be done by accessing eBay and searching for sold, used pool cues. For each item listed on eBay, click on the item’s title.

This will lead you to each item’s listing. Although the top of that page notifies you the item was sold and provides you photos of similar items, scrolling down will show the sale-item’s seller comments, and photos. Saving the file won’t give large photos but only the smaller photos.

Find database of all pool-cue sales at eBay for last 3 months at this Google Drive link:

I also include a file of the 284 sales of Meuccis from the file of all cue sales. The Meuccis are sorted from cheapest sale ($69.80 for “Meucci Originals MO-1 Pool Cue (1980s) with soft case) to most expensive ($1283 for Meucci Originals – Hubbart Pool Cue -4 points with veneers & loaded with inlays).

Find the Meucci database at

Databases were prepared as follows:

In eBay, search in the billiards category (probably should search in billards category, and sub-category cues) for POOL CUE.

Use filters of sold items, completed items, and used.

Make copy of the search. Do this by “printing’ it and selecting a printer of “Microsoft Print to PDF”. For each file, use Adobe’s OCR to convert images to text.

Find attached on this AZ forum a copy of just the Schmelkes sold on eBay from the last 3 months.
 

Attachments

So you or someone would need to write a scrapping program that could run the search query on eBay and then pull down the target data values and load them into a preformatted table.

There is no way to take your PDF and convert that into tableized data that I know of unless there is some AI/GPT type process that could do it.
 
To track the sales records of certain brands/models to know if their perceived value is going up or down.

Also to know what a fair price would be for a cue you were selling or buying
This will plummet the value of cues because the cue market isn’t so good right now. A lot of people are going to be holding on to them.

I’ve thought of this a while back. I wanted it similar to Stock X.

Let’s say a bunch of SW cues are out on the market for 6 months and not sold. Average price is 6k. Then all of a sudden one sells for 3K because the seller was desperate.

3k is now the benchmark price according to data.

There’s plenty of these sites with trading cards.

I’m sure you can make one. It won’t be able to differentiate material unless the programmer digs deeper.
 
Last edited:
There is no way to take your PDF and convert that into tableized data that I know of unless there is some AI/GPT type process that could do it
I’m sure you can make one. It won’t be able to differentiate material unless the programmer digs deeper.
The task of putting the 78MB file into a spreadsheet would be helpful but, like Shooter_hans notes, the meat is only if you dig deeper. eBay does provide some stats on each make. Look at the Meucci or Schmelke files I posted. eBay provides graph showing Meucci used cues sold between about $60 and $1300 versus Schmelke's $20 to $200. The median value can be estimated with the graph, too.

The 78MB file only provides the item title as far as a description. That might not be too helpful. The website that described the item, however, gives the seller's comments on the item and photographs. With that, one could identify, for example, Hueblers by age or logo. It would include info such as the cue wobbled, the sale was only a butt or shaft.

Still, its a treasure house of info. Using the three months as a guess, eBay sells each year about 12,000 used cues (not new or cues for parts) of which 1,000 are Meucci, 600 Players, 200 Hueblers.

Let’s say a bunch of SW cues are out on the market for 6 months and not sold. Average price is 6k. Then all of a sudden one sells for 3K because the seller was desperate.

3k is now the benchmark price according to data.
I think some buyers are smarter than that.
Also, there are too many Hueblers and Meucci being sold. Even if one or two sold at unrealistically low prices, the average still would be much more than that.
 
See Google Drive link below for 78-MB file of all eBay used cue sales of the last 3 months. It is a file of an eBay listing of each sale, each item’s sale title, each item’s selling price, each item’s shipping charge, and each item’s photo from the sales of the last 3 months.

It would be nice to use that database to make a spreasheet of each used cue sale and each sale item: cue brand, sale price, shipping charge, total sale price, and sale date. Can you do that?
The proper way would be to use ebay's own APIs.

Trying to develop something to read html embedded into a PDF and generate a spreadsheet is just idiotic.
 
This has been a popular trend in the scotty cameron putter world and I've been wondering when it would make its way here. Its pretty interesting to see how the prices fluctuate so much.
 
See Google Drive link below for 78-MB file of all eBay used cue sales of the last 3 months. It is a file of an eBay listing of each sale, each item’s sale title, each item’s selling price, each item’s shipping charge, and each item’s photo from the sales of the last 3 months.

It would be nice to use that database to make a spreasheet of each used cue sale and each sale item: cue brand, sale price, shipping charge, total sale price, and sale date. Can you do that?

It would be even better to have a copy of each sale-item description: the seller’s sale-item title, seller’s comments, and all the seller’s photographs. This can be done by accessing eBay and searching for sold, used pool cues. For each item listed on eBay, click on the item’s title.

This will lead you to each item’s listing. Although the top of that page notifies you the item was sold and provides you photos of similar items, scrolling down will show the sale-item’s seller comments, and photos. Saving the file won’t give large photos but only the smaller photos.

Find database of all pool-cue sales at eBay for last 3 months at this Google Drive link:

I also include a file of the 284 sales of Meuccis from the file of all cue sales. The Meuccis are sorted from cheapest sale ($69.80 for “Meucci Originals MO-1 Pool Cue (1980s) with soft case) to most expensive ($1283 for Meucci Originals – Hubbart Pool Cue -4 points with veneers & loaded with inlays).

Find the Meucci database at

Databases were prepared as follows:

In eBay, search in the billiards category (probably should search in billards category, and sub-category cues) for POOL CUE.

Use filters of sold items, completed items, and used.

Make copy of the search. Do this by “printing’ it and selecting a printer of “Microsoft Print to PDF”. For each file, use Adobe’s OCR to convert images to text.

Find attached on this AZ forum a copy of just the Schmelkes sold on eBay from the last 3 months.

I couldn’t access those files on Google Drive. Are they just big PDFs of all the listings? If so, it wouldnt be hard to write a python script to extract information from the pdf and save it into a csv.
 
This has been a popular trend in the scotty cameron putter world and I've been wondering when it would make its way here. Its pretty interesting to see how the prices fluctuate so much.
Also sports cards. I use to go a site that showed this.

I use to document the For Sale section and gave up. Print screen save the file under whatever the cue is. Very archaic but works. Lol
 
I couldn’t access those files on Google Drive. Are they just big PDFs of all the listings? If so, it wouldnt be hard to write a python script to extract information from the pdf and save it into a csv.
If it works correctly, you click on the link above, Google Drive tells you that you must ask me for permission to download. You agree and click, and Google Drive sends me email. I respond with viewing permissions and approve. GoogleDrive only told me of one person who wanted to view the larger file --- AZer, Mr. Laughlin. I gave him viewing privileges. He is one person who has permission to download either file.

The file is a large pdf file with searchable text. It is composed of about fifteen eBay screen downloads of the pool-cue search with about 240 sales per screen.

The proper way would be to use ebay's own APIs.

Point taken. Can you explain more to a lay person? I presume you take the html file and go from there. Sounds difficult to me but I know near zero about programming. Your opinion on Python option?
 
This will plummet the value of cues because the cue market isn’t so good right now. A lot of people are going to be holding on to them.
Then you would have fewer SW cues hitting the market and the prices would start to go back up.

Data cuts both ways and allows for both an informed buyer and seller.

Personally, I love the thought of having a resource for cue prices, I also collect silkscreened posters, and the best website for that hobby shows a lifetime graph for all recorded sales for every poster in their database.

Screenshot 2024-07-08 100807.png


Screenshot 2024-07-08 101325.png


We need something similar here!
 
Last edited:
If it works correctly, you click on the link above, Google Drive tells you that you must ask me for permission to download. You agree and click, and Google Drive sends me email. I respond with viewing permissions and approve. GoogleDrive only told me of one person who wanted to view the larger file --- AZer, Mr. Laughlin. I gave him viewing privileges. He is one person who has permission to download either file.

The file is a large pdf file with searchable text. It is composed of about fifteen eBay screen downloads of the pool-cue search with about 240 sales per screen.



Point taken. Can you explain more to a lay person? I presume you take the html file and go from there. Sounds difficult to me but I know near zero about programming. Your opinion on Python option?
I'm sure since @kling&allen doesn't think it would be hard to do a python script to do it for you, I'd consult with him if I were you. Good luck with that.

An API (application programming interface) is basically a way to programmatically do things and is created and approved for public use by whoever owns the application (ebay is the owner and application in this example). Loosely you could compare a business's front door during business hours being the API for the public to use to purchase that business's products. Scripting something with python to scrape text from a bunch of html in a PDF is like trying to access a business's products through pictures of a sewer that drains from a toilet in the back of the business.
 
All this information you require would highly depend on the end user filling item specifics. In my experience people are lazy about doing this.
 
Then you would have fewer SW cues hitting the market and the prices would start to go back up.

Data cuts both ways and allows for both an informed buyer and seller.

Personally, I love the thought of having a resource for cue prices, I also collect silkscreened posters, and the best website for that hobby shows a lifetime graph for all recorded sales for every poster in their database.

View attachment 766414

View attachment 766416

We need something similar here!

No, we don't.

Discretion works.
 
Back
Top