📢 [Cryptosheets] Crypto Correlation Toolkit, NEW EOD Historical Data Integration! + CS.ORDERBOOKSL3 & Model Portfolios

Here's the latest new data, features and updates across the Cryptosheets platform 

Get it now for Excel | Get it now for Googlesheets | Upgrade Now

Providers: 117 | Endpoints: 2,361 | Templates: 82 | Scenarios: 100 | Research Content: 542 | Chart Widgets: 75 | Tutorials & Docs: 2,450 | Custom Functions: 81
 Examples: 9,744 | YouTube: 98

loudspeaker Announcements

Introducing the new CS.ORDERBOOKSL3A custom function! (SNEAK PREVIEW)

  • The new CS.ORDERBOOKSL3A custom function is a powerhouse tool for crypto liquidity delivering unprecedented granularity & flexibility for level 3 market depth data across spot & derivatives markets including futures, options, perpetuals and more
  • point_right Users can also specify three additional parameter fields for type, details and/or symbolId which allows you to pass the entire symbol as one single string
  • point_right It's available now in early access only to analyst and investor level subscriptions 

Announcing the new EOD Historical Data integration! 

The integration of EOD Historical Data is a game changer for Cryptosheets users for several reasons:

  • Tens of thousands of new assets are now available including indexes, commodities, corporate bonds, government bonds, central bank rates, credit default swaps... and more
  • Access to deep historical data for traditional capital markets assets and benchmarks like the VIX, Gold, Crude Oil, S&P500, S&P E-Mini Futures, Corporate Bond index (HY & IG), FTSE, DAX, CBOE S&P 500 PutWrite Index, SSEX and many more
  • Metrics like historical short interest are now all easily accessible using familiar =CS.QUERY formulas!
  • The EOD symbol catalog is integrated into the =CS.SYMBOLS custom function making it easier than ever to search hundreds of thousands of assets and symbols  point_right that you can all pull data for!

chart_with_upwards_trend  Cryptosheets Model Portfolios! (UPDATE)

  • The default Cointracking portfolio has been updated to reflect a sample portfolio for easier user testing. 
  • For a basic asset allocation model that can easily be used in comparison vs. major crypto benchmark indices, the portfolio allocated $100,000 USD buying equal USD value of the top 20 ranked assets on January 1st, 2020. (see how you can use this for your own portfolio here)
  • We will be rolling out the new Cryptosheets Model Portfolios Series (Powered by Cointracking.info) in the very near future point_right you will NOT want to miss it
  • Cointracking.info now also supports DEX & DeFi trades and swaps! 

chart_with_upwards_trend Formulas Of The Week: 

See Institutional & Fund Equity Shareholders of RIOT Blockchain using EOD Historical Data

See the 'whales' & institutional 'HODLers' of traditional stock markets with the largest shareholdings for a publicly traded crypto mining company RIOT Blockchain. Try it yourself using the EOD Historical Data API

point_right Excel
=CS.QUERYA("EOD Historical Data","Fundamentals","api_token","Your api_token","symbol","RIOT.US","_path","Holders")

point_right Googlesheets
=CSQUERYA("EOD Historical Data","Fundamentals","api_token","Your api_token","symbol","RIOT.US","_path","Holders")

How To Use:

  1. Simply copy + paste the formulas into any cell in your sheet. 
  2. You can change the dates and symbols to whatever you want or point them to specific cells like any other formula. 

__________________

chart_with_upwards_trend Feature Of The Week: 

Send live custom function formulas directly to your spreadsheets with one click using Quick Start Templates

Get started using custom functions with only one click from the side panel. For Excel users this is one of the most powerful, easy ways to get started and learn how to use custom functions.


blue_book Blog Articles

bar_chart Templates

  • NEW Cross Asset Correlation Toolkit (link)
    Using data from the recent EOD Historical Data integration, the cross asset correlation toolkit in combination with Cryptosheets technical indicator custom functions opens new possibilities for powerful and dynamic correlation analysis
  • RECENT CS.PRICEA Custom Function Tutorial (link)
  • RECENT Stablecoin Historical Supply (link)
  • RECENT OHLCV Futures Query Builder (link)

new (NEW) Providers

  • EOD Historical Data (link) 

new (NEW) Endpoints

  • EOD Historical Data (link) Added 17 new endpoints


closed_book Tutorials & Support Documentation

  • NEW Help Center tutorial on refreshing data & formulas (custom functions) in Googlesheets (link)

Stay up to date with the latest announcements, new data providers & features by following us on Twitter and Medium

Answer: (interest rate derivatives are a multi hundred trillion USD global market)

___________________

+1 -1 Feedback

If you have any questions, feedback or suggestions for new integrations or features, we love to hear about them. They also help us improve the platform and make it more useful for you.

Users who post reviews in the Microsoft or Google stores automatically get access to preview features, discounted upgrades and more. You can do that right now (link)

You can also contact us directly any time or reply to this email.

Get the Excel Add-in Now

Get the Googlesheets add-on Now

ADDITIONAL RESOURCES

Website  |  WebApp  |  Cryptosheets Docs
Excel  |  Googlesheets  
 
Help Center  |  Blog  |  Twitter |  Changelog

intercom

留言

這個網誌中的熱門文章

The Crypto Roundup - 31 March 2020

The Crypto Roundup - 27 May 2020

The Crypto Roundup - 29 May 2020