Activity
Mon
Wed
Fri
Sun
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
What is this?
Less
More

Memberships

Pokemon Card Investing

Public โ€ข 320 โ€ข Free

2 contributions to Pokemon Card Investing
Price Tracker customization
Hey guys I've been using the price tracker for sealed product for a while now and I have to say it's amazing. Saves me so much time when I wanna get an update on the collection. However I don't really like the 7-day average as I find it quite inaccurate when gauging prices. Does anyone know how to change the code so it gives the From (lowest price) instead? I did notice with some products there are fake sellers at a much lower price than market price and that would mess that up. I guess the only way around that would be taking an X amount of lowest prices and averaging them out but that sounds like quite a hustle so not sure if that would be possible.
4
13
New comment 15d ago
Price Tracker customization
1 like โ€ข Sep 6
@Trung Tran The formula for cards and boxes is apparently different. The one I mentioned before works for cards. This one works for both, so it might be better to use: =VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTXML(E4, "//*[@id='table']/div/div/div/div/div/div[1]/div/span"), 1), " โ‚ฌ", ""),",", "."))
1 like โ€ข Sep 6
This one was a hassle, but now it works for both cards and boxes. I present to you... the average price of the five cheapest sellers: =ROUND(AVERAGE(VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTXML(E4, "//*[@id='table']/div/div/div/div/div/div[1]/div/span"), 1), " โ‚ฌ", ""),",", ".")), VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTXML(E4, "//*[@id='table']/div/div/div/div/div/div[1]/div/span"), 2), " โ‚ฌ", ""),",", ".")), VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTXML(E4, "//*[@id='table']/div/div/div/div/div/div[1]/div/span"), 3), " โ‚ฌ", ""),",", ".")), VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTXML(E4, "//*[@id='table']/div/div/div/div/div/div[1]/div/span"), 4), " โ‚ฌ", ""),",", ".")), VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTXML(E4, "//*[@id='table']/div/div/div/div/div/div[1]/div/span"), 5), " โ‚ฌ", ""),",", "."))), 2)
Hello
Heya everyone. I'm Robyn (F24). I live in the Netherlands. I recently re-started my tcg adventure after like 12 years. My favorite pokรฉmon is Zoroark, but I also really like Jirachi and Fletchling. Favorite card is Crown Zenith's Hisuian Zoroark. Currently I'm trying to make the perfect excel sheet to track all cards and their values. I'm also trying to include a pokedex, a multiples tracker and recommender for the cheapest/best seller for cards I want. I'd love to help anyone making their own sheet.
3
1
New comment Sep 6
Hello
1-2 of 2
@ryn-roo-2659
โ™ก โ™ฅ ๐Ÿ’• โค Crown Zenith & Zoroark & Jirachi โค ๐Ÿ’• โ™ฅ โ™ก

Active 23d ago
Joined Sep 5, 2024
INTP
Netherlands
powered by