How to refresh ...

Overview

Refresh Methods...

Streaming Refre...

Refresh Examples

Googlesheets

Excel

Custom Function...

Limitations

## How to refresh data in Cryptosheets

### Overview
There are multiple ways to refresh data in both <linkify text="Excel"></linkify>
& <linkify text="Googlesheets"></linkify>. Some methods may be limited by your <linkify text="subscription"></linkify> which you can see on the <linkify text="subscription"></linkify> page. This page explores various methods & examples for both environments.

![IMG](https://res.cloudinary.com/cryptosheets/image/upload/v1571966039/cryptosheets-docs/excel/functions/exrate-hp-9.gif)


<iframe
  style={{ maxWidth: "570px" }}
  width="570"
  height="350"
  src="https://www.youtube.com/embed/2xYvhc-3KA8"
  frameborder="0"
  allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture"
  allowfullscreen
></iframe>


### Refresh Methods (from your spreadsheet application)

1. Automatically refresh the entire workbook ([Google Sheets](https://intercom.help/cryptosheets/en/articles/4456485-how-to-configure-auto-refresh-for-googlesheets))
2. Refresh a single worksheet
3. Refresh a specific range of cells
4. Refresh a specific cell or formula
 
### Streaming Refresh Methods (from the source)

1. Streaming refresh (ie [`CS.EXRATE`](https://docs.cryptosheets.com/functions/streaming)) at custom intervals
2. Auto invocating refresh at custom intervals (ie [`CS.TIME`](https://docs.cryptosheets.com/functions/time) for Excel) useable with any integrated data source



### Refresh Methods (using templates)

[Read our extensive blog tutorial](https://medium.com/cryptosheets/how-to-build-a-real-time-streaming-cryptocurrency-dashboard-in-excel-in-5-minutes-60dca67a6627) on how to build a real time streaming dashboard using the CS.EXRATE custom function (Excel only)

[![img](https://miro.medium.com/max/1000/1*QRnBQV0MrPgGUevPotqFcw.gif)](https://medium.com/cryptosheets/how-to-build-a-real-time-streaming-cryptocurrency-dashboard-in-excel-in-5-minutes-60dca67a6627)







### Refresh Examples

> TIP: [Use Google](https://www.google.com/search?q=how+do+i+refresh+data+in+cryptosheets) to help search for Cryptosheets data refresh examples by adding a **`"?"`** to your question

**Example**: [`"How do I refresh data in Cryptosheets?"`](https://www.google.com/search?q=how+do+i+refresh+data+in+cryptosheets)

[![IMG](https://paradigmas.blob.core.windows.net/paradigmas-content/sharex/cryptosheets-docs_google_refreshing-data-search-questions-from-google.png)](https://www.google.com/search?q=how+do+i+refresh+data+in+cryptosheets)

### Googlesheets

Try these methods to manually or automatically refresh Cryptosheets data in Google Sheets

1. Using your keyboard select any cell with a formula then **`press F2 + enter`**

2. Change any parameter in the formula and/or change it back
   
   Example: <inline-code functionvalue='=CSPRICE("BTC","USD")'>=CSPRICE("BTC","USD")</inline-code> to <inline-code functionvalue='=CSPRICE("ETH","USD")'>=CSPRICE("ETH","USD")</inline-code>


2. [Using a checkbox - see YouTube tutorial](https://www.youtube.com/watch?v=2xYvhc-3KA8&list=PLBg8GR5ao-azCwkh769O7WUMPOKdleKNH&index=14&t=0s) from the Insert menu to create a trigger/control cell that others can link too

![](https://paradigmas.blob.core.windows.net/paradigmas-content/sharex/cryptosheets-docs_google_functions_insert-checkbox.png)

![](https://paradigmas.blob.core.windows.net/paradigmas-content/sharex/cryptosheets-docs_functions_google_pricea-refresh-example.png)

3. Using [Googlesheets built in spreadsheet settings](https://intercom.help/cryptosheets/en/articles/4456485-how-to-configure-auto-refresh-for-googlesheets)
4. [Using =GOOGLEFINANCE()](https://intercom.help/cryptosheets/en/articles/3972081-how-to-automatically-refresh-cryptosheets-custom-functions-data-in-excel-googlesheets-using-cs-time)

   <inline-code functionvalue='=CSPRICE("BTC","USD",,"Coinbase","ask",GOOGLEFINANCE("CURRENCY:USDEUR"))'>=CSPRICE("BTC","USD",,"Coinbase","ask",GOOGLEFINANCE("CURRENCY:USDEUR"))</inline-code>

   ![img](https://downloads.intercomcdn.com/i/o/246206395/2b52e9967491a70de99f8e18/image.png)

   ![img](https://downloads.intercomcdn.com/i/o/207124346/54bb53399eed1955a7a3c800/image.png)



### Excel

1. Using your keyboard select any cell with a formula then **`press F2 + enter`**

2. [Using a checkbox](https://www.youtube.com/watch?v=2xYvhc-3KA8&list=PLBg8GR5ao-azCwkh769O7WUMPOKdleKNH&index=14&t=0s) 
3. Using the [`CS.TIME`](https://docs.cryptosheets.com/functions/time) custom function as a scheduled trigger for other cells/formulas at custom intervals

   ![img](https://downloads.intercomcdn.com/i/o/207137503/62ff7ae9a5a28fe1697ca1ad/cryptosheets-docs_excel_functions_csprice-refresh-example%5B1%5D.png)

4. Using the [`CS.EXRATE`](https://docs.cryptosheets.com/functions/streaming) custom function for real time global VWAP pricing
5. Using a simple **control or trigger cell** (similar to the checkbox method)

   ![ControlCell](https://paradigmas.blob.core.windows.net/paradigmas-content/sharex/YT-1355-3873_cryptosheets-docs_providers_cryptosheets_console_csPRICEA-example6.gif)


### Custom Function Comparison

Below is a detailed comparison of the different features and capabilities of three of the most commonly used **[Cryptosheets custom functions](https://docs.cryptosheets.com/functions)** (aka formulas) including the ability for each to define specific data providers & sources (ie global VWAP default, exchanges, API providers) **and their built-in or supported refresh capabilities**

<div class="markdown">


| **functionality** | **[EXRATE](https://docs.cryptosheets.com/functions/streaming)** | **[PRICE](https://docs.cryptosheets.com/functions/price)** | **[PRICEA](https://docs.cryptosheets.com/functions/pricea)** |
|:-----------------------|:----------:|:----------:|:----------:|
| **live current price**                                                                             | ✅                            | ✅                          | ✅                          |
| **live, streaming prices** (streaming for Excel only)                                                                          | ✅ | ❌                          | ❌                          |
| **live, automatic custom refresh** (using CS.TIME in Excel only)                                                          | ❌                            | ✅  | ✅  |
| **built-in native refresh as a parameter**                                                          | ✅                            | ❌  | ❌  |
| **global VWAP** as default/fallback                                                                  | ✅                            | ✅                          | ✅                          |
| specific **[pricing from over 314+ exchanges](https://docs.cryptosheets.com/metadata)**                                                        | ❌                            | ✅                          | ✅                          |
| specific **[pricing from over 588+ exchanges](https://docs.cryptosheets.com/metadata)**                                                        | ❌                            | ❌                          | ✅                          |
| [**default price source overrides** (for CoinGecko, CryptoCompare, Messari)](https://docs.cryptosheets.com/functions/pricea)                           | ❌                            | ❌                          | ✅                          |
| **historical prices** by date/time                                                                   | ❌                            | ✅                          | ✅                          |
| supports single string **`symbolId` parameter**                                                        | ❌                            | ❌                          | ✅                          |
| **supports the `source` parameter**                                                                    | ❌                            | ❌                          | ✅                          |
| **market price type** (bid/mid/ask)                                                                  | ❌                            | ✅                          | ✅                          |
| **derivatives live, current pricing** (futures, options, perpetuals, swaps, index, credit)           | ❌                            | ❌                          | ✅                          |
| **derivatives historical pricing by date/time** (futures, options, perpetuals, swaps, index, credit) | ❌                            | ❌                          | ✅                          |

</div>

> **[See the full help center article on CS.EXRATE vs CS.PRICE vs CS.PRICEA here](https://intercom.help/cryptosheets/en/articles/4448907-what-s-the-difference-between-cs-exrate-vs-cs-price-vs-cs-pricea)**


### Limitations

> **TIP**: Remember that just because you are refreshing a formula or API call in your spreadsheet doesn't necessarily mean the actual underlying data (from the source) is being refreshed at the same time or frequency

- Your **[Request concurrency limits](https://cryptosheets.com/pricing)** define the amount of API calls or formulas you can refresh simultaneously, if you exceed the limits of your subscription tier your formulas will ERROR out and add up towards your quota and potentially triggering your account to be auto-disabled - **[please read our help center tutorials = it's easy to avoid!](https://intercom.help/cryptosheets/en/articles/4283962-you-have-been-disabled-due-to-excessive-usage-or-errors)**
- You can **[monitor your quota usage in real time anytime](https://intercom.help/cryptosheets/en/articles/3712846-see-your-subscription-usage-in-real-time)** using the side panel or the **[CS.STATUS CSSTATUS custom function](https://intercom.help/cryptosheets/en/articles/4820458-use-the-status-function-to-run-a-quick-diagnostic-or-check-your-subscription-quota)**

#### Googlesheets
1. Does not support real time refresh or streaming


Learn several options for how to automatically refresh your Cryptosheets data in Excel and Google Sheets

How to refresh data in Cryptosheets

Data Refresh