We are back in business!

I found that I was still able to scrape off of TCGPlayer, and I am not sure they know I can do it, but I can!

Before the printable price guides, I was able to scrape off just the table from the website.  They then change it so you had to repoint to the printable versions, but it looks like now with their new price guide they opened up the table on the webpage.

I will update this later, but I just wanted to send a quick update.  I was able to update my Price.xlsx with all the new connections, and update the Collection spreadsheet, but there are even more edits I need to post for the spreadsheets.  The prices for Mid shifted over a column, and the issue with N/A being presented on the web prices, so there will be some new updates to those changes.

But I have been able to get things 75% back up and running with Excel, and that will give me some more time to get coding to get my database up and running.

It is late and the wif is wanted to head to bed, so look for an update later!

FYI, I was going to make a pretty large purchase with some extra money I have saved up, and with the changes that had occurred I was really looking to not use TCG to buy anything and just go to the sites themselves.  But now with being able to keep my spreadsheets up to date with price, I just might throw some cash to the site again!

I know, it is pretty sad to not buy from the site for them wanting to keep this information to themselves, but come-on!  I am not some big business guy, I just don't want to post my collection on any site and keep the prices up to date.

I hate my life right now

So....

TCGPlayer has now decided to change the way they post the Price Guides and I am no longer able to scrape the website pages to get my information that I load into collection sheets.  This is not so bad when it comes to gathering the set information, but now I am no longer able to update my prices to see what my collection total is.

Options now are to use a site like MTGPrices, Deckbox, or even TCGPlayer to keep track of my inventory.  OR... I build my own application to scrape off data from websites to get prices and keep going with my own application.  TCGPlayer will not give me their API to write my own application because I am not a company that is trying to drive traffic to their site, and MTGPrices has an API that I have a request out to in order to see if I can use theirs.

All in all, I need to start building a python script that will allow me to gather data from sites for the prices so I can then merge it with data I can gather from other sites on card information.

This is going to be a long process...

More to update later.