Back to blog
Crypto Basics

How to Get Crypto Price Data in Excel and Google Sheets?

Learn how to get crypto data in Excel and Google Sheets in this step-by-step guide.
Token Metrics Team
5 minutes
Want Smarter Crypto Picks—Free?
See unbiased Token Metrics Ratings for BTC, ETH, and top alts.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
 No credit card | 1-click unsubscribe

Cryptocurrencies have become increasingly popular over the past few years, and more people are now investing in them. As a result, there is a growing need for tools and methods that can help investors track their cryptocurrency holdings and monitor market trends.

One such tool is the use of an API to pull crypto data into an Excel spreadsheet. This method allows investors to easily analyze and manipulate data in a familiar format. In this article, we will explore the steps involved in pulling crypto data into an Excel and Google spreadsheet using Token Metrics Crypto Data API. 

Token Metrics API Overview

The Token Metrics Data API is a comprehensive data solution that offers both real-time and historical market data for cryptocurrencies. Its purpose is to aid developers and businesses in accessing and analyzing data promptly to make informed decisions.

Regardless of whether you're a seasoned developer or just starting in the cryptocurrency world, you can maximize your crypto portfolio using the end-points provided by Token Metrics. 

The Data API provides a stream of 14 endpoints, including exclusive grades, analytics, and indicators, that can be utilized to empower your bots, models, and platforms. The data provided by the API can assist you in:

  • Validating
  • Back-testing, and 
  • Refining your investment decision-making process. 

Let’s check the process of pulling the crypto data into an Excel sheet in the 7-step breakdown below…

Import Crypto Data in Google Sheets and Excel

Here’s the step-by-step breakdown of extracting crypto data into an Excel Sheet using Token Metrics:

1. Register on Token Metrics Platform

First, head over to www.tokenmetrics.com/crypto-data-api and login/signup using your credentials.

Note: If you are new to Token Metrics, then click on Register, and sign-up for a 7-day free trial. One Bonus: You can pay with NFT.

Token metrics free trial

2. Go to Homepage

Once you are in, you will be guided to the homepage, where you will have all rating of crypto assets, as shown below:  

Token metrics crypto market page

3. Click on the DATA API

Now, click on the “DATA API” from the Menu Bar on the top. [Refer to the image below]

Click on Data API

4. Generate Access Key

From here, you need to generate your access key using the "Generate Access Key" button [as seen on the top-right corner of the image below]. 

Generate access key

Important Note:

Copy and save the access key shown on the next page as it will not be made visible again.

5. Open Google Sheets

It’s now time to open Google Sheets and create a new spreadsheet.

In this new spreadsheet, enter some crypto assets under Column 1 and their symbol in Column 2 like this.

Open Google Sheet

Here, we have put TM Token ID in Column 3, a unique identifier associated with each token in the TM Data API ecosystem. This will make your life easier once you become familiar with our interface on a daily basis.

In Column 4 and Column 5, we have put TM Investor Grade and TM Trader Signal, respectively, which will be fetched from TM Data API in the following steps.

6. Go to Extensions and click Apps Script

Now, hover over to the "Extensions" tab under the menu bar and click "Apps Script" where we will write scripts to automate the fetching of the above metrics in the Google Sheets. 

Go to Extensions and click Apps Script

7. Apps Script IDE

Now, our powerful ‘Apps Script IDE’ will be opened, where we will write the code to the script and later deploy as necessary. 

Apps Script IDE

The Code Format: 

We will start writing the script in Code.gs file.

The following part will be focused on the actual code that will be written in the script file.

Run the Open() function once using the above command, and you will see a menu "Update Metrics" in the spreadsheet menu bar with the following options:

  • TM Token Ids
  • TM Investor Grade
  • TM Trader Signal 

You can click on all the three options, one at a time, to see the results displayed on the spreadsheet.

crypto data results

Also, you can update the metrics whenever required by pressing the above buttons in the menu bar, so that you get the accurate data for your investments. 

Crypto data metrics on Google sheet

Interested?

Looking to learn more about our Crypto data API?

Just head over here - developers.tokenmetrics.com

Having explained all this, let the truth be told. Token Metrics does not personally favor or vouch for any particular cryptocurrency in the market. 

The Bottom Line

