Ecoer Logo
VOTING POWER100.00%
DOWNVOTE POWER100.00%
RESOURCE CREDITS100.00%
REPUTATION PROGRESS85.19%
Net Worth
4.102USD
STEEM
0.000STEEM
SBD
8.247SBD
Effective Power
5.001SP
├── Own SP
0.636SP
└── Incoming Deleg
+4.365SP

Detailed Balance

STEEM
balance
0.000STEEM
market_balance
0.000STEEM
savings_balance
0.000STEEM
reward_steem_balance
0.000STEEM
STEEM POWER
Own SP
0.636SP
Delegated Out
0.000SP
Delegation In
4.365SP
Effective Power
5.001SP
Reward SP (pending)
3.829SP
SBD
sbd_balance
0.000SBD
sbd_conversions
0.000SBD
sbd_market_balance
0.000SBD
savings_sbd_balance
0.000SBD
reward_sbd_balance
8.247SBD
{
  "balance": "0.000 STEEM",
  "savings_balance": "0.000 STEEM",
  "reward_steem_balance": "0.000 STEEM",
  "vesting_shares": "1035.682370 VESTS",
  "delegated_vesting_shares": "0.000000 VESTS",
  "received_vesting_shares": "7107.977436 VESTS",
  "sbd_balance": "0.000 SBD",
  "savings_sbd_balance": "0.000 SBD",
  "reward_sbd_balance": "8.247 SBD",
  "conversions": []
}

Account Info

namenickg
id183674
rank691,921
reputation16060761947
created2017-06-08T05:55:15
recovery_accountsteem
proxyNone
post_count1
comment_count0
lifetime_vote_count0
witnesses_voted_for0
last_post2017-06-17T06:18:42
last_root_post1970-01-01T00:00:00
last_vote_time1970-01-01T00:00:00
proxied_vsf_votes0, 0, 0, 0
can_vote1
voting_power0
delayed_votes0
balance0.000 STEEM
savings_balance0.000 STEEM
sbd_balance0.000 SBD
savings_sbd_balance0.000 SBD
vesting_shares1035.682370 VESTS
delegated_vesting_shares0.000000 VESTS
received_vesting_shares7107.977436 VESTS
reward_vesting_balance7924.462962 VESTS
vesting_balance0.000 STEEM
vesting_withdraw_rate0.000000 VESTS
next_vesting_withdrawal1969-12-31T23:59:59
withdrawn0
to_withdraw0
withdraw_routes0
savings_withdraw_requests0
last_account_recovery1970-01-01T00:00:00
reset_accountnull
last_owner_update1970-01-01T00:00:00
last_account_update1970-01-01T00:00:00
minedNo
sbd_seconds0
sbd_last_interest_payment1970-01-01T00:00:00
savings_sbd_last_interest_payment1970-01-01T00:00:00
{
  "id": 183674,
  "name": "nickg",
  "owner": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM6jumkTWMtonS2h4mTFb45itGgmvFaZvR2y7VPN3gGicgh28CVA",
        1
      ]
    ]
  },
  "active": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM6KUpcc6bkzTa68ND4NYnLgqTB5RKTa7V8JRrM9TvvsrNLNe4rQ",
        1
      ]
    ]
  },
  "posting": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM7GWHdzMucfTkoiPiGhkbGwdLqJEcVGtNp3SqzNA1FBVQ9miqps",
        1
      ]
    ]
  },
  "memo_key": "STM8GCvT728U47ugThCfrdSpMMLYCatirxTdmEiX4a7MSgzD2bTnJ",
  "json_metadata": "",
  "posting_json_metadata": "",
  "proxy": "",
  "last_owner_update": "1970-01-01T00:00:00",
  "last_account_update": "1970-01-01T00:00:00",
  "created": "2017-06-08T05:55:15",
  "mined": false,
  "recovery_account": "steem",
  "last_account_recovery": "1970-01-01T00:00:00",
  "reset_account": "null",
  "comment_count": 0,
  "lifetime_vote_count": 0,
  "post_count": 1,
  "can_vote": true,
  "voting_manabar": {
    "current_mana": "8143659806",
    "last_update_time": 1779078459
  },
  "downvote_manabar": {
    "current_mana": 2035914951,
    "last_update_time": 1779078459
  },
  "voting_power": 0,
  "balance": "0.000 STEEM",
  "savings_balance": "0.000 STEEM",
  "sbd_balance": "0.000 SBD",
  "sbd_seconds": "0",
  "sbd_seconds_last_update": "1970-01-01T00:00:00",
  "sbd_last_interest_payment": "1970-01-01T00:00:00",
  "savings_sbd_balance": "0.000 SBD",
  "savings_sbd_seconds": "0",
  "savings_sbd_seconds_last_update": "1970-01-01T00:00:00",
  "savings_sbd_last_interest_payment": "1970-01-01T00:00:00",
  "savings_withdraw_requests": 0,
  "reward_sbd_balance": "8.247 SBD",
  "reward_steem_balance": "0.000 STEEM",
  "reward_vesting_balance": "7924.462962 VESTS",
  "reward_vesting_steem": "3.829 STEEM",
  "vesting_shares": "1035.682370 VESTS",
  "delegated_vesting_shares": "0.000000 VESTS",
  "received_vesting_shares": "7107.977436 VESTS",
  "vesting_withdraw_rate": "0.000000 VESTS",
  "next_vesting_withdrawal": "1969-12-31T23:59:59",
  "withdrawn": 0,
  "to_withdraw": 0,
  "withdraw_routes": 0,
  "curation_rewards": 0,
  "posting_rewards": 7658,
  "proxied_vsf_votes": [
    0,
    0,
    0,
    0
  ],
  "witnesses_voted_for": 0,
  "last_post": "2017-06-17T06:18:42",
  "last_root_post": "1970-01-01T00:00:00",
  "last_vote_time": "1970-01-01T00:00:00",
  "post_bandwidth": 0,
  "pending_claimed_accounts": 0,
  "vesting_balance": "0.000 STEEM",
  "reputation": "16060761947",
  "transfer_history": [],
  "market_history": [],
  "post_history": [],
  "vote_history": [],
  "other_history": [],
  "witness_votes": [],
  "tags_usage": [],
  "guest_bloggers": [],
  "rank": 691921
}

