I would like a price tracker for www.amazon.com that would pull every “Textbook” with a sales ranking between 1 and 3,000,000. Prices would be pulled 100 times per year, per book, (roughly once every 4 days).
Amazon currently has 750,000 textbooks, roughly 60 – 70% of them have a sales ranking within the range I specified.
This would amount to about 19million prices pulled per year for a total of 2 years. Prices older than 2 years get deleted as well any books that have went over the sales ranking limit. I would like the output to be in MySQL so that I may export it to an excel sheet for further analysis.
Outputs
ISBN’s on the Y-axis
Prices on the X-axis
Dates as the column title for each price.
I am trying to track the long-term price fluctuations.
My budget is no more than $300.
