Sign in. See our Reader Terms for details.
Subscribe to RSS
Trading crypto currencies can be an extremely interesting and rewarding activity. There are many different platforms and exchanges for trading that will offer API access to their data which allows the savvy trader to build their own tools around their own strategy and trading needs. Microsoft Excel is the go to choice for many traders because of the enormous potential it offers to create custom tools and dashboards to build market insights, test and experiment with data and ideas, and to monitor portfolio performance and keep track of positions.
More serious technically minded traders will also want to use Python for data analysis and back testing trading strategies, or even building systematic or automated trading strategies.
- Real Time Crypto Prices in Excel.
- Excel and Coinmarketcap – live cryptocurrency dashboard.
- Available on Google GSuite.
- investing bitcoin halal.
Most crypto exchanges offer a way to get data from their platforms programmatically via an API. This is what we would use to connect our Excel or Python based tools to the platform to fetch data and manage orders. The code above shows how to use the websockets package to connect to the BitMex API to receive price updates in Python.
- Learn how to stream live crypto prices into Microsoft Excel.
- Cryptosheets.
- Available on Microsoft Appsource.
- All Your Crypto Data in One Place;
Using this we can subscribe to individual updates. The BitMex class will handle routing the messages it receives from the websockets API to the relevant callbacks for each symbol and field that has been subscribed to. Now we have this BitMex class and the ability to subscribe to specific fields and symbols we will next expose this to Excel using PyXLL. The folder containing this module, as well as the bitmex. The pythonpath can also be set in the pyxll. We can use the same techniques shown above to access those prices in Python.
We can use that to build and integrate bespoke trading applications written in Python, but using Excel as our interface to those tools. Generate custom formulas, test different queries and try template samples for easy report creation. Unified global parameters for filtering, sorting, limiting and selecting any data integrated with our platform. Save hours of work by instantly generating fully dynamic one-click templates using any API endpoint. Instantly search across massive nested JSON objects and arrays to find specific data fields.
Cryptosheets is natively integrated into the Cryptocompare API portal, an industry first. Pull your entire portfolio into custom dashboards and models in seconds. IEX Cloud is natively integrated with Cryptosheets. Access extensive data from conventional markets including equities, ETFs, options, fixed income, commodities, derivatives, economic indicators and macro benchmarks along with fundamentals, financials, regulatory filings and corporate actions.
Secure integrations with Cointracking. See for yourself and try our live add-in right now using the web app. Explore an extensive and diverse collection of datasets including native provider APIs and custom mashups. The largest collection of actionable crypto data built with the biggest crypto content engine anywhere. No VBA or macros necessary. No scripts to install. Just crypto data, and lots of it.
Your Answer
Cryptosheets is used by a wide array of individuals and companies. See below for some of the notable users of our platform.
How to import data from Blockchain. Asked 5 years, 11 months ago.
Excel and Coinmarketcap - live cryptocurrency dashboard - The Excel Club
Active 1 year, 1 month ago. Viewed 4k times.
Improve this question. John John 11 1 1 silver badge 2 2 bronze badges. What sort of data are you trying to get from Blockchain. Add a comment. Active Oldest Votes. Improve this answer. JohnDvorak JohnDvorak 7 7 silver badges 18 18 bronze badges. Summary: whether you'll be able to do what you want to do depends on which data you want. Sign up or log in Sign up using Google.