Hello,
I have gone through your files and the sites, and can offer you a .NET Window tool, which you can run from your desktop, by a click of a button.
It will-
1. accept as input the URL of the auction, of any of the four sites
2. go to each item of each page of the URL
3. extract lot number, title, description, min estimate, max estimate, price sold, link to page(to check)
Also, in case of Bonhams, data will be additionally extracted from the PDF.
4. write it into a CSV file - which can be opened in Excel (similar to your example files)
However, I have a couple of questions-
1. which currency should be set for the sites?
2. some of the items are not yet sold - so will have no "sold" price, should these still be extracted?
Let me know.
It will take me between 3 to 5 days to complete it.
I expect NO upfront payment.
However I will need a 100% milestone to be created before I start work.
Once I give you the working files, you can test them and only satisfied that everything works as expected, you can release the milestone to me, and not before.
Do get in touch if you're interested.
Thank you.
Divya