Google Workspace Marketplace
Live crypto and tokenized stock prices in Google Sheets™. One formula, no API key — 10,000+ coins plus stocks, ETFs and commodities. RSI, MACD and auto-refresh on paid plans.
بواسطة:
تم تحديث البيانات في:15 نوفمبر 2026
يتوافق مع:
404
نظرة عامة
CryptoTrackPro adds custom formulas to Google Sheets™ that return live cryptocurrency prices and live prices for tokenized stocks, ETFs and commodities, directly in your cells.

Type =cryptotrackpro("BTC-USD") into any cell and the current price appears. There are no scripts to write, no API key to register and no CSV files to import.

The same spreadsheet can price digital assets and tokenized traditional assets side by side, so a single sheet can total a portfolio that holds both.


FORMULAS — ALL PLANS

=cryptotrackpro("BTC-USD")
Live price for a cryptocurrency pair. Covers 10,000+ cryptocurrencies listed on CoinMarketCap, quoted in major fiat currencies (USD, EUR, GBP, JPY, AUD, CAD, CHF and more) or against another coin, such as "BTC-ETH".

=cryptotrackproRWA("AAPL")
Live price for a tokenized real-world asset — 700+ stocks, ETFs and commodities such as NVDA, TSLA, SPY and GOLD. Add a currency suffix, for example "AAPL-GBP", to quote in another currency. A second argument returns "price", "marketcap" or "volume".

=cryptotrackproChange("BTC")
24-hour percentage change for a cryptocurrency.

=cryptotrackproData("BTC", "marketcap")
Market data for a cryptocurrency. Fields: change24h, change7d, marketcap, volume, rank.

=cryptotrackproPrice("BTC", "2025-01-01")
Historical daily reference price for supported cryptocurrency dates, useful alongside cost-basis records. Coverage varies by asset, quote currency and provider; keep actual execution prices and fees. Results are cached.


FORMULAS — BASE AND PRO PLANS

=cryptotrackproRSI("BTC", 14)
Relative Strength Index, 0–100, for the period you choose.

=cryptotrackproMACD("BTC", "line")
MACD (12/26/9). Returns the "line", "signal" or "histogram" value.

=cryptotrackproHistory("BTC", 30)
Historical OHLCV table that spills into the cells below: Date, Open, High, Low, Close and Volume, for up to 365 days.

Every formula recalculates like any other spreadsheet function, so it can be referenced by SUM, charts, pivot tables and conditional formatting in the usual way.


THE SIDEBAR

Open it from Extensions → CryptoTrackPro → Open CryptoTrackPro.

• Asset search with autocomplete — type a name rather than a ticker. "apple" finds AAPL, "ethereum" finds ETH. Covers the top 1,000 cryptocurrencies and every tokenized stock, ETF and commodity available. Tickers outside the suggestion list still work when typed in full.
• One-click insert — the chosen asset is written into the selected cell as a ready-made formula, so you do not have to remember the syntax.
• Quote-currency picker — USD, EUR, GBP, AUD, CAD, JPY, CHF, CNY, INR, KRW, BRL, ZAR, plus BTC and ETH, applied to the formulas you insert.
• Technical analysis — insert RSI, MACD and OHLCV history formulas.
• Live daily usage — lookups used, your limit and your current plan.
• Auto-refresh toggle.
• Price alerts (Base and Pro plans).


PRICE ALERTS (BASE AND PRO PLANS)

Set a price or 24-hour-change threshold for a USD pair in the sidebar and receive an email, Discord or Slack message when it is crossed.

• Alerts are checked server-side every few minutes, also while the spreadsheet is closed.
• Alerts do not use your daily lookups.


MENU COMMANDS

Extensions → CryptoTrackPro gives you:

• Open CryptoTrackPro — opens the sidebar.
• Refresh All Prices — refetches every CryptoTrackPro formula in the spreadsheet at once.
• Insert Formula — inserts a price formula into the selected cell.
• Create Tax Report — builds a cost-basis sheet. Enter each purchase (coin, date, quantity) and the historical buy price, per-lot profit or loss and short-term or long-term classification are filled in for you.
• Usage Status — shows today's lookup count and your plan.


FREE TEMPLATE

A ready-made spreadsheet is available from the Copy Free Template button in the sidebar, or at cryptotrackpro.com/template. Make a copy in Google Drive™ and it opens with six tabs already wired to CryptoTrackPro formulas:

