Project Title: Scraping Auction Results from Sothebys
We need to record the realized auction prices of diamond studs on the Sothebys website.
To do this properly, we need to categorize the diamonds
Go to Sothebys.com
In the upper right, search “diamond studs” –> 1717 results.
Filter on left –> Date > Past –> 1701 results.
Each stud has two “main” diamonds. The “main diamonds” are the big stones in them.
What you need to do is go to the description and get the details on each main diamond. Sometimes studs will have smaller diamonds around them. We don’t care about these smaller diamonds. We also don’t care about “total carats.” What we care about are the details of the two large diamonds in the pair.
You can find this in one of two places. The first is many listings have the GIA certificate.
The other way is to read the description writing down what the GIA report says. For example: Two GIA reports no. 2175749065 and 2175716051, stating that the 1.53 and 1.28 carat diamonds are E and F Colour, VS2 and VVS1 Clarity respectively. You need to be very careful not to mix this stuff up.
There are two diamonds in each pair, all of the columns will be the same for each diamond except weight, color, clarity.
To get the date, find the date of the auction. For example, in this listing, https://www.sothebys.com/en/buy/auction/2020/fine-jewels-10/pair-of-diamond-studs-1-53ji1-28ka-la-gu-dian-xing find the lot number and click the word before it. In this case, the word before it is “Hong Kong”. That will bring you to the auction listing and you can find the date.
Put this into excel.
For similar work requirement feel free to email us on firstname.lastname@example.org.
Description of requirements/functionality:-
I have a website that I am looking to scrape and perform actions on the site depending on the data that is scraped.
This is NOT just a scraping project – most of the effort will be in applying the automation.
Can you help?
I would like a program to scrape data from an online auction site and store the information in a normalized fashion.
The program will need to go through each category, then each listing for each category and store the data into the mysql database.
Some of the fields that I need are:
Do you have ability to scrape data from auctions on eBay (US).
I’m interested in tracking and storing final sales prices on items SOLD on eBay to compile a database of prices on select items (i.e. baseball cards).
We are interesting to create website similar to poctra.com, we need to extract daily auction data from poctra.com, Copart and IAAI Auto Auction Data.