Overview
Excel for Apple/Mac/OSX has come a long way over the last several years. Cryptosheets was designed specifically with Mac and Online users (ie non Windows) in mind.
In this article we show you how to:
Install and setup Cryptosheets for Mac OSX Excel
Use custom functions to get data
Use the side panel API console to get data
The following features are available for Cryptosheets on Mac OSX:
All custom functions like
=CS.PRICE(), =CS.OHLCV()
and othersFully interactive side panel
Fully interactive API consoles
Setup & Install
Install the Cryptosheets add-in from the Microsoft AppSource Store
Make sure you are logged in to your Cryptosheets account
Custom Functions
Cryptosheets Custom functions in Excel for Mac are very similar to PC
Excel for Mac actually has a better formula builder side panel interface than the Windows version which can be very helpful
1. In any cell type the following examples
(make sure you give each example adequate room for the output*)
=CS.QUERY("Cryptocompare","v2 histoday",{"fsym","ETH";"tsym","USD";"limit",50})
=CS.QUERY("Coinapi","exchanges")
=CS.PRICE("BTC","USD")
=CS.EXRATE("BTC","USD","1")
*Note: this is a real time streaming function for live prices
2. If you need help remembering the exact parameters for any function, you can always just type in any cell:
=CS.PARAMETERS("Cryptocompare","v2 histoday")
=CS.PARAMETERS("Coinapi","exchanges")
3. Use the Side Panel function builder
Excel for Mac actually has the same interactive and customizable side panel user interface including the ability to have multiple Cryptosheets side panels open at the same time
Side Panel API Console
Additional Resources for Mac users:
Find quick help and information about current version, build, license type and insider program status
How to side load Excel add-ins for Mac or iPad:
________________________________________________________________
Tags: mac, osx, apple, ipad, install, setup, online, insider, updates, office365, excel, googlesheets, spreadsheet