Ecoer Logo
VOTING POWER100.00%
DOWNVOTE POWER100.00%
RESOURCE CREDITS100.00%
REPUTATION PROGRESS0.00%
Net Worth
0.007USD
STEEM
0.000STEEM
SBD
0.000SBD
Effective Power
5.007SP
├── Own SP
0.125SP
└── Incoming Deleg
+4.882SP

Detailed Balance

STEEM
balance
0.000STEEM
market_balance
0.000STEEM
savings_balance
0.000STEEM
reward_steem_balance
0.000STEEM
STEEM POWER
Own SP
0.125SP
Delegated Out
0.000SP
Delegation In
4.882SP
Effective Power
5.007SP
Reward SP (pending)
0.000SP
SBD
sbd_balance
0.000SBD
sbd_conversions
0.000SBD
sbd_market_balance
0.000SBD
savings_sbd_balance
0.000SBD
reward_sbd_balance
0.000SBD
{
  "balance": "0.000 STEEM",
  "savings_balance": "0.000 STEEM",
  "reward_steem_balance": "0.000 STEEM",
  "vesting_shares": "203.951927 VESTS",
  "delegated_vesting_shares": "0.000000 VESTS",
  "received_vesting_shares": "7939.707879 VESTS",
  "sbd_balance": "0.000 SBD",
  "savings_sbd_balance": "0.000 SBD",
  "reward_sbd_balance": "0.000 SBD",
  "conversions": []
}

Account Info

