📢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 users, capital markets and crypto data is more accessible and easier to use in one place than ever before.
1) WHAT DOES THIS MEAN?
This means that Cryptosheets users can now access institutional quality capital markets data in addition to the largest amount of combined crypto data with the same easy to use formulas:
=CS.QUERY(“IEX”, “Key Stats”,{“symbol”,”AAPL”})
If you can copy + paste = you can now use IEX Cloud data!
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
Any Cryptosheets user can start using the entire IEX Cloud API in Excel or Googlesheets right now. Users can either use their existing IEX Cloud API keys or use the Cryptosheets default API key.
👉 HOW TO INSTALL CRYPTOSHEETS
- Install Cryptosheets for Excel or Googlesheets
- Make sure you’re logged in to access data
- That’s it!
👉 HOW TO USE IEX CLOUD DATA IN CRYPTOSHEETS
- Install Cryptosheets for Excel or Googlesheets
- 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”}) - That’s it!
OTHER WAYS TO USE
- Custom Functions or Cryptosheets Side Panel API Console
- Cryptosheets Docs examples & tutorials
- Templates
- YouTube Video Examples
- Use your own existing IEX Cloud API key for any endpoint at any time
Try a free Cryptosheets template for IEX Cloud
Follow us on Twitter for more advanced templates, models & dashboards
Why IEX Cloud?
- Cryptosheets works with more data providers than any other crypto data platform which means our job requires gaining an exceptionally intimate understanding of each data provider, their data and their API service. We believe IEX Cloud is a reliable and well-built platform, with a breadth of data that will be useful for Cryptosheets users.
- 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
👉 This page shows how to use the Cryptosheets API console and custom function formulas to access all of IEX Cloud’s API endpoints & data in Excel & Googlesheets
▶️ 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 Googlesheet add-on now
Get started with IEX Cloud today!
See important terms of use for the IEX cloud API here
ADDITIONAL RESOURCES
Website | WebApp | Excel | Googlesheets | Help Center | Blog | Twitter
______________________________________________________________________
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