CoinGecko: Live Crypto Prices & Market Data
de GeckoLabs
Easiest way to pull live & historical crypto market data into Excel™ spreadsheets with one formula
Bring the power of CoinGecko’s world-leading cryptocurrency data directly into your Excel™ spreadsheets.
Designed for professional analysts and DeFi traders, this add-in provides institutional-grade access to 18,000+ coins and 30 million+ onchain tokens aggregated across 1,700+ exchanges and 250+ networks.
Key Features
Live Price and Market Data
Fetch real-time cryptocurrency prices using simple, native Excel formulas:
- =CG.PRICE("bitcoin") — Current Bitcoin price in USD
- =CG.PRICE("solana") — Current Solana price in USD
Onchain and DEX Data
Track decentralized exchange prices for any token with a contract address—powered by GeckoTerminal:
- =CG.ONCHAIN("eth", "0xa0b...eb48") — Ethereum network token
- =CG.ONCHAIN("solana", "2zM...ds76") — Solana SPL token
Perfect for meme coin hunters, DeFi researchers, and long-tail altcoin portfolio trackers.
NFT Floor Prices
Monitor NFT collection floor prices directly in your spreadsheet — no third-party tools needed:
- =CG.NFT("pudgy-penguins") — Pudgy Penguins floor price
Historical Price Data
Build backtesting models, analyze price trends, or power your crypto trading journal:
- =CG.HISTORY("bitcoin", "2021-12-31") — Bitcoin price on a specific date (UTC 00:00)
Market Cap Rankings
Import up to 5,000 tokens in a single formula:
- =CG.TOP(100) — Top 100 cryptocurrencies by market cap
- =CG.TOP(50, "decentralized-exchange") — Top 50 DEX tokens
High Performance
Built with streaming technology to handle up to 10,000 rows without freezing Excel.
Getting Started
- Install the add-in from Microsoft Marketplace or the Excel Add-ins store.
- Open any Microsoft Excel™ document.
- Get your API key (free Demo plan or a paid Pro plan) at https://www.coingecko.com/en/api/pricing
- Enter your key via Add-ins → CoinGecko → Settings.
- Start tracking: Type =CG.PRICE("bitcoin") in any cell and press Enter.
Pricing
The add-in itself is free to install. API usage is billed through your CoinGecko API plan:
- Demo API (Free): Suitable for personal portfolio tracking and casual use.
- Pro API (Paid): Higher rate limits and access to 10 years+ historical data for power users and professionals.
Support and Resources
For full documentation and advanced guides, visit: https://docs.coingecko.com/docs/excel
Stop copy-pasting and start automating your crypto research today.
Capacitățile aplicației
- Poate să citească și să aducă modificări documentului
- Poate să transmită date prin internet