namemirio
id912403
rank1,455,592
reputation40856583
created2018-04-02T18:31:24
recovery_accountsteem
proxyNone
post_count3
comment_count0
lifetime_vote_count0
witnesses_voted_for0
last_post2018-04-06T05:57:03
last_root_post2018-04-06T05:57:03
last_vote_time2018-04-08T17:07:18
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_shares203.951927 VESTS
delegated_vesting_shares0.000000 VESTS
received_vesting_shares7939.707879 VESTS
reward_vesting_balance0.000000 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
{
  "active": {
    "account_auths": [],
    "key_auths": [
      [
        "STM684Kin4Lh1moLDVXgP2fNy5de2vtHdFPGB46s7stgNAhMZU6Ta",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "balance": "0.000 STEEM",
  "can_vote": true,
  "comment_count": 0,
  "created": "2018-04-02T18:31:24",
  "curation_rewards": 0,
  "delegated_vesting_shares": "0.000000 VESTS",
  "downvote_manabar": {
    "current_mana": 2035914951,
    "last_update_time": 1779076284
  },
  "guest_bloggers": [],
  "id": 912403,
  "json_metadata": "{}",
  "last_account_recovery": "1970-01-01T00:00:00",
  "last_account_update": "1970-01-01T00:00:00",
  "last_owner_update": "1970-01-01T00:00:00",
  "last_post": "2018-04-06T05:57:03",
  "last_root_post": "2018-04-06T05:57:03",
  "last_vote_time": "2018-04-08T17:07:18",
  "lifetime_vote_count": 0,
  "market_history": [],
  "memo_key": "STM7EMAJvjZXWAmZBCi6pDJ1CtQ1DA6bBMARarjeL57xWHSGeUgnJ",
  "mined": false,
  "name": "mirio",
  "next_vesting_withdrawal": "1969-12-31T23:59:59",
  "other_history": [],
  "owner": {
    "account_auths": [],
    "key_auths": [
      [
        "STM6DyUV9BLkSw4wTLNx6mBjU3WUcXp3H1PqwBj6DG9Jjp3fVPykY",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "pending_claimed_accounts": 0,
  "post_bandwidth": 0,
  "post_count": 3,
  "post_history": [],
  "posting": {
    "account_auths": [],
    "key_auths": [
      [
        "STM5rieH4u1QGstCvsoo4d85rwQdgevC5HeqJTByLsBv26XKPmtPo",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "posting_json_metadata": "",
  "posting_rewards": 0,
  "proxied_vsf_votes": [
    0,
    0,
    0,
    0
  ],
  "proxy": "",
  "received_vesting_shares": "7939.707879 VESTS",
  "recovery_account": "steem",
  "reputation": 40856583,
  "reset_account": "null",
  "reward_sbd_balance": "0.000 SBD",
  "reward_steem_balance": "0.000 STEEM",
  "reward_vesting_balance": "0.000000 VESTS",
  "reward_vesting_steem": "0.000 STEEM",
  "savings_balance": "0.000 STEEM",
  "savings_sbd_balance": "0.000 SBD",
  "savings_sbd_last_interest_payment": "1970-01-01T00:00:00",
  "savings_sbd_seconds": "0",
  "savings_sbd_seconds_last_update": "1970-01-01T00:00:00",
  "savings_withdraw_requests": 0,
  "sbd_balance": "0.000 SBD",
  "sbd_last_interest_payment": "1970-01-01T00:00:00",
  "sbd_seconds": "0",
  "sbd_seconds_last_update": "1970-01-01T00:00:00",
  "tags_usage": [],
  "to_withdraw": 0,
  "transfer_history": [],
  "vesting_balance": "0.000 STEEM",
  "vesting_shares": "203.951927 VESTS",
  "vesting_withdraw_rate": "0.000000 VESTS",
  "vote_history": [],
  "voting_manabar": {
    "current_mana": "8143659806",
    "last_update_time": 1779076284
  },
  "voting_power": 0,
  "withdraw_routes": 0,
  "withdrawn": 0,
  "witness_votes": [],
  "witnesses_voted_for": 0,
  "rank": 1455592
}

Withdraw Routes

IncomingOutgoing
Empty
Empty
{
  "incoming": [],
  "outgoing": []
}
From Date
To Date
steemdelegated 4.882 SP to @mirio
2026/05/18 03:51:24
delegateemirio
delegatorsteem
vesting shares7939.707879 VESTS
Transaction InfoBlock #106147751/Trx b579c8a74d99c619b952810a364c85323e486d39
View Raw JSON Data
{
  "block": 106147751,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "7939.707879 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-05-18T03:51:24",
  "trx_id": "b579c8a74d99c619b952810a364c85323e486d39",
  "trx_in_block": 4,
  "virtual_op": 0
}
steemdelegated 3.214 SP to @mirio
2026/05/12 18:26:27
delegateemirio
delegatorsteem
vesting shares5227.497474 VESTS
Transaction InfoBlock #105993192/Trx 3ec1ac5da5638cc20e95ee2421e3ffdcb6e67b9e
View Raw JSON Data
{
  "block": 105993192,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "5227.497474 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-05-12T18:26:27",
  "trx_id": "3ec1ac5da5638cc20e95ee2421e3ffdcb6e67b9e",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 4.890 SP to @mirio
2026/04/26 03:06:39
delegateemirio
delegatorsteem
vesting shares7952.223635 VESTS
Transaction InfoBlock #105515301/Trx fd94e655256f10c07c035759cbc3420234640211
View Raw JSON Data
{
  "block": 105515301,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "7952.223635 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-04-26T03:06:39",
  "trx_id": "fd94e655256f10c07c035759cbc3420234640211",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 3.240 SP to @mirio
2026/01/23 17:28:15
delegateemirio
delegatorsteem
vesting shares5269.044293 VESTS
Transaction InfoBlock #102863398/Trx df13d0554ef6cd63029b10dcd280f16b216b8610
View Raw JSON Data
{
  "block": 102863398,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "5269.044293 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-01-23T17:28:15",
  "trx_id": "df13d0554ef6cd63029b10dcd280f16b216b8610",
  "trx_in_block": 2,
  "virtual_op": 0
}
steemdelegated 3.341 SP to @mirio
2024/12/17 12:40:48
delegateemirio
delegatorsteem
vesting shares5433.263490 VESTS
Transaction InfoBlock #91309660/Trx 18597d5c8736b06c2a68be0bc80b359014de2b22
View Raw JSON Data
{
  "block": 91309660,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "5433.263490 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2024-12-17T12:40:48",
  "trx_id": "18597d5c8736b06c2a68be0bc80b359014de2b22",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 3.445 SP to @mirio
2023/11/14 04:22:27
delegateemirio
delegatorsteem
vesting shares5602.397022 VESTS
Transaction InfoBlock #79863831/Trx d704ac74e65dbf58cc89d9244498947593365a30
View Raw JSON Data
{
  "block": 79863831,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "5602.397022 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2023-11-14T04:22:27",
  "trx_id": "d704ac74e65dbf58cc89d9244498947593365a30",
  "trx_in_block": 1,
  "virtual_op": 0
}
steemdelegated 5.251 SP to @mirio
2023/09/22 07:30:30
delegateemirio
delegatorsteem
vesting shares8539.305808 VESTS
Transaction InfoBlock #78359416/Trx 7b8f3f276a062a57a93da3ddcdd9463da03e33be
View Raw JSON Data
{
  "block": 78359416,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "8539.305808 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2023-09-22T07:30:30",
  "trx_id": "7b8f3f276a062a57a93da3ddcdd9463da03e33be",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 5.387 SP to @mirio
2022/11/03 15:20:36
delegateemirio
delegatorsteem
vesting shares8761.357246 VESTS
Transaction InfoBlock #69117607/Trx 919afbe63235563e42d4b1c1946973e33fed3e8a
View Raw JSON Data
{
  "block": 69117607,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "8761.357246 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-11-03T15:20:36",
  "trx_id": "919afbe63235563e42d4b1c1946973e33fed3e8a",
  "trx_in_block": 2,
  "virtual_op": 0
}
steemdelegated 5.522 SP to @mirio
2022/01/17 20:46:51
delegateemirio
delegatorsteem
vesting shares8981.464847 VESTS
Transaction InfoBlock #60821142/Trx ac26a8a22a3cb82fe766141a704144861ca508f5
View Raw JSON Data
{
  "block": 60821142,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "8981.464847 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-01-17T20:46:51",
  "trx_id": "ac26a8a22a3cb82fe766141a704144861ca508f5",
  "trx_in_block": 2,
  "virtual_op": 0
}
steemdelegated 5.636 SP to @mirio
2021/06/14 04:04:06
delegateemirio
delegatorsteem
vesting shares9165.659135 VESTS
Transaction InfoBlock #54611604/Trx 023e8197b2ec4ee8295acc25d3ed3b9c24848eef
View Raw JSON Data
{
  "block": 54611604,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "9165.659135 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-06-14T04:04:06",
  "trx_id": "023e8197b2ec4ee8295acc25d3ed3b9c24848eef",
  "trx_in_block": 2,
  "virtual_op": 0
}
steemdelegated 5.751 SP to @mirio
2020/12/11 14:18:48
delegateemirio
delegatorsteem
vesting shares9353.081109 VESTS
Transaction InfoBlock #49358939/Trx f44766a0cb0c4ab7d9c9391d3dacebdd35832c0c
View Raw JSON Data
{
  "block": 49358939,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "9353.081109 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-11T14:18:48",
  "trx_id": "f44766a0cb0c4ab7d9c9391d3dacebdd35832c0c",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 1.176 SP to @mirio
2020/12/06 07:54:45
delegateemirio
delegatorsteem
vesting shares1912.543513 VESTS
Transaction InfoBlock #49210470/Trx 06308c2c74d54a77eb0ec281f1048812400a9d12
View Raw JSON Data
{
  "block": 49210470,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "1912.543513 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-06T07:54:45",
  "trx_id": "06308c2c74d54a77eb0ec281f1048812400a9d12",
  "trx_in_block": 2,
  "virtual_op": 0
}
steemdelegated 5.755 SP to @mirio
2020/12/05 17:56:30
delegateemirio
delegatorsteem
vesting shares9359.288963 VESTS
Transaction InfoBlock #49194022/Trx 68d1c8af4d547c8c4fcbf39ceb48555977394c18
View Raw JSON Data
{
  "block": 49194022,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "9359.288963 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-05T17:56:30",
  "trx_id": "68d1c8af4d547c8c4fcbf39ceb48555977394c18",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 1.181 SP to @mirio
2020/11/02 22:14:45
delegateemirio
delegatorsteem
vesting shares1920.017158 VESTS
Transaction InfoBlock #48265583/Trx c22cefb2291640e2ec0da6634aa2d0ef6ae95319
View Raw JSON Data
{
  "block": 48265583,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "1920.017158 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-11-02T22:14:45",
  "trx_id": "c22cefb2291640e2ec0da6634aa2d0ef6ae95319",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 5.879 SP to @mirio
2020/05/09 08:55:45
delegateemirio
delegatorsteem
vesting shares9562.094322 VESTS
Transaction InfoBlock #43220772/Trx 77aecf5279c66d7d2819de731f89788c47941834
View Raw JSON Data
{
  "block": 43220772,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "9562.094322 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-05-09T08:55:45",
  "trx_id": "77aecf5279c66d7d2819de731f89788c47941834",
  "trx_in_block": 2,
  "virtual_op": 0
}
steemdelegated 1.201 SP to @mirio
2020/05/08 13:01:00
delegateemirio
delegatorsteem
vesting shares1953.311140 VESTS
Transaction InfoBlock #43197441/Trx d8fe7131bca772c27a65d1fb03388d535b033973
View Raw JSON Data
{
  "block": 43197441,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "1953.311140 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-05-08T13:01:00",
  "trx_id": "d8fe7131bca772c27a65d1fb03388d535b033973",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 5.991 SP to @mirio
2019/06/28 23:44:30
delegateemirio
delegatorsteem
vesting shares9743.199482 VESTS
Transaction InfoBlock #34208092/Trx 7a9354846fbb57f953db38e45bc5ac28c1ae41b4
View Raw JSON Data
{
  "block": 34208092,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "9743.199482 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-06-28T23:44:30",
  "trx_id": "7a9354846fbb57f953db38e45bc5ac28c1ae41b4",
  "trx_in_block": 1,
  "virtual_op": 0
}
2019/04/02 19:52:36
authorsteemitboard
bodyCongratulations @mirio! You received a personal award! <table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@mirio/birthday1.png</td><td>Happy Birthday! - You are on the Steem blockchain for 1 year!</td></tr></table> <sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@mirio) and compare to others on the [Steem Ranking](http://steemitboard.com/ranking/index.php?name=mirio)_</sub> ###### [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 authormirio
parent permlinkcome-tracciare-il-trend-delle-cryptovalute-real-time
permlinksteemitboard-notify-mirio-20190402t195236000z
title
Transaction InfoBlock #31701687/Trx 598643e89c4caec85473626915cc313e054ea904
View Raw JSON Data
{
  "block": 31701687,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @mirio! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@mirio/birthday1.png</td><td>Happy Birthday! - You are on the Steem blockchain for 1 year!</td></tr></table>\n\n<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@mirio) and compare to others on the [Steem Ranking](http://steemitboard.com/ranking/index.php?name=mirio)_</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": "mirio",
      "parent_permlink": "come-tracciare-il-trend-delle-cryptovalute-real-time",
      "permlink": "steemitboard-notify-mirio-20190402t195236000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-04-02T19:52:36",
  "trx_id": "598643e89c4caec85473626915cc313e054ea904",
  "trx_in_block": 8,
  "virtual_op": 0
}
steemdelegated 6.113 SP to @mirio
2018/07/08 19:07:42
delegateemirio
delegatorsteem
vesting shares9942.197636 VESTS
Transaction InfoBlock #24003642/Trx e9a6bbc1ad37c225e6762a2e0d2758ca42038e1b
View Raw JSON Data
{
  "block": 24003642,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "9942.197636 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-07-08T19:07:42",
  "trx_id": "e9a6bbc1ad37c225e6762a2e0d2758ca42038e1b",
  "trx_in_block": 21,
  "virtual_op": 0
}
2018/05/27 06:20:36
authormirio
permlinkcome-tracciare-il-trend-delle-cryptovalute-real-time
voterbitbollo
weight10000 (100.00%)
Transaction InfoBlock #22789488/Trx c52328d096cd4cbdfdc5f488d8c9dfc785d863c8
View Raw JSON Data
{
  "block": 22789488,
  "op": [
    "vote",
    {
      "author": "mirio",
      "permlink": "come-tracciare-il-trend-delle-cryptovalute-real-time",
      "voter": "bitbollo",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-27T06:20:36",
  "trx_id": "c52328d096cd4cbdfdc5f488d8c9dfc785d863c8",
  "trx_in_block": 43,
  "virtual_op": 0
}
2018/04/08 17:07:18
authorarcange
permlinkre-come-tracciare-il-trend-delle-cryptovalute-real-time-20180406t171634000z
votermirio
weight-10000 (-100.00%)
Transaction InfoBlock #21392493/Trx 5d7c3a68b07933df9e28493a442dac6696524a2c
View Raw JSON Data
{
  "block": 21392493,
  "op": [
    "vote",
    {
      "author": "arcange",
      "permlink": "re-come-tracciare-il-trend-delle-cryptovalute-real-time-20180406t171634000z",
      "voter": "mirio",
      "weight": -10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-08T17:07:18",
  "trx_id": "5d7c3a68b07933df9e28493a442dac6696524a2c",
  "trx_in_block": 37,
  "virtual_op": 0
}
2018/04/08 17:06:39
authormirio
permlinkhow-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending
votermirio
weight10000 (100.00%)
Transaction InfoBlock #21392480/Trx 4e43b29d90dcf6db8163e123771757586306a389
View Raw JSON Data
{
  "block": 21392480,
  "op": [
    "vote",
    {
      "author": "mirio",
      "permlink": "how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending",
      "voter": "mirio",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-08T17:06:39",
  "trx_id": "4e43b29d90dcf6db8163e123771757586306a389",
  "trx_in_block": 15,
  "virtual_op": 0
}
2018/04/06 16:29:39
authormirio
permlinkcome-tracciare-il-trend-delle-cryptovalute-real-time
votersamjverteli
weight10000 (100.00%)
Transaction InfoBlock #21334143/Trx 0274a863e0b01aa033d77e6668f1d3c017f5d445
View Raw JSON Data
{
  "block": 21334143,
  "op": [
    "vote",
    {
      "author": "mirio",
      "permlink": "come-tracciare-il-trend-delle-cryptovalute-real-time",
      "voter": "samjverteli",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-06T16:29:39",
  "trx_id": "0274a863e0b01aa033d77e6668f1d3c017f5d445",
  "trx_in_block": 59,
  "virtual_op": 0
}
2018/04/06 16:29:39
authormirio
permlinkcome-tracciare-il-trend-delle-cryptovalute-real-time
voterknotmilcala
weight10000 (100.00%)
Transaction InfoBlock #21334143/Trx e1190ca20001b1d2e3463cfa1a62c37599abeb89
View Raw JSON Data
{
  "block": 21334143,
  "op": [
    "vote",
    {
      "author": "mirio",
      "permlink": "come-tracciare-il-trend-delle-cryptovalute-real-time",
      "voter": "knotmilcala",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-06T16:29:39",
  "trx_id": "e1190ca20001b1d2e3463cfa1a62c37599abeb89",
  "trx_in_block": 37,
  "virtual_op": 0
}
2018/04/06 15:16:30
authorarcange
bodyWARNING - The message you received from @eliterry12 is a CONFIRMED SCAM! DO NOT FOLLOW any instruction and DO NOT CLICK on any link in the comment! For more information, read this post: https://steemit.com/steemit/@arcange/phishing-site-reported-steemautobot-dot-ml Please consider to upvote this warning if you find my work to protect you and the platform valuable. Your support is welcome!
json metadata{"image":["http://i.cubeupload.com/d1Dr28.png"]}
parent authormirio
parent permlinkcome-tracciare-il-trend-delle-cryptovalute-real-time
permlinkre-come-tracciare-il-trend-delle-cryptovalute-real-time-20180406t171634000z
title
Transaction InfoBlock #21332680/Trx 8c16911f6b3c3a4daa8a38dd97cb9f3699994a54
View Raw JSON Data
{
  "block": 21332680,
  "op": [
    "comment",
    {
      "author": "arcange",
      "body": "WARNING - The message you received from @eliterry12 is a CONFIRMED SCAM!\nDO NOT FOLLOW any instruction and DO NOT CLICK on any link in the comment!\nFor more information, read this post: https://steemit.com/steemit/@arcange/phishing-site-reported-steemautobot-dot-ml\nPlease consider to upvote this warning if you find my work to protect you and the platform valuable. Your support is welcome!",
      "json_metadata": "{\"image\":[\"http://i.cubeupload.com/d1Dr28.png\"]}",
      "parent_author": "mirio",
      "parent_permlink": "come-tracciare-il-trend-delle-cryptovalute-real-time",
      "permlink": "re-come-tracciare-il-trend-delle-cryptovalute-real-time-20180406t171634000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-06T15:16:30",
  "trx_id": "8c16911f6b3c3a4daa8a38dd97cb9f3699994a54",
  "trx_in_block": 6,
  "virtual_op": 0
}
2018/04/06 06:34:06
authormirio
permlinkhow-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending
voterwetpoverin
weight10000 (100.00%)
Transaction InfoBlock #21322232/Trx 81f792cc20d4f22e31ce7562a63d5511369f167e
View Raw JSON Data
{
  "block": 21322232,
  "op": [
    "vote",
    {
      "author": "mirio",
      "permlink": "how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending",
      "voter": "wetpoverin",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-06T06:34:06",
  "trx_id": "81f792cc20d4f22e31ce7562a63d5511369f167e",
  "trx_in_block": 20,
  "virtual_op": 0
}
2018/04/06 06:01:36
authoreliterry12
permlinkre-mirio-come-tracciare-il-trend-delle-cryptovalute-real-time-20180406t055642476z
votermirio
weight-10000 (-100.00%)
Transaction InfoBlock #21321582/Trx 8805ba79408535f1477a29b8d5de3d86b4a40ae9
View Raw JSON Data
{
  "block": 21321582,
  "op": [
    "vote",
    {
      "author": "eliterry12",
      "permlink": "re-mirio-come-tracciare-il-trend-delle-cryptovalute-real-time-20180406t055642476z",
      "voter": "mirio",
      "weight": -10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-06T06:01:36",
  "trx_id": "8805ba79408535f1477a29b8d5de3d86b4a40ae9",
  "trx_in_block": 20,
  "virtual_op": 0
}
2018/04/06 05:57:30
authoreliterry12
body## Try Our Service Befre Buy🎁 * **Exclusive 30 days free upvotes to your every new post.** * **Limited Time Offer** * **No need to send any kinds of steem or sbd its full free service.** _**we have paid service too so please check them too. Active the free upvote service and learn more about it here : [JOIN NOW CLICK HERE](http://nullrefer.com/?http://steemupper.gq/)**_
json metadata{"tags":["cryptocurrency"],"links":["http://nullrefer.com/?http://steemupper.gq/"],"app":"steemit/0.1"}
parent authormirio
parent permlinkcome-tracciare-il-trend-delle-cryptovalute-real-time
permlinkre-mirio-come-tracciare-il-trend-delle-cryptovalute-real-time-20180406t055642476z
title
Transaction InfoBlock #21321500/Trx 1ee8c7af0141b395248cad1a50bfc7b05ca0e092
View Raw JSON Data
{
  "block": 21321500,
  "op": [
    "comment",
    {
      "author": "eliterry12",
      "body": "## Try Our Service Befre Buy🎁\n* **Exclusive 30 days free upvotes to your every new post.** \n* **Limited Time Offer**\n* **No need to send any kinds of steem or sbd its full free service.**\n _**we have paid service too so please check them too. Active the free upvote service and learn more about it here : [JOIN NOW CLICK HERE](http://nullrefer.com/?http://steemupper.gq/)**_",
      "json_metadata": "{\"tags\":[\"cryptocurrency\"],\"links\":[\"http://nullrefer.com/?http://steemupper.gq/\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "mirio",
      "parent_permlink": "come-tracciare-il-trend-delle-cryptovalute-real-time",
      "permlink": "re-mirio-come-tracciare-il-trend-delle-cryptovalute-real-time-20180406t055642476z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-06T05:57:30",
  "trx_id": "1ee8c7af0141b395248cad1a50bfc7b05ca0e092",
  "trx_in_block": 6,
  "virtual_op": 0
}
2018/04/06 05:57:03
authormirio
permlinkcome-tracciare-il-trend-delle-cryptovalute-real-time
votermirio
weight10000 (100.00%)
Transaction InfoBlock #21321491/Trx 9987cf64766e09276e09b6157004b6a79ae3f735
View Raw JSON Data
{
  "block": 21321491,
  "op": [
    "vote",
    {
      "author": "mirio",
      "permlink": "come-tracciare-il-trend-delle-cryptovalute-real-time",
      "voter": "mirio",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-06T05:57:03",
  "trx_id": "9987cf64766e09276e09b6157004b6a79ae3f735",
  "trx_in_block": 5,
  "virtual_op": 0
}
2018/04/06 05:57:03
authormirio
body--- ENGLISH GUIDE --> [CLICK HERE](https://steemit.com/howto/@mirio/how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending) --- ## Introduzione Questa guida nasce con lo scopo di aiutare sia i neofiti sia gli esperti a tener traccia dei repentini cambiamenti di mercato senza l'utilizzo di tool proprietari o accessi a siti specifici dietro pagamento. La guida servirà ad avere: * Una lista dei prezzi aggiornati in tempo reale * Una lista di transazioni completa (opzionale) * Un recap completo della vostra situazione in ambito crypto (guadagno, perdite...) ## Requisito * Account Google ## Procedimento Step-by-Step Vai all'indirizzo relativo al [Google Docs Spreadsheets](https://docs.google.com/spreadsheets/) e procedi a creare un nuovo foglio cliccando sul pulsante "+" ![](https://steemitimages.com/DQmPpYcywpsb3HjYqbZCFqbCv6S85SZ29VHAM4LymvjxnTT/image.png) Dai un nome significativo al foglio, così da ricordarti a posteriori il contenuto (per esempio: `Bilancio crypto`) per farlo clicca in alto a sinistra dove vi è il blocco relativo al titolo e inserisci al suo interno il nome che hai scelto (nel mio caso `Bilancio crypto`). ![](https://steemitimages.com/DQmaU82gDBVJPNdDNPhBZf4qYYga2JPAnXbtuCw5Yg6eHvD/image.png) ### Lista transazioni completa (opzionale) Se vuoi avere uno storico delle transazioni indipendente dall'exchange usato e dal tipo di scambio avvenuto ti consiglio di partire da uno schema simile a questo: ![](https://steemitimages.com/DQmWwtS9jdbDtJiLKeQuvLiYh4hJuN6sg5fAQbm4Rkk6qGa/image.png) Nello specifico le indicazioni per i field indicati: * Data = Inserisci la data dell'operazione, ti consiglio il formato %YYYY-%MM-%DD %HH:%mm (es: `2018-04-03 22:50`) * Azione = Breve descrizione dell'operazione svolta, per esempio `DEP SEPA` per indicare un bonifico sepa * Valuta Guadagnata = Qual è la valuta guadagnata dall'operazione * Descrizione = Descrizione completa dell'operazione esempio "Deposito Sepa verso Kraken" * Euro Caricati = In caso di investimento in euro consiglio di compilare questo campo per gli step successivi * Valuta Spesa = in caso venga spesa una crypto va inserita in questo campo, per esempio (`-5000 BTC`) * Conseguenza = Guadagno e/o perdita in ambito crypto, per esempio (`+20000 ETH`) * Exchange = Exchange dov'è avvenuta tale transazione * Wallet Src / Wallet Dst = In caso di trasferimento di crypto bisogna indicare il nome del wallet, per esempio in source "Kraken" e in dest "Ledger" Si può aggiungere qualsiasi altro campo tu voglia, sentiti libero di modificarlo a tuo piacimento. ### Prezzi e guadagno/perdite in tempo reale Per sapere in tempo reale i prezzi di un token o una coin ci affideremo alle API di [https://coinmarketcap.com/](CoinMarketCap) (noto sito in ambito crypto). Se hai già fatto la lista delle transazioni ti consiglio di creare un nuovo foglio cliccando sul "+" in basso a sinistra ![](https://steemitimages.com/DQmXXP6MHrwYdGunkxM49KKYuGf93ryHdH5G3D7MpDcnopC/image.png) A questo punto è necessario aggiungere una funzione in google scripts al fine di avere l'aggiornamento in tempo reale. Apri il menu "Strumenti" e vai nella voce "Editor di script" ![](https://steemitimages.com/DQmd4X79dYhMYeoUMWhiBtVE82vGwEsJLj5f4ZPW84Y26q1/image.png) Ti aprirà una scheda parallela con un contenuto simile a questo: ![](https://steemitimages.com/DQmY5ocDJFcM55z8F997DRTYdkv3gKzvKjbeGXmPEHVgYe8/image.png) Cancella completamente il contenuto e inserisci quanto segue per intero ``` function ccprice(name) { var url = "https://api.coinmarketcap.com/v1/ticker/" + name + "/?convert=EUR"; var response = UrlFetchApp.fetch(url); var json = response.getContentText(); var data = JSON.parse(json); var price = parseFloat(data[0]["price_eur"]) return price } ``` (Versione modificata dello script https://github.com/rathergood/Crypto-Currency-Price/) Infine clicca sul tasto salva in alto a sinistra ![](https://steemitimages.com/DQmckkX4xeP5AGsGNEK3sUZzwtxVEaHeQj4n8U91pSqPm9Z/image.png) Immetti il nome ```ccprice``` Il risultato finale sarà qualcosa di simile a questo ![](https://steemitimages.com/DQmXJoPZ2yv81BMx8Jg3xdn9erUkLTemvqqpyYtqjPPMssR/image.png) Perfetto, ora puoi chiudere quella schede e tornare al nostro foglio. Crea una griglia simile a quella che segue: ![](https://steemitimages.com/DQmPzpbuxeCcwkm5wxetszCxcKfnQ9RxHVQYfERGusQK637/image.png) Nel primo field inserisci il nome della moneta o del token, per esempio Bitcoin. ![](https://steemitimages.com/DQmShmKWaBbZJefEwgjZdCWHCE1dM6xDGsBoCdmJq9p9HmS/image.png) Nel secondo field andremo a richiamare la funzione che abbiamo creato poco fa in questo modo: ```=ccprice("<NOME MONETA/TOKEN>")``` Per esempio: ```=ccprice("Bitcoin")``` Al fine di inserirla correttamente clicca sul field e di seguito in alto a sinistra nello spazio preceduto dalla scritta `fx` ![](https://steemitimages.com/DQmbT4vbsNJ2wZ3GJ94shMbTccTwZa4net8SrDgDzUsnKMn/image.png) E scrivi esattamente come indicato poco fa, per esempio ![](https://steemitimages.com/DQmZLnyhxvrtmmY9Zyk9cWGuh4kuNqK3GCLWm4kEzuziRk5/image.png) Premi invio e in questo modo apparirà il prezzo in tempo reale. Procediamo dunque ad inserire il field "Hold num", al suo interno devi inserire il numero della coin/token che possiedi in valore numerico, per esempio 10000000 ![](https://steemitimages.com/DQmRM7fwYwbZwW6FJEZxEEkAH6LfDNT65mJUmpeZhJzjqfh/image.png) Infine compila il campo "Totale in euro" come quanto segue al fine di calcolare esattamente quanto sia il valore attuale della tua moneta rispetto all'euro ```=B2*C2``` Il risultato sarà simile a quanto segue ![](https://steemitimages.com/DQmRVzSg4u9Eo7ntFBKwVS6N1CkXSQM7Vrvs5MKCD3zrfiu/image.png) Ripeti l'operazione per tutte le coin/token che possiedi stando attento al nome della moneta, infatti le monete/token che contengono degli spazi devono essere sostituite con il "-" al suo interno, per esempio Bitcoin Cash diventa "bitcoin-cash". ### Recap guadagni / perdite Se hai fatto correttamente tutti i passaggi precedenti, per il prossimo si tratterà solo di applicare un po' di matematica per avere un recap generale di ciò che sta succedendo. Ti consiglio una griglia del genere: ![](https://steemitimages.com/DQmWjBED9CgPfdVBAS4pesViPNHuZG59bX5hMLq8SZG3Mm5/image.png) Andiamo a compilare il primo field "Totale euro immesso" e qui ci sono due scenari: #### Scenario 1: Hai seguito il passo "Lista transazioni completa" e hai il field "Euro Caricati" a cui agganciarvi Nel field scrivi `=SUM(` torna sul primo foglio e seleziona *TUTTE* le righe relative al field "Euro Caricati" (ricordati di aggiornare la funzione in caso allungassi la lista), il risultato dovrebbe essere una funzione simile: ```=SUM('Lista Transazioni'!E2:E5)``` Premi invio e nel primo field avrai il totale degli euro spesi #### Scenario 2: NON hai seguito il passo "Lista transazioni completa" Inserisci manualmente il totale degli euro spesi nel field In entrambi i casi ti dovresti trovare davanti ad una situazione simile ![](https://steemitimages.com/DQmWfR8hPQAMf4fKXzcV5GWXnHSHeGn7UA6ZXU9R8qshy97/image.png) Procediamo ora con il field "Totale Attuale", seleziona il field e scrivi `=SUM(` e seleziona *TUTTE* tutte le righe relative al field "Totale in euro" precedentemente creato: ![](https://steemitimages.com/DQmcU8YHaXATB2qXPvPUiN6Nzw9iPHsimo2jZenEVgMDZzp/image.png) E premi invio: ![](https://steemitimages.com/DQmVqhcCRoUTkgrwcaud4FMu2qhNJ43Yvojqn4q43KNUguU/image.png) Procediamo dunque a compilare anche il field "Totale Guadagno" Ovviamente il totale del guadagno sarà dato dal totale attuale meno il totale immesso, quindi possiamo inserire la formula ```=<Numero cella totale guadagnato>-<Numero cella totale immesso>``` Nel mio caso per esempio èš: ```=G2-F2``` ![](https://steemitimages.com/DQmZD5pCt2XgBkZ4Dgmdx6CGkxdKakdiZk3RBpDCT478UHt/image.png) Infine andiamo a calcolare la percentuale di guadagno Quest'ultima sarà data dal totale attuale DIVISO il totale immesso ```=<Numero cella totale guadagnato>/<Numero cella totale immesso>``` Nel mio caso per esempio è: ```=G2/F2``` #### Ultimi ritocchi per rendere il tutto più leggibile Nei field "Totale in euro", "Totale euro immesso", "Totale Attuale" e "Totale Guadagno" effettua questa operazione: * Seleziona la colonna * Apri il menu Formato-> Numero e seleziona "Valuta" ![](https://steemitimages.com/DQmUiuBq44U2eo7rWeNAwTkY6KQUnNFJknrjNkatgvPCZXU/image.png) Mentre per il field "Guadagno percentuale" effettua la seguente operazione * Seleziona la colonna * Apri il menù Formato -> Numero e seleziona "Percentuale" Il risultato finale sarà qualcosa del genere ![](https://steemitimages.com/DQmSt4JVrQtUwbdqYteeKaDYnQktSTq41jty9NpEFZxiJ7B/image.png) Spero di esserti stato utile nella guida :) Alla prossima,
json metadata{"tags":["cryptocurrency","ita","trending","investment","education"],"image":["https://steemitimages.com/DQmPpYcywpsb3HjYqbZCFqbCv6S85SZ29VHAM4LymvjxnTT/image.png","https://steemitimages.com/DQmaU82gDBVJPNdDNPhBZf4qYYga2JPAnXbtuCw5Yg6eHvD/image.png","https://steemitimages.com/DQmWwtS9jdbDtJiLKeQuvLiYh4hJuN6sg5fAQbm4Rkk6qGa/image.png","https://steemitimages.com/DQmXXP6MHrwYdGunkxM49KKYuGf93ryHdH5G3D7MpDcnopC/image.png","https://steemitimages.com/DQmd4X79dYhMYeoUMWhiBtVE82vGwEsJLj5f4ZPW84Y26q1/image.png","https://steemitimages.com/DQmY5ocDJFcM55z8F997DRTYdkv3gKzvKjbeGXmPEHVgYe8/image.png","https://steemitimages.com/DQmckkX4xeP5AGsGNEK3sUZzwtxVEaHeQj4n8U91pSqPm9Z/image.png","https://steemitimages.com/DQmXJoPZ2yv81BMx8Jg3xdn9erUkLTemvqqpyYtqjPPMssR/image.png","https://steemitimages.com/DQmPzpbuxeCcwkm5wxetszCxcKfnQ9RxHVQYfERGusQK637/image.png","https://steemitimages.com/DQmShmKWaBbZJefEwgjZdCWHCE1dM6xDGsBoCdmJq9p9HmS/image.png","https://steemitimages.com/DQmbT4vbsNJ2wZ3GJ94shMbTccTwZa4net8SrDgDzUsnKMn/image.png","https://steemitimages.com/DQmZLnyhxvrtmmY9Zyk9cWGuh4kuNqK3GCLWm4kEzuziRk5/image.png","https://steemitimages.com/DQmRM7fwYwbZwW6FJEZxEEkAH6LfDNT65mJUmpeZhJzjqfh/image.png","https://steemitimages.com/DQmRVzSg4u9Eo7ntFBKwVS6N1CkXSQM7Vrvs5MKCD3zrfiu/image.png","https://steemitimages.com/DQmWjBED9CgPfdVBAS4pesViPNHuZG59bX5hMLq8SZG3Mm5/image.png","https://steemitimages.com/DQmWfR8hPQAMf4fKXzcV5GWXnHSHeGn7UA6ZXU9R8qshy97/image.png","https://steemitimages.com/DQmcU8YHaXATB2qXPvPUiN6Nzw9iPHsimo2jZenEVgMDZzp/image.png","https://steemitimages.com/DQmVqhcCRoUTkgrwcaud4FMu2qhNJ43Yvojqn4q43KNUguU/image.png","https://steemitimages.com/DQmZD5pCt2XgBkZ4Dgmdx6CGkxdKakdiZk3RBpDCT478UHt/image.png","https://steemitimages.com/DQmUiuBq44U2eo7rWeNAwTkY6KQUnNFJknrjNkatgvPCZXU/image.png","https://steemitimages.com/DQmSt4JVrQtUwbdqYteeKaDYnQktSTq41jty9NpEFZxiJ7B/image.png"],"links":["https://steemit.com/howto/@mirio/how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending","https://docs.google.com/spreadsheets/","CoinMarketCap","https://github.com/rathergood/Crypto-Currency-Price/"],"app":"steemit/0.1","format":"markdown"}
parent author
parent permlinkcryptocurrency
permlinkcome-tracciare-il-trend-delle-cryptovalute-real-time
titleCome tracciare il trend delle cryptovalute real-time
Transaction InfoBlock #21321491/Trx 9987cf64766e09276e09b6157004b6a79ae3f735
View Raw JSON Data
{
  "block": 21321491,
  "op": [
    "comment",
    {
      "author": "mirio",
      "body": "---\nENGLISH GUIDE --> [CLICK HERE](https://steemit.com/howto/@mirio/how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending)\n---\n\n## Introduzione \nQuesta guida nasce con lo scopo di aiutare sia i neofiti sia gli esperti a tener traccia dei repentini cambiamenti di mercato senza l'utilizzo di tool proprietari o accessi a siti specifici dietro pagamento.\nLa guida servirà ad avere: \n* Una lista dei prezzi aggiornati in tempo reale\n* Una lista di transazioni completa (opzionale)\n* Un recap completo della vostra situazione in ambito crypto (guadagno, perdite...)\n\n## Requisito\n* Account Google\n\n## Procedimento Step-by-Step\nVai all'indirizzo relativo al [Google Docs Spreadsheets](https://docs.google.com/spreadsheets/) e procedi a creare un nuovo foglio cliccando sul pulsante \"+\"\n\n![](https://steemitimages.com/DQmPpYcywpsb3HjYqbZCFqbCv6S85SZ29VHAM4LymvjxnTT/image.png)\n\nDai un nome significativo al foglio, così da ricordarti a posteriori il contenuto (per esempio: `Bilancio crypto`) per farlo clicca in alto a sinistra dove vi è il blocco relativo al titolo e inserisci al suo interno il nome che hai scelto (nel mio caso `Bilancio crypto`).\n\n![](https://steemitimages.com/DQmaU82gDBVJPNdDNPhBZf4qYYga2JPAnXbtuCw5Yg6eHvD/image.png)\n\n### Lista transazioni completa (opzionale)\nSe vuoi avere uno storico delle transazioni indipendente dall'exchange usato e dal tipo di scambio avvenuto ti consiglio di partire da uno schema simile a questo:\n\n![](https://steemitimages.com/DQmWwtS9jdbDtJiLKeQuvLiYh4hJuN6sg5fAQbm4Rkk6qGa/image.png)\n\nNello specifico le indicazioni per i field indicati:\n* Data  = Inserisci la data dell'operazione, ti consiglio il formato %YYYY-%MM-%DD %HH:%mm (es: `2018-04-03 22:50`)\n* Azione = Breve descrizione dell'operazione svolta, per esempio `DEP SEPA` per indicare un bonifico sepa\n* Valuta Guadagnata = Qual è la valuta guadagnata dall'operazione\n* Descrizione = Descrizione completa dell'operazione esempio \"Deposito Sepa verso Kraken\"\n* Euro Caricati = In caso di investimento in euro consiglio di compilare questo campo per gli step successivi\n* Valuta Spesa = in caso venga spesa una crypto va inserita in questo campo, per esempio (`-5000 BTC`)\n* Conseguenza = Guadagno e/o perdita in ambito crypto, per esempio (`+20000 ETH`)\n* Exchange = Exchange dov'è avvenuta tale transazione\n* Wallet Src / Wallet Dst = In caso di trasferimento di crypto bisogna indicare il nome del wallet, per esempio in source \"Kraken\" e in dest \"Ledger\"\n\nSi può aggiungere qualsiasi altro campo tu voglia, sentiti libero di modificarlo a tuo piacimento.\n\n### Prezzi e guadagno/perdite in tempo reale\nPer sapere in tempo reale i prezzi di un token o una coin ci affideremo alle API di [https://coinmarketcap.com/](CoinMarketCap) (noto sito in ambito crypto).\nSe hai già fatto la lista delle transazioni ti consiglio di creare un nuovo foglio cliccando sul \"+\" in basso a sinistra\n\n![](https://steemitimages.com/DQmXXP6MHrwYdGunkxM49KKYuGf93ryHdH5G3D7MpDcnopC/image.png)\n\nA questo punto è necessario aggiungere una funzione in google scripts al fine di avere l'aggiornamento in tempo reale.\n\nApri il menu \"Strumenti\" e vai nella voce \"Editor di script\"\n\n![](https://steemitimages.com/DQmd4X79dYhMYeoUMWhiBtVE82vGwEsJLj5f4ZPW84Y26q1/image.png)\n\nTi aprirà una scheda parallela con un contenuto simile a questo:\n\n![](https://steemitimages.com/DQmY5ocDJFcM55z8F997DRTYdkv3gKzvKjbeGXmPEHVgYe8/image.png)\n\n\nCancella completamente il contenuto e inserisci quanto segue per intero\n\n```\nfunction ccprice(name) \n{\n  var url = \"https://api.coinmarketcap.com/v1/ticker/\" + name + \"/?convert=EUR\";\n  var response = UrlFetchApp.fetch(url);\n  var json = response.getContentText();\n  var data = JSON.parse(json);\n  \n  var price = parseFloat(data[0][\"price_eur\"])                     \n  return price\n}\n```\n(Versione modificata dello script https://github.com/rathergood/Crypto-Currency-Price/)\n\nInfine clicca sul tasto salva in alto a sinistra\n\n![](https://steemitimages.com/DQmckkX4xeP5AGsGNEK3sUZzwtxVEaHeQj4n8U91pSqPm9Z/image.png)\n\nImmetti il nome ```ccprice```\n\nIl risultato finale sarà qualcosa di simile a questo\n![](https://steemitimages.com/DQmXJoPZ2yv81BMx8Jg3xdn9erUkLTemvqqpyYtqjPPMssR/image.png)\n\nPerfetto, ora puoi chiudere quella schede e tornare al nostro foglio.\nCrea una griglia simile a quella che segue:\n\n![](https://steemitimages.com/DQmPzpbuxeCcwkm5wxetszCxcKfnQ9RxHVQYfERGusQK637/image.png)\n\nNel primo field inserisci il nome della moneta o del token, per esempio Bitcoin.\n![](https://steemitimages.com/DQmShmKWaBbZJefEwgjZdCWHCE1dM6xDGsBoCdmJq9p9HmS/image.png)\n\nNel secondo field andremo a richiamare la funzione che abbiamo creato poco fa in questo modo:\n```=ccprice(\"<NOME MONETA/TOKEN>\")```\nPer esempio:\n```=ccprice(\"Bitcoin\")```\n\nAl fine di inserirla correttamente clicca sul field e di seguito in alto a sinistra nello spazio preceduto dalla scritta `fx`\n\n![](https://steemitimages.com/DQmbT4vbsNJ2wZ3GJ94shMbTccTwZa4net8SrDgDzUsnKMn/image.png)\n\nE scrivi esattamente come indicato poco fa, per esempio\n![](https://steemitimages.com/DQmZLnyhxvrtmmY9Zyk9cWGuh4kuNqK3GCLWm4kEzuziRk5/image.png)\nPremi invio e in questo modo apparirà il prezzo in tempo reale.\n\nProcediamo dunque ad inserire il field \"Hold num\", al suo interno devi inserire il numero della coin/token che possiedi in valore numerico, per esempio 10000000\n\n![](https://steemitimages.com/DQmRM7fwYwbZwW6FJEZxEEkAH6LfDNT65mJUmpeZhJzjqfh/image.png)\n\nInfine compila il campo \"Totale in euro\" come quanto segue al fine di calcolare esattamente quanto sia il valore attuale della tua moneta rispetto all'euro \n\n```=B2*C2```\n\nIl risultato sarà simile a quanto segue\n\n![](https://steemitimages.com/DQmRVzSg4u9Eo7ntFBKwVS6N1CkXSQM7Vrvs5MKCD3zrfiu/image.png)\n\nRipeti l'operazione per tutte le coin/token che possiedi stando attento al nome della moneta, infatti le monete/token che contengono degli spazi devono essere sostituite con il \"-\" al suo interno, per esempio Bitcoin Cash diventa \"bitcoin-cash\".\n\n\n### Recap guadagni / perdite\nSe hai fatto correttamente tutti i passaggi precedenti, per il prossimo si tratterà solo di applicare un po' di matematica per avere un recap generale di ciò che sta succedendo.\nTi consiglio una griglia del genere:\n![](https://steemitimages.com/DQmWjBED9CgPfdVBAS4pesViPNHuZG59bX5hMLq8SZG3Mm5/image.png)\n\nAndiamo a compilare il primo field \"Totale euro immesso\" e qui ci sono due scenari:\n#### Scenario 1: Hai seguito il passo \"Lista transazioni completa\" e hai il field \"Euro Caricati\" a cui agganciarvi\n\nNel field scrivi `=SUM(` torna sul primo foglio e seleziona *TUTTE* le righe relative al field \"Euro Caricati\" (ricordati di aggiornare la funzione in caso allungassi la lista), il risultato dovrebbe essere una funzione simile:\n\n```=SUM('Lista Transazioni'!E2:E5)```\n\nPremi invio e nel primo field avrai il totale degli euro spesi\n\n#### Scenario 2: NON hai seguito il passo \"Lista transazioni completa\"\nInserisci manualmente il totale degli euro spesi nel field \n\nIn entrambi i casi ti dovresti trovare davanti ad una situazione simile\n\n![](https://steemitimages.com/DQmWfR8hPQAMf4fKXzcV5GWXnHSHeGn7UA6ZXU9R8qshy97/image.png)\n\nProcediamo ora con il field \"Totale Attuale\", seleziona il field e scrivi `=SUM(` e seleziona *TUTTE* tutte le righe relative al field \"Totale in euro\" precedentemente creato:\n\n![](https://steemitimages.com/DQmcU8YHaXATB2qXPvPUiN6Nzw9iPHsimo2jZenEVgMDZzp/image.png)\n\nE premi invio:\n\n![](https://steemitimages.com/DQmVqhcCRoUTkgrwcaud4FMu2qhNJ43Yvojqn4q43KNUguU/image.png)\n\nProcediamo dunque a compilare anche il field \"Totale Guadagno\"\nOvviamente il totale del guadagno sarà dato dal totale attuale meno il totale immesso, quindi possiamo inserire la formula\n\n```=<Numero cella totale guadagnato>-<Numero cella totale immesso>```\n\nNel mio caso per esempio èš:\n```=G2-F2```\n\n![](https://steemitimages.com/DQmZD5pCt2XgBkZ4Dgmdx6CGkxdKakdiZk3RBpDCT478UHt/image.png)\n \nInfine andiamo a calcolare la percentuale di guadagno\nQuest'ultima sarà data dal totale attuale DIVISO il totale immesso\n```=<Numero cella totale guadagnato>/<Numero cella totale immesso>```\n\nNel mio caso per esempio è:\n```=G2/F2```\n\n\n#### Ultimi ritocchi per rendere il tutto più leggibile\n\nNei field \"Totale in euro\", \"Totale euro immesso\", \"Totale Attuale\" e \"Totale Guadagno\" effettua questa operazione:\n* Seleziona la colonna \n* Apri il menu Formato-> Numero e seleziona \"Valuta\"\n\n![](https://steemitimages.com/DQmUiuBq44U2eo7rWeNAwTkY6KQUnNFJknrjNkatgvPCZXU/image.png)\n\nMentre per il field \"Guadagno percentuale\"  effettua la seguente operazione\n* Seleziona la colonna\n* Apri il menù Formato -> Numero e seleziona \"Percentuale\"\n\nIl risultato finale sarà qualcosa del genere\n\n![](https://steemitimages.com/DQmSt4JVrQtUwbdqYteeKaDYnQktSTq41jty9NpEFZxiJ7B/image.png)\n\nSpero di esserti stato utile nella guida :)\nAlla prossima,",
      "json_metadata": "{\"tags\":[\"cryptocurrency\",\"ita\",\"trending\",\"investment\",\"education\"],\"image\":[\"https://steemitimages.com/DQmPpYcywpsb3HjYqbZCFqbCv6S85SZ29VHAM4LymvjxnTT/image.png\",\"https://steemitimages.com/DQmaU82gDBVJPNdDNPhBZf4qYYga2JPAnXbtuCw5Yg6eHvD/image.png\",\"https://steemitimages.com/DQmWwtS9jdbDtJiLKeQuvLiYh4hJuN6sg5fAQbm4Rkk6qGa/image.png\",\"https://steemitimages.com/DQmXXP6MHrwYdGunkxM49KKYuGf93ryHdH5G3D7MpDcnopC/image.png\",\"https://steemitimages.com/DQmd4X79dYhMYeoUMWhiBtVE82vGwEsJLj5f4ZPW84Y26q1/image.png\",\"https://steemitimages.com/DQmY5ocDJFcM55z8F997DRTYdkv3gKzvKjbeGXmPEHVgYe8/image.png\",\"https://steemitimages.com/DQmckkX4xeP5AGsGNEK3sUZzwtxVEaHeQj4n8U91pSqPm9Z/image.png\",\"https://steemitimages.com/DQmXJoPZ2yv81BMx8Jg3xdn9erUkLTemvqqpyYtqjPPMssR/image.png\",\"https://steemitimages.com/DQmPzpbuxeCcwkm5wxetszCxcKfnQ9RxHVQYfERGusQK637/image.png\",\"https://steemitimages.com/DQmShmKWaBbZJefEwgjZdCWHCE1dM6xDGsBoCdmJq9p9HmS/image.png\",\"https://steemitimages.com/DQmbT4vbsNJ2wZ3GJ94shMbTccTwZa4net8SrDgDzUsnKMn/image.png\",\"https://steemitimages.com/DQmZLnyhxvrtmmY9Zyk9cWGuh4kuNqK3GCLWm4kEzuziRk5/image.png\",\"https://steemitimages.com/DQmRM7fwYwbZwW6FJEZxEEkAH6LfDNT65mJUmpeZhJzjqfh/image.png\",\"https://steemitimages.com/DQmRVzSg4u9Eo7ntFBKwVS6N1CkXSQM7Vrvs5MKCD3zrfiu/image.png\",\"https://steemitimages.com/DQmWjBED9CgPfdVBAS4pesViPNHuZG59bX5hMLq8SZG3Mm5/image.png\",\"https://steemitimages.com/DQmWfR8hPQAMf4fKXzcV5GWXnHSHeGn7UA6ZXU9R8qshy97/image.png\",\"https://steemitimages.com/DQmcU8YHaXATB2qXPvPUiN6Nzw9iPHsimo2jZenEVgMDZzp/image.png\",\"https://steemitimages.com/DQmVqhcCRoUTkgrwcaud4FMu2qhNJ43Yvojqn4q43KNUguU/image.png\",\"https://steemitimages.com/DQmZD5pCt2XgBkZ4Dgmdx6CGkxdKakdiZk3RBpDCT478UHt/image.png\",\"https://steemitimages.com/DQmUiuBq44U2eo7rWeNAwTkY6KQUnNFJknrjNkatgvPCZXU/image.png\",\"https://steemitimages.com/DQmSt4JVrQtUwbdqYteeKaDYnQktSTq41jty9NpEFZxiJ7B/image.png\"],\"links\":[\"https://steemit.com/howto/@mirio/how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending\",\"https://docs.google.com/spreadsheets/\",\"CoinMarketCap\",\"https://github.com/rathergood/Crypto-Currency-Price/\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "cryptocurrency",
      "permlink": "come-tracciare-il-trend-delle-cryptovalute-real-time",
      "title": "Come tracciare il trend delle cryptovalute real-time"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-06T05:57:03",
  "trx_id": "9987cf64766e09276e09b6157004b6a79ae3f735",
  "trx_in_block": 5,
  "virtual_op": 0
}
2018/04/05 22:44:48
authormirio
bodyAtm i'm still hold the coins/token, i think the market go up on long term
json metadata{"tags":["howto"],"app":"steemit/0.1"}
parent authorcryptoissweet
parent permlinkre-mirio-how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending-1522960312495te82575d7-58fd-47bb-a189-9b5554ffb265uid
permlinkre-cryptoissweet-re-mirio-how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending-1522960312495te82575d7-58fd-47bb-a189-9b5554ffb265uid-20180405t224447858z
title
Transaction InfoBlock #21312846/Trx 0f08c6ef868eece9e4f9447de2ca5fb6f0aa2d85
View Raw JSON Data
{
  "block": 21312846,
  "op": [
    "comment",
    {
      "author": "mirio",
      "body": "Atm i'm still hold the coins/token, i think the market go up on long term",
      "json_metadata": "{\"tags\":[\"howto\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "cryptoissweet",
      "parent_permlink": "re-mirio-how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending-1522960312495te82575d7-58fd-47bb-a189-9b5554ffb265uid",
      "permlink": "re-cryptoissweet-re-mirio-how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending-1522960312495te82575d7-58fd-47bb-a189-9b5554ffb265uid-20180405t224447858z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-05T22:44:48",
  "trx_id": "0f08c6ef868eece9e4f9447de2ca5fb6f0aa2d85",
  "trx_in_block": 22,
  "virtual_op": 0
}
2018/04/05 21:30:09
authormirio
permlinkhow-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending
votermendace
weight10000 (100.00%)
Transaction InfoBlock #21311353/Trx d377ffcf8cd3d2419e9d0a14c27925d9ad33d600
View Raw JSON Data
{
  "block": 21311353,
  "op": [
    "vote",
    {
      "author": "mirio",
      "permlink": "how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending",
      "voter": "mendace",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-05T21:30:09",
  "trx_id": "d377ffcf8cd3d2419e9d0a14c27925d9ad33d600",
  "trx_in_block": 45,
  "virtual_op": 0
}
2018/04/05 20:31:54
authorcryptoissweet
bodyAdded to my follow list. Keep up the good work and what do you think of the current market?
json metadata{"tags":["Bitcoin"],"app":"SteemJ-Core/0.5.0-SNAPSHOT","format":"markdown"}
parent authormirio
parent permlinkhow-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending
permlinkre-mirio-how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending-1522960312495te82575d7-58fd-47bb-a189-9b5554ffb265uid
title
Transaction InfoBlock #21310188/Trx 2941639b2dd27cc90ed51081828564e75ac2fb55
View Raw JSON Data
{
  "block": 21310188,
  "op": [
    "comment",
    {
      "author": "cryptoissweet",
      "body": "Added to my follow list. Keep up the good work and what do you think of the current market?",
      "json_metadata": "{\"tags\":[\"Bitcoin\"],\"app\":\"SteemJ-Core/0.5.0-SNAPSHOT\",\"format\":\"markdown\"}",
      "parent_author": "mirio",
      "parent_permlink": "how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending",
      "permlink": "re-mirio-how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending-1522960312495te82575d7-58fd-47bb-a189-9b5554ffb265uid",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-05T20:31:54",
  "trx_id": "2941639b2dd27cc90ed51081828564e75ac2fb55",
  "trx_in_block": 6,
  "virtual_op": 0
}
2018/04/05 20:01:48
authormirio
body## Introduction The aim of this guide is to help either the newbies or the experts to keep track of the continuous change of the market without using a subscription service or the access to specific websites against payment of a fee. This guide will help you make: * A list of real-time prices * A complete list of transactions (optional) * A complete recap of your situation within the crypto (profit, losses...) ## Prerequisite * Google Account ## Step-by-Step process Go to [Google Docs Spreadsheets](https://docs.google.com/spreadsheets/) and create a new file clicking the icon "+" ![](https://steemitimages.com/DQmWnnhhUZ3Ca7Rmf8Kg6LMacBEciszNDtBTuSa9uJEd62E/image.png) Give the file a revealing name so that later you can remember the contents (e.g."Crypto Balance"), in order to do this click in the upper left where there is the area concerning the title and fit in the name you chose (in my case "Crypto Balance"). ![](https://steemitimages.com/DQmTsVCoqF5ezADrygWR5VFgckaYhEWb573dWYNE7pHs38o/image.png) ### Complete transactions list (optional) If you want to have a transaction history regardless of the exchange I suggest you to begin from a similar scheme: ![](https://steemitimages.com/DQmS9hPYRYKeW7v4G6USxSAPQH63uk9fazpVv9H5f48SttU/image.png) Here the instructions for the fields: * Date = Fill in the date of the transaction, I suggest you the format %YYYY-%MM-%DD %HH:%mm (e.g. `2018-04-03 22:50`) * Action = Short description of the transaction done, e.g. `DEP SEPA` in order to indicate a sepa transfer * Earned crypto = What is the earned value from the transaction * Description = A complete description of the transaction e.g. `Sepa Deposit towards Kraken` * FIAT deposited = In case of investment in euros I suggest you to fill in this field for the following steps * Spent Value = In case of spending a crypto you have to fill in this field, e.g. `-5000 BTC` * Result = Profit and/or loss as regarding crypto, e.g. `+20000 ETH` * Exchange = Where the transaction happened * Wallet Src / Wallet Dst = In case of crypto transfer you need to indicate the name of the wallet, e.g. in source `Kraken` and in dest `Ledger` You can add any kind of field, feel free to modify it as much as you like. ### Prices and profit/losses in real-time In order to know in real-time the prices of a token or a coin we will rely on the API of [https://coinmarketcap.com/](CoinMarketCap) (well-known website regarding crypto). If you already done a transactions list I suggest you to create a new file clicking on the icon "+" in the lower left ![](https://steemitimages.com/DQmdsdfAvyGt3hYfvYd8sL37LTwV15LRG5ff1W3ER9XHegH/image.png) At this point it is necessary to add a function in google scripts in order to have the real-time updating. Open the menu "Tools" and go to the item `Script Editor` ![](https://steemitimages.com/DQmSubsypBv4zvxcTpcCfQK1MbDdEEB71v5yQGVpgj6B7Uj/image.png) It will open a parallel tab with a similar content: ![](https://steemitimages.com/DQmY5ocDJFcM55z8F997DRTYdkv3gKzvKjbeGXmPEHVgYe8/image.png) Delete completely the content and fill in as follows: **Price in EUR** ``` function ccprice(name) { var url = "https://api.coinmarketcap.com/v1/ticker/" + name + "/?convert=EUR"; var response = UrlFetchApp.fetch(url); var json = response.getContentText(); var data = JSON.parse(json); var price = parseFloat(data[0]["price_eur"]) return price } ``` **Price in USD** ``` function ccprice(name) { var url = "https://api.coinmarketcap.com/v1/ticker/" + name + "/"; var response = UrlFetchApp.fetch(url); var json = response.getContentText(); var data = JSON.parse(json); var price = parseFloat(data[0]["price_usd"]) return price } ``` (Modified version of the script https://github.com/rathergood/Crypto-Currency-Price/) Now click on save on the top left ![](https://steemitimages.com/DQmc92JEwZU1qw15ZCNpUzVTycrYvRkdQ8674LB4cBxi4ML/image.png) Fill in the name ```ccprice``` The final result should be something like this: ![](https://steemitimages.com/DQmZraZtHY2wpaP7QXKJG5T7XwAWRVww8zEjaHXcDW2zL8s/image.png) Perfect, now you can close those tabs and go back to our file. Create a scheme similar as it follows (if you want USD use usd name): ![](https://steemitimages.com/DQmbodkwwJqsm14X8AoB6GQUzGsAT7E2bi3AQnnKPrKvDap/image.png) In the first filed fill in the name of the coin or the token, e.g. `Bitcoin`. ![](https://steemitimages.com/DQmXtueY8mLD8JKAstDsyPZF9fDQKqvrHU2EHGnaaS17kcx/image.png) In the second field we will recall the function that we created few minutes ago in this way: ```=ccprice("<NAME OF COIN/TOKEN>")``` e.g. ```=ccprice("Bitcoin")``` In order to fill in it correctly click on the filed and then on the top left in the space preceded by the writing `fx` ![](https://steemitimages.com/DQmR9Kg81epPz42fz9xkk1M1VfQpXdNX7TG1ZeehutPuPsu/image.png) Now you have to write exactly like we said before, e.g. ![](https://steemitimages.com/DQmcQ6uK2cPLmQo2pdAAqV8bWKDmiNh8Y3XBtytoRMvoR9G/image.png) Push the enter key and you will have the real-time price. Let's fill in the field "Hold num", you have to insert the number of the coin or the token that you have got in numeric value, e.g. `10000000` ![](https://steemitimages.com/DQmRM7fwYwbZwW6FJEZxEEkAH6LfDNT65mJUmpeZhJzjqfh/image.png) Finally fill in the field "Total in euro" (or usd) as it follows in order to calculate exactly what is the current price of your coin in comparison with euros ```=B2*C2``` The result should be something like it follows: ![](https://steemitimages.com/DQmPJotaxLreKjdZLC9wbzuzV3deMrikikntkBwkjSFijdC/image.png) Repeat the transaction for every coin/token that you have. **Beware** of the name of the coin, remember that coins or tokens that contain spaces have to be replaces with "-", e.g. `Bitcoin Cash` become `bitcoin-cash`. ### Recap profit/ losses If you did all the previous steps for the next one you will just have to apply a little bit of maths in order to have a general recap of what it is happening. I suggest you a scheme like it follows: ![](https://steemitimages.com/DQmeLDACEQp8MwyynuwFSeuyo3upq9NJ7cSXVC8UV2jwshw/image.png) Now let's fill in the first field "FIAT deposited" and here there are two possible scenarios: #### Scenario No 1: You have followed the step "Completed transactions list" and you have the field "FIAT deposited" In the field write `=SUM(` go back to the first file and select *ALL* the lines relating to the field "FIAT deposited" (remember to update the function in case you add something to the list), the result should be something similar to this: ```=SUM('Transaction list'!E2:E5)``` Now push the enter key and in the first field you will have the total amount of euros #### Scenario No 2: You DON'T have followed the step "Completed transactions list" So fill in manually the total amount of euros in the field In both cases you should be confronted with a similar situation: ![](https://steemitimages.com/DQmfPoFLYqG7vTbP7R1gg9UC5rp1sFXShBX6JxwT7yGetf7/image.png) Now let's see the field "Current Total in FIAT", select it and write `=SUM(` and select *ALL* the lines regarding the field "Total in EUR" that we created before: ![](https://steemitimages.com/DQmXk4RhvMaVvUxwhW78Vcw7ocNxeL2BCPeYCbi5z1RbD43/image.png) Push the enter key: ![](https://steemitimages.com/DQmQvpXt8PYCBR2bRFXqSZKxdW8acEkRqH8B3HkfhQY7mTW/image.png) Now let's fill in also the "Total Profit" field Obviously the total of profit will consist of the current total less the total introduced, at this point we can fit in the formula ```=<No cell total profit>-<No cell total introduced>``` In my case for example is¨: ```=G2-F2``` ![](https://steemitimages.com/DQmNfZQqgdpYidNed8dGXMSVh4vVn5Be7cRETiN54jC9sQT/image.png) Let's now calculate the percentage of profit This will consist of the current total DIVIDED the total introduced ```=<No cell total profit>/<No cell total introduced>``` In my case for example is: ```=G2/F2``` #### Now let's give this the finishing touches in order to make it easier to read In the field "Total in euros", "Total introduced euros", "Current total" e "Total profit" do this: * Select the column * Open the menu Format-> Number and select "Currency" ![](https://steemitimages.com/DQmTKoyQnakBjh7cH3CnyZnLnetdkTQhXjLaxNwX4u7PmLN/image.png) While in the field "Percentage profit" do like it follows: * Select the column * Open the menu Format -> Number and select "Percentage" The result should be something like it follows: ![](https://steemitimages.com/DQmPBhxr5NCPiNJuajoDNpdBLWUJxTbgKPrhkMQH4BBSsvs/image.png) I hope this guide helped you :) See you to the next one,
json metadata{"tags":["howto","market","trending","bitcoin","cryptocurrency"],"image":["https://steemitimages.com/DQmWnnhhUZ3Ca7Rmf8Kg6LMacBEciszNDtBTuSa9uJEd62E/image.png","https://steemitimages.com/DQmTsVCoqF5ezADrygWR5VFgckaYhEWb573dWYNE7pHs38o/image.png","https://steemitimages.com/DQmS9hPYRYKeW7v4G6USxSAPQH63uk9fazpVv9H5f48SttU/image.png","https://steemitimages.com/DQmdsdfAvyGt3hYfvYd8sL37LTwV15LRG5ff1W3ER9XHegH/image.png","https://steemitimages.com/DQmSubsypBv4zvxcTpcCfQK1MbDdEEB71v5yQGVpgj6B7Uj/image.png","https://steemitimages.com/DQmY5ocDJFcM55z8F997DRTYdkv3gKzvKjbeGXmPEHVgYe8/image.png","https://steemitimages.com/DQmc92JEwZU1qw15ZCNpUzVTycrYvRkdQ8674LB4cBxi4ML/image.png","https://steemitimages.com/DQmZraZtHY2wpaP7QXKJG5T7XwAWRVww8zEjaHXcDW2zL8s/image.png","https://steemitimages.com/DQmbodkwwJqsm14X8AoB6GQUzGsAT7E2bi3AQnnKPrKvDap/image.png","https://steemitimages.com/DQmXtueY8mLD8JKAstDsyPZF9fDQKqvrHU2EHGnaaS17kcx/image.png","https://steemitimages.com/DQmR9Kg81epPz42fz9xkk1M1VfQpXdNX7TG1ZeehutPuPsu/image.png","https://steemitimages.com/DQmcQ6uK2cPLmQo2pdAAqV8bWKDmiNh8Y3XBtytoRMvoR9G/image.png","https://steemitimages.com/DQmRM7fwYwbZwW6FJEZxEEkAH6LfDNT65mJUmpeZhJzjqfh/image.png","https://steemitimages.com/DQmPJotaxLreKjdZLC9wbzuzV3deMrikikntkBwkjSFijdC/image.png","https://steemitimages.com/DQmeLDACEQp8MwyynuwFSeuyo3upq9NJ7cSXVC8UV2jwshw/image.png","https://steemitimages.com/DQmfPoFLYqG7vTbP7R1gg9UC5rp1sFXShBX6JxwT7yGetf7/image.png","https://steemitimages.com/DQmXk4RhvMaVvUxwhW78Vcw7ocNxeL2BCPeYCbi5z1RbD43/image.png","https://steemitimages.com/DQmQvpXt8PYCBR2bRFXqSZKxdW8acEkRqH8B3HkfhQY7mTW/image.png","https://steemitimages.com/DQmNfZQqgdpYidNed8dGXMSVh4vVn5Be7cRETiN54jC9sQT/image.png","https://steemitimages.com/DQmTKoyQnakBjh7cH3CnyZnLnetdkTQhXjLaxNwX4u7PmLN/image.png","https://steemitimages.com/DQmPBhxr5NCPiNJuajoDNpdBLWUJxTbgKPrhkMQH4BBSsvs/image.png"],"links":["https://docs.google.com/spreadsheets/","CoinMarketCap","https://github.com/rathergood/Crypto-Currency-Price/"],"app":"steemit/0.1","format":"markdown"}
parent author
parent permlinkhowto
permlinkhow-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending
titleHow to create a Google docs in order to track the real-time crypto trending
Transaction InfoBlock #21309586/Trx 9856f4d761dd7f323586fbf8a7528223a0c4584b
View Raw JSON Data
{
  "block": 21309586,
  "op": [
    "comment",
    {
      "author": "mirio",
      "body": "## Introduction \n\nThe aim of this guide is to help either the newbies or the experts to keep track of the continuous change of the market without using a subscription service or the access to specific websites against payment of a fee. \n\nThis guide will help you make: \n\n* A list of real-time prices\n\n* A complete list of transactions (optional)\n\n* A complete recap of your situation within the crypto (profit, losses...)\n\n\n## Prerequisite\n\n* Google Account\n\n\n## Step-by-Step process\n\nGo to [Google Docs Spreadsheets](https://docs.google.com/spreadsheets/) and create a new file clicking the icon \"+\"\n\n\n![](https://steemitimages.com/DQmWnnhhUZ3Ca7Rmf8Kg6LMacBEciszNDtBTuSa9uJEd62E/image.png)\n\n\nGive the file a revealing name so that later you can remember the contents (e.g.\"Crypto Balance\"), in order to do this click in the upper left where there is the area concerning the title and fit in the name you chose (in my case \"Crypto Balance\").\n\n\n![](https://steemitimages.com/DQmTsVCoqF5ezADrygWR5VFgckaYhEWb573dWYNE7pHs38o/image.png)\n\n\n### Complete transactions list (optional)\n\nIf you want to have a transaction history regardless of the exchange I suggest you to begin from a similar scheme:\n\n![](https://steemitimages.com/DQmS9hPYRYKeW7v4G6USxSAPQH63uk9fazpVv9H5f48SttU/image.png)\n\nHere the instructions for the fields:\n\n* Date = Fill in the date of the transaction, I suggest you the format %YYYY-%MM-%DD %HH:%mm (e.g. `2018-04-03 22:50`)\n\n* Action = Short description of the transaction done, e.g. `DEP SEPA` in order to indicate a sepa transfer\n\n* Earned crypto = What is the earned value from the transaction\n\n* Description = A complete description of the transaction e.g. `Sepa Deposit towards Kraken`\n\n* FIAT deposited = In case of investment in euros I suggest you to fill in this field for the following steps\n\n* Spent Value = In case of spending a crypto you have to fill in this field, e.g. `-5000 BTC`\n\n* Result = Profit and/or loss as regarding crypto, e.g. `+20000 ETH`\n\n* Exchange = Where the transaction happened\n\n* Wallet Src / Wallet Dst = In case of crypto transfer you need to indicate the name of the wallet, e.g. in source `Kraken` and in dest `Ledger`\n\n\nYou can add any kind of field, feel free to modify it as much as you like.\n\n\n### Prices and profit/losses in real-time\n\nIn order to know in real-time the prices of a token or a coin we will rely on the API of [https://coinmarketcap.com/](CoinMarketCap) (well-known website regarding crypto).\n\nIf you already done a transactions list I suggest you to create a new file clicking on the icon \"+\" in the lower left\n\n![](https://steemitimages.com/DQmdsdfAvyGt3hYfvYd8sL37LTwV15LRG5ff1W3ER9XHegH/image.png)\n\nAt this point it is necessary to add a function in google scripts in order to have the real-time updating. \n\nOpen the menu \"Tools\" and go to the item `Script Editor`\n\n![](https://steemitimages.com/DQmSubsypBv4zvxcTpcCfQK1MbDdEEB71v5yQGVpgj6B7Uj/image.png)\n\nIt will open a parallel tab with a similar content:\n\n![](https://steemitimages.com/DQmY5ocDJFcM55z8F997DRTYdkv3gKzvKjbeGXmPEHVgYe8/image.png)\n\nDelete completely the content and fill in as follows: \n\n**Price in EUR**\n```\nfunction ccprice(name) {\n    var url = \"https://api.coinmarketcap.com/v1/ticker/\" + name + \"/?convert=EUR\";\n    var response = UrlFetchApp.fetch(url);\n    var json = response.getContentText();\n    var data = JSON.parse(json);\n    var price = parseFloat(data[0][\"price_eur\"]) \n    return price\n}\n```\n**Price in USD**\n```\nfunction ccprice(name) {\n    var url = \"https://api.coinmarketcap.com/v1/ticker/\" + name + \"/\";\n    var response = UrlFetchApp.fetch(url);\n    var json = response.getContentText();\n    var data = JSON.parse(json);\n    var price = parseFloat(data[0][\"price_usd\"]) \n    return price\n}\n```\n\n\n(Modified version of the script https://github.com/rathergood/Crypto-Currency-Price/)\n\n\nNow click on save on the top left\n\n\n![](https://steemitimages.com/DQmc92JEwZU1qw15ZCNpUzVTycrYvRkdQ8674LB4cBxi4ML/image.png)\n\nFill in the name ```ccprice```\n\n\nThe final result should be something like this:\n\n![](https://steemitimages.com/DQmZraZtHY2wpaP7QXKJG5T7XwAWRVww8zEjaHXcDW2zL8s/image.png)\n\n\nPerfect, now you can close those tabs and go back to our file.\n\n\nCreate a scheme similar as it follows (if you want USD use usd name):\n\n![](https://steemitimages.com/DQmbodkwwJqsm14X8AoB6GQUzGsAT7E2bi3AQnnKPrKvDap/image.png)\n\nIn the first filed fill in the name of the coin or the token, e.g. `Bitcoin`.\n\n![](https://steemitimages.com/DQmXtueY8mLD8JKAstDsyPZF9fDQKqvrHU2EHGnaaS17kcx/image.png)\n\nIn the second field we will recall the function that we created few minutes ago in this way:\n\n```=ccprice(\"<NAME OF COIN/TOKEN>\")```\n\ne.g.\n\n```=ccprice(\"Bitcoin\")```\n\n\nIn order to fill in it correctly click on the filed and then on the top left in the space preceded by the writing `fx`\n\n![](https://steemitimages.com/DQmR9Kg81epPz42fz9xkk1M1VfQpXdNX7TG1ZeehutPuPsu/image.png)\n\nNow you have to write exactly like we said before, e.g.\n\n![](https://steemitimages.com/DQmcQ6uK2cPLmQo2pdAAqV8bWKDmiNh8Y3XBtytoRMvoR9G/image.png)\n\nPush the enter key and you will have the real-time price.\n\n\nLet's fill in the field \"Hold num\", you have to insert the number of the coin or the token that you have got in numeric value, e.g. `10000000`\n\n\n![](https://steemitimages.com/DQmRM7fwYwbZwW6FJEZxEEkAH6LfDNT65mJUmpeZhJzjqfh/image.png)\n\n\nFinally fill in the field \"Total in euro\" (or usd) as it follows in order to calculate exactly what is the current price of your coin in comparison with euros\n\n\n```=B2*C2```\n\n\nThe result should be something like it follows:\n\n![](https://steemitimages.com/DQmPJotaxLreKjdZLC9wbzuzV3deMrikikntkBwkjSFijdC/image.png)\n\nRepeat the transaction for every coin/token that you have. \n**Beware** of the name of the coin, remember that coins or tokens that contain spaces have to be replaces with \"-\", e.g. `Bitcoin Cash` become `bitcoin-cash`.\n\n\n### Recap profit/ losses\n\nIf you did all the previous steps for the next one you will just have to apply a little bit of maths in order to have a general recap of what it is happening. \n\n\nI suggest you a scheme like it follows:\n\n![](https://steemitimages.com/DQmeLDACEQp8MwyynuwFSeuyo3upq9NJ7cSXVC8UV2jwshw/image.png)\n\nNow let's fill in the first field \"FIAT deposited\" and here there are two possible scenarios: \n\n\n#### Scenario No 1: You have followed the step \"Completed transactions list\" and you have the field \"FIAT deposited\"\n\n\nIn the field write `=SUM(` go back to the first file and select *ALL* the lines relating to the field \"FIAT deposited\" (remember to update the function in case you add something to the list), the result should be something similar to this:\n\n\n```=SUM('Transaction list'!E2:E5)```\n\n\nNow push the enter key and in the first field you will have the total amount of euros\n\n\n#### Scenario No 2: You DON'T have followed the step \"Completed transactions list\"\n\nSo fill in manually the total amount of euros in the field\n\n\nIn both cases you should be confronted with a similar situation:\n\n![](https://steemitimages.com/DQmfPoFLYqG7vTbP7R1gg9UC5rp1sFXShBX6JxwT7yGetf7/image.png)\n\nNow let's see the field \"Current Total in FIAT\", select it and write `=SUM(` and select *ALL* the lines regarding the field \"Total in EUR\" that we created before:\n\n![](https://steemitimages.com/DQmXk4RhvMaVvUxwhW78Vcw7ocNxeL2BCPeYCbi5z1RbD43/image.png)\n\nPush the enter key:\n\n![](https://steemitimages.com/DQmQvpXt8PYCBR2bRFXqSZKxdW8acEkRqH8B3HkfhQY7mTW/image.png)\n\nNow let's fill in also the \"Total Profit\" field\n\nObviously the total of profit will consist of the current total less the total introduced, at this point we can fit in the formula\n\n\n```=<No cell total profit>-<No cell total introduced>```\n\n\nIn my case for example is¨:\n\n```=G2-F2```\n\n![](https://steemitimages.com/DQmNfZQqgdpYidNed8dGXMSVh4vVn5Be7cRETiN54jC9sQT/image.png)\n\nLet's now calculate the percentage of profit\n\nThis will consist of the current total DIVIDED the total introduced\n\n```=<No cell total profit>/<No cell total introduced>```\n\n\nIn my case for example is:\n\n```=G2/F2```\n\n\n#### Now let's give this the finishing touches in order to make it easier to read\n\n\nIn the field \"Total in euros\", \"Total introduced euros\", \"Current total\" e \"Total profit\" do this:\n\n* Select the column\n\n* Open the menu Format-> Number and select \"Currency\"\n\n![](https://steemitimages.com/DQmTKoyQnakBjh7cH3CnyZnLnetdkTQhXjLaxNwX4u7PmLN/image.png)\n\nWhile in the field \"Percentage profit\" do like it follows:\n\n* Select the column\n\n* Open the menu Format -> Number and select \"Percentage\"\n\n\nThe result should be something like it follows:\n\n![](https://steemitimages.com/DQmPBhxr5NCPiNJuajoDNpdBLWUJxTbgKPrhkMQH4BBSsvs/image.png)\n\nI hope this guide helped you :) \nSee you to the next one,",
      "json_metadata": "{\"tags\":[\"howto\",\"market\",\"trending\",\"bitcoin\",\"cryptocurrency\"],\"image\":[\"https://steemitimages.com/DQmWnnhhUZ3Ca7Rmf8Kg6LMacBEciszNDtBTuSa9uJEd62E/image.png\",\"https://steemitimages.com/DQmTsVCoqF5ezADrygWR5VFgckaYhEWb573dWYNE7pHs38o/image.png\",\"https://steemitimages.com/DQmS9hPYRYKeW7v4G6USxSAPQH63uk9fazpVv9H5f48SttU/image.png\",\"https://steemitimages.com/DQmdsdfAvyGt3hYfvYd8sL37LTwV15LRG5ff1W3ER9XHegH/image.png\",\"https://steemitimages.com/DQmSubsypBv4zvxcTpcCfQK1MbDdEEB71v5yQGVpgj6B7Uj/image.png\",\"https://steemitimages.com/DQmY5ocDJFcM55z8F997DRTYdkv3gKzvKjbeGXmPEHVgYe8/image.png\",\"https://steemitimages.com/DQmc92JEwZU1qw15ZCNpUzVTycrYvRkdQ8674LB4cBxi4ML/image.png\",\"https://steemitimages.com/DQmZraZtHY2wpaP7QXKJG5T7XwAWRVww8zEjaHXcDW2zL8s/image.png\",\"https://steemitimages.com/DQmbodkwwJqsm14X8AoB6GQUzGsAT7E2bi3AQnnKPrKvDap/image.png\",\"https://steemitimages.com/DQmXtueY8mLD8JKAstDsyPZF9fDQKqvrHU2EHGnaaS17kcx/image.png\",\"https://steemitimages.com/DQmR9Kg81epPz42fz9xkk1M1VfQpXdNX7TG1ZeehutPuPsu/image.png\",\"https://steemitimages.com/DQmcQ6uK2cPLmQo2pdAAqV8bWKDmiNh8Y3XBtytoRMvoR9G/image.png\",\"https://steemitimages.com/DQmRM7fwYwbZwW6FJEZxEEkAH6LfDNT65mJUmpeZhJzjqfh/image.png\",\"https://steemitimages.com/DQmPJotaxLreKjdZLC9wbzuzV3deMrikikntkBwkjSFijdC/image.png\",\"https://steemitimages.com/DQmeLDACEQp8MwyynuwFSeuyo3upq9NJ7cSXVC8UV2jwshw/image.png\",\"https://steemitimages.com/DQmfPoFLYqG7vTbP7R1gg9UC5rp1sFXShBX6JxwT7yGetf7/image.png\",\"https://steemitimages.com/DQmXk4RhvMaVvUxwhW78Vcw7ocNxeL2BCPeYCbi5z1RbD43/image.png\",\"https://steemitimages.com/DQmQvpXt8PYCBR2bRFXqSZKxdW8acEkRqH8B3HkfhQY7mTW/image.png\",\"https://steemitimages.com/DQmNfZQqgdpYidNed8dGXMSVh4vVn5Be7cRETiN54jC9sQT/image.png\",\"https://steemitimages.com/DQmTKoyQnakBjh7cH3CnyZnLnetdkTQhXjLaxNwX4u7PmLN/image.png\",\"https://steemitimages.com/DQmPBhxr5NCPiNJuajoDNpdBLWUJxTbgKPrhkMQH4BBSsvs/image.png\"],\"links\":[\"https://docs.google.com/spreadsheets/\",\"CoinMarketCap\",\"https://github.com/rathergood/Crypto-Currency-Price/\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "howto",
      "permlink": "how-to-create-a-google-docs-in-order-to-track-the-real-time-crypto-trending",
      "title": "How to create a Google docs in order to track the real-time crypto trending"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-05T20:01:48",
  "trx_id": "9856f4d761dd7f323586fbf8a7528223a0c4584b",
  "trx_in_block": 13,
  "virtual_op": 0
}
steemdelegated 18.685 SP to @mirio
2018/04/02 20:43:48
delegateemirio
delegatorsteem
vesting shares30388.698406 VESTS
Transaction InfoBlock #21224043/Trx 6f056a46959ace1694bfb4db6d764ed9475b30d0
View Raw JSON Data
{
  "block": 21224043,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "mirio",
      "delegator": "steem",
      "vesting_shares": "30388.698406 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-02T20:43:48",
  "trx_id": "6f056a46959ace1694bfb4db6d764ed9475b30d0",
  "trx_in_block": 49,
  "virtual_op": 0
}
steemcreated a new account: @mirio
2018/04/02 18:31:24
active{"account_auths":[],"key_auths":[["STM684Kin4Lh1moLDVXgP2fNy5de2vtHdFPGB46s7stgNAhMZU6Ta",1]],"weight_threshold":1}
creatorsteem
delegation30690.000000 VESTS
extensions[]
fee0.100 STEEM
json metadata{}
memo keySTM7EMAJvjZXWAmZBCi6pDJ1CtQ1DA6bBMARarjeL57xWHSGeUgnJ
new account namemirio
owner{"account_auths":[],"key_auths":[["STM6DyUV9BLkSw4wTLNx6mBjU3WUcXp3H1PqwBj6DG9Jjp3fVPykY",1]],"weight_threshold":1}
posting{"account_auths":[],"key_auths":[["STM5rieH4u1QGstCvsoo4d85rwQdgevC5HeqJTByLsBv26XKPmtPo",1]],"weight_threshold":1}
Transaction InfoBlock #21221395/Trx 2a676f6ca5f6b984b07f053db24cd99a591cc6fd
View Raw JSON Data
{
  "block": 21221395,
  "op": [
    "account_create_with_delegation",
    {
      "active": {
        "account_auths": [],
        "key_auths": [
          [
            "STM684Kin4Lh1moLDVXgP2fNy5de2vtHdFPGB46s7stgNAhMZU6Ta",
            1
          ]
        ],
        "weight_threshold": 1
      },
      "creator": "steem",
      "delegation": "30690.000000 VESTS",
      "extensions": [],
      "fee": "0.100 STEEM",
      "json_metadata": "{}",
      "memo_key": "STM7EMAJvjZXWAmZBCi6pDJ1CtQ1DA6bBMARarjeL57xWHSGeUgnJ",
      "new_account_name": "mirio",
      "owner": {
        "account_auths": [],
        "key_auths": [
          [
            "STM6DyUV9BLkSw4wTLNx6mBjU3WUcXp3H1PqwBj6DG9Jjp3fVPykY",
            1
          ]
        ],
        "weight_threshold": 1
      },
      "posting": {
        "account_auths": [],
        "key_auths": [
          [
            "STM5rieH4u1QGstCvsoo4d85rwQdgevC5HeqJTByLsBv26XKPmtPo",
            1
          ]
        ],
        "weight_threshold": 1
      }
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-02T18:31:24",
  "trx_id": "2a676f6ca5f6b984b07f053db24cd99a591cc6fd",
  "trx_in_block": 3,
  "virtual_op": 0
}

Account Metadata

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

Auth Keys

Owner
Single Signature
Public Keys
STM6DyUV9BLkSw4wTLNx6mBjU3WUcXp3H1PqwBj6DG9Jjp3fVPykY1/1
Active
Single Signature
Public Keys
STM684Kin4Lh1moLDVXgP2fNy5de2vtHdFPGB46s7stgNAhMZU6Ta1/1
Posting
Single Signature
Public Keys
STM5rieH4u1QGstCvsoo4d85rwQdgevC5HeqJTByLsBv26XKPmtPo1/1
Memo
STM7EMAJvjZXWAmZBCi6pDJ1CtQ1DA6bBMARarjeL57xWHSGeUgnJ
{
  "owner": {
    "account_auths": [],
    "key_auths": [
      [
        "STM6DyUV9BLkSw4wTLNx6mBjU3WUcXp3H1PqwBj6DG9Jjp3fVPykY",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "active": {
    "account_auths": [],
    "key_auths": [
      [
        "STM684Kin4Lh1moLDVXgP2fNy5de2vtHdFPGB46s7stgNAhMZU6Ta",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "posting": {
    "account_auths": [],
    "key_auths": [
      [
        "STM5rieH4u1QGstCvsoo4d85rwQdgevC5HeqJTByLsBv26XKPmtPo",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "memo": "STM7EMAJvjZXWAmZBCi6pDJ1CtQ1DA6bBMARarjeL57xWHSGeUgnJ"
}

Witness Votes

0 / 30
No active witness votes.
[]