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.

Hi I am working on a Pokemon sealed Tracking Tool. I am using the 7d avg cardmarket prices for tracking. There are some downsides like in the sheet. Cardmarket does not provide access to past prices. This is a limitation. Let me know if you would like to test it and use it productively. I would then adjust the final details and translate it into English. I would have to charge a fee for this in the future because it incurs ongoing costs. I may include cards in the future.

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. :)