Greetings guys, i made a list of my collection which i would like some sort of value on (Just to have an idea) I was wondering if anyone has done similar in Excel - Heres what i want to do.
I want to attach the price seen in the picture into the actual cell (See attachment)
To start with, I need to say I'm not an expert with Excel. I'm forced to use it as part of my job at... my er... job. Given a choice, I wouldn't bother with it. That said.
What you want is to pull down data and it requires a little bit of set up on your part. The Microsoft office website has this bit of information on the subject Import Data From External Data.... there is a gaggle of friendlier tutorials such as one from Excel University. I never cared to try pulling down data this way so YMMV.
Some things to consider though.
Excel doesn't really have a very intelligent method of handling "live" data without causing frustrations. Sraping your EDH deck won't cause too many problems with 100 cards but scraping 15,000 entries all at once might be a bear. IIRC, there are settings you need to tweak to avoid slowing your computer down every time you open the file at the cost of not using the latest live data. Basically, once you reach a threshold, consider using a full blown database like MariaDB or MySQL.
In addition most websites have something in their terms of service that disallows scraping data off of their website (I don't know about MTGgoldfish). Sites like TCGPlayer offer an API that allows you to snag price lists in quantity without tying both yours and their bandwidth downloading cruft you're not using anyways.
This is the price lookup someone set up in a Google Sheet a while back at work when attempting to set up a in-office trading community (that never took off):
To start with, I need to say I'm not an expert with Excel. I'm forced to use it as part of my job at... my er... job. Given a choice, I wouldn't bother with it. That said.
What you want is to pull down data and it requires a little bit of set up on your part. The Microsoft office website has this bit of information on the subject Import Data From External Data.... there is a gaggle of friendlier tutorials such as one from Excel University. I never cared to try pulling down data this way so YMMV.
Some things to consider though.
Excel doesn't really have a very intelligent method of handling "live" data without causing frustrations. Sraping your EDH deck won't cause too many problems with 100 cards but scraping 15,000 entries all at once might be a bear. IIRC, there are settings you need to tweak to avoid slowing your computer down every time you open the file at the cost of not using the latest live data. Basically, once you reach a threshold, consider using a full blown database like MariaDB or MySQL.
In addition most websites have something in their terms of service that disallows scraping data off of their website (I don't know about MTGgoldfish). Sites like TCGPlayer offer an API that allows you to snag price lists in quantity without tying both yours and their bandwidth downloading cruft you're not using anyways.
This is the price lookup someone set up in a Google Sheet a while back at work when attempting to set up a in-office trading community (that never took off):
The formula Lithl gives is for row 6 of an excel spread sheet. In the model given. Column D contains the set initials, in your original post for a Beta Black Lotus, that would be "leb". Column A contains the card name. Specifically, in this instance, the formula resides in column F. E column specifies foil or normal (non-foil).
You would need to make adjustments to the formula to accommodate your excel sheet layout. The formula, as given, is going to be in its own cell (or rather column) but it doesn't have to be right next to the cells containing the names.
I want to attach the price seen in the picture into the actual cell (See attachment)
mtggoldfish[DOT]com/price/Limited+Edition+Beta/Black+Lotus#paper
^For instance from this. This should lead to the ability to autoupdate as the prices flutuate.
Any idea how to make this happen? It could also be something other than excel though.
Thanks so much in advance!
What you want is to pull down data and it requires a little bit of set up on your part. The Microsoft office website has this bit of information on the subject Import Data From External Data.... there is a gaggle of friendlier tutorials such as one from Excel University. I never cared to try pulling down data this way so YMMV.
Some things to consider though.
Excel doesn't really have a very intelligent method of handling "live" data without causing frustrations. Sraping your EDH deck won't cause too many problems with 100 cards but scraping 15,000 entries all at once might be a bear. IIRC, there are settings you need to tweak to avoid slowing your computer down every time you open the file at the cost of not using the latest live data. Basically, once you reach a threshold, consider using a full blown database like MariaDB or MySQL.
In addition most websites have something in their terms of service that disallows scraping data off of their website (I don't know about MTGgoldfish). Sites like TCGPlayer offer an API that allows you to snag price lists in quantity without tying both yours and their bandwidth downloading cruft you're not using anyways.
Good luck.
I personally have a program written to pull all the data from their site every so often. It takes about 40 minutes at a time for me.
I agree that trying to do this directly in Excel might lead to frustration.
Where E# is "Normal" or "Foil" and F# is:
Where A# is a card name and D# is the card's set abbreviation.
Two Score, Minus Two or: A Stargate Tail
(Image by totallynotabrony)
Thanks for the reminder WizrdMN and Lithl.
So I would just place this in a cell next to the card and change the names basically?
Anyone else have experience with this?
The formula Lithl gives is for row 6 of an excel spread sheet. In the model given. Column D contains the set initials, in your original post for a Beta Black Lotus, that would be "leb". Column A contains the card name. Specifically, in this instance, the formula resides in column F. E column specifies foil or normal (non-foil).
You would need to make adjustments to the formula to accommodate your excel sheet layout. The formula, as given, is going to be in its own cell (or rather column) but it doesn't have to be right next to the cells containing the names.