## Thursday, February 12, 2009

### Flash Prices

So I was going through my flash price spreadsheet, and I noticed the cheapest price from when I stopped updating it in Nov-07 was $6/GB. Today it's$1.50/GB. So I thought about how I wished I had kept it up, as I'd like to see if there was any pattern. Also I again tried to find any kind of record of Newegg's prices, and couldn't. I decided now that I have the ability to scrap web pages I'd use that to automate it. So I made a batch script to download the search results for 1-32GB, and then .7z them. That was going to be it, I figured I'd set that up to run once a day and then have a nice archive in a year. But, then I decided to just make the perl script to parse the plain text and extract the price, model, and type and then append that data to the end of a csv file. Now I had a spreadsheet that updated daily and had the prices for the different sizes. Then I really wanted some way to upload it to the web automatically. I figured I could get something that would sync it with a google doc spreadsheet, but no such luck. Then I found some command line tools to upload stuff, but it was all python, and I don't have python installed, still looked promsising for the future.