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

Badpenguin said:
Scripting something with python to scrape text from a bunch of html in a PDF is like trying
Click to expand...
Just to be clear, I didn't save a file of html code. I copied what you see on the computer screen.

Maybe what Badpenguin is saying that I should have saved the search results as an html file (or mhtml?). A user could read that file of search results in his browser. Web links would be available and words searchable. I would not have to save the web pages to pdf and OCR them to be text searchable. My 78 MB pdf file has no links and, to get to the original sale item, I need to open browser, redo eBay search to find sale item, and click on item title.

Zerksies said:
All this information you require would highly depend on the end user filling item specifics. In my experience people are lazy about doing this.
Click to expand...
If you mean the information in the database? There is no end user for the info --- that is whatever the seller put in the title of his sale on eBay and eBay's note on sale price.

There is also the seller's additional description he provided in his sale description --- that would require a separate download of each seller's sale-item web page. Even if the seller did not know much about the cue, the seller's photos may provide information unknown to seller but known to an AZer. This information must be discovered and added cue by cue. It would improve results.
 
Paul_#_ said:
Just to be clear, I didn't save a file of html code. I copied what you see on the computer screen.

Maybe what Badpenguin is saying that I should have saved the search results as an html file (or mhtml?). A user could read that file of search results in his browser. Web links would be available and words searchable. I would not have to save the web pages to pdf and OCR them to be text searchable. My 78 MB pdf file has no links and, to get to the original sale item, I need to open browser, redo eBay search to find sale item, and click on item title.


If you mean the information in the database? There is no end user for the info --- that is whatever the seller put in the title of his sale on eBay and eBay's note on sale price.

There is also the seller's additional description he provided in his sale description --- that would require a separate download of each seller's sale-item web page. Even if the seller did not know much about the cue, the seller's photos may provide information unknown to seller but known to an AZer. This information must be discovered and added cue by cue. It would improve results.
Click to expand...
I don't have access to the google datafile. So i don't know what the file contains. But I work with datafiles all day.

The #1 issue always is People and how well people input the data and people are quite lazy.

Making a database of such things is probably a waste of time, eBay has their own tools for such things the Advanced search function and it does a wonderful job of doing such things. I use to be a reseller and i used that tool daily to find pricing and see how much i could buy something for.
 
I also work with data.

I copied the text from the Schmelke sample PDF, and tweaked it with an editor (TextPad). It was simple enough to get separate records, but normalizing the columns would take a bit more time/effort--although, a lot of the data can simply be thrown out (like pretty much everything after the sales price, except for the Shipping cost). Then, it can be imported into Excel--or copy/pasted (the data defaulted well into the data types--like, no needing to change everything to text before pasting, and then changing back things like the price and shipping).

However, I agree w/ the others, as far as finding a way to scrape it directly to what you need, or as Zerksies suggests, using the eBay tools. Although, I am not so familiar with the eBay tools, so defer to his expertise.
 
Badpenguin said:
The proper way would be to use ebay's own APIs.
Click to expand...

heater451 said:
, or as Zerksies suggests, using the eBay tools.
Click to expand...

Badpenguin and Zerksies may also have been referring to eBay's Terapeak --- a tool that helps eBay sellers analyze eBay sales. eBay describes it:

Terapeak is an eBay service, a suite of exclusive insights tools for market analysis. Terapeak uses recent eBay supply, demand, and pricing data to help you determine what to sell, when to sell it, and at what price. Research market trends based on real data from millions of eBay transactions to effectively strategize your sales.​


See https://export.ebay.com/en/marketing/ebay-services-and-tools-help-seller/terapeak/
 
Paul_#_ said:
Badpenguin and Zerksies may also have been referring to eBay's Terapeak --- a tool that helps eBay sellers analyze eBay sales. eBay describes it:

Terapeak is an eBay service, a suite of exclusive insights tools for market analysis. Terapeak uses recent eBay supply, demand, and pricing data to help you determine what to sell, when to sell it, and at what price. Research market trends based on real data from millions of eBay transactions to effectively strategize your sales.​


See https://export.ebay.com/en/marketing/ebay-services-and-tools-help-seller/terapeak/
Click to expand...
Terapeak is garbage. I'm talking about the advanced search function on the website and app. You put in the things you are looking for and filter
 
Paul_#_ said:
Badpenguin and Zerksies may also have been referring to eBay's Terapeak --- a tool that helps eBay sellers analyze eBay sales. eBay describes it:

Terapeak is an eBay service, a suite of exclusive insights tools for market analysis. Terapeak uses recent eBay supply, demand, and pricing data to help you determine what to sell, when to sell it, and at what price. Research market trends based on real data from millions of eBay transactions to effectively strategize your sales.​


See https://export.ebay.com/en/marketing/ebay-services-and-tools-help-seller/terapeak/
Click to expand...
No, I was referring to the developer APIs, not anything else...

 
Paul_#_ said:
Maybe what Badpenguin is saying that I should have saved the search results as an html file (or mhtml?). A user could read that file of search results in his browser. Web links would be available and words searchable. I would not have to save the web pages to pdf and OCR them to be text searchable. My 78 MB pdf file has no links and, to get to the original sale item, I need to open browser, redo eBay search to find sale item, and click on item title.
Click to expand...
Yes, saving the search results as html would at least allow someone to load it and use the DOM to extract what you need.
 
Badpenguin said:
Yes, saving the search results as html would at least allow someone to load it and use the DOM to extract what you need.
Click to expand...
See search results of sold cues from the last three months at eBay in web-browser friendly HTML format in link below.


To use file: click link above, ask me for permission to use, I give you permission, you download file onto your computer, click on the file name, your browser should open it up in its browser.

If you are familiar with eBay searching, using eBay to search for items may be easier than using this file.

What this file does, however, is its search results should be available forever. eBay only searches the last three months and eBay will lose all the results in this file in three months. I am not sure whether all the links in this file will be okay in the future.

The file lists only used, sold items sorted by cost (sale price plus shipping). If the item is “Best offer accepted’ and the price green-lined out? It sold for something less than the price listed.

I searched for items using the words ‘pool cue’. eBay limited the results to 2500 hits
 
Last edited:
You must log in or register to reply here.
Back
Top