Activity
Mon
Wed
Fri
Sun
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
What is this?
Less
More
Memberships
Pokemon Card Investing
Public • 347 • Free
2 contributions to Pokemon Card Investing
Sep 5 in
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.
3
14
New comment 4d ago
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)
0 likes • 4d
@Juzam Djinn Don't know if you still need it, but I improved the formula so it takes only one "IMPORTXML", meaning less computation and loading time: =AVERAGE(ARRAY_CONSTRAIN(ARRAYFORMULA(VALUE(SUBSTITUTE(SUBSTITUTE(IMPORTXML(E12; "//*[@id='table']/div/div/div/div/div/div[1]/div/span"); ","; "."); " €"; "")));5;1))) You can change the 5 here to whatever you want, so if you change it to 3, you get the average of the 3 cheapest.
Sep 5 in
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
1-2 of 2
@ryn-roo-2659
♡ ♥ 💕 ❤ Crown Zenith & Zoroark & Jirachi ❤ 💕 ♥ ♡
Active 4d ago
Joined Sep 5, 2024
INTP
Netherlands
powered by