• Portfolio — holdings, cost basis, profit and loss in $ and %, and allocation.
• Market — price, 24-hour and 7-day change, market cap, volume and rank.
• Stocks & Metals — tokenized stocks, ETFs, gold and silver next to your crypto.
• Technicals — RSI and MACD (Base and Pro plans).
• Historical — the price on a past date, plus OHLCV history on Base and Pro.
• Guide — every formula with an example.

The template itself is free; its live prices count towards your daily lookups.


HOW PRICES REFRESH

Prices are fetched when a formula first evaluates and are then served from a short-lived cache, so a busy dashboard does not consume a lookup for every recalculation.

• On demand — use Refresh All Prices at any time.
• Auto-refresh — re-runs your prices every 30 minutes on the Base plan or every 5 minutes on the Pro plan, for as long as the CryptoTrackPro sidebar is open in that spreadsheet. Google Sheets™ add-ons cannot run a timer in a closed sidebar.
• On reopen — prices also refresh when you reopen the spreadsheet, within your daily lookup allowance.


DATA SOURCE

Cryptocurrency and tokenized-asset prices come from CoinMarketCap. Historical daily closes are matched to exchange candle data.

Tokenized real-world assets are blockchain tokens that track an underlying stock, ETF or commodity. Their traded price follows the underlying but can differ from it, particularly for thinly traded tokens.

Prices are provided for information only and are not investment advice.


PRIVACY

• Stored — account and plan records, daily usage counts and operational diagnostics.
• Within Google Apps Script™ — the add-on scans formulas and resolves referenced symbols or dates.
• Sent to our backend — your account email and requested market-data parameters. Holdings and portfolio totals are not sent.
• Third parties — Stripe processes subscriptions and Resend delivers account notifications.

The full policy is at cryptotrackpro.com/privacy-policy.


PLANS AND DAILY LIMITS

• New accounts start with a 30-day Base trial — no card required. When it ends, the account moves to Free with 20 lookups per day (the limit for new accounts) unless you subscribe.
• Base — $3.99 per month or $39.99 per year. 500 lookups per day, auto-refresh every 30 minutes while the sidebar is open, the RSI, MACD and OHLCV history formulas, and up to 10 price alerts delivered by email, Discord or Slack.
• Pro — $11.99 per month or $119.99 per year. Unlimited lookups, auto-refresh every 5 minutes while the sidebar is open, and up to 50 price alerts.

Your remaining lookups are shown in the sidebar, and the count resets daily. Paid plans include a 14-day money-back guarantee and can be cancelled at any time.


GETTING STARTED

1. Install CryptoTrackPro and open a spreadsheet in Google Sheets™.
2. Choose Extensions → CryptoTrackPro → Open CryptoTrackPro and grant the requested permissions.
3. Type =cryptotrackpro("BTC-USD") in a cell, or search for an asset in the sidebar and click Insert. Turn on Auto-refresh to keep the sheet updating while the sidebar is open.

Documentation, worked examples and support are at cryptotrackpro.com.

Google Sheets™, Google Drive™ and Google Apps Script™ are trademarks of Google LLC. CryptoTrackPro is an independent product and is not affiliated with, endorsed by or sponsored by Google LLC.
معلومات إضافية
الأسعارميزات بدون أي تكلفة مع ميزات مدفوعة
مطوّر برامج
غير تاجر
الدعم
سياسة الخصوصية
بنود الخدمة
سيطلب منك التطبيق CryptoTrackPro – Crypto & Stock Prices الأذونات المُوضَحة أدناه. مزيد من المعلومات
سيحتاج التطبيق CryptoTrackPro – Crypto & Stock Prices إلى الدخول إلى حسابك على Google.
سيسمح ذلك لتطبيق CryptoTrackPro – Crypto & Stock Prices بما يلي:
عرض جداول البيانات التي تمّ تثبيت هذا التطبيق فيها، وإدارتها
الاتصال بخدمة خارجية
عرض المحتوى التابع لجهة خارجيه وتشغيله في رسائل المطالبات والأشرطة الجانبية في تطبيقات Google
السماح بتشغيل هذا التطبيق في غيابك
عرض وإدارة البيانات المقترنة بالتطبيق
الاطّلاع على عنوان البريد الإلكتروني الرئيسي لحسابك على Google
الاطّلاع على بياناتك الشخصية، بما في ذلك أيّ بيانات شخصية قد جعلتها متاحة للجميع
التعليقات
اللغة:
ترتيب بحسب:
لا تتحقق Google من المراجعات أو التقييمات. مزيد من المعلومات حول المراجعات
لا تعليقات
بحث
محو البحث
إغلاق البحث
تطبيقات Google
القائمة الرئيسية