Open in app

Sign In

Write

Sign In

Chris Ware
Chris Ware

141 Followers

Home

About

Published in Cryptosheets

·Apr 15, 2022

Deribit API data in Excel & Google Sheets for Crypto Derivatives Risk Management & Options Analysis

Advanced crypto asset portfolio management strategies and tools — Easily access live trading account data including orders, trades, balance, P&L, margin, greeks & more. Learn how to perform complex analysis & market risk calculations with simple, automatically refreshing formulas using Cryptosheets OVERVIEW This article highlights several use case examples from an institutional crypto fund manager including (actual) screenshots of advanced…

Crypto

6 min read

Deribit API data in Excel & Google Sheets for Crypto Derivatives Risk Management & Options Analysis
Deribit API data in Excel & Google Sheets for Crypto Derivatives Risk Management & Options Analysis
Crypto

6 min read


Published in Cryptosheets

·Oct 29, 2020

How to Add Fundamental Analysis to Your Crypto Portfolio with Messari (Part 1)

Adding fundamental analysis to your crypto portfolio is the next step after basic market data for volatility and risk adjusted performance. Using the Messari API with Cointracking & Cryptosheets makes that easier than ever before, here’s how to do it. OVERVIEW Portfolio asset allocation and risk management is critically dependent on…

Bitcoin

6 min read

How to Add Fundamental Analysis to Your Crypto Portfolio with Messari (Part 1)
How to Add Fundamental Analysis to Your Crypto Portfolio with Messari (Part 1)
Bitcoin

6 min read


Published in Cryptosheets

·Oct 27, 2020

Introducing Cryptosheets Scenarios

Cryptosheets scenarios are dynamic combinations of pre-configured queries, transformations and filters easily searchable & accessible with one click. Scenarios are a gamechanger for the way you access and use crypto data, see how. OVERVIEW 🌐 Crypto data is a paradigm shift in the evolution of data accessibility. It’s fully transparent and…

Bitcoin

6 min read

Introducing Cryptosheets Scenarios
Introducing Cryptosheets Scenarios
Bitcoin

6 min read


Published in Cryptosheets

·Sep 29, 2020

How to Get Crypto DeFi Data Into Your Spreadsheet: Part 1

While DeFi continues gaining in popularity, DeFi data remains difficult to access for non-developers. Learn how to get different types of common DeFi data, metrics & analytics into your Excel or Google spreadsheet.

Defi

6 min read

How to Get Crypto DeFi Data Into Your Spreadsheet: Part 1
How to Get Crypto DeFi Data Into Your Spreadsheet: Part 1
Defi

6 min read


Published in Spreadstreet

·Aug 20, 2020

How To Get Crypto Derivatives Data

Crypto derivatives data is challenging to source and use. Cryptosheets changes that by providing instant, unified access to data for tens of thousands of tradable instruments, here’s how. OVERVIEW This article is intended for users with some minimum knowledge of or experience with derivatives. The purpose is to demonstrate how to…

Crypto

8 min read

How To Get Crypto Derivatives Data
How To Get Crypto Derivatives Data
Crypto

8 min read


Published in Cryptosheets

·Jul 28, 2020

How to Build a Real Time Streaming Cryptocurrency Dashboard in Excel in 5 Minutes

It has never been easier to pull live streaming cryptocurrency prices into your spreadsheets. Now you can do it for free in a few seconds, here’s how. OVERVIEW This article is intended for anyone including noobies to professional traders. It focuses on using basic Cryptosheets custom functions (aka formulas) to create…

Bitcoin

6 min read

How to Build a Real Time Streaming Cryptocurrency Dashboard in Excel in 5 Minutes
How to Build a Real Time Streaming Cryptocurrency Dashboard in Excel in 5 Minutes
Bitcoin

6 min read


Published in Cryptosheets

·Jul 17, 2020

🔎 How to use the Cryptosheets CS.SYMBOLS function to get live or historical data for any crypto asset in Excel & Googlesheets

The most important crypto data for global adoption above all else isn’t the price or marketcap — it’s the symbol, identifier, ticker, slug, id, name or whatever the hell you want to call it — and that’s exactly the point. Here’s why.

Crypto

5 min read

🔎 How to use the Cryptosheets CS.SYMBOLS function to get live/historical data for any crypto asset
🔎 How to use the Cryptosheets CS.SYMBOLS function to get live/historical data for any crypto asset
Crypto

5 min read


Published in Cryptosheets

·Jun 30, 2020

How to Pull 30,000 Cryptocurrency Sharpe Ratios in 5 seconds

Access in depth Sharpe ratio & performance data on crypto assets to leverage one of the most widely used risk metrics in professional finance without doing any math, here’s how.

Blockchain

7 min read

How to Pull 30,000 Cryptocurrency Sharpe Ratios in 5 seconds
How to Pull 30,000 Cryptocurrency Sharpe Ratios in 5 seconds
Blockchain

7 min read


Published in Cryptosheets

·May 12, 2020

📢Announcing IEX Cloud API & Cryptosheets Integration

We are excited to officially announce the integration of IEX Cloud with Cryptosheets! Institutional quality capital markets and crypto data has literally never been easier to access, here’s how. Using IEX Cloud data in your Excel & Google spreadsheets with Cryptosheets We are proud to officially announce our integration with IEX Cloud! With 800 million daily Excel & 250 million daily Googlesheets…

Bitcoin

6 min read

📢Announcing IEX Cloud API & Cryptosheets Integration
📢Announcing IEX Cloud API & Cryptosheets Integration
Bitcoin

6 min read


Published in Spreadstreet

·May 7, 2020

Automatically Refresh 110,000 Crypto Assets in Real Time or at Any Interval in Excel & Googlesheets using Cryptosheets

Keeping crypto data up to date in a spreadsheet can be a real pain in the #ss. No more VBA, no shady scripts or downloads, no complicated triggers & you can use it anywhere. Here’s how to do it with one single formula OVERVIEW Any Cryptosheets custom function, data set or…

Crypto

4 min read

Automatically Refresh 110,000 Crypto Assets in Real Time or at Any Interval in Excel &…
Automatically Refresh 110,000 Crypto Assets in Real Time or at Any Interval in Excel &…
Crypto

4 min read

Chris Ware

Chris Ware

141 Followers

Don’t confuse motion with progress

Following
  • Pyth Network

    Pyth Network

  • TokenInsight

    TokenInsight

  • 1inch Network

    1inch Network

  • Jesus Rodriguez

    Jesus Rodriguez

  • David Luecke

    David Luecke

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech