📢Announcing IEX Cloud API & Cryptosheets Integration

Chris Ware
May 12, 2020 · 6 min read

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

1) WHAT DOES THIS MEAN?

If you can copy + paste = you can now use IEX Cloud data!

Access capital markets data in seconds with formulas like =CS.QUERY(“IEX”,”Advanced Stats”,{“symbol”,”AAPL”})
Cryptosheets users have immediately gained access to over 50,000+ new capital markets assets!
Combining crypto and capital markets data into a unified access point is a gamechanger

2) EXAMPLES & USE CASE SCENARIOS

With so many use cases we can only highlight a few here.

We’ll be showcasing more examples of how to leverage the IEX Cloud API in future articles.

Follow us on Twitter for more enhanced content including templates, models & video tutorials.

A few common scenarios include…

  • Cross asset benchmark comparison (S&P500 vs Bitcoin)
  • Cross asset correlations (BTC vs Gold vs equities)
  • Investment vehicles vs underlying crypto asset (GBTC vs Bitcoin)
  • Interest rates & yield (Defi rates vs treasuries, S&P500 dividend yield and high yield bonds)
  • Cross asset relative performance & returns (risk/volatility adjusted)
  • Public companies vs tokenized STOs/ICOs
  • Historical macro economic indicators vs crypto fundamentals (CPI vs BTC inflation)
  • Performance of recent IPOs vs ICOs, STOs & IEOs

Excel & Googlesheets examples for every IEX Cloud endpoint are available at our Cryptosheets Docs portal — just copy + paste into your spreadsheet!

✅ Traders

  • Easily build custom cross asset trading dashboards that automatically update in real time or at any custom interval
  • Pull in detailed metrics on cross asset class performance, volatility and correlations. Easily plot charts with SP500, Bitcoin, Oil, Gold, Global GDP all with the same easy to use formulas.
  • Easily build trading arbitrage screeners & models to identify risk sentiment patterns and capitalize on cross market dislocations
  • Overlay RSI, MACD, BBANDS, EMA and other technical analysis indicators on ANY historical data set in real time or use IEX Cloud historical OHLCV data to help back test and time trading strategies

✅ Professional Portfolio Managers

  • Compare institutional benchmarks across asset classes to analyze tracking error, performance and relative value strategies
  • Track correlation between major risk assets across crypto vs conventional markets and relative to your portfolio
  • Analyze conventional macroeconomic themes and secular/cyclical trends vs crypto fundamentals

✅ Research Analysts & Journalists

  • Combine datasets across asset classes & industries to inspire your narratives and align them with data driven themes, trends and analysis
  • Analyze institutional holders of crypto funds vs publicly traded blockchain companies or ETFs

✅ Back Office & Accounting

  • Leverage IEX Cloud’s institutional caliber historical data to easily compare and assess proper historical index reference rates for marking positions, trade booking and account maintenance

✅ Hobbyists, Beginners & Students

  • Simplify managing & tracking your crypto investments by easily accessing them in Excel and Googlesheets. Using Cryptosheets, all the heavy lifting for API integration, custom developer work, coding and security is already taken care of for you. This allows less experienced users to focus on the data they need to understand in a simple and familiar environment

3) HOW TO START USING IEX CLOUD DATA NOW

👉 HOW TO INSTALL CRYPTOSHEETS

  1. Make sure you’re logged in to access data
  2. That’s it!

👉 HOW TO USE IEX CLOUD DATA IN CRYPTOSHEETS

  1. In any cell type or paste the following
    Excel
    =CS.QUERY(“IEX”,”Key Stats”,{“symbol”,”AAPL”;”token”,”Your token”})
    GoogleSheets
    =CSQUERY(“IEX”,”Key Stats”,{“symbol”,”AAPL”;”token”,”Your token”})
  2. That’s it!

OTHER WAYS TO USE

  1. Cryptosheets Docs examples & tutorials
  2. Templates
  3. YouTube Video Examples
  4. Use your own existing IEX Cloud API key for any endpoint at any time
The dedicated IEX Cloud provider page on Cryptosheets Docs w/ tutorials & hundreds of example formulas

Try a free Cryptosheets template for IEX Cloud

The IEX query builder template lets you start using IEX Cloud data in seconds without typing anything!

Why IEX Cloud?

  • This ability to make this integration possible demonstrates IEX Cloud’s commitment to expanding access and visibility to cross asset and conventional markets data
  • This is an important step towards educating the masses about the growing similarities in markets by adding new, user friendly ways to consume and understand their data
  • It also reflects the very high caliber and professionalism of the entire IEX Cloud team who have been great to work with during this integration
  • The integration of IEX Cloud with Cryptosheets brings together two best in class platforms dedicated to improving and maintaining the most powerful and comprehensive tools in the crypto data arena
  • The ability to copy + paste and gain instant access to the full breadth & depth of the entire IEX Cloud data catalog changes everything no matter where you’re sitting and opens new and previously unobtainable possibilities

You can pull over 106+ API endpoints from IEX Cloud into Excel or Googlesheets with Cryptosheets using the side panel console or custom functions (aka formulas)

RESOURCES

▶️ Cryptosheets is free to sign up and start using now.
What are you waiting for? ➡ Get crypto data in 30 seconds or less

Get the Excel add-in now

Get the Googlesheet add-on now

Get started with IEX Cloud today!
See important terms of use for the IEX cloud API here

ADDITIONAL RESOURCES

TAGS : iex, iex cloud, stocks, bonds, equities, commodities, cross-asset, capital markets, fundamentals, financials, api, excel, googlesheets, spreadsheet, crypto data, bitcoin, blockchain, metrics, data crypto api, stocks api

Cryptosheets

All your crypto data in one place for Excel or…

Cryptosheets

All your crypto data in one place for Excel or Googlesheets. Hundreds of providers. Thousands of datasets. Real time streaming data into your worksheets. Crypto data just got easy.

Chris Ware

Written by

Don’t confuse motion with progress

Cryptosheets

All your crypto data in one place for Excel or Googlesheets. Hundreds of providers. Thousands of datasets. Real time streaming data into your worksheets. Crypto data just got easy.

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store