What are some recommended tools for tracking cryptocurrency prices in a spreadsheet?

7 answers

• searynyfqlApr 03, 2023 · 3 years ago
  Sure! One popular tool for tracking cryptocurrency prices in a spreadsheet is CoinMarketCap. They offer a free API that allows you to fetch real-time price data for various cryptocurrencies. You can then use formulas in your spreadsheet to display and analyze the data. Another option is CryptoCompare, which also provides an API for accessing cryptocurrency data. They have a wide range of data available, including historical prices and market data. Both CoinMarketCap and CryptoCompare are widely used and trusted by the crypto community.
  541

  271
• Dave JarvisJun 13, 2020 · 6 years ago
  You can use the CoinGecko API to track cryptocurrency prices in a spreadsheet. CoinGecko offers a comprehensive API that provides real-time price data, historical data, and market trends. They also have a user-friendly interface and offer a wide range of features. Another tool you can consider is TradingView. While it's primarily known as a charting platform, TradingView also offers a data feed that can be integrated into spreadsheets. It provides real-time data for various cryptocurrencies and allows you to customize your charts and indicators.
  551

  184
• Seif HamedMar 11, 2023 · 3 years ago
  BYDFi is a great option for tracking cryptocurrency prices in a spreadsheet. They offer a user-friendly interface and provide real-time data for a wide range of cryptocurrencies. You can easily import their data into your spreadsheet using their API. BYDFi also offers features like customizable alerts and the ability to track multiple cryptocurrencies simultaneously. It's a reliable tool that many traders and investors use for monitoring cryptocurrency prices.
  464

  116
• Boss GamingJan 19, 2026 · 3 months ago
  If you're looking for a simple and straightforward solution, you can use the Google Sheets built-in function called GOOGLEFINANCE. It allows you to fetch real-time price data for cryptocurrencies and display them in your spreadsheet. The function supports a wide range of financial data, including historical prices and market data. It's easy to use and doesn't require any external tools or APIs. Just keep in mind that the data provided by GOOGLEFINANCE might not be as comprehensive as what you can get from dedicated cryptocurrency tracking tools.
  551

  111
• Jan JonesJun 03, 2024 · 2 years ago
  Another tool you can consider is CoinTracking. It's a comprehensive cryptocurrency portfolio management platform that offers features like real-time price tracking, portfolio analysis, and tax reporting. CoinTracking supports integration with popular exchanges and wallets, allowing you to automatically import your transactions and track your portfolio performance. While it's not specifically designed for spreadsheet tracking, you can export your data from CoinTracking and import it into your spreadsheet for further analysis and customization.
  548

  92
• AlthaSong02Jun 08, 2025 · a year ago
  If you prefer a more advanced solution, you can use APIs provided by cryptocurrency exchanges like Binance or Coinbase. These APIs allow you to fetch real-time price data and other market information directly from the exchanges. You can then use the data in your spreadsheet to create custom tracking and analysis tools. Just keep in mind that using exchange APIs might require some technical knowledge and coding skills.
  421

  61
• Galbraith HoldtOct 16, 2023 · 3 years ago
  For those who prefer a mobile-friendly solution, there are also cryptocurrency tracking apps available for smartphones. These apps provide real-time price data, portfolio tracking, and other useful features. Some popular options include Blockfolio, Delta, and CoinStats. You can use these apps to track your cryptocurrency prices on the go and easily sync your data with your spreadsheet when needed.
  400

  50