MarketXLS returns cryptocurrency data in Excel with the same functions used for stocks. Add the exchange after the symbol, for example =Last("BTCUSD:BINANCE"), or use :DEFAULT (for example =Ask("ETHUSD:DEFAULT")) to let MarketXLS pick the most appropriate exchange for the token. Price, bid and ask, historical closes, technical indicators, returns, and drawdowns work on crypto symbols. This post announced the feature in January 2022; see crypto data in Excel for the current overview.
Try it in your own spreadsheet
Get the free MarketXLS sample workbook (.xlsx).
No account needed. MarketXLS live data requires a paid plan. Preview workbook
Explore more videos
stats related to crypto
How crypto symbols work in MarketXLS
With MarketXLS, you can use the name of the exchange at the end of the symbol to get the data from that specific exchange.For example– use BTCUSD:BINANCE to get data from the Binance exchange and ETHUSD: BITMEX to get data from the BitMEX exchange.
However, sometimes, you might find that a crypto token is not listed on an exchange.
So,we have developed our own methodology and symbology for exchanges, which we call “DEFAULT.”** For example –**You can use BTCUSD: DEFAULT to get the default data.
Then, our system will automatically determine where that token is listed and return the most appropriate price and analytics.
You can download a list of all cryptos available straight to your excel by going to “Utilities” and “Utilities List” in the dropdown menu.
Next, choose “Crypto Currencies,” which will open the whole list of cryptos with their exchanges.
Here is what you can do with Crypto data now being available:
1) Get intraday prices with the =Last(), =Ask(), and =Bid() functions
Just go to an excel cell and type =Ask(“ETHUSD:DEFAULT”).
Similarly, you can also try other functions such as last and bid to get the desired output.
2) Get historical data points on specific days in the past using =close historicals.
3) Get 20 Technical indicators using technical functions like = SMA, =EMA, etc.
4) Get Other analytical results like Drawdown and Stock Return functions.
5) Use mxls_db_query functions to get Min, Max, High and Low from a range of data series.
6) Get Volume averages.
And a lot more.
To find which functions work with cryptos, click on search and help and search for Crypto. All the functions you will see should be available for crypto symbols.
** Note :**At the time of this 2022 announcement, crypto data was not streaming.
Check out our informative knowledge base for a step-by-step guide to MarketXLS.
You can use cryptos on numerous functions such as
=close_historical(), =stockreturnfifteendays(), =custombetaoneyear() and many more.
Our team has also performed minor optimizations to run MarketXLS smoothly.
Email us at** support@marketxls.com** with any of your concerns or issues that you face.
