BrookIsland
New Member, Must Send First ,

The above is a graph from the front page Saturday NY Times article (NB: Paywall may be active) - with the following opener:
So question becomes, how does this affect card prices.NY Times said:Prices are rising at the fastest clip in nearly 40 years, fresh data released on Friday showed, as supply chain disruptions, rapid consumer demand and rising housing costs fuel an inflationary burst.
Was thinking there might be a fun (fun?) way to track this using e.g., a basket of marquee cards for which there are large or very large population reports.
I think PWCC may have something like this but I thought we could create our own and maybe track it as an indication of trends in the market.
What do you think the constituents should be - I was thinking each constituent should:
1. Be at various levels of price point so they reflect the buying appetite of people not just at the very top of the market going for the very top grades so as to capture more of the market appetite generally instead of specifically at the top end
2. Be "blue chip" players (as is the DJIA) so that e.g., we're not using players' cards that have fallen out of fashion or that have underperformed/overperformed as that leads to unhelpful noise & pricing volatility
3. Have many observable price points that are publicly available and auditable (e.g., eBay closed sales, acknowledging the limitations inherent to eBay)
4. Be quite "common" and easily acquired - i.e., "liquid" (e.g., I would think we should seek to avoid cards for which there are only 5 copies given the illiquidity premium paid by buyers for the exclusivity of having one of a very limited number of copies)
5. What other criteria?
On that basis, I think we are generally going to be focused on Young Guns and similar rookie cards from Topps/OPC from other eras.
Something like:
PSA 10 Auston Matthews Base YG
PSA 10 Connor McDavid Base YG
PSA 6 Wayne Gretzky OPC RC
PSA 6 Wayne Gretzky Topps RC
PSA 8 Mario Lemiuex OPC RC
PSA 8 Jaromir Jagr OPC Premier RC
Etc.
And to include how slightly lower end cards are fairing:
PSA 9 Auston Matthews Base YG
PSA 9 Connor McDavid Base YG
And lower grade versions of the cards listed above which satisfy the above criteria(?)
Was thinking of trying to do this monthly to have enough data to have observable prices.
So questions are:
1. What are the right cards for an index like this? (And noting that like the DJIA, we can have cards come in and out from month to month.)
2. Will this have any real utility?
3. Would anyone else be interested in helping populate the data into Google Sheet and then I or they can run the algo in Excel (but would be grateful for help on the Excel algo to run as we might want to e.g., put different weights to different cards instead of them all being equally weighted)
4. What else?
Was going to add a poll to this thread but thought comments might be more helpful.