In conclusion, pulling crypto data into an Excel spreadsheet using an API can be a useful and efficient way to keep track of market trends and analyze cryptocurrency performance. 

By following the steps outlined in this process, one can easily integrate an API into Excel and retrieve real-time data on various cryptocurrencies. 

Additionally, with the vast array of features available on Token Metrics API, one can tailor their data retrieval to specific preferences and easily manipulate the data in Excel for further analysis. 

With the growing importance of cryptocurrencies in the financial world, utilizing APIs to pull crypto data into Excel can provide a valuable tool for traders, investors, and researchers alike.

Build Smarter Crypto Apps &
AI Agents in Minutes, Not Months
Real-time prices, trading signals, and on-chain insights all from one powerful API.
Grab a Free API Key
About Token Metrics
Token Metrics: AI-powered crypto research and ratings platform. We help investors make smarter decisions with unbiased Token Metrics Ratings, on-chain analytics, and editor-curated “Top 10” guides. Our platform distills thousands of data points into clear scores, trends, and alerts you can act on.
30 Employees
analysts, data scientists, and crypto engineers
Daily Briefings
concise market insights and “Top Picks”
Transparent & Compliant
Sponsored ≠ Ratings; research remains independent
Want Smarter Crypto Picks—Free?
See unbiased Token Metrics Ratings for BTC, ETH, and top alts.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
 No credit card | 1-click unsubscribe
Token Metrics Team
Token Metrics Team

Recent Posts

Research

Why Manual Crypto Portfolio Management Is Costing You Money (And Time)

Token Metrics Team
6

You're tracking 50+ tokens across three exchanges, updating your rebalancing spreadsheet every weekend, and second-guessing every exit decision at 2 AM. Sound familiar? Manual crypto portfolio management isn't just exhausting—it's expensive. Between missed rebalances, execution drag, and behavioral mistakes during volatility, DIY portfolio management quietly erodes returns before you see any market gains.

The data tells the story: investors who manually manage diversified crypto portfolios typically underperform comparable automated strategies by 12-18% annually, with 60% of that gap coming from operational inefficiency rather than market timing. If you're spending 10+ hours weekly maintaining positions, those hours have a cost—and it's higher than you think.

The Hidden Costs Destroying Your Returns

Time Drain: The 500-Hour Tax

Managing a diversified crypto portfolio demands constant vigilance. For investors holding 20+ positions, the weekly time investment breaks down to approximately:

  • Market monitoring: 5-8 hours tracking prices, news, and on-chain metrics
  • Rebalancing calculations: 2-3 hours determining optimal weights and required trades
  • Order execution: 3-5 hours placing trades across multiple platforms
  • Record keeping: 1-2 hours logging transactions for tax reporting
  • Research updates: 3-5 hours staying current on project developments

That's 14-23 hours weekly, or 728-1,196 hours annually. At a conservative $50/hour opportunity cost, you're spending $36,400-$59,800 in time value maintaining your portfolio. Even if you value your time at minimum wage, that's still $10,000+ in annual "sweat equity" that automated solutions eliminate.

Execution Drag: Death by a Thousand Trades

Small trades erode portfolios through accumulated friction. Every manual rebalance across a 50-token portfolio requires dozens of individual transactions, each incurring:

  • Trading fees: 0.1-0.5% per trade (average 0.25%)
  • Bid-ask spreads: 0.2-0.8% depending on liquidity
  • Slippage: 0.3-1.2% on smaller cap tokens
  • Gas fees: $2-50 per transaction depending on network congestion

For a $100,000 portfolio rebalanced monthly with 40 trades per rebalance, the costs add up:

  • Average cost per trade: ~$100
  • Monthly execution drag: $4,000
  • Annual execution drag: $48,000 (48% of portfolio value)

The smaller your individual trades, the worse the ratio becomes. A $500 rebalancing trade on a low-liquidity altcoin might pay $25 in fees—a 5% instant loss before any price movement.

Automated indices solve this. TM Global 100, Token Metrics' rules-based index, consolidates 100 individual positions into a single transaction at purchase, with weekly rebalances executed through optimized smart contract batching. Users typically save 3-7% annually in execution costs alone compared to manual approaches.

Behavioral Mistakes: Your Worst Enemy Is in the Mirror

