Real ChatGPT answer + Gemini simulation · index seedq0DaMPyQMAocompleteAI OverviewFinance and banking · cryptocurrencyinformational
Can you write an Excel macro or formula to calculate my crypto capital gains and losses for taxes automatically?
ChatGPTgpt-6Geminigemini-3.5-flash-lite3 passes + 1 real-search36 queries10/30/2026
Download run
Gemini unique queries
34
0 in ≥ half the passes · stability 33%
ChatGPT real searches predicted
0%
0 of 2 matched the simulation
Fan-out diagram
Seed → topic clusters → sub-queries, per model.
SEED QUERY
Can you write an Excel macro or formula to calculate my crypto capital gains and losses for taxes automatically?
34 unique queries · 3 passes
excel templates and portfolio tracking
9 queries · 9 hits
vba macro for crypto tax tracking excel1xGoogle ↗
REFORMULATIONInstruction
automated crypto tax spreadsheet template download1xGoogle ↗
IMPLICITInstruction
best crypto tax tracking spreadsheet template excel1xGoogle ↗
RELATEDComparison
best crypto tax software with excel export1xGoogle ↗
ENTITY EXPANSIONComparison
best crypto portfolio trackers with api export to excel1xGoogle ↗
ENTITY EXPANSIONComparison
excel template for cryptocurrency portfolio and taxes1xGoogle ↗
RELATEDOther / navigational
cryptocurrency wash sale rule excel tracker1xGoogle ↗
ENTITY EXPANSIONOther / navigational
automatically update crypto prices in excel for tax basis1xGoogle ↗
IMPLICITComparison
how to track crypto staking rewards in excel for taxes1xGoogle ↗
PERSONALIZEDInstruction
excel formulas and code for gains
5 queries · 5 hits
excel vba code to calculate crypto capital gains1xGoogle ↗
REFORMULATIONInstruction
excel formula to calculate crypto capital gains1xGoogle ↗
REFORMULATIONConsequence
how to calculate crypto capital gains in excel formula1xGoogle ↗
REFORMULATIONInstruction
excel formula for capital gains tax crypto1xGoogle ↗
REFORMULATIONReason
automate crypto capital gains calculation spreadsheet1xGoogle ↗
IMPLICITInstruction
importing crypto transactions and apis
5 queries · 5 hits
automate crypto transaction import into excel for taxes1xGoogle ↗
IMPLICITComparison
how to import crypto transaction history into excel1xGoogle ↗
RELATEDInstruction
how to import binance transaction history into excel for taxes1xGoogle ↗
PERSONALIZEDInstruction
can excel vba connect to crypto exchange api for taxes1xGoogle ↗
IMPLICITComparison
can excel handle complex multi wallet crypto tax accounting1xGoogle ↗
PERSONALIZEDComparison
fifo and lifo tax methods
4 queries · 4 hits
excel vba macro for crypto capital gains tax fifo1xGoogle ↗
REFORMULATIONInstruction
how to use fifo lico fifo method for crypto taxes in excel1xGoogle ↗
RELATEDInstruction
fifo vs lifo crypto tax calculation excel1xGoogle ↗
COMPARATIVEComparison
how to calculate fifo vs lifo for cryptocurrency taxes1xGoogle ↗
RELATEDInstruction
irs tax rules and guidelines
4 queries · 4 hits
cryptocurrency tax lot relief methods irs guidelines1xGoogle ↗
RELATEDComparison
irs cryptocurrency tax rules capital gains cost basis1xGoogle ↗
RELATEDReason
what is cost basis and capital gains in crypto trading1xGoogle ↗
REFORMULATIONReason
irs guidelines on cryptocurrency capital gains tracking1xGoogle ↗
RELATEDReason
excel versus crypto tax software
3 queries · 3 hits
python scripts and online tools
3 queries · 3 hits
irs tax compliance and reporting
1 query · 1 hit
excel vba error handling for missing crypto cost basis1xGoogle ↗
RELATEDReason
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.
Gemini simulated (34)ChatGPT real searches (2)
Classes come from the query-classifier (a local Laya model). 27 of 36 calls are low-confidence (under 50%) — hover a query in the table to see its confidence.
What the models actually searched
Each model answered the query with its own web search. These are the searches it ran, matched to the closest simulated query.
Semantic map
Every query placed by meaning (EmbeddingGemma 2, 256-d). Shaded regions are topics, nearby points are near-paraphrases, and a circle's size is how often the query came back.
Colour
SimulatedReal search
Hover a query to see its counterpart · click a topic to focus it · zoom with Ctrl/⌘ + scroll, a pinch, double-click or +
Queries
34 queries · click a column to sort
| Query / type | Search | Intent | Query class | Routing format | Cluster | Freq ↓ | Weight |
|---|---|---|---|---|---|---|---|
excel vba code to calculate crypto capital gains REFORMULATION | Google ↗ AI Mode ↗ | The user wants the exact VBA macro script to compute cryptocurrency gains and losses automatically within Excel. | Instruction | code_samples/docs | excel formulas and code for gains | 1x of 3 | |
excel vba macro for crypto capital gains tax fifo REFORMULATION | Google ↗ AI Mode ↗ | The user wants a VBA script in Excel to automate crypto tax calculations using the First-In, First-Out method. | Instruction | code_samples/docs | fifo and lifo tax methods | 1x of 3 | |
excel formula to calculate crypto capital gains REFORMULATION | Google ↗ AI Mode ↗ | Find specific Excel formulas that calculate capital gains for cryptocurrency transactions. | Consequence | how_to_steps | excel formulas and code for gains | 1x of 3 | |
how to use fifo lico fifo method for crypto taxes in excel RELATED | Google ↗ AI Mode ↗ | The user wants to understand how to implement specific accounting methods like FIFO or LIFO in Excel for tax reporting. | Instruction | how_to_steps | fifo and lifo tax methods | 1x of 3 | |
how to calculate crypto capital gains in excel formula REFORMULATION | Google ↗ AI Mode ↗ | The user seeks specific standard Excel formulas rather than complex macros to track cost basis and gains. | Instruction | how_to_steps | excel formulas and code for gains | 1x of 3 | |
vba macro for crypto tax tracking excel REFORMULATION | Google ↗ AI Mode ↗ | Locate an existing VBA macro script designed for tracking crypto taxes in Excel. | Instruction | code_samples/docs | excel templates and portfolio tracking | 1x of 3 | |
automated crypto tax spreadsheet template download IMPLICIT | Google ↗ AI Mode ↗ | The user is looking for ready-made templates that can automatically calculate crypto taxes without building them from scratch. | Instruction | dataset | excel templates and portfolio tracking | 1x of 3 | |
best crypto tax tracking spreadsheet template excel RELATED | Google ↗ AI Mode ↗ | The user is looking for pre-made downloadable Excel templates designed for cryptocurrency taxes. | Comparison | buyers_guide | excel templates and portfolio tracking | 1x of 3 | |
fifo vs lifo crypto tax calculation excel COMPARATIVE | Google ↗ AI Mode ↗ | Understand how to implement different accounting methods like FIFO and LIFO in Excel for crypto. | Comparison | comparison_table | fifo and lifo tax methods | 1x of 3 | |
excel formula for capital gains tax crypto REFORMULATION | Google ↗ AI Mode ↗ | The user wants standard spreadsheet formulas to calculate capital gains on cryptocurrency transactions. | Reason | how_to_steps | excel formulas and code for gains | 1x of 3 | |
automate crypto transaction import into excel for taxes IMPLICIT | Google ↗ AI Mode ↗ | The user needs a way to pull exchange and wallet transaction history directly into Excel. | Comparison | how_to_steps | importing crypto transactions and apis | 1x of 3 | |
best crypto tax software with excel export ENTITY EXPANSION | Google ↗ AI Mode ↗ | Discover dedicated crypto tax software platforms that can export data to Excel or automate the process entirely. | Comparison | review_roundup | excel templates and portfolio tracking | 1x of 3 | |
koinly vs cointracker vs custom excel crypto tax tracking COMPARATIVE | Google ↗ AI Mode ↗ | The user wants to compare dedicated crypto tax software with building a custom Excel macro solution. | Comparison | comparison_table | excel versus crypto tax software | 1x of 3 | |
excel vs dedicated crypto tax software koinly cointracking COMPARATIVE | Google ↗ AI Mode ↗ | The user wants to compare doing taxes in Excel versus using specialized third-party crypto tax software. | Comparison | comparison_table | excel versus crypto tax software | 1x of 3 | |
how to import crypto transaction history into excel RELATED | Google ↗ AI Mode ↗ | Learn the process of bringing CSV files from exchanges into Excel for tax analysis. | Instruction | how_to_steps | importing crypto transactions and apis | 1x of 3 | |
best crypto portfolio trackers with api export to excel ENTITY EXPANSION | Google ↗ AI Mode ↗ | The user wants to find platforms that connect via API to pull transaction data into Excel automatically. | Comparison | buyers_guide | excel templates and portfolio tracking | 1x of 3 | |
cointracker koinly cointracking api excel export ENTITY EXPANSION | Google ↗ AI Mode ↗ | The user wants to know if major crypto tax platforms allow exporting processed tax data back into Excel. | Other / navigational | product_spec_sheet | excel versus crypto tax software | 1x of 3 | |
automate crypto capital gains calculation spreadsheet IMPLICIT | Google ↗ AI Mode ↗ | Find fully automated spreadsheet templates or advanced automation techniques for crypto taxes. | Instruction | calculator/tool | excel formulas and code for gains | 1x of 3 | |
cryptocurrency tax lot relief methods irs guidelines RELATED | Google ↗ AI Mode ↗ | The user wants to know official tax agency rules regarding how crypto cost basis must be tracked. | Comparison | web_article | irs tax rules and guidelines | 1x of 3 | |
how to calculate fifo vs lifo for cryptocurrency taxes RELATED | Google ↗ AI Mode ↗ | The user wants to understand the accounting rules behind capital gains methods required for tax filing. | Instruction | glossary/definition | fifo and lifo tax methods | 1x of 3 | |
excel template for cryptocurrency portfolio and taxes RELATED | Google ↗ AI Mode ↗ | Download a pre-made Excel template built specifically for portfolio tracking and tax preparation. | Other / navigational | dataset | excel templates and portfolio tracking | 1x of 3 | |
how to import binance transaction history into excel for taxes PERSONALIZED | Google ↗ AI Mode ↗ | The user needs guidance on formatting raw exchange data so their Excel calculation script can read it. | Instruction | how_to_steps | importing crypto transactions and apis | 1x of 3 | |
python script vs excel macro for crypto tax calculation COMPARATIVE | Google ↗ AI Mode ↗ | The user is exploring alternative programming approaches for automating crypto tax math. | Comparison | code_samples/docs | python scripts and online tools | 1x of 3 | |
irs cryptocurrency tax rules capital gains cost basis RELATED | Google ↗ AI Mode ↗ | Review official tax guidelines regarding crypto capital gains and cost basis reporting. | Reason | pdf_whitepaper | irs tax rules and guidelines | 1x of 3 | |
excel vba error handling for missing crypto cost basis RELATED | Google ↗ AI Mode ↗ | The user wants troubleshooting help when their macro encounters incomplete transaction histories. | Reason | forum/qna | irs tax compliance and reporting | 1x of 3 | |
free crypto tax calculator tools online RELATED | Google ↗ AI Mode ↗ | The user is looking for free web tools if Excel automation proves too difficult. | Other / navigational | calculator/tool | python scripts and online tools | 1x of 3 | |
can excel vba connect to crypto exchange api for taxes IMPLICIT | Google ↗ AI Mode ↗ | Determine if Excel VBA can pull live transaction data via API for real-time tax calculations. | Comparison | api_reference | importing crypto transactions and apis | 1x of 3 | |
what is cost basis and capital gains in crypto trading REFORMULATION | Google ↗ AI Mode ↗ | The user wants a basic definition of key financial terms required to calculate crypto taxes. | Reason | glossary/definition | irs tax rules and guidelines | 1x of 3 | |
irs guidelines on cryptocurrency capital gains tracking RELATED | Google ↗ AI Mode ↗ | The user needs to ensure their calculation method complies with official tax authority regulations. | Reason | pdf_whitepaper | irs tax rules and guidelines | 1x of 3 | |
cryptocurrency wash sale rule excel tracker ENTITY EXPANSION | Google ↗ AI Mode ↗ | Find out how to account for wash sale rules or other special conditions within an Excel crypto tracker. | Other / navigational | faq_page | excel templates and portfolio tracking | 1x of 3 | |
automatically update crypto prices in excel for tax basis IMPLICIT | Google ↗ AI Mode ↗ | The user needs a mechanism inside Excel to pull historical and current cryptocurrency market prices. | Comparison | how_to_steps | excel templates and portfolio tracking | 1x of 3 | |
free crypto tax calculator vs excel spreadsheet COMPARATIVE | Google ↗ AI Mode ↗ | Weigh the pros and cons of using a manual Excel spreadsheet versus using automated web calculators. | Comparison | comparison_table | python scripts and online tools | 1x of 3 | |
can excel handle complex multi wallet crypto tax accounting PERSONALIZED | Google ↗ AI Mode ↗ | The user is evaluating the scalability and limitations of spreadsheets for extensive trading activity. | Comparison | forum/qna | importing crypto transactions and apis | 1x of 3 | |
how to track crypto staking rewards in excel for taxes PERSONALIZED | Google ↗ AI Mode ↗ | Learn how to record income events like staking rewards alongside capital gains in Excel. | Instruction | how_to_steps | excel templates and portfolio tracking | 1x of 3 |
Passes
Does another pass still surface new queries? A flattening curve means the fan-out has stabilised.
Geminix = pass, y = cumulative unique queries
| Model | Pass | Target | Generated | Seconds | Tokens (in / out) | Notes |
|---|---|---|---|---|---|---|
| gemini-3.5-flash-lite | 1 | 10 | 10 | — | 913 / 1,224 | |
| gemini-3.5-flash-lite | 2 | 12 | 12 | — | 913 / 1,484 | |
| gemini-3.5-flash-lite | 3 | 12 | 12 | — | 913 / 1,369 |