{
  "block": 96410648,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "aacoimbra",
      "delegator": "steem",
      "vesting_shares": "1668.863846 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2025-06-13T02:28:39",
  "trx_id": "b21a90745aaf5200ac4614138974c8aaefbf7f2d",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 61055943,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "aacoimbra",
      "delegator": "steem",
      "vesting_shares": "1835.751409 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-01-26T01:29:09",
  "trx_id": "22a41e71f9c05354064acca70c66f6a444f43f92",
  "trx_in_block": 6,
  "virtual_op": 0
}

{
  "block": 39819587,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "c5ya",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-01-10T23:49:54",
  "trx_id": "960b83706aafe6d275204471fbb9ea2bf7c7ffd6",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 37032137,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @aacoimbra! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@aacoimbra/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table>\n\n<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@aacoimbra) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=aacoimbra)_</sub>\n\n\n###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
      "parent_author": "aacoimbra",
      "parent_permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "permlink": "steemitboard-notify-aacoimbra-20191006t003141000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-10-06T00:31:42",
  "trx_id": "8ac96b761fa8fb2b7c74ca56c519e3d0a03825a1",
  "trx_in_block": 4,
  "virtual_op": 0
}

{
  "block": 31278529,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "car10s77",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-03-19T03:02:15",
  "trx_id": "8fa67f451d557a6e9a7346566f9c1db51d456589",
  "trx_in_block": 5,
  "virtual_op": 0
}

{
  "block": 27266735,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "mckibbinusa",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-30T17:24:24",
  "trx_id": "4db2f794300745a36d8aef3b9f42460e79dc7461",
  "trx_in_block": 38,
  "virtual_op": 0
}

{
  "block": 26631313,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "aacoimbra",
      "delegator": "steem",
      "vesting_shares": "2019.336318 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-08T15:29:27",
  "trx_id": "75a869bacb48509d3c3f3afb6e5bb56fdc266067",
  "trx_in_block": 35,
  "virtual_op": 0
}

