Pokemon card prices in Excel with Power Query

In Excel for Windows: Data, Get Data, From Other Sources, From Web (Excel 2016: Data, New Query, From Other Sources, From Web). Paste one URL (a whole set, or one card), press OK, choose Anonymous if Excel asks how to connect, then Transform Data. The set id is the number in its TickerMint page URL (tickermint.cards/set/23237).

https://api.tickermint.cards/sets/23237.csv
https://api.tickermint.cards/products/517045.csv

In the Power Query editor: Home, Advanced Editor, replace everything with this, then Done. It keeps the collector number as text (so a number like 1/102 never becomes a date) and the price as a number.

let
    Source = Csv.Document(
        Web.Contents("https://api.tickermint.cards/sets/23237.csv"),
        [Delimiter = ",", Encoding = 65001, QuoteStyle = QuoteStyle.Csv]
    ),
    Headers = Table.PromoteHeaders(Source, [PromoteAllScalars = true]),
    Typed = Table.TransformColumnTypes(
        Headers,
        {{"date", type date}, {"product_id", Int64.Type}, {"number", type text},
         {"market_price_usd", type number}},
        "en-US"
    )
in
    Typed

Home, Close & Load puts the table on a new sheet. Data, Refresh All pulls the latest prices; in Query Properties you can also tick Refresh data when opening the file. Price your own list with =XLOOKUP(A2, Table1[product_id], Table1[market_price_usd]).

The search endpoint returns JSON. This query lists every match for a name with its latest market price; swap the q value for your card.

let
    Source = Json.Document(
        Web.Contents(
            "https://api.tickermint.cards/products/search",
            [Query = [q = "charizard ex 199/165", game = "pokemon"]]
        )
    ),
    Cards = Table.FromRecords(Source),
    Picked = Table.SelectColumns(Cards, {"product_id", "name", "set_name", "card_number", "market"}),
    Typed = Table.TransformColumnTypes(Picked, {{"market", type number}}, "en-US")
in
    Typed

• date: the day of the price (prices update once a day)
• product_id: TickerMint's id, the number in the card page URL
• name: card or product name as TCGplayer lists it
• set: set name
• number: collector number, empty for sealed product
• printing: the printing the price is for (Holofoil, Reverse Holofoil, Normal...)
• market_price_usd: TCGplayer market price in US dollars, the same number the card page shows
• url: the TickerMint card page (the link back the free plan asks for)

Prices are TCGplayer market prices for the card's main printing, the same number its TickerMint page shows. Full endpoint list and OpenAPI on /developers.