zhuo-er-jin-sheng-ji-a2-can-shu-du-qu.md

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

{% hint style="info" %}

参数读取由 CryptoSheets 和 GlassNode 支持

未来考虑增加 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时间转换
• 通过Excel将Unix时间转换为日期时间

|

Hi there,

Refreshing Crypto API Data in Cryptosheets

It's easy to refresh data with Cryptosheets and there are a number of different methods for both Excel & Googlesheets.

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

• Docs portal: Data refresh concepts
• YouTube: Refreshing Crypto API Data playlist channel
  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 & tutorials for real time dashboards

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

Paste or type these formulas into any cell\

EXAMPLE 1

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

EXAMPLE 2

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

EXAMPLE 3

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

*CS.TIME is only available for paid subscriptions - upgrade today!\

Googlesheets

Paste or type these formulas into any cell

EXAMPLE 4

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

*Fastest refresh interval using this method is ~2 minutes

EXAMPLE 5

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