Market psychology research shows that manual portfolio managers tend to make predictable, costly mistakes:

  • Panic selling during drawdowns: When Bitcoin drops 25% in a week, can you stick to your exit rules? Many override their plans during high volatility, often selling near local bottoms.
  • FOMO buying at peaks: Tokens up 300% in a week attract chase behavior, with managers entering after the movement is mostly over.
  • Rebalancing procrastination: Putting off rebalancing leads to drift, holding too much of past winners and missing new opportunities.

Token Metrics' systematic approach removes emotion from the equation. The TM Global 100 Index follows a transparent ruleset: hold the top 100 tokens by market cap during bullish phases, shift to stablecoins during bearish cycles, and rebalance weekly—eliminating emotional override and procrastination.

Missed Rebalances: Drifting Out of Position

Market cap rankings shift constantly. A token ranked #73 on Monday might hit #95 by Friday, or surge to #58. Without systematic rebalancing, your portfolio becomes a collection of recent winners or dumpers.

In Q3 2024, Solana ecosystem tokens surged while Ethereum DeFi tokens consolidated. Manual managers who missed weekly rebalances held too much ETH and insufficient SOL exposure. The result: 15-20% underperformance compared to systematically rebalanced portfolios. Data from Token Metrics shows that weekly rebalancing outperforms monthly or quarterly approaches by 8-12% annually.

Tax Reporting Nightmares

Every trade creates a taxable event. Manual managers executing over 200 trades yearly face:

  • Hours spent compiling transaction logs
  • Reconciliation across multiple exchanges
  • Cost-basis tracking for numerous lots
  • High professional accounting fees ($500-2,000+)

Automated solutions like Token Metrics provide transparent transaction logs for each rebalance, simplifying tax reporting and reducing accounting costs.

The Token Metrics Advantage: Research Meets Execution

Token Metrics has established itself as a leading crypto analytics platform, supporting over 50,000 users with AI-powered token ratings, market regime detection, portfolio optimization tools, and trading signals. But analysis alone isn't enough—implementation is crucial.

TM Global 100 Index bridges this gap. It turns research into actionable, tradeable products by automating rebalancing based on Token Metrics' signals and methodology. One click replaces hours of manual work, following a validated systematic approach.

Automation Without Compromise

The best automation is transparent. TM Global 100 offers:

  • Rules-Based Discipline: Bull markets—hold top 100 tokens; bear markets—move to stablecoins
  • Weekly rebalancing every Monday
  • Full methodology disclosure
  • One-Click execution via embedded self-custodial wallet
  • Real-time market insights and holdings visualization
  • Transaction logs with fees and timestamps

This streamlined process allows users to rapidly execute disciplined rebalancing, saving countless hours and increasing operational efficiency while maintaining asset control.

Decision Framework: When to Automate

Automation suits investors who:

  • Hold 15+ tokens and find rebalancing burdensome
  • Miss optimal rebalancing windows due to time constraints
  • Have experienced emotional trading decisions during volatility
  • Spend over 5 hours a week on portfolio management
  • Want broad exposure without manual tracking

Manual management may be suitable for those with fewer positions, active trading infrastructure, or tactical strategies. For most diversified portfolios, automation enhances efficiency and reduces operational errors.

The Compound Effect of Efficiency

Small inefficiencies compound over time. Over five years, a $50,000 portfolio managed manually with a 12% annual return minus 4-2-1% losses yields roughly a 5% net return, ending at about $63,814. A systematic approach with optimizer integration, zero behavioral errors, and regular rebalancing can attain a 13% net return, reaching approximately $92,246—an increase of over $28,000, not counting time saved.

Conclusion: Time Back, Returns Up

Manual crypto portfolio management made sense when portfolios were small and concentrated. Today’s diversified sets require operational discipline to prevent erosion of returns due to execution drag, missed rebalances, and emotional mistakes. Token Metrics built TM Global 100 to turn research into automated, transparent execution, reclaim your time, and boost portfolio discipline—without sacrificing control.

Research

Moonshots API: Discover Breakout Tokens Before the Crowd

Token Metrics Team
5

