Activity
Mon
Wed
Fri
Sun
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
What is this?
Less
More
Memberships
Pokemon Card Investing
Public • 309 • Free
2 contributions to Pokemon Card Investing
11d ago
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
10
New comment 10d ago
1 like • 11d
@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 • 11d
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)
11d ago
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 10d ago
1-2 of 2
@ryn-roo-2659
♡ ♥ 💕 ❤ Crown Zenith & Zoroark & Jirachi ❤ 💕 ♥ ♡
Active 5d ago
Joined Sep 5, 2024
INTP
Netherlands
powered by