How do I write an XLOOKUP formula in Excel to pull real time cryptocurrency prices from Yahoo Finance into my personal budget tracker
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
How do I write an XLOOKUP formula in Excel to pull real time cryptocurrency prices from Yahoo Finance into my personal budget tracker
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
Yahoo Finance API terms of use chart endpoint 2026 cryptocurrency data Google ↗
Yahoo Finance chart API cryptocurrency query1.finance.yahoo.com/v8/finance/chart documentation Excel Power Query Google ↗
- yahoo-finance-excel-power-query/Yahoo Finance Power Query Script.txt at main · cobwebscripts/yahoo-finance-excel-power-query · github.com
- Vibe-Trading/agent/src/skills/yfinance/references/yahoo_client_get_chart.md at main · HKUDS/Vibe-Trading · github.com
- Yahoo Developer API Terms of Use · legal.yahoo.com
- Exchanges and data providers on Yahoo Finance · help.yahoo.com
Queries
2 queries · click a column to sort
| Query / type | Search | Intent | Query class | Routing format | Cluster | Freq ↓ | Weight |
|---|---|---|---|---|---|---|---|
Yahoo Finance API terms of use chart endpoint 2026 cryptocurrency data OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 | |
Yahoo Finance chart API cryptocurrency query1.finance.yahoo.com/v8/finance/chart documentation Excel Power Query OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 |