{
  "block": 26556763,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @aacoimbra! You have received a personal award!\n\n[![](https://steemitimages.com/70x70/http://steemitboard.com/@aacoimbra/birthday1.png)](http://steemitboard.com/@aacoimbra)  1 Year on Steemit\n<sub>_Click on the badge to view your Board of Honor._</sub>\n\n\n**Do not miss the last post from @steemitboard:**\n<table><tr><td><a href=\"https://steemit.com/steemitboard/@steemitboard/introducing-steemitboard-ranking\"><img src=\"https://steemitimages.com/64x128/https://cdn.steemitimages.com/DQmfRVpHQhLDhnjDtqck8GPv9NPvNKPfMsDaAFDE1D9Er2Z/header_ranking.png\"></a></td><td><a href=\"https://steemit.com/steemitboard/@steemitboard/introducing-steemitboard-ranking\">Introducing SteemitBoard Ranking</a></td></tr></table>\n\n> Support [SteemitBoard's project](https://steemit.com/@steemitboard)! **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
      "parent_author": "aacoimbra",
      "parent_permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "permlink": "steemitboard-notify-aacoimbra-20181006t011947000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-10-06T01:19:45",
  "trx_id": "75feb98d34695dd59d696d5ef5adff1ca6def20b",
  "trx_in_block": 16,
  "virtual_op": 0
}

{
  "block": 23668155,
  "op": [
    "vote",
    {
      "author": "aneeqamajeed",
      "permlink": "summary-of-institution-is-a-fundamental-of-long-run-growth",
      "voter": "aacoimbra",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-06-26T19:14:06",
  "trx_id": "840af20af0838e0582249cd877fd9e0494506bce",
  "trx_in_block": 16,
  "virtual_op": 0
}

{
  "block": 22950005,
  "op": [
    "transfer",
    {
      "amount": "26.586 STEEM",
      "from": "aacoimbra",
      "memo": "101249050",
      "to": "deepcrypto8"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-06-01T20:08:09",
  "trx_id": "1fe3de640f50a7dc353fb645213ba06a12f51a90",
  "trx_in_block": 30,
  "virtual_op": 0
}

{
  "block": 21811934,
  "op": [
    "vote",
    {
      "author": "embomb701",
      "permlink": "if-your-not-mining-vert-coin-you-need-to-start",
      "voter": "aacoimbra",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-23T06:42:36",
  "trx_id": "0d0dd7c8077f9e360703bfba0f54c341e1a65651",
  "trx_in_block": 5,
  "virtual_op": 0
}

{
  "block": 19384749,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "0.000 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "0.000007 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-28T21:54:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 7
}

{
  "block": 19183246,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "1.892 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "3874.300209 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-21T21:54:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 8
}

{
  "block": 19060921,
  "op": [
    "vote",
    {
      "author": "rawpride",
      "permlink": "did-the-bitconnect-exit-scam-crash-the-markets",
      "voter": "aacoimbra",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-17T15:54:57",
  "trx_id": "827631efcb0af3aaf25695e8efc5b8a57b5d8ea1",
  "trx_in_block": 11,
  "virtual_op": 0
}

{
  "block": 18981750,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "1.891 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "3874.300209 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-14T21:54:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 5
}

{
  "block": 18874682,
  "op": [
    "transfer",
    {
      "amount": "0.001 STEEM",
      "from": "money-dreamer",
      "memo": "I just followed you!",
      "to": "aacoimbra"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-11T04:35:24",
  "trx_id": "c2873f26213904aacc11e4b4ac5f1b7576be2581",
  "trx_in_block": 35,
  "virtual_op": 0
}

{
  "block": 18806362,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "aacoimbra",
      "delegator": "steem",
      "vesting_shares": "12687.877583 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-08T19:37:03",
  "trx_id": "4f6d38f9b88278eb6d1a925edf2b6920d253c8bd",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 18780350,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "1.891 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "3874.300209 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-07T21:54:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 12
}

{
  "block": 18579070,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "1.890 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "3874.300209 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-12-31T21:54:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 8
}

{
  "block": 18463165,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "aacoimbra",
      "delegator": "steem",
      "vesting_shares": "4957.277165 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-12-27T21:17:36",
  "trx_id": "c32940a1ee8127d84b5a4719cbcc1c4810506985",
  "trx_in_block": 5,
  "virtual_op": 0
}

{
  "block": 18377562,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "1.889 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "3874.300209 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-12-24T21:54:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 9
}

{
  "block": 18176029,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "1.889 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "3874.300209 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-12-17T21:54:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 6
}

{
  "block": 18136780,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "kingofallcrypto",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-12-16T13:11:30",
  "trx_id": "0bc20955a7879cb24ebdc981071fb1a71d9ef20b",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 17974486,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "1.888 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "3874.300209 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-12-10T21:54:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 11
}

{
  "block": 17773020,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "1.888 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "3874.300209 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-12-03T21:54:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 14
}

{
  "block": 17571503,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "1.887 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "3874.300209 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-11-26T21:54:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 8
}

{
  "block": 17518868,
  "op": [
    "vote",
    {
      "author": "sdot",
      "permlink": "crypto-exchange-fees-is-bittrex-making-usd160-000-000-a-month-why-do-we-pay-this",
      "voter": "aacoimbra",
      "weight": 0
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-11-25T02:02:21",
  "trx_id": "838f32096762fa554981dbbf638fbf6780a7f5e8",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 17518864,
  "op": [
    "vote",
    {
      "author": "sdot",
      "permlink": "crypto-exchange-fees-is-bittrex-making-usd160-000-000-a-month-why-do-we-pay-this",
      "voter": "aacoimbra",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-11-25T02:02:09",
  "trx_id": "d78d442bf5f0852d9bb9356791ec5691e7b7f785",
  "trx_in_block": 29,
  "virtual_op": 0
}

{
  "block": 17369987,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "1.886 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "3874.300209 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-11-19T21:54:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 4
}

{
  "block": 17168430,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "1.885 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "3874.300209 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-11-12T21:54:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 8
}

{
  "block": 16966994,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "1.885 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "3874.300209 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-11-05T21:54:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 8
}

{
  "block": 16829517,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "davidgibbin",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-11-01T03:18:12",
  "trx_id": "6fde2a395b5f1545499fb970b104782899805b83",
  "trx_in_block": 11,
  "virtual_op": 0
}

{
  "block": 16765445,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "1.884 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "3874.300209 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-29T21:54:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 4
}

{
  "block": 16691026,
  "op": [
    "vote",
    {
      "author": "bittrex-richie",
      "permlink": "re-cryptoiskey-bittrex-update-probably-my-fault-20170623t151643696z",
      "voter": "aacoimbra",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-27T07:49:42",
  "trx_id": "485d322bd6e5590eeac5a6bda029c780a77dcc9d",
  "trx_in_block": 32,
  "virtual_op": 0
}

{
  "block": 16691013,
  "op": [
    "vote",
    {
      "author": "cryptoiskey",
      "permlink": "bittrex-update-probably-my-fault",
      "voter": "aacoimbra",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-27T07:49:03",
  "trx_id": "56f83648486b2dcd76c4bf3cc5f747c717df890c",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 16690648,
  "op": [
    "transfer",
    {
      "amount": "32.292 SBD",
      "from": "aacoimbra",
      "memo": "8f016189d6fb605c",
      "to": "poloniex"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-27T07:30:48",
  "trx_id": "9ce6dfab69b4436cb961fb1ccc63bab52904917d",
  "trx_in_block": 5,
  "virtual_op": 0
}

{
  "block": 16650849,
  "op": [
    "fill_transfer_from_savings",
    {
      "amount": "32.292 SBD",
      "from": "aacoimbra",
      "memo": "",
      "request_id": 1508710805,
      "to": "aacoimbra"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-25T22:20:06",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 7
}

{
  "block": 16564484,
  "op": [
    "transfer_from_savings",
    {
      "amount": "32.292 SBD",
      "from": "aacoimbra",
      "memo": "",
      "request_id": 1508710805,
      "to": "aacoimbra"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-22T22:20:06",
  "trx_id": "6a3b86c944eeb95d4377af06efa80e66db1cccee",
  "trx_in_block": 13,
  "virtual_op": 0
}

{
  "block": 16564151,
  "op": [
    "cancel_transfer_from_savings",
    {
      "from": "aacoimbra",
      "request_id": 1508709423
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-22T22:03:24",
  "trx_id": "1ccd2dccc5bb83b5cc4fe4d4680cc8797e633da4",
  "trx_in_block": 7,
  "virtual_op": 0
}

{
  "block": 16564024,
  "op": [
    "transfer_from_savings",
    {
      "amount": "32.292 SBD",
      "from": "aacoimbra",
      "memo": "",
      "request_id": 1508709423,
      "to": "aacoimbra"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-22T21:57:03",
  "trx_id": "ca601b174932206134d19de86118f6149ef884ce",
  "trx_in_block": 15,
  "virtual_op": 0
}

{
  "block": 16564011,
  "op": [
    "transfer_to_savings",
    {
      "amount": "32.292 SBD",
      "from": "aacoimbra",
      "memo": "",
      "to": "aacoimbra"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-22T21:56:24",
  "trx_id": "3076937307adf172c157bdca185cbfd544315bab",
  "trx_in_block": 6,
  "virtual_op": 0
}

{
  "block": 16563970,
  "op": [
    "withdraw_vesting",
    {
      "account": "aacoimbra",
      "vesting_shares": "50365.902724 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-22T21:54:21",
  "trx_id": "01fb1608d33a282b717f73814674819cb029fc2f",
  "trx_in_block": 8,
  "virtual_op": 0
}

{
  "block": 16544230,
  "op": [
    "fill_vesting_withdraw",
    {
      "deposited": "2.040 STEEM",
      "from_account": "aacoimbra",
      "to_account": "aacoimbra",
      "withdrawn": "4197.158560 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-22T05:27:09",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 3
}

{
  "block": 16342726,
  "op": [
    "withdraw_vesting",
    {
      "account": "aacoimbra",
      "vesting_shares": "54563.061284 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-15T05:27:09",
  "trx_id": "8aca738021fd7952fcc6318222ee130d57ddd79a",
  "trx_in_block": 16,
  "virtual_op": 0
}

{
  "block": 16340604,
  "op": [
    "claim_reward_balance",
    {
      "account": "aacoimbra",
      "reward_sbd": "32.292 SBD",
      "reward_steem": "0.000 STEEM",
      "reward_vests": "63822.448503 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-15T03:40:42",
  "trx_id": "fd7a6682af85322b17389725db44df74e29c76b4",
  "trx_in_block": 10,
  "virtual_op": 0
}

{
  "block": 16316412,
  "op": [
    "author_reward",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "sbd_payout": "32.292 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "63822.448503 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-14T07:11:48",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 15
}

{
  "block": 16285243,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "aacoimbra",
      "delegator": "steem",
      "vesting_shares": "29832.865227 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-13T05:12:21",
  "trx_id": "121a1e7879f1538fc6a1e7025a003b9cac5f1bfd",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 16244362,
  "op": [
    "vote",
    {
      "author": "bengineering",
      "permlink": "re-aacoimbra-the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap-20171010t064641367z",
      "voter": "aacoimbra",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-11T19:07:03",
  "trx_id": "8b15650d0c0dea62e5724dc651ad67a999666a1e",
  "trx_in_block": 18,
  "virtual_op": 0
}

{
  "block": 16244354,
  "op": [
    "vote",
    {
      "author": "bengineering",
      "permlink": "excel-crypto-portfolio-with-live-prices-updates",
      "voter": "aacoimbra",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-11T19:06:39",
  "trx_id": "8ff553dd8154c01bf53b678ed8b28be16c7c2048",
  "trx_in_block": 16,
  "virtual_op": 0
}

{
  "block": 16224262,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "ubg",
      "weight": 100
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-11T02:21:51",
  "trx_id": "40d56a0c98545e66a49c2a51951e5d07a373bb0b",
  "trx_in_block": 4,
  "virtual_op": 0
}

{
  "block": 16224235,
  "op": [
    "comment",
    {
      "author": "aacoimbra",
      "body": "I've seen some tutorials on how to import Coinmarketcap data into excel, but most of them are a little too time consuming as you need to create a new worksheet for every different coin. Here is the way I found that works the best for me. We will be creating a custom excel funcion. Here is the step by step guide:\n\nEdit: I've just update the article to include variants of the custom function for data other than price. (Market Cap, Volume,  Supply, etc).\n\n---\n1. First, create a new file (or use your own portifolio workbook) and on the \"Data\" tab click on \"New Query\" -> \"From Other Sources\" -> \"From Web\".\n![](https://steemitimages.com/DQmcr6f7uzYsArNQTLPa1svUoB3PKKiqQMGCB37bwm4hnX1/image.png)\n\n2. Past this link: \"https://api.coinmarketcap.com/v1/ticker/\" and click OK.\n\n3. A new widow will pop up. Click on \"To Table\" at the top left corner and hit OK.\n\n4. Click on the small grey box with two arrows pointing in opposite directions next to \"Column1\" and press OK. Here you can select what info do you want excel to load. I personally load all of them as you can later retreive any data you want from this source.\n![](https://steemitimages.com/DQmdZCZFzNCZz1oFcSnkZrtxmeNnCmS6KNiVbzF6kypmxb2/image.png)\n\n5. Now click on \"Close & Load\"\n\n6. A new worksheet will be created. Rename it to \"CMC\".\n**Note: It's important to rename it exactly to \"CMC\", we will use a macro that will search for a \"CMC\" worksheet.**\n\n7. Select the first cell of the first column and click on the \"Data\" tab -> Refresh All -> \"Connection Properties\" -> Select \"Refresh every\" and set the interval you want your prices updated (I set to 20) and select \"Refresh data when opening the file\"\n![](https://steemitimages.com/DQmPJsT5PvGdhBMoec9JB4x7cu1GyqXiDBaRtrju6hkC1UW/image.png)\n\n8. Press ALT+F11 and a new widnow should open up. Now create a new module as shown below.\n![](https://steemitimages.com/DQmeg8zsVHntt9DhTftJkp7rKytEdnWk7baDdvGTsn6KJ65/image.png)\n\n9. Past this code: \n\n`Function CMCPrice(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n    CMCPrice = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 3, 0)    `\n`End Function`\n\n\nNow it's all set. The code above added a custom function to excel.  You can now retrieve the price of any coin registered on Coinmarketcap. To retrieve a price from Bitcoin for example, type *=TokenPrice(\"BTC\")* on the cell you want the price at.\n\n\nLet's say you track the value of your crypto holdings in this worksheet and you have one bitcoin:\n\n![](https://steemitimages.com/DQmUJe8612imCethi86oySpjvHUzsJj2PUGh7iZh7uuQdmA/image.png)\n\nBut now you just bought 2 Ethereum and want to add it tho the table. Just select and drag the cells as following:\n![](https://steemitimages.com/DQmXHNQrZUdTFcvWmZ7DVY8DW8hSAQShDqDE4JV26e5e9EA/image.png)\n\nAnd change the refence name to ETH:\n![](https://steemitimages.com/DQmVL2zCsDWhinou81GiTaAuYpm8Bbk6SqCakdefbYqVrFf/image.png)\n\nYou can add as many crypto as you want. e.g.\n![](https://steemitimages.com/DQmWtGZqL6hrRBdXQRSFt16hDyCeCHu9KVWbnXLJR8q6Mg2/image.png)\n\nI've uploaded an [example workbook](https://drive.google.com/file/d/0B634XdeaWr4iR2F2elhYc0UtQm8/view?usp=sharing) to google drive.\n\n\nI hope I've helped you! :D\n\n*Note: Remember to save your workbook as a macro enabled workbook or else the macro will not be saved.*\n\n---\n\nEdit: I've created variants of the custom function for data other than price. (Market Cap, Volume,  Supply, etc).Paste the function you want in the module window as we did with the price function.\n\nFor the coin rank on CMC:\n`Function CMCRank(CMCTokenSymbol As String)`\n`    Application.Volatile`    \n    `CMCRank = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 2, 0)`    \n`End Function`\n\nFor the coin price in BTC:\n`Function CMCPriceBTC(CMCTokenSymbol As String)`\n `   Application.Volatile    `\n`    CMCPriceBTC = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 4, 0)`\n`End Function`\n\nFor the trading volume in the last 24h:\n`Function CMCVolume24h(CMCTokenSymbol As String)`\n `   Application.Volatile `   \n`    CMCVolume24h = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 5, 0)   `\n`End Function`\n\nFor the market cap:\n`Function CMCMarketCap(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n`    CMCMarketCap = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 6, 0)    `\n`End Function`\n\nFor the available supply:\n`Function CMCAvailableSupply(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n`    CMCAvailableSupply = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 7, 0)`   \n`End Function`\n\nFor the total supply:\n`Function CMCTotalSupply(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n`    CMCTotalSupply = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 8, 0)  `\n`End Function`\n\nFor the percent change in the last 1h:\n`Function CMCPercentChange1h(CMCTokenSymbol As String)`\n   ` Application.Volatile    `\n  `  CMCPercentChange1h = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 9, 0)  `  \n`End Function`\n\nFor the percent change in the last 24h:\n`Function CMCPercentChange24h(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n`  CMCPercentChange24h = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 10, 0)` \n`End Function`\n\nFor the percent change in the last 7d:\n` Function CMCPercentChange7d(CMCTokenSymbol As String)`\n`Application.Volatile `\n` CMCPercentChange7d = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 11, 0)    `\n`End Function`\n\n\nNow you can easily create tables like this one, in the [example workbook](https://drive.google.com/file/d/0B634XdeaWr4iR2F2elhYc0UtQm8/view?usp=sharing):\n\n![](https://steemitimages.com/DQmdv1L8N11Ya6WSEBR54yjUiXmfcEN8RkFnXrRjLeyDs45/image.png)\n\n:)",
      "json_metadata": "{\"tags\":[\"cryptocurrency\",\"bitcoin\",\"excel\",\"import\",\"prices\"],\"image\":[\"https://steemitimages.com/DQmcr6f7uzYsArNQTLPa1svUoB3PKKiqQMGCB37bwm4hnX1/image.png\",\"https://steemitimages.com/DQmdZCZFzNCZz1oFcSnkZrtxmeNnCmS6KNiVbzF6kypmxb2/image.png\",\"https://steemitimages.com/DQmPJsT5PvGdhBMoec9JB4x7cu1GyqXiDBaRtrju6hkC1UW/image.png\",\"https://steemitimages.com/DQmeg8zsVHntt9DhTftJkp7rKytEdnWk7baDdvGTsn6KJ65/image.png\",\"https://steemitimages.com/DQmUJe8612imCethi86oySpjvHUzsJj2PUGh7iZh7uuQdmA/image.png\",\"https://steemitimages.com/DQmXHNQrZUdTFcvWmZ7DVY8DW8hSAQShDqDE4JV26e5e9EA/image.png\",\"https://steemitimages.com/DQmVL2zCsDWhinou81GiTaAuYpm8Bbk6SqCakdefbYqVrFf/image.png\",\"https://steemitimages.com/DQmWtGZqL6hrRBdXQRSFt16hDyCeCHu9KVWbnXLJR8q6Mg2/image.png\",\"https://steemitimages.com/DQmdv1L8N11Ya6WSEBR54yjUiXmfcEN8RkFnXrRjLeyDs45/image.png\"],\"links\":[\"https://api.coinmarketcap.com/v1/ticker/\",\"https://drive.google.com/file/d/0B634XdeaWr4iR2F2elhYc0UtQm8/view?usp=sharing\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "cryptocurrency",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "title": "The easiest way to have LIVE cryptocurrencies prices, and any other data, on excel! With a custom function! (Importing from Coinmarketcap)"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-11T02:20:30",
  "trx_id": "a2857fdb27dec7d420caa350d029062728b807eb",
  "trx_in_block": 28,
  "virtual_op": 0
}

{
  "block": 16217344,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "danarm",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-10T20:35:54",
  "trx_id": "0bb1ece0a564acc245224dbd73511040fde855d5",
  "trx_in_block": 30,
  "virtual_op": 0
}

{
  "block": 16210842,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "stephanj79",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-10T15:08:54",
  "trx_id": "d09b5cd5353b82c9a913322c497254326a296ca4",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 16200802,
  "op": [
    "comment",
    {
      "author": "bengineering",
      "body": "Here's a cleaned up version I made with a few more bells. https://steemit.com/cryptocurrency/@bengineering/excel-crypto-portfolio-with-live-prices-updates",
      "json_metadata": "{\"tags\":[\"cryptocurrency\"],\"links\":[\"https://steemit.com/cryptocurrency/@bengineering/excel-crypto-portfolio-with-live-prices-updates\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "aacoimbra",
      "parent_permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "permlink": "re-aacoimbra-the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap-20171010t064641367z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-10T06:46:39",
  "trx_id": "a37cc4e478353a3caa695e906ae6054a6a1bcad5",
  "trx_in_block": 22,
  "virtual_op": 0
}

{
  "block": 16189520,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "fivestargroup",
      "weight": 2
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T21:22:24",
  "trx_id": "c18481bcfee689b8a3654487e754d821ffe32b1d",
  "trx_in_block": 4,
  "virtual_op": 0
}

{
  "block": 16189495,
  "op": [
    "comment",
    {
      "author": "aacoimbra",
      "body": "I've seen some tutorials on how to import Coinmarketcap data into excel, but most of them are a little too time consuming as you need to create a new worksheet for every different coin. Here is the way I found that works the best for me. We will be creating a custom excel funcion. Here is the step by step guide:\n\nEdit: I've just update the article to include variants of the custom function for data other than price. (Market Cap, Volume,  Supply, etc).\n\n---\n1. First, create a new file (or use your own portifolio workbook) and on the \"Data\" tab click on \"New Query\" -> \"From Other Sources\" -> \"From Web\".\n![](https://steemitimages.com/DQmcr6f7uzYsArNQTLPa1svUoB3PKKiqQMGCB37bwm4hnX1/image.png)\n\n2. Past this link: \"https://api.coinmarketcap.com/v1/ticker/\" and click OK.\n\n3. A new widow will pop up. Click on \"To Table\" at the top left corner and hit OK.\n\n4. Click on the small grey box with two arrows pointing in opposite directions next to \"Column1\" and press OK. Here you can select what info do you want excel to load. I personally load all of them as you can later retreive any data you want from this source.\n![](https://steemitimages.com/DQmdZCZFzNCZz1oFcSnkZrtxmeNnCmS6KNiVbzF6kypmxb2/image.png)\n\n5. Now click on \"Close & Load\"\n\n6. A new worksheet will be created. Rename it to \"CMC\".\n**Note: It's important to rename it exactly to \"CMC\", we will use a macro that will search for a \"CMC\" worksheet.**\n\n7. Select the first cell of the first column and click on the \"Data\" tab -> Refresh All -> \"Connection Properties\" -> Select \"Refresh every\" and set the interval you want your prices updated (I set to 20) and select \"Refresh data when opening the file\"\n![](https://steemitimages.com/DQmPJsT5PvGdhBMoec9JB4x7cu1GyqXiDBaRtrju6hkC1UW/image.png)\n\n8. Press ALT+F11 and a new widnow should open up. Now create a new module as shown below.\n![](https://steemitimages.com/DQmeg8zsVHntt9DhTftJkp7rKytEdnWk7baDdvGTsn6KJ65/image.png)\n\n9. Past this code: \n\n`Function CMCPrice(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n    CMCPrice = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 3, 0)    `\n`End Function`\n\n\nNow it's all set. The code above added a custom function to excel.  You can now retrieve the price of any coin registered on Coinmarketcap. To retrieve a price from Bitcoin for example, type *=TokenPrice(\"BTC\")* on the cell you want the price at.\n\n\nLet's say you track the value of your crypto holdings in this worksheet and you have one bitcoin:\n\n![](https://steemitimages.com/DQmUJe8612imCethi86oySpjvHUzsJj2PUGh7iZh7uuQdmA/image.png)\n\nBut now you just bought 2 Ethereum and want to add it tho the table. Just select and drag the cells as following:\n![](https://steemitimages.com/DQmXHNQrZUdTFcvWmZ7DVY8DW8hSAQShDqDE4JV26e5e9EA/image.png)\n\nAnd change the refence name to ETH:\n![](https://steemitimages.com/DQmVL2zCsDWhinou81GiTaAuYpm8Bbk6SqCakdefbYqVrFf/image.png)\n\nYou can add as many crypto as you want. e.g.\n![](https://steemitimages.com/DQmWtGZqL6hrRBdXQRSFt16hDyCeCHu9KVWbnXLJR8q6Mg2/image.png)\n\nI've uploaded an [example workbook](https://drive.google.com/file/d/0B634XdeaWr4iR2F2elhYc0UtQm8/view?usp=sharing) to google drive.\n\n\nI hope I've helped you! :D\n\n*Note: Remember to save your workbook as a macro enabled workbook or else the macro will not be saved.*\n\n---\n\nEdit: I've created variants of the custom function for data other than price. (Market Cap, Volume,  Supply, etc).Paste the function you want in the module window as we did with the price function.\n\nFor the coin rank on CMC:\n`Function CMCRank(CMCTokenSymbol As String)`\n`    Application.Volatile`    \n    `CMCRank = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 2, 0)`    \n`End Function`\n\nFor the coin price in BTC:\n`Function CMCPriceBTC(CMCTokenSymbol As String)`\n `   Application.Volatile    `\n`    CMCPriceBTC = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 4, 0)`\n`End Function`\n\nFor the trading volume in the last 24h:\n`Function CMCVolume24h(CMCTokenSymbol As String)`\n `   Application.Volatile `   \n`    CMCVolume24h = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 5, 0)   `\n`End Function`\n\nFor the market cap:\n`Function CMCMarketCap(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n`    CMCMarketCap = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 6, 0)    `\n`End Function`\n\nFor the available supply:\n`Function CMCAvailableSupply(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n`    CMCAvailableSupply = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 7, 0)`   \n`End Function`\n\nFor the total supply:\n`Function CMCTotalSupply(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n`    CMCTotalSupply = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 8, 0)  `\n`End Function`\n\nFor the percent change in the last 1h:\n`Function CMCPercentChange1h(CMCTokenSymbol As String)`\n   ` Application.Volatile    `\n  `  CMCPercentChange1h = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 9, 0)  `  \n`End Function`\n\nFor the percent change in the last 24h:\n`Function CMCPercentChange24h(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n`  CMCPercentChange24h = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 10, 0)` \n`End Function`\n\nFor the percent change in the last 7d:\n` Function CMCPercentChange7d(CMCTokenSymbol As String)`\n`Application.Volatile `\n` CMCPercentChange7d = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 11, 0)    `\n`End Function`\n\n\nNow you can easily create tables like this one, in the [example workbook](https://drive.google.com/file/d/0B634XdeaWr4iR2F2elhYc0UtQm8/view?usp=sharing):\n\n![](https://steemitimages.com/DQmdv1L8N11Ya6WSEBR54yjUiXmfcEN8RkFnXrRjLeyDs45/image.png)\n\n:)",
      "json_metadata": "{\"tags\":[\"cryptocurrency\",\"bitcoin\",\"excel\",\"import\",\"prices\"],\"image\":[\"https://steemitimages.com/DQmcr6f7uzYsArNQTLPa1svUoB3PKKiqQMGCB37bwm4hnX1/image.png\",\"https://steemitimages.com/DQmdZCZFzNCZz1oFcSnkZrtxmeNnCmS6KNiVbzF6kypmxb2/image.png\",\"https://steemitimages.com/DQmPJsT5PvGdhBMoec9JB4x7cu1GyqXiDBaRtrju6hkC1UW/image.png\",\"https://steemitimages.com/DQmeg8zsVHntt9DhTftJkp7rKytEdnWk7baDdvGTsn6KJ65/image.png\",\"https://steemitimages.com/DQmUJe8612imCethi86oySpjvHUzsJj2PUGh7iZh7uuQdmA/image.png\",\"https://steemitimages.com/DQmXHNQrZUdTFcvWmZ7DVY8DW8hSAQShDqDE4JV26e5e9EA/image.png\",\"https://steemitimages.com/DQmVL2zCsDWhinou81GiTaAuYpm8Bbk6SqCakdefbYqVrFf/image.png\",\"https://steemitimages.com/DQmWtGZqL6hrRBdXQRSFt16hDyCeCHu9KVWbnXLJR8q6Mg2/image.png\",\"https://steemitimages.com/DQmdv1L8N11Ya6WSEBR54yjUiXmfcEN8RkFnXrRjLeyDs45/image.png\"],\"links\":[\"https://api.coinmarketcap.com/v1/ticker/\",\"https://drive.google.com/file/d/0B634XdeaWr4iR2F2elhYc0UtQm8/view?usp=sharing\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "cryptocurrency",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "title": "The easiest way to have LIVE cryptocurrencies prices, and any other data, on excel! With a custom function! (Importing from Coinmarketcap)"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T21:21:09",
  "trx_id": "30d40cb2adc7fc4307afc7fd9eb0ba73fb7502a1",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 16188795,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "blade325",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T20:46:03",
  "trx_id": "789b1f832aaf8ed4f06dd58f6784eef5c65184f9",
  "trx_in_block": 17,
  "virtual_op": 0
}

{
  "block": 16179487,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "koltregaskes",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T13:00:33",
  "trx_id": "a8eb0a75ad3aea54b35b96c39cc45bee441d34a3",
  "trx_in_block": 5,
  "virtual_op": 0
}

{
  "block": 16177236,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "gianluccio",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T11:08:00",
  "trx_id": "96079e17db0332e6219226c4966d9f26a88ab78d",
  "trx_in_block": 11,
  "virtual_op": 0
}

{
  "block": 16177170,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "aymanamer",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T11:04:42",
  "trx_id": "f65427b8256f2c4af1632b6f60a0a9cf035e4281",
  "trx_in_block": 10,
  "virtual_op": 0
}

{
  "block": 16176613,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "ubik-1984",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T10:36:51",
  "trx_id": "356d3934495e646f8cfffa81117420c006ede79d",
  "trx_in_block": 8,
  "virtual_op": 0
}

{
  "block": 16176291,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "dlal0522802",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T10:20:45",
  "trx_id": "71dd42258bef1a59596ec317102a213144e1fdc0",
  "trx_in_block": 12,
  "virtual_op": 0
}

{
  "block": 16176043,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "ninjasnake",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T10:08:21",
  "trx_id": "94391e660fc2ad633bd06191175ae981d55aff83",
  "trx_in_block": 11,
  "virtual_op": 0
}

{
  "block": 16175300,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "imib",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T09:31:12",
  "trx_id": "b6f711668961b619aeaab0724423f46b75f8ba59",
  "trx_in_block": 9,
  "virtual_op": 0
}

{
  "block": 16173909,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "vrrom",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T08:21:39",
  "trx_id": "38045f4d144342911ac2af5739faf5fe3ce4a6e4",
  "trx_in_block": 21,
  "virtual_op": 0
}

{
  "block": 16170911,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "delicacies",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T05:51:45",
  "trx_id": "ca485c5c398049c815747ee061dcc2feebe12562",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 16167988,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "saju",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T03:25:36",
  "trx_id": "cf5fa2487a156a14090dc0814171b724ff733868",
  "trx_in_block": 19,
  "virtual_op": 0
}

{
  "block": 16167423,
  "op": [
    "comment",
    {
      "author": "aacoimbra",
      "body": "@@ -60,17 +60,72 @@\n  of them\n-:\n+. Just copy and past this in the workbook module window.\n %0A%0A%0A%60Func\n",
      "json_metadata": "{\"tags\":[\"cryptocurrency\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "aacoimbra",
      "parent_permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "permlink": "re-aacoimbra-the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap-20171008t205131220z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T02:57:21",
  "trx_id": "da4fb81b8db69b77f621eb55bc592a7a380f0d3e",
  "trx_in_block": 13,
  "virtual_op": 0
}

{
  "block": 16166576,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "turymenecier",
      "weight": 3000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T02:15:00",
  "trx_id": "bec26a89d844087c5c5343e97bac13f70a6bd2cd",
  "trx_in_block": 29,
  "virtual_op": 0
}

{
  "block": 16166555,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "teamsteem",
      "weight": 2500
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T02:13:57",
  "trx_id": "4b7a9be1b29ceab6793e5441e1f21f14a7663612",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 16165383,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "red-rose",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-09T01:15:21",
  "trx_id": "ed7139cb18d0e1ebd20c730e3a8c2ac354317d8c",
  "trx_in_block": 8,
  "virtual_op": 0
}

{
  "block": 16163479,
  "op": [
    "comment",
    {
      "author": "bengineering",
      "body": "Thank you! Very helpful and simple to use. Updating my spreadsheet now.",
      "json_metadata": "{\"tags\":[\"cryptocurrency\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "aacoimbra",
      "parent_permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "permlink": "re-aacoimbra-the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap-20171008t234009887z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-08T23:40:09",
  "trx_id": "5452e8dff3bc392c0d729721def5162986eb4971",
  "trx_in_block": 26,
  "virtual_op": 0
}

{
  "block": 16162748,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "bengineering",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-08T23:03:36",
  "trx_id": "a75474eece71793ba87f67ed8fd1d5a659ad56c4",
  "trx_in_block": 33,
  "virtual_op": 0
}

{
  "block": 16161225,
  "op": [
    "vote",
    {
      "author": "aacoimbra",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "voter": "primetimesports",
      "weight": 2
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-08T21:47:27",
  "trx_id": "2eef2ae19d29ffbb8e4e3f4ddcfb2bc5a4f667c4",
  "trx_in_block": 32,
  "virtual_op": 0
}

{
  "block": 16161197,
  "op": [
    "comment",
    {
      "author": "aacoimbra",
      "body": "I've seen some tutorials on how to import Coinmarketcap data into excel, but most of them are a little too time consuming as you need to create a new worksheet for every different coin. Here is the way I found that works the best for me. We will be creating a custom excel funcion. Here is the step by step guide:\n\nEdit: I've just update the article to include variants of the custom function for data other than price. (Market Cap, Volume,  Supply, etc).\n\n---\n1. First, create a new file (or use your own portifolio workbook) and on the \"Data\" tab click on \"New Query\" -> \"From Other Sources\" -> \"From Web\".\n![](https://steemitimages.com/DQmcr6f7uzYsArNQTLPa1svUoB3PKKiqQMGCB37bwm4hnX1/image.png)\n\n2. Past this link: \"https://api.coinmarketcap.com/v1/ticker/\" and click OK.\n\n3. A new widow will pop up. Click on \"To Table\" at the top left corner and hit OK.\n\n4. Click on the small grey box with two arrows pointing in opposite directions next to \"Column1\" and press OK. Here you can select what info do you want excel to load. I personally load all of them as you can later retreive any data you want from this source.\n![](https://steemitimages.com/DQmdZCZFzNCZz1oFcSnkZrtxmeNnCmS6KNiVbzF6kypmxb2/image.png)\n\n5. Now click on \"Close & Load\"\n\n6. A new worksheet will be created. Rename it to \"CMC\".\n**Note: It's important to rename it exactly to \"CMC\", we will use a macro that will search for a \"CMC\" worksheet.**\n\n7. Select the first cell of the first column and click on the \"Data\" tab -> Refresh All -> \"Connection Properties\" -> Select \"Refresh every\" and set the interval you want your prices updated (I set to 20) and select \"Refresh data when opening the file\"\n![](https://steemitimages.com/DQmPJsT5PvGdhBMoec9JB4x7cu1GyqXiDBaRtrju6hkC1UW/image.png)\n\n8. Press ALT+F11 and a new widnow should open up. Now create a new module as shown below.\n![](https://steemitimages.com/DQmeg8zsVHntt9DhTftJkp7rKytEdnWk7baDdvGTsn6KJ65/image.png)\n\n9. Past this code: \n\n`Function CMCPrice(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n    CMCPrice = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 3, 0)    `\n`End Function`\n\n\nNow it's all set. The code above added a custom function to excel.  You can now retrieve the price of any coin registered on Coinmarketcap. To retrieve a price from Bitcoin for example, type *=TokenPrice(\"BTC\")* on the cell you want the price at.\n\n\nLet's say you track the value of your crypto holdings in this worksheet and you have one bitcoin:\n\n![](https://steemitimages.com/DQmUJe8612imCethi86oySpjvHUzsJj2PUGh7iZh7uuQdmA/image.png)\n\nBut now you just bought 2 Ethereum and want to add it tho the table. Just select and drag the cells as following:\n![](https://steemitimages.com/DQmXHNQrZUdTFcvWmZ7DVY8DW8hSAQShDqDE4JV26e5e9EA/image.png)\n\nAnd change the refence name to ETH:\n![](https://steemitimages.com/DQmVL2zCsDWhinou81GiTaAuYpm8Bbk6SqCakdefbYqVrFf/image.png)\n\nYou can add as many crypto as you want. e.g.\n![](https://steemitimages.com/DQmWtGZqL6hrRBdXQRSFt16hDyCeCHu9KVWbnXLJR8q6Mg2/image.png)\n\nI've uploaded an [example workbook](https://drive.google.com/file/d/0B634XdeaWr4iR2F2elhYc0UtQm8/view?usp=sharing) to google drive.\n\n\nI hope I've helped you! :D\n\n*Note: Remember to save your workbook as a macro enabled workbook or else the macro will not be saved.*\n\n---\n\nEdit: I've created variants of the custom function for data other than price. (Market Cap, Volume,  Supply, etc).Paste the function you want in the module window as we did with the price function.\n\nFor the coin rank on CMC:\n`Function CMCRank(CMCTokenSymbol As String)`\n`    Application.Volatile`    \n    `CMCRank = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 2, 0)`    \n`End Function`\n\nFor the coin price in BTC:\n`Function CMCPriceBTC(CMCTokenSymbol As String)`\n `   Application.Volatile    `\n`    CMCPriceBTC = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 4, 0)`\n`End Function`\n\nFor the trading volume in the last 24h:\n`Function CMCVolume24h(CMCTokenSymbol As String)`\n `   Application.Volatile `   \n`    CMCVolume24h = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 5, 0)   `\n`End Function`\n\nFor the market cap:\n`Function CMCMarketCap(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n`    CMCMarketCap = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 6, 0)    `\n`End Function`\n\nFor the available supply:\n`Function CMCAvailableSupply(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n`    CMCAvailableSupply = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 7, 0)`   \n`End Function`\n\nFor the total supply:\n`Function CMCTotalSupply(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n`    CMCTotalSupply = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 8, 0)  `\n`End Function`\n\nFor the percent change in the last 1h:\n`Function CMCPercentChange1h(CMCTokenSymbol As String)`\n   ` Application.Volatile    `\n  `  CMCPercentChange1h = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 9, 0)  `  \n`End Function`\n\nFor the percent change in the last 24h:\n`Function CMCPercentChange24h(CMCTokenSymbol As String)`\n`    Application.Volatile    `\n`  CMCPercentChange24h = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 10, 0)` \n`End Function`\n\nFor the percent change in the last 7d:\n` Function CMCPercentChange7d(CMCTokenSymbol As String)`\n`Application.Volatile `\n` CMCPercentChange7d = WorksheetFunction.VLookup(CMCTokenSymbol, Worksheets(\"CMC\").Range(\"$C:$M\"), 11, 0)    `\n`End Function`\n\n\nNow you can easily create tables like this one, in the [example workbook](https://drive.google.com/file/d/0B634XdeaWr4iR2F2elhYc0UtQm8/view?usp=sharing):\n\n![](https://steemitimages.com/DQmdv1L8N11Ya6WSEBR54yjUiXmfcEN8RkFnXrRjLeyDs45/image.png)\n\n:)",
      "json_metadata": "{\"tags\":[\"cryptocurrency\",\"bitcoin\",\"excel\",\"import\",\"prices\"],\"image\":[\"https://steemitimages.com/DQmcr6f7uzYsArNQTLPa1svUoB3PKKiqQMGCB37bwm4hnX1/image.png\",\"https://steemitimages.com/DQmdZCZFzNCZz1oFcSnkZrtxmeNnCmS6KNiVbzF6kypmxb2/image.png\",\"https://steemitimages.com/DQmPJsT5PvGdhBMoec9JB4x7cu1GyqXiDBaRtrju6hkC1UW/image.png\",\"https://steemitimages.com/DQmeg8zsVHntt9DhTftJkp7rKytEdnWk7baDdvGTsn6KJ65/image.png\",\"https://steemitimages.com/DQmUJe8612imCethi86oySpjvHUzsJj2PUGh7iZh7uuQdmA/image.png\",\"https://steemitimages.com/DQmXHNQrZUdTFcvWmZ7DVY8DW8hSAQShDqDE4JV26e5e9EA/image.png\",\"https://steemitimages.com/DQmVL2zCsDWhinou81GiTaAuYpm8Bbk6SqCakdefbYqVrFf/image.png\",\"https://steemitimages.com/DQmWtGZqL6hrRBdXQRSFt16hDyCeCHu9KVWbnXLJR8q6Mg2/image.png\",\"https://steemitimages.com/DQmdv1L8N11Ya6WSEBR54yjUiXmfcEN8RkFnXrRjLeyDs45/image.png\"],\"links\":[\"https://api.coinmarketcap.com/v1/ticker/\",\"https://drive.google.com/file/d/0B634XdeaWr4iR2F2elhYc0UtQm8/view?usp=sharing\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "cryptocurrency",
      "permlink": "the-easiest-way-to-have-live-cryptocurrencies-prices-on-excel-importing-from-coinmarketcap",
      "title": "The easiest way to have LIVE cryptocurrencies prices, and any other data, on excel! With a custom function! (Importing from Coinmarketcap)"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-10-08T21:46:03",
  "trx_id": "b6eef6f88758a36c403ed09e604963c23ca8c30f",
  "trx_in_block": 5,
  "virtual_op": 0
}