# 卓尔金升级A2——参数读取

{% hint style="info" %}

### 参数读取由 [CryptoSheets](https://app.cryptosheets.com/) 和 [GlassNode](https://studio.glassnode.com/settings/api) 支持

未来考虑增加 <https://sheets.santiment.net/> 的支持
{% endhint %}

【链接】HowtopullCCXTdataintoExcelandGoogleSheets <https://docs.cryptosheets.com/providers/ccxt/>

<https://store.office.com/addinsinstallpage.aspx%3Frs=en-US&assetid=WA104381695&ui=en-US&ad=US>

<https://docs.cryptosheets.com/cryptosheets-concepts/beginner-tutorial/>

<https://docs.cryptosheets.com/functions/querya/>

<https://docs.cryptosheets.com/providers/glassnode/mvrv-z-score/>

<https://docs.cryptosheets.com/providers/cryptoquant/btc-mvrv/>

<https://docs.cryptosheets.com/providers/glassnode/stock-to-flow-ratio/>

<https://docs.cryptosheets.com/providers/glassnode/stock-to-flow-deflection/>

<http://help.cryptosheets.com/en/articles/3499319-troubleshooting-cannot-log-in-or-you-are-not-logged-in-and-other-login-errors>

{% hint style="info" %}
准备发起一个新活动，

目标是对接CryptoSheets。

1，练手：通过CryptoSheets读取各个币种对美元，人民币，比特币和以太坊的价格（群主已完成）

<http://help.cryptosheets.com/en/articles/4448907-what-s-the-difference-between-cs-exrate-vs-cs-price-vs-cs-pricea>

2，市值：通过CryptoSheets读取各个币种的美元市值（实时），输出到Excel表格。（通过<https://app.cryptosheets.com/#/templates/133>已完成）

<https://cryptosheets.com/templates>

<https://app.cryptosheets.com/#/browse/templates>

3，MVRV：通过CryptoSheets读取BTC的MVRV（当日），输出到Excel表格。(已完成)

<https://docs.cryptosheets.com/scenarios/marketcap-metrics---realized,-mvrv-and-basic-historical-marketcap/>

4，S2F：通过CryptoSheets读取BTC的S2F（当日），输出到Excel表格。

5，增加交易所排名支持

<https://app.cryptosheets.com/#/templates/428>
{% endhint %}

* [Unix时间与Excel时间转换](https://blog.csdn.net/flora_zhl/article/details/73920260)
* [通过Excel将Unix时间转换为日期时间](https://www.it1352.com/2037257.html)

| ![](https://ci3.googleusercontent.com/proxy/mIahoxuhPjkwSlmSzsvmRrjoiF85TWP8_HExCs5vLImyD0oAkHw9-8oy_fyRI4VXzxF2MD8vrl3QvVnaxn6XqpySq1Sx6rrrg6eYK6901klaUQobxjZ3LP3Bf5-Gz440z6dQLNAj_h1Va-e1t9vuU8XN=s0-d-e1-ft#https://cryptosheets.intercom-mail.com/i/o/163477801/e3239dd408a0f426c81e40be/File1573823790483) |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

|

Hi there,

## Refreshing Crypto API Data in Cryptosheets

\
![👉](https://fonts.gstatic.com/s/e/notoemoji/14.0/1f449/72.png) It's easy to refresh data with Cryptosheets and there are a number of different methods for both [Excel](https://cryptosheets.intercom-clicks.com/via/e?ob=dpNFJpA05C1%2BKysb%2Fo1pR18Yi5tfaM2nMFyRNYlmmLOoc82brdXNDa6vfEAzEHeHMDAh%2BTXQexalwHMA3W9WmBKiPFG2ikAjCr0e09k1%2FAtZZCL2URqUQzu8ZgRirvb7ygAUugzu6xlf0oRO2%2BBc1xT1RnKaFicQtOykHwv1l65UxwDihvDzwflehTRkX7ZG\&h=9123addc1eac27a678e297770eb0008262102047-w1ppxcjb_98178001422580\&l=cea91ab435d7b2e567051fba18d22d53ad7f6473-10924630) & [Googlesheets](https://cryptosheets.intercom-clicks.com/via/e?ob=vqJYWGSOSCthykQzXu6JvhJ0m%2BN4iq%2BPoPyBKkE48yDcyHe77%2ByRokFcgW9V15U0VsiM5FAhZNKAUFj2nE0ReSs77KOImgVvV6tpuApg6EIgjQ5ulxq1nUmF%2FW9RcK6OV7C9N2HkG0lMlSY39KGtj6BCp5l0oyPHGTPMdIF%2Fk9wCq1LiBrRG46VtL3i57fK2\&h=484961ee63b0f5137eeba1966a18ab46a4b3bc6e-w1ppxcjb_98178001422580\&l=5ffe088f06ec14104154cf671383ad4c972bf760-10924631).

We have several resources to help you understand and learn how to choose which method to use

* **Docs portal:** [Data refresh concepts](https://cryptosheets.intercom-clicks.com/via/e?ob=kKdxjVB4gYnhMEq7Zlnt1laBQ7W8tC%2FFDnFXaI4kYywzhYpzJ0eg9rr5CL20TBdpY8RCKDe%2B7pLz4e%2FJG2cZdzYxovWnSbt3aCMCqAiVxuE%3D\&h=2ccabdc34f23a7d428e7dc89eb15cc80958b0b7a-w1ppxcjb_98178001422580\&l=4770d824d7e9b778f49e4f092901c9338471f79c-10924632)
* **YouTube:** [Refreshing Crypto API Data playlist channel](https://cryptosheets.intercom-clicks.com/via/e?ob=ext542A0w%2BFEejiKaDnA3n4Inlczal0iZ%2BnK2TgCzWnQbqIhd%2B0%2F%2BEpl%2B1d5s1Bpl0nWU79PnfL5eB3HQUP%2ByHwxDOkGqglDResAQhQilX0%3D\&h=c7d209bdb4a3569821667602e61651d92d5d5902-w1ppxcjb_98178001422580\&l=bc7bc5061006db0d90dfbd823e8b5c2a5cb513ca-10924633)\
  \&#xNAN;*Make sure to subscribe to our YouTube channel to receive the latest examples and tutorials for how to refresh data*
* **Medium Blog**: [Focus articles on refreshing data](https://cryptosheets.intercom-clicks.com/via/e?ob=HHCGwsFeUzdyBfOUyJNBFc8%2FcYuaUNufyhzsAov4riEgn7BdkLejg3tywkvza3Hfdpdl41PUe6Cy47%2F%2FprqlPHSbpduENod9ArFiuXJwwZs0vepkpWuQGkveXkwvPPq8CJaHLhNsjWuFg9FPdP9bwy1VdTCFZj6NVOfhA83btbY0CiAUYuG6noQvQOv92Jv2\&h=706ca5267296c8fb2cbda18ca2848547e263112d-w1ppxcjb_98178001422580\&l=a207748c530ea8b58e9e36e32072161c9599f366-10924634) & [tutorials for real time dashboards](https://cryptosheets.intercom-clicks.com/via/e?ob=h02zjA6VYVfvkYffTfFeXKSYSrfzVcIe8CqjC9uELc2JLU2gOLSPbmE7VZTW05X6fg4ITTz%2Bj5fzcfhWr%2B6OIEPdfAImDS4Lg%2B2IevfIyC%2BgJkLTGGahjEqApig10lL7qA81aK%2BpUjvqBiWpK1ziUO%2BmeBLCV0CNdJlYKlhp3SE%3D\&h=02d3abc879d9fde87fb25adbafd6830246c06a5d-w1ppxcjb_98178001422580\&l=a931ed836a51cb1a887e9db6a936840e381124a9-10924635)

## Try some quick data refresh examples

*Excel & Google Sheets refresh capabilities are slightly different so checkout examples for both with Google Sheets examples at the bottom of this email.*

### [Excel](https://cryptosheets.intercom-clicks.com/via/e?ob=dpNFJpA05C1%2BKysb%2Fo1pR18Yi5tfaM2nMFyRNYlmmLOoc82brdXNDa6vfEAzEHeHMDAh%2BTXQexalwHMA3W9WmBKiPFG2ikAjCr0e09k1%2FAtZZCL2URqUQzu8ZgRirvb7ygAUugzu6xlf0oRO2%2BBc1xT1RnKaFicQtOykHwv1l65UxwDihvDzwflehTRkX7ZG\&h=9123addc1eac27a678e297770eb0008262102047-w1ppxcjb_98178001422580\&l=cea91ab435d7b2e567051fba18d22d53ad7f6473-10924630)

![✅](https://fonts.gstatic.com/s/e/notoemoji/14.0/2705/72.png) *Paste or type these formulas into any cell*<br>

### EXAMPLE 1

```
 =CS.EXRATE("BTC","USD",1)
```

[![](https://ci3.googleusercontent.com/proxy/BEBVs-iG1IE3Fs2ohdwVPCJgusgm3zR3pS3347coHmcmxwngn7MhD4DmnIk3Wi40TlYr3G8MuqJXnnoKrYlmojiYGW93sXH36EuSG3afZ9M9aLUVvWEgU5LUf4gK7Po-mWSpCPinyIQmyxM2GXCrGVX5OpZnwH4MADbsY6569uB5LHy1FerTIMZurg99ghQwzo3qZA7ylImz5Y8ZlwdcVg=s0-d-e1-ft#https://cryptosheets.intercom-mail.com/i/o/246207473/5359446bf38be6e50bbe465b/cryptosheets-docs_excel_functions_csEXRATE-example5%5B1%5D.gif)](https://cryptosheets.intercom-clicks.com/via/e?ob=dpNFJpA05C1%2BKysb%2Fo1pR18Yi5tfaM2nMFyRNYlmmLOoc82brdXNDa6vfEAzEHeHMDAh%2BTXQexalwHMA3W9WmBKiPFG2ikAjCr0e09k1%2FAtZZCL2URqUQzu8ZgRirvb7ygAUugzu6xlf0oRO2%2BBc1xT1RnKaFicQtOykHwv1l65UxwDihvDzwflehTRkX7ZG\&h=9123addc1eac27a678e297770eb0008262102047-w1ppxcjb_98178001422580\&l=25dc78d22b54724fc7213ede45dcdb961d625dbb-10924636)

### EXAMPLE 2

```
 =CS.PRICEA("base","BTC","quote","USD",A1,B1)
```

[![](https://ci4.googleusercontent.com/proxy/yPcyK7VIIYGQtXsBZQmOPm3yt1TUwnoNGr1j1ChhfmmdPG_CvASE8LlPSi1rlrW_oYOhMxVcHW94VfeiTLP45lOjYoyFiPRzyiTyXCEZBK6d0UJ_Wbbz8YOq-yNyJogtMR4kmh7bruqqdnsFsNS4mondI_hyzlAFm1Sv79AHPbScZ9Wt8MNP2VCdN32PpnoDAdz8a_hTsCiYgaOzpip9qaZLDw9fjKnqd2ah_Ww7DcORAXnVeAmpvDVrgT8=s0-d-e1-ft#https://cryptosheets.intercom-mail.com/i/o/260279717/39bbb3fcab5724a29f95aaea/YT-1355-3873_cryptosheets-docs_providers_cryptosheets_console_csPRICEA-example6%5B1%5D.gif)](https://cryptosheets.intercom-clicks.com/via/e?ob=ext542A0w%2BFEejiKaDnA3n4Inlczal0iZ%2BnK2TgCzWnQbqIhd%2B0%2F%2BEpl%2B1d5s1Bpl0nWU79PnfL5eB3HQUP%2ByHwxDOkGqglDResAQhQilX0%3D\&h=c7d209bdb4a3569821667602e61651d92d5d5902-w1ppxcjb_98178001422580\&l=1ef294789cc426d360384e70e8d6e9e2912f50da-10924637)

### EXAMPLE 3

```
 =CS.OHLCVA("base","BTC","quote","USD","refresh",CS.TIME(10))
```

![](https://ci3.googleusercontent.com/proxy/qPaq6jjUAmpfNxYoGjvygRq3I1IgmXkhJ7f03SwWUgL70RDtie5_3p1hq15WVmFM15Ypua86QCp-h_n5mm2wDTfyIH7Gf7HLAooWpXEzWJU9J-aWkZuP8yIoHjl7j6Q5KzMf8XPfdU6SOoSreWtpOYGDg8pQtaGQ9Bmwx8UgLGT1ytl5pnZwiHHkhLWN135F-r16-LVRg5P3=s0-d-e1-ft#https://cryptosheets.intercom-mail.com/i/o/246216883/546e1044e001261bca970af6/cryptosheets-docs_excel_functions_csOHLCVA-example2.gif)

*\**[*CS.TIME*](https://cryptosheets.intercom-clicks.com/via/e?ob=jBWl7I74XD9EF%2FyKqAjyXWg%2BqDx8taFJ0VsK5IdKRK7TpFXWwKdl9stJ80jYTzaP\&h=3d0fcfeba9020a97c31668c3b9a3defb8f8750bb-w1ppxcjb_98178001422580\&l=516b2f38b0eecab0c5695bebdc620c2cd16c6ec2-10924638) *is only available for* [*paid subscriptions - upgrade today!*](https://cryptosheets.com/pricing)<br>

### [Googlesheets](https://cryptosheets.intercom-clicks.com/via/e?ob=vqJYWGSOSCthykQzXu6JvhJ0m%2BN4iq%2BPoPyBKkE48yDcyHe77%2ByRokFcgW9V15U0VsiM5FAhZNKAUFj2nE0ReSs77KOImgVvV6tpuApg6EIgjQ5ulxq1nUmF%2FW9RcK6OV7C9N2HkG0lMlSY39KGtj6BCp5l0oyPHGTPMdIF%2Fk9wCq1LiBrRG46VtL3i57fK2\&h=484961ee63b0f5137eeba1966a18ab46a4b3bc6e-w1ppxcjb_98178001422580\&l=5ffe088f06ec14104154cf671383ad4c972bf760-10924631)

![✅](https://fonts.gstatic.com/s/e/notoemoji/14.0/2705/72.png) *Paste or type these formulas into any cell*

### EXAMPLE 4

```
 =CSPRICE("BTC","USD",,"Coinbase","ask",GOOGLEFINANCE("CURRENCY:USDEUR"))
```

[![](https://ci3.googleusercontent.com/proxy/GPqFjLR33wPQwK8vrEpFiRkDUquMPoZNUuh60YKyUkSIgFkgUb3fnz97c1eodsRD8w9w-JpBbgdIo_nvkc9X-onI4CQ5sICZOinsa_dSKDpFl_V8s_Hzwwn4W586FHjmgMCCs44DLNwcAg=s0-d-e1-ft#https://cryptosheets.intercom-mail.com/i/o/246206395/2b52e9967491a70de99f8e18/image.png)](https://cryptosheets.intercom-clicks.com/via/e?ob=vqJYWGSOSCthykQzXu6JvhJ0m%2BN4iq%2BPoPyBKkE48yDcyHe77%2ByRokFcgW9V15U0VsiM5FAhZNKAUFj2nE0ReSs77KOImgVvV6tpuApg6EIgjQ5ulxq1nUmF%2FW9RcK6OV7C9N2HkG0lMlSY39KGtj6BCp5l0oyPHGTPMdIF%2Fk9wCq1LiBrRG46VtL3i57fK2\&h=484961ee63b0f5137eeba1966a18ab46a4b3bc6e-w1ppxcjb_98178001422580\&l=b1fcf70edbb8b7137237de913f3754758ea81f66-10924640)

*\*Fastest refresh interval* [*using this method*](https://cryptosheets.intercom-clicks.com/via/e?ob=HHCGwsFeUzdyBfOUyJNBFc8%2FcYuaUNufyhzsAov4riEgn7BdkLejg3tywkvza3Hfdpdl41PUe6Cy47%2F%2FprqlPHSbpduENod9ArFiuXJwwZs0vepkpWuQGkveXkwvPPq8CJaHLhNsjWuFg9FPdP9bwy1VdTCFZj6NVOfhA83btbY0CiAUYuG6noQvQOv92Jv2\&h=706ca5267296c8fb2cbda18ca2848547e263112d-w1ppxcjb_98178001422580\&l=a207748c530ea8b58e9e36e32072161c9599f366-10924634) *is \~2 minutes*

### EXAMPLE 5

```
 =CSPRICEA("base","BTC","quote","USD","refresh",A1)











```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://www.bfm-unity.org/4.0.0/bfm-ds-bi-fang-meng-shu-ju-zhi-chi/zi-chan-pei-zhi/the-tzolkin-calendar/zhuo-er-jin-sheng-ji-a2-can-shu-du-qu.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.