The biggest gains in crypto rarely come from the majors. They come from Moonshots—fast-moving tokens with breakout potential. The Moonshots API surfaces these candidates programmatically so you can rank, alert, and act inside your product. In this guide, you’ll call /v2/moonshots, display a high-signal list with TM Grade and Bullish tags, and wire it into bots, dashboards, or screeners in minutes. Start by grabbing your key at Get API Key, then Run Hello-TM and Clone a Template to ship fast.

What You’ll Build in 2 Minutes

Why This Matters

Discovery that converts. Users want more than price tickers, they want a curated, explainable list of high-potential tokens. The Moonshots API encapsulates multiple signals into a short list designed for exploration, alerts, and watchlists you can monetize.

Built for builders. The endpoint returns a consistent schema with grade, signal, and context so you can immediately sort, badge, and trigger workflows. With predictable latency and clear filters, you can scale to dashboards, mobile apps, and headless bots without reinventing the discovery pipeline.

Where to Find The Moonshots API

The cURL request for the Moonshots endpoint is displayed in the top right of the API Reference. Grab it and start tapping into the potential!

How It Works (Under the Hood)

The Moonshots endpoint aggregates a set of evidence—often combining TM Grade, signal state, and momentum/volume context—into a shortlist of breakout candidates. Each row includes a symbol, grade, signal, and timestamp, plus optional reason tags for transparency.

For UX, a common pattern is: headline list → token detail where you render TM Grade (quality), Trading Signals (timing), Support/Resistance (risk placement), Quantmetrics (risk-adjusted performance), and Price Prediction scenarios. This enables users to understand why a token was flagged and how to act with risk controls.

Polling vs webhooks. Dashboards typically poll with short-TTL caching. Alerting flows use scheduled jobs or webhooks to smooth traffic and avoid duplicates. Always make notifications idempotent.

Production Checklist

Use Cases & Patterns

Next Steps

FAQs

1) What does the Moonshots API return?

A list of breakout candidates with fields such as symbol, tm_grade, signal (often Bullish/Bearish), optional reason tags, and updated_at. Use it to drive discover tabs, alerts, and watchlists.

2) How fresh is the list? What about latency/SLOs?

The endpoint targets predictable latency and timely updates for dashboards and alerts. Use short-TTL caching and queued jobs/webhooks to avoid bursty polling.

3) How do I use Moonshots in a trading workflow?

Common stack: Moonshots for discovery, Trading Signals for timing, Support/Resistance for SL/TP, Quantmetrics for sizing, and Price Prediction for scenario context. Always backtest and paper-trade first.

4) I saw results like “+241%” and a “7.5% average return.” Are these guaranteed?

No. Any historical results are illustrative and not guarantees of future performance. Markets are risky; use risk management and testing.

5) Can I filter the Moonshots list?

Yes—pass parameters like min_grade, signal, and limit (as supported) to tailor to your audience and keep pages fast.

6) Do you provide SDKs or examples?

REST works with JavaScript and Python snippets above. Docs include quickstarts, Postman collections, and templates—start with Run Hello-TM.

7) Pricing, limits, and enterprise SLAs?

Begin free and scale up. See API plans for rate limits and enterprise options.

Research

Support and Resistance API: Auto-Calculate Smart Levels for Better Trades

Token Metrics Team
4

Most traders still draw lines by hand in TradingView. The support and resistance API from Token Metrics auto-calculates clean support and resistance levels from one request, so your dashboard, bot, or alerts can react instantly. In minutes, you’ll call /v2/resistance-support, render actionable levels for any token, and wire them into stops, targets, or notifications. Start by grabbing your key on Get API Key, then Run Hello-TM and Clone a Template to ship a production-ready feature fast.

What You’ll Build in 2 Minutes

A minimal script that fetches Support/Resistance via /v2/resistance-support for a symbol (e.g., BTC, SOL).

  • A one-liner curl to smoke-test your key.
  • A UI pattern to display nearest support, nearest resistance, level strength, and last updated time.

Next Endpoints to add

  • /v2/trading-signals (entries/exits)
  • /v2/hourly-trading-signals (intraday updates)
  • /v2/tm-grade (single-score context)
  • /v2/quantmetrics (risk/return framing)

Why This Matters

Precision beats guesswork. Hand-drawn lines are subjective and slow. The support and resistance API standardizes levels across assets and timeframes, enabling deterministic stops and take-profits your users (and bots) can trust.

