Download Coin Sheets, Templates and Dashboards





Simple and easy to use Google Sheet Dashboard to import live Crypto prices from Google Finance. 

Description: The file imports real-time and historical prices. Importing historical prices for different periods and coins from the drop list is possible. The sheet also has simple historical data statistics: average, minimum, and maximum price. Download the file, and upload it to your Google Drive. On your local computer file will work as Excel without connection with Google Finance.

Click here to download. For any personalization or improvement, feel free to direct message me on LinkedIn or X. 

Popular posts from this blog

Import Crypto live prices into Excel

Image
 Excel is a powerful tool that can be leveraged to track cryptocurrency prices. There are several methods to achieve this, but I shall explain a process in this article: Built-in Stock Data in this article.  Excel offers to fetch real-time prices for a limited number of cryptocurrencies without additional Add-ins, code, or API. This is free and the simplest method available to everyone, but the method restricts the available cryptocurrencies. At the moment of publishing this article available crypto are: -         Bitcoin (BTC) -         Ethereum (ETH) -         Litecoin (LTC) -         Bitcoin Cash (BCH) -         Ripple (XRP). To track a wider range of cryptocurrencies, including lesser-known or newly launched ones, you'll need to use third-party APIs or some of ...
Read more

Use GOOGLEFINANCE Function to Import Crypto prices into Google Sheets

Image
 Understanding "GOOGLEFINANCE" The GOOGLEFINANCE function is a powerful and handy tool that is a Built-In Function in Google Sheets that allows you to fetch real-time financial data directly into your spreadsheet. It's particularly useful for tracking stock prices, exchange rates, and cryptocurrency prices as we'll explore. The GOOGLEFINANCE function enables the creation of simple trackers or grandiose dashboards into Google Sheets without code, API, or anything else. Unlike most of the other solutions, importing real-time and historical prices using the GOOGLE FINANCE function  is free.  Basic Syntax: =GOOGLEFINANCE(ticker, attribute, [start_date], [end_date], [interval]) ticker: The symbol for the asset you want to track (e.g., "BTC-USD" for Bitcoin in USD). attribute: Optional. Specifies the type of data you want to retrieve (e.g., "price", "close", "high", "low", "open", "volume"). I...
Read more

Use Exponential Moving Average in Crypto Technical Analysis in Excel or Google Sheets

Image
  Understanding the Exponential Moving Average in Crypto Technical Analysis Cryptocurrency trading is a dynamic field that demands traders stay ahead of the curve with accurate and responsive tools. Among these tools, the Exponential Moving Average (EMA) stands out due to its ability to smooth out price data, making trends more apparent. This blog post delves into the EMA, its history, calculation, and application in cryptocurrency trading. A Brief History of the Exponential Moving Average The Exponential Moving Average is a type of weighted moving average that assigns greater importance to the most recent data points. Developed in the 1950s by technical analysts, the EMA was designed to address the lag problem inherent in Simple Moving Averages (SMA). This responsiveness makes the EMA particularly useful in the fast-paced world of cryptocurrency trading, where price volatility is a common occurrence. EMA vs. SMA: What's the Difference? The Simple Moving Average (SMA) calculates th...
Read more