Real ChatGPT answer · index seed8Cxv6dHiyAgcompleteFinance and banking · cryptocurrencyinformational

My Excel spreadsheet for tracking my crypto portfolio is totally broken because the Yahoo Finance API stopped working, so what formula should I use instead right now?

ChatGPTgpt-62 queries10/31/2026
Download run

Fan-out diagram

The searches the AI actually ran for this prompt.

SEED QUERY
My Excel spreadsheet for tracking my crypto portfolio is totally broken because the Yahoo Finance API stopped working, so what formula should I use instead right now?
2 real searches · 1 real-search pass
CoinGecko API simple price endpoint authentication demo API key requirements 2026 Excel WEBSERVICE cryptocurrency pricesGoogle ↗
OBSERVED
Microsoft Excel WEBSERVICE function Windows limitations Mac Excel for web documentationGoogle ↗
OBSERVED

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 simple price endpoint authentication demo API key requirements 2026 Excel WEBSERVICE cryptocurrency prices Google ↗
Microsoft Excel WEBSERVICE function Windows limitations Mac Excel for web documentation Google ↗

Queries

2 queries · click a column to sort
Query / typeSearchIntentQuery classRouting formatClusterFreq ↓Weight
CoinGecko API simple price endpoint authentication demo API key requirements 2026 Excel WEBSERVICE cryptocurrency prices
OBSERVED
Google ↗
AI Mode ↗
————1x
of 1
Microsoft Excel WEBSERVICE function Windows limitations Mac Excel for web documentation
OBSERVED
Google ↗
AI Mode ↗
————1x
of 1