<center><a href="https://upload.view.ly/view/useruploads/4204--2017-10-04--connect-excel-to-coinmarketcap-for-live-and-historic-data"><img src="https://ipfs.view.ly/ipfs/QmPRH52uwHEmfTXY67H61ZmS2Vi8hrhsZR8i4DERnduJ2n/thumbnail_masked.png" alt=""></a><br>Watch it on <a href="https://upload.view.ly/view/useruploads/4204--2017-10-04--connect-excel-to-coinmarketcap-for-live-and-historic-data">Viewly</a></center><br><br>In this video you will learn how to connect Excel to Coinmarketcap data. First we will look at using the API to connect to live ticker data. Then we look connect to a historic table on the coinmarketcap website to gather historic cryptocoin pricing and volume data The API used is https://api.coinmarketcap.com/v1/ticker/ and for the historic prices we will look at the coins STEEM and BITCOIN This can be used to create a crypto currency excel tracker that will auto update. Follow me to see how you can use this data to create your own cryptocurrency holding dashboard in Excel. Follow me to see the next video and learn how to create this tracker WILDSPARK.ME link : https://l.wildspark.me:8000/H12OrNzhW
| author | useruploads |
|---|---|
| permlink | 4204--2017-10-04--connect-excel-to-coinmarketcap-for-live-and-historic-data |
| category | excel |
| json_metadata | "{"app": "steemq/0.1", "steemq": {"ipfs_root": "QmPRH52uwHEmfTXY67H61ZmS2Vi8hrhsZR8i4DERnduJ2n", "video_file": "raw_video.mp4", "files": [{"Name": "raw_video.mp4", "Hash": "QmNMmsz7NzMqmXaY6XKyAQsaHUPtWQXhTbTpbJWsrk7Q4Y", "Size": 65166774}, {"Name": "thumbnail_0.png", "Hash": "QmXzcphGkpHFXhUAhtDAng8JYTob64JRnFoKyTwi4FTd1m", "Size": 136708}, {"Name": "thumbnail_1.png", "Hash": "QmRRJ9sq11waYtmst5R6KL2aXjei84KdLC4MhK4NfyfJMB", "Size": 110853}, {"Name": "thumbnail_2.png", "Hash": "Qmer3CNorTw7CfXDt7aADFvEexVRQzaoqUwj4aaByEapBL", "Size": 122576}, {"Name": "thumbnail_3.png", "Hash": "QmcoWXwwSZwyMyLo4hNJoXyZBxJBBAJYy1GcoxPrBLmmYE", "Size": 139853}, {"Name": "thumbnail_masked.png", "Hash": "QmfJsPFuBT9sESNjdyHDV9MRyGbFun1heaJ4zLQAWrfwA8", "Size": 404410}, {"Name": "tilesheet_73_10_192_103.png", "Hash": "QmYXJZ7HevvwsyQ51bHuFMoahzRPbW3QjZCALT3437yf69", "Size": 1148990}]}, "image": ["https://ipfs.view.ly/ipfs/QmPRH52uwHEmfTXY67H61ZmS2Vi8hrhsZR8i4DERnduJ2n/thumbnail_masked.png"], "community": "viewly", "tags": ["excel", "crypotcurrency", "cyrptocurrencytracker", "coinmarketcapdata"]}" |
| created | 2017-10-04 10:44:48 |
| last_update | 2017-10-04 10:44:48 |
| depth | 0 |
| children | 0 |
| last_payout | 2017-10-11 10:44:48 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 1,142 |
| author_reputation | -642,592,913,672 |
| root_title | "Connect Excel to Coinmarketcap for live and historic data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 16,752,066 |
| net_rshares | 0 |
hiveblocks