Withdraw Routes

IncomingOutgoing
Empty
Empty
{
  "incoming": [],
  "outgoing": []
}
From Date
To Date
steemdelegated 4.365 SP to @nickg
2026/05/18 04:27:39
delegatorsteem
delegateenickg
vesting shares7107.977436 VESTS
Transaction InfoBlock #106148473/Trx d2630623d70d06be21be61100345996e774c7738
View Raw JSON Data
{
  "trx_id": "d2630623d70d06be21be61100345996e774c7738",
  "block": 106148473,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2026-05-18T04:27:39",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "7107.977436 VESTS"
    }
  ]
}
steemdelegated 2.699 SP to @nickg
2026/05/12 20:54:39
delegatorsteem
delegateenickg
vesting shares4395.767031 VESTS
Transaction InfoBlock #105996150/Trx 7ea55ef3ff366b2ca3f28f32f9ec354812b8dc33
View Raw JSON Data
{
  "trx_id": "7ea55ef3ff366b2ca3f28f32f9ec354812b8dc33",
  "block": 105996150,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2026-05-12T20:54:39",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "4395.767031 VESTS"
    }
  ]
}
steemdelegated 4.373 SP to @nickg
2026/04/26 03:41:57
delegatorsteem
delegateenickg
vesting shares7120.493192 VESTS
Transaction InfoBlock #105516005/Trx 1ffb2efde5071c34be3bcad57bb55314b7e19bdb
View Raw JSON Data
{
  "trx_id": "1ffb2efde5071c34be3bcad57bb55314b7e19bdb",
  "block": 105516005,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2026-04-26T03:41:57",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "7120.493192 VESTS"
    }
  ]
}
steemdelegated 2.725 SP to @nickg
2026/01/23 19:05:51
delegatorsteem
delegateenickg
vesting shares4437.313850 VESTS
Transaction InfoBlock #102865345/Trx 56f97a9d5ddee4a4b010cf171d818c011c269c8f
View Raw JSON Data
{
  "trx_id": "56f97a9d5ddee4a4b010cf171d818c011c269c8f",
  "block": 102865345,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2026-01-23T19:05:51",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "4437.313850 VESTS"
    }
  ]
}
steemdelegated 2.826 SP to @nickg
2024/12/17 14:17:39
delegatorsteem
delegateenickg
vesting shares4601.533047 VESTS
Transaction InfoBlock #91311594/Trx fe073d3177f575dcb715ecf0ab1cc210338240c9
View Raw JSON Data
{
  "trx_id": "fe073d3177f575dcb715ecf0ab1cc210338240c9",
  "block": 91311594,
  "trx_in_block": 8,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2024-12-17T14:17:39",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "4601.533047 VESTS"
    }
  ]
}
steemdelegated 2.930 SP to @nickg
2023/11/14 05:59:18
delegatorsteem
delegateenickg
vesting shares4770.666579 VESTS
Transaction InfoBlock #79865761/Trx 7703d602df5a30715b9c3ec6fc67320e2fd7c29a
View Raw JSON Data
{
  "trx_id": "7703d602df5a30715b9c3ec6fc67320e2fd7c29a",
  "block": 79865761,
  "trx_in_block": 3,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2023-11-14T05:59:18",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "4770.666579 VESTS"
    }
  ]
}
steemdelegated 4.733 SP to @nickg
2023/09/22 08:13:09
delegatorsteem
delegateenickg
vesting shares7707.575365 VESTS
Transaction InfoBlock #78360268/Trx 1ae6b65f8950d03e25926d1b2df546903d3588ab
View Raw JSON Data
{
  "trx_id": "1ae6b65f8950d03e25926d1b2df546903d3588ab",
  "block": 78360268,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2023-09-22T08:13:09",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "7707.575365 VESTS"
    }
  ]
}
steemdelegated 4.870 SP to @nickg
2022/11/03 15:58:15
delegatorsteem
delegateenickg
vesting shares7929.626803 VESTS
Transaction InfoBlock #69118357/Trx 1467c6625923c29410cea58d733f1e620fe9c353
View Raw JSON Data
{
  "trx_id": "1467c6625923c29410cea58d733f1e620fe9c353",
  "block": 69118357,
  "trx_in_block": 3,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-11-03T15:58:15",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "7929.626803 VESTS"
    }
  ]
}
steemdelegated 5.005 SP to @nickg
2022/01/17 21:20:45
delegatorsteem
delegateenickg
vesting shares8149.734404 VESTS
Transaction InfoBlock #60821817/Trx 06ac9d1d8fb72f75237030cbb447dab2bad05310
View Raw JSON Data
{
  "trx_id": "06ac9d1d8fb72f75237030cbb447dab2bad05310",
  "block": 60821817,
  "trx_in_block": 24,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-01-17T21:20:45",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "8149.734404 VESTS"
    }
  ]
}
steemdelegated 5.118 SP to @nickg
2021/06/14 04:36:27
delegatorsteem
delegateenickg
vesting shares8333.928692 VESTS
Transaction InfoBlock #54612244/Trx 2008a9671d9f0e672693b1b62e031212afc839e0
View Raw JSON Data
{
  "trx_id": "2008a9671d9f0e672693b1b62e031212afc839e0",
  "block": 54612244,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-06-14T04:36:27",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "8333.928692 VESTS"
    }
  ]
}
steemdelegated 5.233 SP to @nickg
2020/12/11 14:50:27
delegatorsteem
delegateenickg
vesting shares8521.350666 VESTS
Transaction InfoBlock #49359558/Trx f8d157ce492f803a2a269b911ddd7bf8e9bca1f3
View Raw JSON Data
{
  "trx_id": "f8d157ce492f803a2a269b911ddd7bf8e9bca1f3",
  "block": 49359558,
  "trx_in_block": 3,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2020-12-11T14:50:27",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "8521.350666 VESTS"
    }
  ]
}
steemdelegated 1.174 SP to @nickg
2020/12/06 08:26:45
delegatorsteem
delegateenickg
vesting shares1912.543513 VESTS
Transaction InfoBlock #49211100/Trx eec2e5d14c47e095e9b6bc012a8a2af9857e1cdc
View Raw JSON Data
{
  "trx_id": "eec2e5d14c47e095e9b6bc012a8a2af9857e1cdc",
  "block": 49211100,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2020-12-06T08:26:45",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "1912.543513 VESTS"
    }
  ]
}
steemdelegated 5.237 SP to @nickg
2020/12/05 18:28:06
delegatorsteem
delegateenickg
vesting shares8527.558520 VESTS
Transaction InfoBlock #49194643/Trx 14942593f76e6af1063a723b94e444e371dafa60
View Raw JSON Data
{
  "trx_id": "14942593f76e6af1063a723b94e444e371dafa60",
  "block": 49194643,
  "trx_in_block": 7,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2020-12-05T18:28:06",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "8527.558520 VESTS"
    }
  ]
}
steemdelegated 1.179 SP to @nickg
2020/11/02 23:19:18
delegatorsteem
delegateenickg
vesting shares1920.017158 VESTS
Transaction InfoBlock #48266851/Trx 20d548b55c46660c71d39186abc1d25799e8f8a5
View Raw JSON Data
{
  "trx_id": "20d548b55c46660c71d39186abc1d25799e8f8a5",
  "block": 48266851,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2020-11-02T23:19:18",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "1920.017158 VESTS"
    }
  ]
}
steemdelegated 5.361 SP to @nickg
2020/05/09 09:27:45
delegatorsteem
delegateenickg
vesting shares8730.363879 VESTS
Transaction InfoBlock #43221397/Trx 24b6e0ab105ee76f1cd67c2b9a63dd9208692e67
View Raw JSON Data
{
  "trx_id": "24b6e0ab105ee76f1cd67c2b9a63dd9208692e67",
  "block": 43221397,
  "trx_in_block": 12,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2020-05-09T09:27:45",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "8730.363879 VESTS"
    }
  ]
}
steemdelegated 1.200 SP to @nickg
2020/05/08 13:37:39
delegatorsteem
delegateenickg
vesting shares1953.311140 VESTS
Transaction InfoBlock #43198155/Trx fd291a41320734c9aafd16475b3551f52a5a3373
View Raw JSON Data
{
  "trx_id": "fd291a41320734c9aafd16475b3551f52a5a3373",
  "block": 43198155,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2020-05-08T13:37:39",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "1953.311140 VESTS"
    }
  ]
}
steemdelegated 5.369 SP to @nickg
2020/04/16 02:15:36
delegatorsteem
delegateenickg
vesting shares8743.251327 VESTS
Transaction InfoBlock #42567950/Trx 3314889d9b696aaf6feba887cefd1550fa5bd39f
View Raw JSON Data
{
  "trx_id": "3314889d9b696aaf6feba887cefd1550fa5bd39f",
  "block": 42567950,
  "trx_in_block": 19,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2020-04-16T02:15:36",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "8743.251327 VESTS"
    }
  ]
}
steemdelegated 5.489 SP to @nickg
2019/05/12 19:22:18
delegatorsteem
delegateenickg
vesting shares8938.868140 VESTS
Transaction InfoBlock #32850847/Trx 58623a1ae933c7233e579b41f9e6ef587abc8a1f
View Raw JSON Data
{
  "trx_id": "58623a1ae933c7233e579b41f9e6ef587abc8a1f",
  "block": 32850847,
  "trx_in_block": 25,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2019-05-12T19:22:18",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "8938.868140 VESTS"
    }
  ]
}
steemdelegated 5.612 SP to @nickg
2018/05/16 23:20:39
delegatorsteem
delegateenickg
vesting shares9138.479008 VESTS
Transaction InfoBlock #22493514/Trx dc72fa7c9eed76af5eb464cf43fb669f6cc25224
View Raw JSON Data
{
  "trx_id": "dc72fa7c9eed76af5eb464cf43fb669f6cc25224",
  "block": 22493514,
  "trx_in_block": 11,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-05-16T23:20:39",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "9138.479008 VESTS"
    }
  ]
}
2018/04/15 23:22:42
votertrader3199
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #21601571/Trx cf48c2d56256fec3aa8fb636db5a5ca5ce391da3
View Raw JSON Data
{
  "trx_id": "cf48c2d56256fec3aa8fb636db5a5ca5ce391da3",
  "block": 21601571,
  "trx_in_block": 33,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-04-15T23:22:42",
  "op": [
    "vote",
    {
      "voter": "trader3199",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2018/03/05 01:15:45
voterhasse72
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #20395689/Trx 64dce874a5cdfe8458b543691dd5814a34227f92
View Raw JSON Data
{
  "trx_id": "64dce874a5cdfe8458b543691dd5814a34227f92",
  "block": 20395689,
  "trx_in_block": 89,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-05T01:15:45",
  "op": [
    "vote",
    {
      "voter": "hasse72",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2018/02/17 13:20:21
voteretheogenist
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #19949673/Trx b4641e00253f8b3881a8f421a0b76d3261d715b5
View Raw JSON Data
{
  "trx_id": "b4641e00253f8b3881a8f421a0b76d3261d715b5",
  "block": 19949673,
  "trx_in_block": 56,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-17T13:20:21",
  "op": [
    "vote",
    {
      "voter": "etheogenist",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2018/02/13 00:07:42
voterrajureddy
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #19818748/Trx 32cdac653a56e9a6040685b82d2efd5291fa958e
View Raw JSON Data
{
  "trx_id": "32cdac653a56e9a6040685b82d2efd5291fa958e",
  "block": 19818748,
  "trx_in_block": 31,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-13T00:07:42",
  "op": [
    "vote",
    {
      "voter": "rajureddy",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2018/01/12 12:46:12
voterbelenele
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #18913275/Trx e18611b5f394a5c4fca8920fc8d40635627d1f8e
View Raw JSON Data
{
  "trx_id": "e18611b5f394a5c4fca8920fc8d40635627d1f8e",
  "block": 18913275,
  "trx_in_block": 26,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-01-12T12:46:12",
  "op": [
    "vote",
    {
      "voter": "belenele",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
steemdelegated 18.232 SP to @nickg
2018/01/09 06:43:33
delegatorsteem
delegateenickg
vesting shares29689.506922 VESTS
Transaction InfoBlock #18819667/Trx 252b899e8ad56a5e4e784f047a37c63bc855f230
View Raw JSON Data
{
  "trx_id": "252b899e8ad56a5e4e784f047a37c63bc855f230",
  "block": 18819667,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-01-09T06:43:33",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "29689.506922 VESTS"
    }
  ]
}
2018/01/02 12:27:30
voterflammable71
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #18625102/Trx f020373817230121c8c68a768e83d18d4e022347
View Raw JSON Data
{
  "trx_id": "f020373817230121c8c68a768e83d18d4e022347",
  "block": 18625102,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-01-02T12:27:30",
  "op": [
    "vote",
    {
      "voter": "flammable71",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2018/01/01 03:14:21
voterdoctorv
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #18585471/Trx 83579157e53a4c63a6c745ba875e2cd8c6574e55
View Raw JSON Data
{
  "trx_id": "83579157e53a4c63a6c745ba875e2cd8c6574e55",
  "block": 18585471,
  "trx_in_block": 6,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-01-01T03:14:21",
  "op": [
    "vote",
    {
      "voter": "doctorv",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/12/24 19:29:21
parent authornickg
parent permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
authorcointracking
permlinkre-nickg-re-lukestokes-the-cryptocurrency-bank-spreadsheet-20171224t192919261z
title
bodyI have never been a fan of Spreadsheets for tracking trades as it can become difficult over the time to enter them manually. You should check out [Cointracking Portfolio Manager.](https://steemit.com/cryptocurrency/@gokulnk/best-cryptocurrency-portfolio-manager) It has 1. Automatic import of trades through APIs. 2. Average purchase and sale price reports. 3. Booked and unbooked profits. 4. Ability to calculate your taxes. 5. Set up price notifications. For details of how to use these features checkout [this post](https://steemit.com/cryptocurrency/@gokulnk/best-cryptocurrency-portfolio-manager).
json metadata{"tags":["crypto"],"links":["https://steemit.com/cryptocurrency/@gokulnk/best-cryptocurrency-portfolio-manager"],"app":"steemit/0.1"}
Transaction InfoBlock #18374664/Trx 66422dc143b89fda2262fcec27dc93fcd1121810
View Raw JSON Data
{
  "trx_id": "66422dc143b89fda2262fcec27dc93fcd1121810",
  "block": 18374664,
  "trx_in_block": 9,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-24T19:29:21",
  "op": [
    "comment",
    {
      "parent_author": "nickg",
      "parent_permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "author": "cointracking",
      "permlink": "re-nickg-re-lukestokes-the-cryptocurrency-bank-spreadsheet-20171224t192919261z",
      "title": "",
      "body": "I have never been a fan of Spreadsheets for tracking trades as it can become difficult over the time to enter them manually. You should check out  [Cointracking Portfolio Manager.](https://steemit.com/cryptocurrency/@gokulnk/best-cryptocurrency-portfolio-manager)\n\nIt has \n1. Automatic import of trades through APIs.\n2. Average purchase and sale price reports.\n3. Booked and unbooked profits.\n4. Ability to calculate your taxes. \n5. Set up price notifications.\n\nFor details of how to use these features checkout [this post](https://steemit.com/cryptocurrency/@gokulnk/best-cryptocurrency-portfolio-manager).",
      "json_metadata": "{\"tags\":[\"crypto\"],\"links\":[\"https://steemit.com/cryptocurrency/@gokulnk/best-cryptocurrency-portfolio-manager\"],\"app\":\"steemit/0.1\"}"
    }
  ]
}
2017/12/22 14:47:18
voterhashsecurity
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #18311464/Trx aaf97bf2e173425c86e96d4c29a3e9ad0b9ed108
View Raw JSON Data
{
  "trx_id": "aaf97bf2e173425c86e96d4c29a3e9ad0b9ed108",
  "block": 18311464,
  "trx_in_block": 31,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-22T14:47:18",
  "op": [
    "vote",
    {
      "voter": "hashsecurity",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/12/20 02:57:39
voterframegames
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #18239689/Trx 9ea4d7347ad29188d878f0085a7685cedb3fcf80
View Raw JSON Data
{
  "trx_id": "9ea4d7347ad29188d878f0085a7685cedb3fcf80",
  "block": 18239689,
  "trx_in_block": 19,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-20T02:57:39",
  "op": [
    "vote",
    {
      "voter": "framegames",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/12/16 17:06:03
voterimlocalpro
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #18141470/Trx 8ff6de2e13594b73bdb4cef4864f2dcfe000f55f
View Raw JSON Data
{
  "trx_id": "8ff6de2e13594b73bdb4cef4864f2dcfe000f55f",
  "block": 18141470,
  "trx_in_block": 16,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-16T17:06:03",
  "op": [
    "vote",
    {
      "voter": "imlocalpro",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/12/16 04:17:45
votermeddyboulom
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #18126105/Trx b7ab2fa6752db23b7d49d29ac7d3dc1aa0e43042
View Raw JSON Data
{
  "trx_id": "b7ab2fa6752db23b7d49d29ac7d3dc1aa0e43042",
  "block": 18126105,
  "trx_in_block": 27,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-16T04:17:45",
  "op": [
    "vote",
    {
      "voter": "meddyboulom",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/12/14 15:49:21
votercommonthings
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #18082343/Trx 1ed0406315fc5f4d80bbdbe284a46373bc5d19f1
View Raw JSON Data
{
  "trx_id": "1ed0406315fc5f4d80bbdbe284a46373bc5d19f1",
  "block": 18082343,
  "trx_in_block": 6,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-14T15:49:21",
  "op": [
    "vote",
    {
      "voter": "commonthings",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/12/09 19:58:15
voterbitgod
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #17943372/Trx 9afe803e7dd888923b34341c928f37124c1b8755
View Raw JSON Data
{
  "trx_id": "9afe803e7dd888923b34341c928f37124c1b8755",
  "block": 17943372,
  "trx_in_block": 23,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-09T19:58:15",
  "op": [
    "vote",
    {
      "voter": "bitgod",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/11/20 12:13:15
voteraka-alias
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #17387161/Trx 3a51b426dd51ffff8c0f5f042962e3e51bc13d9f
View Raw JSON Data
{
  "trx_id": "3a51b426dd51ffff8c0f5f042962e3e51bc13d9f",
  "block": 17387161,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-11-20T12:13:15",
  "op": [
    "vote",
    {
      "voter": "aka-alias",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/10/30 06:34:30
voterfurphy
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #16775847/Trx 9e1822fcde77487843ba04012c4de733c20e9f41
View Raw JSON Data
{
  "trx_id": "9e1822fcde77487843ba04012c4de733c20e9f41",
  "block": 16775847,
  "trx_in_block": 3,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-10-30T06:34:30",
  "op": [
    "vote",
    {
      "voter": "furphy",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/09/30 18:21:54
required auths[]
required posting auths["nickg"]
idfollow
json["follow",{"follower":"nickg","following":"boxmining","what":["blog"]}]
Transaction InfoBlock #15926907/Trx 9bd93319ecc07043d3d378f323223cfe36fec163
View Raw JSON Data
{
  "trx_id": "9bd93319ecc07043d3d378f323223cfe36fec163",
  "block": 15926907,
  "trx_in_block": 8,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-09-30T18:21:54",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "nickg"
      ],
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"nickg\",\"following\":\"boxmining\",\"what\":[\"blog\"]}]"
    }
  ]
}
2017/09/20 22:37:51
voterfelpsworld
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #15644103/Trx de5baf0375f65daf280082e5f8d7db2af45cbaaf
View Raw JSON Data
{
  "trx_id": "de5baf0375f65daf280082e5f8d7db2af45cbaaf",
  "block": 15644103,
  "trx_in_block": 9,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-09-20T22:37:51",
  "op": [
    "vote",
    {
      "voter": "felpsworld",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/09/10 02:33:42
voterilwill101
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #15332184/Trx 5efb1b11d8e744e820e416909ff7007e75e1a769
View Raw JSON Data
{
  "trx_id": "5efb1b11d8e744e820e416909ff7007e75e1a769",
  "block": 15332184,
  "trx_in_block": 16,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-09-10T02:33:42",
  "op": [
    "vote",
    {
      "voter": "ilwill101",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/09/03 12:23:42
parent authornickg
parent permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
authorcryptoblock
permlinkre-nickg-re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170903t122343054z
title
bodywow so nice both! very usefull!! just upvoting you ;)
json metadata{"tags":["crypto"],"app":"steemit/0.1"}
Transaction InfoBlock #15142440/Trx ed66c5cb781999873722831fdcd21c8b65c42070
View Raw JSON Data
{
  "trx_id": "ed66c5cb781999873722831fdcd21c8b65c42070",
  "block": 15142440,
  "trx_in_block": 17,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-09-03T12:23:42",
  "op": [
    "comment",
    {
      "parent_author": "nickg",
      "parent_permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "author": "cryptoblock",
      "permlink": "re-nickg-re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170903t122343054z",
      "title": "",
      "body": "wow so nice both! very usefull!! just upvoting you ;)",
      "json_metadata": "{\"tags\":[\"crypto\"],\"app\":\"steemit/0.1\"}"
    }
  ]
}
2017/09/03 12:23:18
votercryptoblock
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #15142432/Trx 7037c8d6795d3c71c27ac0c80f9f262eb363b1b5
View Raw JSON Data
{
  "trx_id": "7037c8d6795d3c71c27ac0c80f9f262eb363b1b5",
  "block": 15142432,
  "trx_in_block": 6,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-09-03T12:23:18",
  "op": [
    "vote",
    {
      "voter": "cryptoblock",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/08/30 05:28:12
voternalgene
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #15019047/Trx 11f0a6cf3935208241316feb095d578accc471eb
View Raw JSON Data
{
  "trx_id": "11f0a6cf3935208241316feb095d578accc471eb",
  "block": 15019047,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-08-30T05:28:12",
  "op": [
    "vote",
    {
      "voter": "nalgene",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/08/20 07:51:54
voterunome
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #14734040/Trx 0c919a82a676132af2f4bc2bfd827f0fa1071a86
View Raw JSON Data
{
  "trx_id": "0c919a82a676132af2f4bc2bfd827f0fa1071a86",
  "block": 14734040,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-08-20T07:51:54",
  "op": [
    "vote",
    {
      "voter": "unome",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/08/12 18:59:51
voterkeithkch
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #14517845/Trx 081e907aed4fbbb1dbe4200a28e92e98a7027990
View Raw JSON Data
{
  "trx_id": "081e907aed4fbbb1dbe4200a28e92e98a7027990",
  "block": 14517845,
  "trx_in_block": 26,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-08-12T18:59:51",
  "op": [
    "vote",
    {
      "voter": "keithkch",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/07/26 16:06:18
voterpersephonept
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #14025353/Trx 89e00b87a97b5d4d3ccb6a49600791bed691e2e3
View Raw JSON Data
{
  "trx_id": "89e00b87a97b5d4d3ccb6a49600791bed691e2e3",
  "block": 14025353,
  "trx_in_block": 6,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-07-26T16:06:18",
  "op": [
    "vote",
    {
      "voter": "persephonept",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/07/24 11:42:24
votermatt-st
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #13962504/Trx b9595aac6d9be091aa74d783732a8721c86b3017
View Raw JSON Data
{
  "trx_id": "b9595aac6d9be091aa74d783732a8721c86b3017",
  "block": 13962504,
  "trx_in_block": 13,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-07-24T11:42:24",
  "op": [
    "vote",
    {
      "voter": "matt-st",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/07/08 12:35:33
voterishah
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #13503248/Trx b23c8a7bc53ab828b63d6871f114b632809861c1
View Raw JSON Data
{
  "trx_id": "b23c8a7bc53ab828b63d6871f114b632809861c1",
  "block": 13503248,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-07-08T12:35:33",
  "op": [
    "vote",
    {
      "voter": "ishah",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/06/28 17:39:42
parent authornickg
parent permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
authorzackcovell
permlinkre-nickg-re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170628t173913461z
title
bodyHello @nickg & @lukestokes after searching online for hours last night for a LIVE Cryptocurrency Spreadsheet and finding the one made by Pablo Yabo in March 2017 I realized that his spreadsheet wasn't at all what I am looking for. *So I figured I'd solve the problem for the Steemit Community myself.* I'm now building out a LIVE @CoinMarketCap Spreadsheet that we can use for daily snapshots of all 100 Cryptocurrencies. **The spreadsheet automatically refreshes every 5 minutes!** When I'm done I'll invite each of you so you can use it how you wish, or we can track certain digi-currencies together. _______ I'm Using the =CRYPTOFINANCE call within the document I'll show you how to build your own with an upcoming Steemit post in a few days. =CRYPTOFINANCE("XXXYYY", "marketcap") =CRYPTOFINANCE("XXXYYY") =CRYPTOFINANCE("XXXYYY", "total_supply") =CRYPTOFINANCE("XXXYYY", "volume") =CRYPTOFINANCE("XXX", "change", "1h") =CRYPTOFINANCE("XXX", "change", "24h") =CRYPTOFINANCE("XXX", "change", "7d") XXX is the coin, e.g. BTC YYY is the fiat money, e.g. USD _______ Also see: [How to get crypto-currencies rates and more in Google Sheets](https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14) [Live Updated Cryptocurrency Investment Tracking Spreadsheet (Update 2)](https://blog.coinfabrik.com/live-cryptocurrency-investment-tracking-history/) # What other ideas can we come up with to make this Spreadsheet more AWESOME??? ***NOTE: the #ERROR in certain cells is because the Cryptocurrency has to be only 3 characters, but some are more, for example; DASH has 4 letters so certain cells cannot go live. ## Here's a sneek peek of the Live CoinMarketCap Spreadsheet: <a href="https://s3-us-west-1.amazonaws.com/cryptocurrency-steemit/LIVE+CoinMarketCap+Spreadsheet.jpg"><img src="https://s3-us-west-1.amazonaws.com/cryptocurrency-steemit/LIVE+CoinMarketCap+Spreadsheet.jpg"/></a>
json metadata{"tags":["error","crypto"],"users":["nickg","lukestokes","coinmarketcap"],"image":["https://s3-us-west-1.amazonaws.com/cryptocurrency-steemit/LIVE+CoinMarketCap+Spreadsheet.jpg"],"links":["https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14","https://blog.coinfabrik.com/live-cryptocurrency-investment-tracking-history/","https://s3-us-west-1.amazonaws.com/cryptocurrency-steemit/LIVE+CoinMarketCap+Spreadsheet.jpg"],"app":"steemit/0.1"}
Transaction InfoBlock #13221956/Trx 7836275ee09e3d4b318faa9fff17340878329eb1
View Raw JSON Data
{
  "trx_id": "7836275ee09e3d4b318faa9fff17340878329eb1",
  "block": 13221956,
  "trx_in_block": 3,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-06-28T17:39:42",
  "op": [
    "comment",
    {
      "parent_author": "nickg",
      "parent_permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "author": "zackcovell",
      "permlink": "re-nickg-re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170628t173913461z",
      "title": "",
      "body": "Hello @nickg & @lukestokes after searching online for hours last night for a LIVE Cryptocurrency Spreadsheet and finding the one made by Pablo Yabo in March 2017 I realized that his spreadsheet wasn't at all what I am looking for. \n\n*So I figured I'd solve the problem for the Steemit Community myself.*\n\nI'm now building out a LIVE @CoinMarketCap Spreadsheet that we can use for daily snapshots of all 100 Cryptocurrencies. \n\n**The spreadsheet automatically refreshes  every 5 minutes!**\n\nWhen I'm done I'll invite each of you so you can use it how you wish, or we can track certain digi-currencies together.\n_______\nI'm Using the =CRYPTOFINANCE call within the document I'll show you how to build your own with an upcoming Steemit post in a few days.\n\n=CRYPTOFINANCE(\"XXXYYY\", \"marketcap\")\n=CRYPTOFINANCE(\"XXXYYY\")\n=CRYPTOFINANCE(\"XXXYYY\", \"total_supply\")\n=CRYPTOFINANCE(\"XXXYYY\", \"volume\")\n=CRYPTOFINANCE(\"XXX\", \"change\", \"1h\")\n=CRYPTOFINANCE(\"XXX\", \"change\", \"24h\")\n=CRYPTOFINANCE(\"XXX\", \"change\", \"7d\")\nXXX is the coin, e.g. BTC\nYYY is the fiat money, e.g. USD\n_______\n\nAlso see: \n[How to get crypto-currencies rates and more in Google Sheets](https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14)\n[Live Updated Cryptocurrency Investment Tracking Spreadsheet (Update 2)](https://blog.coinfabrik.com/live-cryptocurrency-investment-tracking-history/)\n\n# What other ideas can we come up with to make this Spreadsheet more AWESOME???\n***NOTE: the #ERROR in certain cells is because the Cryptocurrency has to be only 3 characters, but some are more, for example; DASH has 4 letters so certain cells cannot go live.\n\n## Here's a sneek peek of the Live CoinMarketCap Spreadsheet:\n\n<a href=\"https://s3-us-west-1.amazonaws.com/cryptocurrency-steemit/LIVE+CoinMarketCap+Spreadsheet.jpg\"><img src=\"https://s3-us-west-1.amazonaws.com/cryptocurrency-steemit/LIVE+CoinMarketCap+Spreadsheet.jpg\"/></a>",
      "json_metadata": "{\"tags\":[\"error\",\"crypto\"],\"users\":[\"nickg\",\"lukestokes\",\"coinmarketcap\"],\"image\":[\"https://s3-us-west-1.amazonaws.com/cryptocurrency-steemit/LIVE+CoinMarketCap+Spreadsheet.jpg\"],\"links\":[\"https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14\",\"https://blog.coinfabrik.com/live-cryptocurrency-investment-tracking-history/\",\"https://s3-us-west-1.amazonaws.com/cryptocurrency-steemit/LIVE+CoinMarketCap+Spreadsheet.jpg\"],\"app\":\"steemit/0.1\"}"
    }
  ]
}
2017/06/28 05:40:39
parent authornickg
parent permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
authorzackcovell
permlinkre-nickg-re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170628t054034758z
title
bodyYaY!
json metadata{"tags":["crypto"],"app":"steemit/0.1"}
Transaction InfoBlock #13207807/Trx 35352f3cbf59f10e0badb2e626a15731a07218d4
View Raw JSON Data
{
  "trx_id": "35352f3cbf59f10e0badb2e626a15731a07218d4",
  "block": 13207807,
  "trx_in_block": 12,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-06-28T05:40:39",
  "op": [
    "comment",
    {
      "parent_author": "nickg",
      "parent_permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "author": "zackcovell",
      "permlink": "re-nickg-re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170628t054034758z",
      "title": "",
      "body": "YaY!",
      "json_metadata": "{\"tags\":[\"crypto\"],\"app\":\"steemit/0.1\"}"
    }
  ]
}
2017/06/28 05:40:24
voterzackcovell
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #13207802/Trx 481c4e61b28b0df23d012f3656435d1d1f53b554
View Raw JSON Data
{
  "trx_id": "481c4e61b28b0df23d012f3656435d1d1f53b554",
  "block": 13207802,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-06-28T05:40:24",
  "op": [
    "vote",
    {
      "voter": "zackcovell",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/06/24 06:18:42
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
sbd payout8.247 SBD
steem payout0.000 STEEM
vesting payout7924.462962 VESTS
Transaction InfoBlock #13093470/Virtual Operation #10
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 13093470,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 10,
  "timestamp": "2017-06-24T06:18:42",
  "op": [
    "author_reward",
    {
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "sbd_payout": "8.247 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "7924.462962 VESTS"
    }
  ]
}
2017/06/17 15:03:36
voterenki
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight1000 (10.00%)
Transaction InfoBlock #12902734/Trx 288c474b1adc46daae5e6e6a3048c7154219d064
View Raw JSON Data
{
  "trx_id": "288c474b1adc46daae5e6e6a3048c7154219d064",
  "block": 12902734,
  "trx_in_block": 10,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-06-17T15:03:36",
  "op": [
    "vote",
    {
      "voter": "enki",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 1000
    }
  ]
}
2017/06/17 15:03:33
voteralbertogm
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #12902733/Trx 904b9ac445538f39ec74738873c10da1d8f95ea6
View Raw JSON Data
{
  "trx_id": "904b9ac445538f39ec74738873c10da1d8f95ea6",
  "block": 12902733,
  "trx_in_block": 20,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-06-17T15:03:33",
  "op": [
    "vote",
    {
      "voter": "albertogm",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/06/17 15:03:33
votershahzadnisar
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #12902733/Trx e5daaf6a3cc243cf4e10559929f05436453cc903
View Raw JSON Data
{
  "trx_id": "e5daaf6a3cc243cf4e10559929f05436453cc903",
  "block": 12902733,
  "trx_in_block": 14,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-06-17T15:03:33",
  "op": [
    "vote",
    {
      "voter": "shahzadnisar",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/06/17 15:03:33
voteripumba
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #12902733/Trx 6947bf881ccb787e3844181c31dfcae822666377
View Raw JSON Data
{
  "trx_id": "6947bf881ccb787e3844181c31dfcae822666377",
  "block": 12902733,
  "trx_in_block": 8,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-06-17T15:03:33",
  "op": [
    "vote",
    {
      "voter": "ipumba",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/06/17 15:02:21
parent authornickg
parent permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
authorlukestokes
permlinkre-nickg-re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t150220180z
title
bodyVery cool! The last time I looked around there wasn't one which had all the new currencies. I'll check it out.
json metadata{"tags":["crypto"],"app":"steemit/0.1"}
Transaction InfoBlock #12902709/Trx 406f110fc0a899822bfc66df09a5dd4cf935a6c8
View Raw JSON Data
{
  "trx_id": "406f110fc0a899822bfc66df09a5dd4cf935a6c8",
  "block": 12902709,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-06-17T15:02:21",
  "op": [
    "comment",
    {
      "parent_author": "nickg",
      "parent_permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "author": "lukestokes",
      "permlink": "re-nickg-re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t150220180z",
      "title": "",
      "body": "Very cool! The last time I looked around there wasn't one which had all the new currencies. I'll check it out.",
      "json_metadata": "{\"tags\":[\"crypto\"],\"app\":\"steemit/0.1\"}"
    }
  ]
}
2017/06/17 15:01:54
voterlukestokes
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
weight10000 (100.00%)
Transaction InfoBlock #12902700/Trx 5e72384c0befae1a7157e212955ae2c333cf6948
View Raw JSON Data
{
  "trx_id": "5e72384c0befae1a7157e212955ae2c333cf6948",
  "block": 12902700,
  "trx_in_block": 8,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-06-17T15:01:54",
  "op": [
    "vote",
    {
      "voter": "lukestokes",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "weight": 10000
    }
  ]
}
2017/06/17 06:18:42
parent authorlukestokes
parent permlinkthe-cryptocurrency-bank-spreadsheet
authornickg
permlinkre-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z
title
bodyGreat tool! Maybe a bit late to the discussion, but I had been looking for the best way to do this for a while now. And even though this works perfectly I might found something easier which doesn't need you to do 'vlookup' etc. This guy; https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14 made an add-on which allows you to pull the rates directly from Coinmarketcap and different exchanges like Kraken. Made it a lot easier for me so I thought I should share..
json metadata{"tags":["crypto"],"links":["https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14"],"app":"steemit/0.1"}
Transaction InfoBlock #12892241/Trx 86a90f56d3feeea409c714729a7b802e25e3aa52
View Raw JSON Data
{
  "trx_id": "86a90f56d3feeea409c714729a7b802e25e3aa52",
  "block": 12892241,
  "trx_in_block": 16,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-06-17T06:18:42",
  "op": [
    "comment",
    {
      "parent_author": "lukestokes",
      "parent_permlink": "the-cryptocurrency-bank-spreadsheet",
      "author": "nickg",
      "permlink": "re-lukestokes-the-cryptocurrency-bank-spreadsheet-20170617t061842782z",
      "title": "",
      "body": "Great tool! \n\nMaybe a bit late to the discussion, but I had been looking for the best way to do this for a while now. And even though this works perfectly I might found something easier which doesn't need you to do 'vlookup' etc. \n\nThis guy; https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14 made  an add-on which allows you to pull the rates directly from Coinmarketcap and different exchanges like Kraken. Made it a lot easier for me so I thought I should share..",
      "json_metadata": "{\"tags\":[\"crypto\"],\"links\":[\"https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14\"],\"app\":\"steemit/0.1\"}"
    }
  ]
}
steemdelegated 18.442 SP to @nickg
2017/06/12 16:23:39
delegatorsteem
delegateenickg
vesting shares30031.317630 VESTS
Transaction InfoBlock #12760440/Trx 6c06fa4b04939b95e968de6d26407af83f83f01e
View Raw JSON Data
{
  "trx_id": "6c06fa4b04939b95e968de6d26407af83f83f01e",
  "block": 12760440,
  "trx_in_block": 13,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-06-12T16:23:39",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "30031.317630 VESTS"
    }
  ]
}
steemdelegated 5.724 SP to @nickg
2017/06/08 22:40:27
delegatorsteem
delegateenickg
vesting shares9320.317630 VESTS
Transaction InfoBlock #12652842/Trx 5830561b491ab8f7987aea7cbaae3535f47a8f17
View Raw JSON Data
{
  "trx_id": "5830561b491ab8f7987aea7cbaae3535f47a8f17",
  "block": 12652842,
  "trx_in_block": 9,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-06-08T22:40:27",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "nickg",
      "vesting_shares": "9320.317630 VESTS"
    }
  ]
}
steemcreated a new account: @nickg
2017/06/08 05:55:15
fee0.500 STEEM
delegation57000.000000 VESTS
creatorsteem
new account namenickg
owner{"weight_threshold":1,"account_auths":[],"key_auths":[["STM6jumkTWMtonS2h4mTFb45itGgmvFaZvR2y7VPN3gGicgh28CVA",1]]}
active{"weight_threshold":1,"account_auths":[],"key_auths":[["STM6KUpcc6bkzTa68ND4NYnLgqTB5RKTa7V8JRrM9TvvsrNLNe4rQ",1]]}
posting{"weight_threshold":1,"account_auths":[],"key_auths":[["STM7GWHdzMucfTkoiPiGhkbGwdLqJEcVGtNp3SqzNA1FBVQ9miqps",1]]}
memo keySTM8GCvT728U47ugThCfrdSpMMLYCatirxTdmEiX4a7MSgzD2bTnJ
json metadata
extensions[]
Transaction InfoBlock #12632763/Trx 95c07a479af40fb4e687c511a251e202bc4ea720
View Raw JSON Data
{
  "trx_id": "95c07a479af40fb4e687c511a251e202bc4ea720",
  "block": 12632763,
  "trx_in_block": 3,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-06-08T05:55:15",
  "op": [
    "account_create_with_delegation",
    {
      "fee": "0.500 STEEM",
      "delegation": "57000.000000 VESTS",
      "creator": "steem",
      "new_account_name": "nickg",
      "owner": {
        "weight_threshold": 1,
        "account_auths": [],
        "key_auths": [
          [
            "STM6jumkTWMtonS2h4mTFb45itGgmvFaZvR2y7VPN3gGicgh28CVA",
            1
          ]
        ]
      },
      "active": {
        "weight_threshold": 1,
        "account_auths": [],
        "key_auths": [
          [
            "STM6KUpcc6bkzTa68ND4NYnLgqTB5RKTa7V8JRrM9TvvsrNLNe4rQ",
            1
          ]
        ]
      },
      "posting": {
        "weight_threshold": 1,
        "account_auths": [],
        "key_auths": [
          [
            "STM7GWHdzMucfTkoiPiGhkbGwdLqJEcVGtNp3SqzNA1FBVQ9miqps",
            1
          ]
        ]
      },
      "memo_key": "STM8GCvT728U47ugThCfrdSpMMLYCatirxTdmEiX4a7MSgzD2bTnJ",
      "json_metadata": "",
      "extensions": []
    }
  ]
}

Account Metadata

POSTING JSON METADATA
None
JSON METADATA
None
{
  "posting_json_metadata": {},
  "json_metadata": {}
}

Auth Keys

Owner
Single Signature
Public Keys
STM6jumkTWMtonS2h4mTFb45itGgmvFaZvR2y7VPN3gGicgh28CVA1/1
Active
Single Signature
Public Keys
STM6KUpcc6bkzTa68ND4NYnLgqTB5RKTa7V8JRrM9TvvsrNLNe4rQ1/1
Posting
Single Signature
Public Keys
STM7GWHdzMucfTkoiPiGhkbGwdLqJEcVGtNp3SqzNA1FBVQ9miqps1/1
Memo
STM8GCvT728U47ugThCfrdSpMMLYCatirxTdmEiX4a7MSgzD2bTnJ
{
  "owner": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM6jumkTWMtonS2h4mTFb45itGgmvFaZvR2y7VPN3gGicgh28CVA",
        1
      ]
    ]
  },
  "active": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM6KUpcc6bkzTa68ND4NYnLgqTB5RKTa7V8JRrM9TvvsrNLNe4rQ",
        1
      ]
    ]
  },
  "posting": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM7GWHdzMucfTkoiPiGhkbGwdLqJEcVGtNp3SqzNA1FBVQ9miqps",
        1
      ]
    ]
  },
  "memo": "STM8GCvT728U47ugThCfrdSpMMLYCatirxTdmEiX4a7MSgzD2bTnJ"
}

Witness Votes

0 / 30
No active witness votes.
[]