Collectibles price tracker from Cardmarket links.
I'm working on some shenanigans to have it work better on windows, and finding ways to run it simply for everyone
| Python version | Compatibility |
|---|---|
| < 3.7 | Untested |
| 3.7 | ✔️ |
| 3.8 | ❌ |
| 3.9 | ❌ |
| 3.10 | ✔️ |
python CMScrape.py→ select input file
→ select output/statistics (minimalist output) file
→
ctrl+Pto check if the parameters are good for your use→ click run
voilà
This tool aims to gain time when checking a collection's price on CardMarket.
The setup is quite long at the moment, you need to make a file containing all the cardmarket links to all the collectibles in your collection. You can find an example of a list here.
You can easily create this list using CMScrape's Firefox Extension.
You can also create a list easily using CMList, my tool dedicated to this.
This tool contains options for multithreaded execution, and an auto proxies scraper/checker/rotator to avoid getting ip-blocked by CardMarket.
You will find below an example of the execution with the latest version.
CMScrape_Demo.mp4
This project is currently in developpment. It works and is tested on ubuntu 22.04 and Windows 10, mostly on yugioh and pokémon cards. If you have any suggestions or any kind of feedback, you can contact me on discord on the dedicated discord server.
Note : this project was developped on Ubuntu 22.04. If you face any issue with the execution, please let me know.
# clone the repo
$ git clone https://github.com/DrankRock/CMScrape.git
# change the working directory to CMScrape
$ cd CMScrape/
# download required packages
$ python -m pip install -r requirements.txtpython3 CMScrape.py
As soon as you launch CMScrape, you will be greeted by the main window. Use the three buttons on the left to choose an input file, and either a Statistic file, an output file, or both.
The input file should be a .txt file containing, on each line, a URL to a specific collectible from CardMarket. This can be cards, decks, boosters, deck boxes etc. As long as it's a collectible with a variable price, it will work. The input is enough to run the app, and if no outputs are given, the total prices will be written on the console.
In the input, you can put non-links to make it clearer. Any line starting with # (e.g. #Binder 71) is seen as an Attribute marker. in the csv output, Attributes will be indicated, as an example to indicate where your cards are stored, or what type of cards they are, or to add any information you want. Any other non-link line will be ignored.
The output file must be a .csv file. If it doesn't exist, it will be created. If it does exist, it will be overwritten. For each url contained in the input file, the output file will contain a line with the information :
attribute,game,item,extension,number,name,min_price,price_trend,mean30d_price,language,sellerType,minCondition,isSigned,isFirstEd,isPlayset,isAltered,isReverseHolo,isFoil,url
in a coma separated form. The price and the url will be surrounded by ", which needs to be set as the String Delimiter in your csv viewer. (Libreoffice works well).
The statistics file must be a .csv file. If it doesn't exist, it will be created. If it does exist, the content of the file won't be overwritten, but a new line will be added at the end containing the information. The statistics option outputs a single file with the information :
current Time, sum of all the minimum prices, sum of all the trending prices, sum of all the "Mean 30 days" prices
in a coma separated form. This output aims to check the evolution of the collection as a whole.
You can and should select parameters to precise the behavior of the application. You can open the preferences menu in Settings -> Preferences or by pressig Ctrl+P.
Number of Threads is the number of cardmarket pages you want to check simultaneously. A bigger number generally means more speed, but you are limited by the quality of your connexion, and the power of your computer. The default value, 50, gives good results. If you are going to check n url, putting more than n threads adds nothing.
Number of Threads in ProxyCheck is the number of Proxies you want to check simultaneously. The need for proxies is explained in the next section.
Number of Proxies is the maximum number of proxies you need.
Use a file containing proxies is self-explanatory. Instead of searching online for proxies, put the path to a file containing your proxies (Https or Http) and it will be used. You can then choose if you want to use this file, and if you want CMScrape to check which proxies are working.
Use proxy file needs to be checked for the file containing proxies to be used
Check proxy file makes it possible to test the proxies in the list before using them
Note: an additional parameter, not in the menu, gives access to a proxyless mode. It can be turned on and off using CMScrape.py --no-proxies <True or False>
All these options are saved in the .cmscrape file and will be loaded in the next execution.
To explain what happens when CMScrape runs, I need to answer a question. If you understand the need for auto-rotating proxies, no need to read this subsection.
A proxy is like a mask that your connection puts on, to make the website think it's a different person. It's not as secure as a VPN, it really is just like a mask, where a VPN would be a complete false identity and modification of your face. We need to disguise our identity because most websites protect themselves from people making too many requests. From my tests, Cardmarket accepts that a single user make 32 requests per minute. Above that, the IP is blocked and will be unsuable for 60 seconds.
When using on single thread, so one url by one, this limit is not reached. But once we go multithreaded, so checking many urls at once, cardmarket sees how fast we go and knows it's not a human doing that, and blocks the IP adress.
This is why we need proxies.
Because this tool might be used by people who are not familiar with these technologies, I added a way to do this automatically. Instead of having to buy, or find proxies, CMScrape will go on various pages online and find free proxies, then check which ones are working.
Proxies need to be checked, because they will not always work. They depend on servers, etc. Non-working proxies will waste time and efficiency, so testing which ones work is necessary. With free proxies like the ones I'm scraping online, around 1 in 10 proxies is working.
If you do not want to use proxies or if you don't need CMScrape to be as fast as possible, you can enable a proxyless mode. See Parameters.
As soon as the run button is clicked, if you did not put a proxy file, CMScrape will dowload free proxies on various sources, then check them. When enough working proxies are found (as specified in the preferences, or when all the proxies were checked), the scraping phase starts for all the links in the input file. For each link, the page is downloaded, information are extracted and put in the selected output.
When it's done, an information dialog will open, and some general information will appear on the console.
Instead of trying to trick Cardmarket into thinking the user is many users, it takes the patience route and just wait for cardmarket to unblock the ip adress before continuing the scraping. This thus goes at a maximal speed of 30 checks/minute.
MinPrice is the minimum price observed on cardmarket taking into account the parameters, such as the condition, or the langage.
Mean30 is the price as indicated on CardMarket, the mean selling/buying price of the last 30 days.
TrendPrice is the trending price.
Trend and mean do not take into account the parameters. In my opinion, they are thus less precise when checking prices for a collection, but more accurate when you are buying cards for playing.
The current terminal version is obsolete, hasn't been maintained for a while. I will update it in the near future, and put all the options back on the README.md. I apologize for the inconvenience. I only left the -h / --help option as it will only work in terminal anyway, and still works.
-h :
/!\ this parameter takes no arguments
Shows the help :
-- Python CardMarket Scraper --
usage: CMScrape.py
Precisions about the results :
_____________________
| minCondition |
|_____________________|
| None = Poor |
| 6 = Played |
| 5 = Light Played |
| 4 = Good |
| 3 = Excellent |
| 2 = Near Mint |
| 1 = Mint |
|_____________________|
| language |
|_____________________|
| None = None |
| 1 = English |
| 2 = French |
| 3 = German |
| 4 = Spanish |
| 5 = Italian |
| 6 = S-Chinese |
| 7 = Japanese |
| 8 = Portuguese |
| 9 = Russian |
| 10 = Korean |
| 11 = T-Chinese |
| 12 = Dutch |
| 13 = Polish |
| 14 = Czech |
| 15 = Hungarian |
|_____________________|
input
command
links.csv
linksStat.csv
Be careful, this script doesn't work with everything buyable on CardMarket. Below is an example of a not working example, because it does not contain trend/mean prices. It's not a collectible, as opposed to the other version of the same kind of item below it.
Through the Firefox extension and the app itself, my goal as of today is reached. I have an easy-to-use software to know the exact price of my collection. It supports proxies etc.
Small things can be improved, proxies added, interface made nicer especially on windows, a terminal only option (to run faster, and automatized runs), and I will be improving them in the future
- Improving the proxyless.
- Added an attribute column in the csv.
Create a card scanner using OpenCV (this is a distant todo, as I have near to no experience in opencv)
The logo was created from another one created by Gregor Cresnar from the Noun Project. Special thanks to Ngapi for his help, his advices, his thorough windows testing, all the idea he gave and the time he spent telling me what was wrong and what could be enhanced while his computer crashed.
The User Agent list is from N0taN3rd.