The Scenario
You run a personal crypto index — 10 coins you've selected based on your own thesis. Every Sunday you want three numbers for the index as a whole: combined market cap, combined 24h trading volume, and how the basket's combined market cap compares to the total crypto market (your version of "index dominance"). These aren't numbers you can pull from any standard view in Coinranking. They require aggregating across a custom set of coins.
Last Sunday you did it by hand: pulled market cap for each of the 10 coins individually, summed them in the workbook, then pulled the global market cap separately and divided. Twelve separate data lookups for three output cells. It took 25 minutes and you're not confident coin 8 was the right version of that token's name.
The bad version:
- Look up each of the 10 coin UUIDs by searching Coinranking for each coin name, since the aggregate endpoint requires UUIDs.
- Make 10 individual price/market-cap API calls, paste the market cap from each into the workbook.
- Pull the global market cap from a separate page, type it in, write the division formula by hand.
You built this index because you wanted a disciplined analytical framework for your portfolio decisions. Running the weekly numbers by hand for 25 minutes is the opposite of that discipline. The analysis should take your time, not the data assembly.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside Excel with a direct Coinranking integration. It can read the coin UUIDs or names from your workbook, call Coinranking's aggregate basket stats endpoint, and write the combined metrics directly into the cells you specify.
For the coin UUIDs listed in column A of this worksheet, fetch Coinranking's aggregate basket statistics and write total market cap in cell B1, combined 24h volume in cell B2, and dominance relative to global crypto market cap in cell B3, with labels in column A
What You Get
- Three aggregate numbers in cells B1, B2, and B3: combined market cap, combined 24h volume, and basket dominance as a percentage
- Labels written into A1:A3 so the table is self-documenting
- All computed from a single Coinranking basket stats call — not from ten individual coin lookups summed in the workbook
What If the Data Is Not Quite Ready
Your column A has coin names rather than UUIDs
The values in column A are coin names. For each one, resolve the Coinranking UUID, then fetch aggregate basket statistics for the full set and write combined market cap in B1, combined 24h volume in B2, and basket dominance percent in B3
You want the individual coin market caps alongside the aggregate
For the coin names in column A rows 2 through 11, fetch each coin's current market cap from Coinranking and write it in column B, then write the combined market cap total in cell B13, combined 24h volume in B14, and dominance percent in B15
You want a timestamp so you know when the numbers were pulled
Fetch aggregate basket statistics from Coinranking for the coin UUIDs in column A, write total market cap in B1, 24h volume in B2, and dominance in B3, then write the current timestamp in cell B4 labeled "Last updated" in A4
Full weekly index refresh in one shot
Clear cells B1 through B5 and column B rows 2 through 11, fetch each coin's current market cap from Coinranking for the coin names in column A rows 2 through 11 and write them in column B, compute aggregate basket stats for those coins and write combined market cap in B13, combined 24h volume in B14, dominance percent in B15, and today's date in B16, then highlight in green any individual coin whose market cap increased since last week (compare against column C if values exist there)
Weekly index refresh, individual breakdowns, and a week-over-week comparison signal — one prompt on Sunday morning.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where you track your personal coin index, then ask it to pull a fresh set of aggregate basket stats from Coinranking. When you want the broader sector picture, see Import All Coinranking Tag Statistics Into an Excel workbook and the Coinranking Excel overview.