How to Use CRYPTOFINANCE Add-On for Google Sheets

The CRYPTOFINANCE add-on for Google Sheets is a powerful tool designed to streamline cryptocurrency data management. By integrating real-time market insights directly into your spreadsheets, it enables users to track, analyze, and visualize data from 988+ cryptocurrencies across 29 exchanges. Now part of Cryptowatch, this add-on transforms Google Sheets into a dynamic platform for cryptocurrency portfolio management and reporting.

Why Use CRYPTOFINANCE in Google Sheets?

Key Benefits:

• Real-Time Data: Access live cryptocurrency prices, trends, and historical data.
• User-Friendly Interface: Leverage Google Sheets’ familiar environment for seamless data manipulation.
• Advanced Analytics: Utilize built-in formulas to generate reports, charts, and custom portfolios.

👉 Explore Cryptowatch’s API plans for tailored data access.

Plans & Pricing:

• Free Tier: 100 monthly requests (Fundamental package).
• Paid Options: Scalable credit-based subscriptions for higher request limits.

How to Install CRYPTOFINANCE

Step 1: Remove Old Versions

1. Open Google Sheets → Add-ons → Manage add-ons.
2. Locate CRYPTOFINANCE → Click ⋮ → Uninstall.

Step 2: Add the Script

1. Navigate to Tools → Script editor.
2. Delete existing code; paste the CRYPTOFINANCE.gs script.
3. Save and name the project.

Step 3: Authorize & Refresh

1. Click Run to grant permissions.
2. Refresh your spreadsheet. A CRYPTOFINANCE menu will appear in the toolbar.

How to Use CRYPTOFINANCE

1. Generate a Cryptowatch API Key

1. Log in to your Cryptowatch account.
2. Go to Account → API Access → Generate Key.
3. Copy the Public Key.

2. Link API to Google Sheets

1. In Sheets, select CRYPTOFINANCE → Enter Public API Key.
2. Paste the key → Click OK.

3. Extract Data with Formulas

• All Cryptocurrencies:
  =CRYPTOFINANCE("CRYPTOWATCH")
• Specific Pair (e.g., BTC/USD):
  =CRYPTOFINANCE("BTC/USD")

Creating a Custom Crypto Portfolio

Step-by-Step Guide:

1. New Tab: Name it "My Portfolio."
2. Headers: Copy relevant columns from your source sheet.
3. Data Transfer: Use formulas like ='All Cryptocurrency'!B4 to pull specific crypto data.
4. Auto-Fill: Drag formulas across columns to populate all fields.

👉 Optimize your portfolio management with advanced tracking tools.

FAQ Section

1. Is CRYPTOFINANCE free?

• Yes, but with limited requests (100/month). Paid plans offer expanded access.

2. Which exchanges does it support?

• Data is sourced from 29 major exchanges, including Binance, Coinbase, and Kraken.

3. Can I use historical data?

• Yes, depending on your Cryptowatch subscription tier.

4. How often does the data update?

• Real-time updates are available for live market tracking.

5. What if my API key expires?

• Generate a new key in Cryptowatch and update it in Google Sheets.

Advanced Tips

• Use Pivot Tables: Summarize large datasets for trend analysis.
• Set Alerts: Combine with Google Apps Script for price notifications.