Connecting to Live Data sources and transforming that data using Excel is relatively easy when you have an API. However the steps used to transform API data to a usable format are unknown to many.
In this video we will look at connecting to Bittrex public API to get live Ticker data for cryptocurrency. If you are looking to manage your cryptocurrency portfolio in Excel or Power BI then this video is for you.
If you are looking for Data Transformation Steps in Excel Power Query or Power BI then this video provides a nice learning example
▶️ DTube
▶️ IPFS