Hi everyone, I noticed the cardmarket tracker has been throwing only errors lately "URL could not be fetched". It started around Friday November 7th for me, has anyone experienced the same behavior? I have not changed my setup and it has been working great over the last months. Now I cannot not fetch any price.

Hello everyone, I figured out a way to prevent the prices from not loading. I tried to explain all the steps required to make it work in your own spreadsheet. It's probably not foolproof but i hope it helps at least one person :)

Hey everyone 😀 I wanted to ask you how you work with the price tracker sheet. I now have over 150 entries and feel that this is quite a lot for one sheet, both in terms of organization and API retrieval on Cardmarket. I have divided the rows in the sheet by generation and language. How do you do it? I'm thinking about putting each generation, e.g., Sword & Shield and Scarlet & Violet, into its own sheet. But that would make the price logs much more time-consuming in the future.

Hi everyone, I'm creating this post for those who want to get the price of the lowest first offer instead of the average price. To do this, you need to replace the line: =IMPORTXML(E7; "//*[@id='tabContent-info']/div/div[1]/div/div[2]/dl/dd[10]/span") with this: =IMPORTXML(E9; "//section[@id='table']/div[@class='table article-table table-striped']/div[@class='table-body']/div[1]/div[@class='col-offer col-auto']//span[@class='color-primary small text-end text-nowrap fw-bold ']") The /div[1] parameter indicates which row to select, so if you don't want to get the first price for any reason, you can change it to the row number you prefer. :)

Use this Google sheet to track the value of your single/sealed Pokemon collection automatically based on live Cardmarket prices. It's 100% free, easy to use, works for any product on Cardmarket, and saves a ton of time. 👉 How to set up your own sheet in 5 minutes: 1. Join the PokeCard Investing community (it's free). 2. Go to the classroom of this community, follow the video instructions. 3. Track your collection effortlessly from now on 👌. I spent a TON of time building this sheet for myself and I'm now sharing it with you guys. Let me know what you think and if you have any questions or suggestions on how to improve it!