I need a step by step guide on building a custom crypto portfolio tracker in Excel that does not require paid API keys.
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
I need a step by step guide on building a custom crypto portfolio tracker in Excel that does not require paid API keys.
2 real searches · 1 real-search pass
Badge and edge weight = share of passes that produced the query. Hover a query for its intent and routing format.
Query classes
Google's semantic query class for every sub-query: what kind of answer each search is after, simulated vs real.
Classifying 2 queries…
Searches and sources
ChatGPT2 real searches · gpt-6
CoinGecko API documentation public demo api key required markets simple price endpoint 2026 Google ↗
Microsoft Excel Power Query From Web JSON refresh documentation Google ↗
- CoinGecko API · coingecko.com
- Simple Price API documentation · docs.coingecko.com
- CoinGecko coin directory · coingecko.com
- Crypto API Pricing Plans · coingecko.com
- User Guide: How to sign up for CoinGecko Demo API and generate an API key? · support.coingecko.com
- I only want crypto prices (e.g., BTC price), how can I do this? · support.coingecko.com
- Microsoft Power Query web connector guide · support.microsoft.com
- Use Power Query in Excel for the Web · support.microsoft.com
- CoinGecko API Licensing: What’s the difference between Commercial and Custom Licenses? · support.coingecko.com
Queries
2 queries · click a column to sort