How to Get Cryptocurrency Prices in Excel — Codeless Approach

Photo by Michael Förtsch on Unsplash

On June 5th 2019, Microsoft released a new feature to Office 365 that allows Excel users to pull real-time stock prices into their spreadsheets. In this article, we are going to look at the way to pull cryptocurrency prices in Microsoft Excel. This can be done just by using an Excel in-built stocks functionality and a STOCKHISTORY formula.




A publication dedicated to providing concise and practical coding solutions to various problems in finance.

Recommended from Medium

DeFi11 proudly announces IDO on Polystarter, the First Native Launchpad based on Polygon

Swap Rates Explained

Crypto Trading Terms

LOCGame Character Spotlight: GameFi Founder

Through the Blockchain Grapevine…

The new anonymous currency of VCC has appeared, and where to go for XMR, DASH and Zcash?

Hillstone Finance Introduces The Cutting Edge Hybrid Investment Platform: Investors


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
Bee Guan Teo

Bee Guan Teo

Data Scientist. Like problem solving with Python

More from Medium

Coding the Volatility-Adjusted RSI in TradingView.

The Secret Places of Stock Market Profits

Building a Simple Trading Strategy in Python — Trend Following

The Rapid Trend Trading Strategy