Production-ready by design. A simple REST shape, predictable latency, and clear semantics let you add levels to token pages, automate SL/TP alerts, and build rule-based execution with minimal glue code.

Where to Find

Need the Support and Resistance data? The cURL request for it is in the top right of the API Reference for quick access.

👉 Keep momentum: Get API KeyRun Hello-TMClone a Template

How It Works (Under the Hood)

The Support/Resistance endpoint analyzes recent price structure to produce discrete levels above and below current price, along with strength indicators you can use for priority and styling. Query /v2/resistance-support?symbol=<ASSET>&timeframe=<HORIZON> to receive arrays of level objects and timestamps.

Polling vs webhooks. For dashboards, short-TTL caching and batched fetches keep pages snappy. For bots and alerts, use queued jobs or webhooks (where applicable) to avoid noisy, bursty polling—especially around market opens and major events.

Production Checklist

  • Rate limits: Respect plan caps; add client-side throttling.
  • Retries/backoff: Exponential backoff with jitter for 429/5xx; log failures.
  • Idempotency: Make alerting and order logic idempotent to prevent duplicates.
  • Caching: Memory/Redis/KV with short TTLs; pre-warm top symbols.
  • Batching: Fetch multiple assets per cycle; parallelize within rate limits.
  • Threshold logic: Add %-of-price buffers (e.g., alert at 0.3–0.5% from level).
  • Error catalog: Map common 4xx/5xx to actionable user guidance; keep request IDs.
  • Observability: Track p95/p99; measure alert precision (touch vs approach).
  • Security: Store API keys in a secrets manager; rotate regularly.

Use Cases & Patterns

  • Bot Builder (Headless): Use nearest support for stop placement and nearest resistance for profit targets. Combine with /v2/trading-signals for entries/exits and size via Quantmetrics (volatility, drawdown).
  • Dashboard Builder (Product): Add a Levels widget to token pages; badge strength (e.g., High/Med/Low) and show last touch time. Color the price region (below support, between levels, above resistance) for instant context.
  • Screener Maker (Lightweight Tools): “Close to level” sort: highlight tokens within X% of a strong level. Toggle alerts for approach vs breakout events.
  • Risk Management: Create policy rules like “no new long if price is within 0.2% of strong resistance.” Export daily level snapshots for audit/compliance.

Next Steps

  • Get API Key — generate a key and start free.
  • Run Hello-TM — verify your first successful call.
  • Clone a Template — deploy a levels panel or alerts bot today.
  • Watch the demo: Compare plans: Scale confidently with API plans.

FAQs

1) What does the Support & Resistance API return?

A JSON payload with arrays of support and resistance levels for a symbol (and optional timeframe), each with a price and strength indicator, plus an update timestamp.

2) How timely are the levels? What are the latency/SLOs?

The endpoint targets predictable latency suitable for dashboards and alerts. Use short-TTL caching for UIs, and queued jobs or webhooks for alerting to smooth traffic.

3) How do I trigger alerts or trades from levels?

Common patterns: alert when price is within X% of a level, touches a level, or breaks beyond with confirmation. Always make downstream actions idempotent and respect rate limits.

4) Can I combine levels with other endpoints?

Yes—pair with /v2/trading-signals for timing, /v2/tm-grade for quality context, and /v2/quantmetrics for risk sizing. This yields a complete decide-plan-execute loop.

5) Which timeframe should I use?

Intraday bots prefer shorter horizons; swing/position dashboards use daily or higher-timeframe levels. Offer a timeframe toggle and cache results per setting.

6) Do you provide SDKs or examples?

Use the REST snippets above (JS/Python). The docs include quickstarts, Postman collections, and templates—start with Run Hello-TM.

7) Pricing, limits, and enterprise SLAs?

Begin free and scale as you grow. See API plans for rate limits and enterprise SLA options.

Disclaimer

This content is for educational purposes only and does not constitute financial advice. Always conduct your own research before making any trading decisions.

Choose from Platinum, Gold, and Silver packages
Reach with 25–30% open rates and 0.5–1% CTR
Craft your own custom ad—from banners to tailored copy
Perfect for Crypto Exchanges, SaaS Tools, DeFi, and AI Products