Ecoer Logo

@jaffasoft

25

Hippie

steemit.com/@jaffasoft
VOTING POWER100.00%
DOWNVOTE POWER100.00%
RESOURCE CREDITS100.00%
REPUTATION PROGRESS0.00%
Net Worth
0.034USD
STEEM
0.000STEEM
SBD
0.000SBD
Effective Power
5.001SP
├── Own SP
0.630SP
└── Incoming Deleg
+4.371SP

Detailed Balance

STEEM
balance
0.000STEEM
market_balance
0.000STEEM
savings_balance
0.000STEEM
reward_steem_balance
0.000STEEM
STEEM POWER
Own SP
0.630SP
Delegated Out
0.000SP
Delegation In
4.371SP
Effective Power
5.001SP
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": "1026.315682 VESTS",
  "delegated_vesting_shares": "0.000000 VESTS",
  "received_vesting_shares": "7117.344124 VESTS",
  "sbd_balance": "0.000 SBD",
  "savings_sbd_balance": "0.000 SBD",
  "reward_sbd_balance": "0.000 SBD",
  "conversions": []
}

Account Info

namejaffasoft
id466453
rank802,844
reputation5898270
created2017-11-28T11:12:30
recovery_accountsteem
proxyNone
post_count5
comment_count0
lifetime_vote_count0
witnesses_voted_for0
last_post2018-06-12T23:08:12
last_root_post2018-06-12T23:08:12
last_vote_time2018-08-10T00:14:42
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_shares1026.315682 VESTS
delegated_vesting_shares0.000000 VESTS
received_vesting_shares7117.344124 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_update2018-06-05T13:38:24
minedNo
sbd_seconds0
sbd_last_interest_payment1970-01-01T00:00:00
savings_sbd_last_interest_payment1970-01-01T00:00:00
{
  "id": 466453,
  "name": "jaffasoft",
  "owner": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM7gYgnDqAmqJYErAhhK23SeATVUsTqWtSjJ1U9cjEG6G4FWHeQq",
        1
      ]
    ]
  },
  "active": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM59mYDKWm3dQ4AfPrUxLdrBz7mBsJTHi4m1RRNUXaYJT1KyYv5Y",
        1
      ]
    ]
  },
  "posting": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM8eienpyJ5Lqc31ZAQyHGELGPMF2ARpJN2i7H8Cg5C8CVAn45ah",
        1
      ]
    ]
  },
  "memo_key": "STM5MUBdSHD5qvSjzNR5kC6D59ggaR77T5agWDtua44eUvGPfXMZg",
  "json_metadata": "{\"profile\":{\"name\":\"Jaffasoft\",\"about\":\"Hippie \",\"location\":\"Northern Rivers, NSW,Australia\",\"profile_image\":\"https://cdn.steemitimages.com/DQmYTmKpNnfycnRmmNhUghdPZFW2FBKBsjJB45ppjjK4VEk/Screen%20Shot%202018-01-22%20at%2011.07.21%20pm.png\"}}",
  "posting_json_metadata": "{\"profile\":{\"name\":\"Jaffasoft\",\"about\":\"Hippie \",\"location\":\"Northern Rivers, NSW,Australia\",\"profile_image\":\"https://cdn.steemitimages.com/DQmYTmKpNnfycnRmmNhUghdPZFW2FBKBsjJB45ppjjK4VEk/Screen%20Shot%202018-01-22%20at%2011.07.21%20pm.png\"}}",
  "proxy": "",
  "last_owner_update": "1970-01-01T00:00:00",
  "last_account_update": "2018-06-05T13:38:24",
  "created": "2017-11-28T11:12:30",
  "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": 5,
  "can_vote": true,
  "voting_manabar": {
    "current_mana": "8143659806",
    "last_update_time": 1779068286
  },
  "downvote_manabar": {
    "current_mana": 2035914951,
    "last_update_time": 1779068286
  },
  "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": "0.000 SBD",
  "reward_steem_balance": "0.000 STEEM",
  "reward_vesting_balance": "0.000000 VESTS",
  "reward_vesting_steem": "0.000 STEEM",
  "vesting_shares": "1026.315682 VESTS",
  "delegated_vesting_shares": "0.000000 VESTS",
  "received_vesting_shares": "7117.344124 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": 0,
  "proxied_vsf_votes": [
    0,
    0,
    0,
    0
  ],
  "witnesses_voted_for": 0,
  "last_post": "2018-06-12T23:08:12",
  "last_root_post": "2018-06-12T23:08:12",
  "last_vote_time": "2018-08-10T00:14:42",
  "post_bandwidth": 0,
  "pending_claimed_accounts": 0,
  "vesting_balance": "0.000 STEEM",
  "reputation": 5898270,
  "transfer_history": [],
  "market_history": [],
  "post_history": [],
  "vote_history": [],
  "other_history": [],
  "witness_votes": [],
  "tags_usage": [],
  "guest_bloggers": [],
  "rank": 802844
}

Withdraw Routes

IncomingOutgoing
Empty
Empty
{
  "incoming": [],
  "outgoing": []
}
From Date
To Date
steemdelegated 4.371 SP to @jaffasoft
2026/05/18 01:38:06
delegatorsteem
delegateejaffasoft
vesting shares7117.344124 VESTS
Transaction InfoBlock #106145097/Trx 02a46b80ee39f109356752ae7ed7116c6044dd0c
View Raw JSON Data
{
  "trx_id": "02a46b80ee39f109356752ae7ed7116c6044dd0c",
  "block": 106145097,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2026-05-18T01:38:06",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "7117.344124 VESTS"
    }
  ]
}
steemdelegated 2.705 SP to @jaffasoft
2026/05/12 09:27:24
delegatorsteem
delegateejaffasoft
vesting shares4405.133719 VESTS
Transaction InfoBlock #105982437/Trx ae2df5a799dcb7e5461276f8bb950dec975b5c57
View Raw JSON Data
{
  "trx_id": "ae2df5a799dcb7e5461276f8bb950dec975b5c57",
  "block": 105982437,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2026-05-12T09:27:24",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "4405.133719 VESTS"
    }
  ]
}
steemdelegated 4.378 SP to @jaffasoft
2026/04/26 00:56:48
delegatorsteem
delegateejaffasoft
vesting shares7129.859880 VESTS
Transaction InfoBlock #105512711/Trx 3e7fd3dae8190fa6ea97f6c894e62ac5f9323615
View Raw JSON Data
{
  "trx_id": "3e7fd3dae8190fa6ea97f6c894e62ac5f9323615",
  "block": 105512711,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2026-04-26T00:56:48",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "7129.859880 VESTS"
    }
  ]
}
steemdelegated 2.731 SP to @jaffasoft
2026/01/23 11:31:24
delegatorsteem
delegateejaffasoft
vesting shares4446.680538 VESTS
Transaction InfoBlock #102856272/Trx 192edae4cd117ab0f80ae8375d8214a65d8e5b95
View Raw JSON Data
{
  "trx_id": "192edae4cd117ab0f80ae8375d8214a65d8e5b95",
  "block": 102856272,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2026-01-23T11:31:24",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "4446.680538 VESTS"
    }
  ]
}
steemdelegated 2.832 SP to @jaffasoft
2024/12/17 06:48:39
delegatorsteem
delegateejaffasoft
vesting shares4610.899735 VESTS
Transaction InfoBlock #91302633/Trx 4f6ae08b4e1bb58e8e0e9131780b50b9ad269ec4
View Raw JSON Data
{
  "trx_id": "4f6ae08b4e1bb58e8e0e9131780b50b9ad269ec4",
  "block": 91302633,
  "trx_in_block": 3,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2024-12-17T06:48:39",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "4610.899735 VESTS"
    }
  ]
}
steemdelegated 2.935 SP to @jaffasoft
2023/11/13 22:30:42
delegatorsteem
delegateejaffasoft
vesting shares4780.033267 VESTS
Transaction InfoBlock #79856818/Trx a1dfcb7ce054baddd99b19b1ebaabc9d61d77a29
View Raw JSON Data
{
  "trx_id": "a1dfcb7ce054baddd99b19b1ebaabc9d61d77a29",
  "block": 79856818,
  "trx_in_block": 10,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2023-11-13T22:30:42",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "4780.033267 VESTS"
    }
  ]
}
steemdelegated 4.739 SP to @jaffasoft
2023/09/21 23:28:00
delegatorsteem
delegateejaffasoft
vesting shares7717.312053 VESTS
Transaction InfoBlock #78349788/Trx 0eb766b5159a3c548b5588526a9a935482c86cb1
View Raw JSON Data
{
  "trx_id": "0eb766b5159a3c548b5588526a9a935482c86cb1",
  "block": 78349788,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2023-09-21T23:28:00",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "7717.312053 VESTS"
    }
  ]
}
steemdelegated 4.875 SP to @jaffasoft
2022/11/03 13:02:33
delegatorsteem
delegateejaffasoft
vesting shares7938.993491 VESTS
Transaction InfoBlock #69114860/Trx 0609a8cb3a3b041dcb7c6f599bd860e9d270b910
View Raw JSON Data
{
  "trx_id": "0609a8cb3a3b041dcb7c6f599bd860e9d270b910",
  "block": 69114860,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-11-03T13:02:33",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "7938.993491 VESTS"
    }
  ]
}
steemdelegated 5.011 SP to @jaffasoft
2022/01/17 12:11:51
delegatorsteem
delegateejaffasoft
vesting shares8159.526722 VESTS
Transaction InfoBlock #60810896/Trx f08b808b0af661bc67291caef87f43277dff6b08
View Raw JSON Data
{
  "trx_id": "f08b808b0af661bc67291caef87f43277dff6b08",
  "block": 60810896,
  "trx_in_block": 4,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-01-17T12:11:51",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "8159.526722 VESTS"
    }
  ]
}
steemdelegated 5.124 SP to @jaffasoft
2021/06/14 02:03:39
delegatorsteem
delegateejaffasoft
vesting shares8343.295380 VESTS
Transaction InfoBlock #54609209/Trx e4c7cf7282a0057251ca3ace9ccd24ed55342e69
View Raw JSON Data
{
  "trx_id": "e4c7cf7282a0057251ca3ace9ccd24ed55342e69",
  "block": 54609209,
  "trx_in_block": 7,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-06-14T02:03:39",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "8343.295380 VESTS"
    }
  ]
}
steemdelegated 5.239 SP to @jaffasoft
2020/12/11 12:20:39
delegatorsteem
delegateejaffasoft
vesting shares8530.717354 VESTS
Transaction InfoBlock #49356615/Trx ed73a4a3ad6839b96c1d75efa353bae292d1b6ae
View Raw JSON Data
{
  "trx_id": "ed73a4a3ad6839b96c1d75efa353bae292d1b6ae",
  "block": 49356615,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2020-12-11T12:20:39",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "8530.717354 VESTS"
    }
  ]
}
steemdelegated 1.174 SP to @jaffasoft
2020/12/06 05:57:33
delegatorsteem
delegateejaffasoft
vesting shares1912.543513 VESTS
Transaction InfoBlock #49208173/Trx 28c2de3342caf8ef2298e57358e4249e7b32a39e
View Raw JSON Data
{
  "trx_id": "28c2de3342caf8ef2298e57358e4249e7b32a39e",
  "block": 49208173,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2020-12-06T05:57:33",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "1912.543513 VESTS"
    }
  ]
}
steemdelegated 5.242 SP to @jaffasoft
2020/12/05 15:58:33
delegatorsteem
delegateejaffasoft
vesting shares8536.925208 VESTS
Transaction InfoBlock #49191709/Trx 9a5c5c3aeee8c1f8b21540422526d37db476b988
View Raw JSON Data
{
  "trx_id": "9a5c5c3aeee8c1f8b21540422526d37db476b988",
  "block": 49191709,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2020-12-05T15:58:33",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "8536.925208 VESTS"
    }
  ]
}
steemdelegated 1.179 SP to @jaffasoft
2020/11/02 18:10:18
delegatorsteem
delegateejaffasoft
vesting shares1920.017158 VESTS
Transaction InfoBlock #48260786/Trx 173fdac2cd033723f98a710abdf760e8c6100e4b
View Raw JSON Data
{
  "trx_id": "173fdac2cd033723f98a710abdf760e8c6100e4b",
  "block": 48260786,
  "trx_in_block": 3,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2020-11-02T18:10:18",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "1920.017158 VESTS"
    }
  ]
}
steemdelegated 5.367 SP to @jaffasoft
2020/05/09 06:56:09
delegatorsteem
delegateejaffasoft
vesting shares8739.730567 VESTS
Transaction InfoBlock #43218438/Trx f3a04468961e614236f675d58453d76b3dd59601
View Raw JSON Data
{
  "trx_id": "f3a04468961e614236f675d58453d76b3dd59601",
  "block": 43218438,
  "trx_in_block": 16,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2020-05-09T06:56:09",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "8739.730567 VESTS"
    }
  ]
}
steemdelegated 1.200 SP to @jaffasoft
2020/05/08 10:43:12
delegatorsteem
delegateejaffasoft
vesting shares1953.311140 VESTS
Transaction InfoBlock #43194746/Trx 193d09f9033cf6847ddcd1d8e807133fd1e63365
View Raw JSON Data
{
  "trx_id": "193d09f9033cf6847ddcd1d8e807133fd1e63365",
  "block": 43194746,
  "trx_in_block": 5,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2020-05-08T10:43:12",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "1953.311140 VESTS"
    }
  ]
}
2019/11/28 12:14:00
parent authorjaffasoft
parent permlinkunlimited-crypto-buy-and-sell-layers-break-even-google-sheet
authorsteemitboard
permlinksteemitboard-notify-jaffasoft-20191128t121400000z
title
bodyCongratulations @jaffasoft! You received a personal award! <table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@jaffasoft/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table> <sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@jaffasoft) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=jaffasoft)_</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"]}
Transaction InfoBlock #38569569/Trx 1a230e03d095e69ef4900f723571119ec29ab0bf
View Raw JSON Data
{
  "trx_id": "1a230e03d095e69ef4900f723571119ec29ab0bf",
  "block": 38569569,
  "trx_in_block": 14,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2019-11-28T12:14:00",
  "op": [
    "comment",
    {
      "parent_author": "jaffasoft",
      "parent_permlink": "unlimited-crypto-buy-and-sell-layers-break-even-google-sheet",
      "author": "steemitboard",
      "permlink": "steemitboard-notify-jaffasoft-20191128t121400000z",
      "title": "",
      "body": "Congratulations @jaffasoft! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@jaffasoft/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table>\n\n<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@jaffasoft) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=jaffasoft)_</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\"]}"
    }
  ]
}
steemdelegated 5.432 SP to @jaffasoft
2019/11/01 08:03:12
delegatorsteem
delegateejaffasoft
vesting shares8846.129650 VESTS
Transaction InfoBlock #37788446/Trx c8ce16c70112a3adb6f6ecab7141665780c5f213
View Raw JSON Data
{
  "trx_id": "c8ce16c70112a3adb6f6ecab7141665780c5f213",
  "block": 37788446,
  "trx_in_block": 16,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2019-11-01T08:03:12",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "8846.129650 VESTS"
    }
  ]
}
2019/07/03 07:04:39
parent authorjaffasoft
parent permlinkcryptocurrency-break-even-point-google-sheet-formula-for-dummies
authorgazzerman
permlinkpu20xf
title
body@@ -256,17 +256,113 @@ purchase -. + or a sell. But the data is invaluable and once you have it you will never want to be without it! %0A%0AIn the
json metadata{"tags":["trading"],"links":["https://www.coinmarketman.com/blog/cryptocurrency-break-even-calculator/"],"app":"steemit/0.1"}
Transaction InfoBlock #34331979/Trx 077b569c3e1a43831dec391ba544a8d7ef10248a
View Raw JSON Data
{
  "trx_id": "077b569c3e1a43831dec391ba544a8d7ef10248a",
  "block": 34331979,
  "trx_in_block": 19,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2019-07-03T07:04:39",
  "op": [
    "comment",
    {
      "parent_author": "jaffasoft",
      "parent_permlink": "cryptocurrency-break-even-point-google-sheet-formula-for-dummies",
      "author": "gazzerman",
      "permlink": "pu20xf",
      "title": "",
      "body": "@@ -256,17 +256,113 @@\n purchase\n-.\n+ or a sell. But the data is invaluable and once you have it you will never want to be without it!\n %0A%0AIn the\n",
      "json_metadata": "{\"tags\":[\"trading\"],\"links\":[\"https://www.coinmarketman.com/blog/cryptocurrency-break-even-calculator/\"],\"app\":\"steemit/0.1\"}"
    }
  ]
}
2019/07/03 07:03:15
parent authorjaffasoft
parent permlinkcryptocurrency-break-even-point-google-sheet-formula-for-dummies
authorgazzerman
permlinkpu20xf
title
bodyWhat a great article, for those that want to track their progress on a manual basis, this really works well. Especially if you like to keep any trace of your holdings away from any external systems. The down side is you need to change the data with every purchase. In the last year there has been a wide range of new trackers on the market so that you can easily track your Break Even in real time as you trade. Here is an article showing you how https://www.coinmarketman.com/blog/cryptocurrency-break-even-calculator/
json metadata{"tags":["trading"],"links":["https://www.coinmarketman.com/blog/cryptocurrency-break-even-calculator/"],"app":"steemit/0.1"}
Transaction InfoBlock #34331951/Trx 1e8e905aa6c948d919a9bebfc180bd7d629505fc
View Raw JSON Data
{
  "trx_id": "1e8e905aa6c948d919a9bebfc180bd7d629505fc",
  "block": 34331951,
  "trx_in_block": 35,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2019-07-03T07:03:15",
  "op": [
    "comment",
    {
      "parent_author": "jaffasoft",
      "parent_permlink": "cryptocurrency-break-even-point-google-sheet-formula-for-dummies",
      "author": "gazzerman",
      "permlink": "pu20xf",
      "title": "",
      "body": "What a great article, for those that want to track their progress on a manual basis, this really works well. Especially if you like to keep any trace of your holdings away from any external systems. The down side is you need to change the data with every purchase.\n\nIn the last year there has been a wide range of new trackers on the market so that you can easily track your Break Even in real time as you trade.\n\nHere is an article showing you how\nhttps://www.coinmarketman.com/blog/cryptocurrency-break-even-calculator/",
      "json_metadata": "{\"tags\":[\"trading\"],\"links\":[\"https://www.coinmarketman.com/blog/cryptocurrency-break-even-calculator/\"],\"app\":\"steemit/0.1\"}"
    }
  ]
}
2018/11/28 18:19:12
parent authorjaffasoft
parent permlinkunlimited-crypto-buy-and-sell-layers-break-even-google-sheet
authorsteemitboard
permlinksteemitboard-notify-jaffasoft-20181128t181912000z
title
bodyCongratulations @jaffasoft! You received a personal award! <table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@jaffasoft/birthday1.png</td><td>1 Year on Steemit</td></tr></table> <sub>_[Click here to view your Board of Honor](https://steemitboard.com/@jaffasoft)_</sub> > Support [SteemitBoard's project](https://steemit.com/@steemitboard)! **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!
json metadata{"image":["https://steemitboard.com/img/notify.png"]}
Transaction InfoBlock #28102503/Trx c99fc74ace52110963335024e3e145df423b8a27
View Raw JSON Data
{
  "trx_id": "c99fc74ace52110963335024e3e145df423b8a27",
  "block": 28102503,
  "trx_in_block": 9,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-11-28T18:19:12",
  "op": [
    "comment",
    {
      "parent_author": "jaffasoft",
      "parent_permlink": "unlimited-crypto-buy-and-sell-layers-break-even-google-sheet",
      "author": "steemitboard",
      "permlink": "steemitboard-notify-jaffasoft-20181128t181912000z",
      "title": "",
      "body": "Congratulations @jaffasoft! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@jaffasoft/birthday1.png</td><td>1 Year on Steemit</td></tr></table>\n\n<sub>_[Click here to view your Board of Honor](https://steemitboard.com/@jaffasoft)_</sub>\n\n\n> Support [SteemitBoard's project](https://steemit.com/@steemitboard)! **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}"
    }
  ]
}
steemdelegated 5.554 SP to @jaffasoft
2018/11/26 17:55:57
delegatorsteem
delegateejaffasoft
vesting shares9043.605027 VESTS
Transaction InfoBlock #28044460/Trx 80b37577ec88d14f81383f16c7624d6945c0df90
View Raw JSON Data
{
  "trx_id": "80b37577ec88d14f81383f16c7624d6945c0df90",
  "block": 28044460,
  "trx_in_block": 45,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-11-26T17:55:57",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "9043.605027 VESTS"
    }
  ]
}
steemdelegated 18.013 SP to @jaffasoft
2018/08/26 09:47:21
delegatorsteem
delegateejaffasoft
vesting shares29333.337042 VESTS
Transaction InfoBlock #25402522/Trx fec6d7186f00a0776a8b38c441a0a3171cf1ecbb
View Raw JSON Data
{
  "trx_id": "fec6d7186f00a0776a8b38c441a0a3171cf1ecbb",
  "block": 25402522,
  "trx_in_block": 34,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-08-26T09:47:21",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "29333.337042 VESTS"
    }
  ]
}
2018/08/10 00:14:42
voterjaffasoft
authorquickfingersluc
permlinkmarket-mathematics-knowing-your-odds-is-the-secret-to-trading
weight10000 (100.00%)
Transaction InfoBlock #24930453/Trx a98a9ccd484861a5578c93e255935c04462ee585
View Raw JSON Data
{
  "trx_id": "a98a9ccd484861a5578c93e255935c04462ee585",
  "block": 24930453,
  "trx_in_block": 13,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-08-10T00:14:42",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "market-mathematics-knowing-your-odds-is-the-secret-to-trading",
      "weight": 10000
    }
  ]
}
2018/06/22 00:26:06
voterjaffasoft
authorbaselinesecurity
permlinkqfl-position-trading-methodology-step-by-step-high-level
weight10000 (100.00%)
Transaction InfoBlock #23530419/Trx 7e9bc6960863e5aea62285ba04dc22195af4c227
View Raw JSON Data
{
  "trx_id": "7e9bc6960863e5aea62285ba04dc22195af4c227",
  "block": 23530419,
  "trx_in_block": 18,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-22T00:26:06",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "baselinesecurity",
      "permlink": "qfl-position-trading-methodology-step-by-step-high-level",
      "weight": 10000
    }
  ]
}
2018/06/17 23:57:24
parent author
parent permlinkqfl
authorjaffasoft
permlinkunlimited-crypto-buy-and-sell-layers-break-even-google-sheet
titleUnlimited Crypto Buy & Sell Layers Break-even Google Sheet
body@@ -2397,20 +2397,16 @@ ave now -now broken e @@ -4461,34 +4461,8 @@ png%22 - width=%221021%22 height=%22427%22 /%3E%3C/ @@ -4857,19 +4857,39 @@ hat you -can +have the choice then to invest @@ -5419,18 +5419,19 @@ he right - i +. I have se @@ -5459,19 +5459,8 @@ ite -and simple by h
json metadata{"tags":["qfl","trading","finance","exchange","cryptocurrency"],"image":["https://i.imgur.com/PFvDrNT.png","https://i.imgur.com/QpVw3qQ.png","https://i.imgur.com/T6ioEcM.png","https://i.imgur.com/nAoxsDa.png"],"links":["https://docs.google.com/spreadsheets/d/1IT-M1FWxr6yzZ-Z7uMAXzJf1ggH_Uk-CQfAsNUT9GF8/edit?usp=sharing","https://steemit.com/trading/@jaffasoft/cryptocurrency-break-even-point-google-sheet-formula-for-dummies","https://steemit.com/@quickfingersluc","https://www.independentreserve.com?invite=YDMBRC","https://www.coinigy.com/?r=e2347957","http://my.fishbank.io/go/1603","https://www.binance.com/?ref=11230913","https://www.cryptopia.co.nz/Register?referrer=Jaffasoft","https://www.coinspot.com.au?affiliate=HHGC1","https://hitbtc.com/?ref_id=5a618558a8c17","https://ref.nordvpn.com/?id=533795790","https://gate.io/signup/1189157","https://www.altcoin.io?kid=MA46T","https://www.bitmex.com/register/IKhyNY","https://www.quadrigacx.com/?ref=s2z3kcinbqi7xtunkzs2uh7g","https://3commas.io/?c=qlf_slack","https://via.world/","https://tradedash.io/"],"app":"steemit/0.1","format":"html"}
Transaction InfoBlock #23414699/Trx 88e69246a6eb2872cf378bc69668ea7fbac6cf6a
View Raw JSON Data
{
  "trx_id": "88e69246a6eb2872cf378bc69668ea7fbac6cf6a",
  "block": 23414699,
  "trx_in_block": 7,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-17T23:57:24",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "qfl",
      "author": "jaffasoft",
      "permlink": "unlimited-crypto-buy-and-sell-layers-break-even-google-sheet",
      "title": "Unlimited Crypto Buy & Sell Layers Break-even Google Sheet",
      "body": "@@ -2397,20 +2397,16 @@\n ave now \n-now \n broken e\n@@ -4461,34 +4461,8 @@\n png%22\n- width=%221021%22 height=%22427%22\n /%3E%3C/\n@@ -4857,19 +4857,39 @@\n hat you \n-can\n+have the choice then to\n  invest \n@@ -5419,18 +5419,19 @@\n he right\n- i\n+. I\n  have se\n@@ -5459,19 +5459,8 @@\n ite \n-and simple \n by h\n",
      "json_metadata": "{\"tags\":[\"qfl\",\"trading\",\"finance\",\"exchange\",\"cryptocurrency\"],\"image\":[\"https://i.imgur.com/PFvDrNT.png\",\"https://i.imgur.com/QpVw3qQ.png\",\"https://i.imgur.com/T6ioEcM.png\",\"https://i.imgur.com/nAoxsDa.png\"],\"links\":[\"https://docs.google.com/spreadsheets/d/1IT-M1FWxr6yzZ-Z7uMAXzJf1ggH_Uk-CQfAsNUT9GF8/edit?usp=sharing\",\"https://steemit.com/trading/@jaffasoft/cryptocurrency-break-even-point-google-sheet-formula-for-dummies\",\"https://steemit.com/@quickfingersluc\",\"https://www.independentreserve.com?invite=YDMBRC\",\"https://www.coinigy.com/?r=e2347957\",\"http://my.fishbank.io/go/1603\",\"https://www.binance.com/?ref=11230913\",\"https://www.cryptopia.co.nz/Register?referrer=Jaffasoft\",\"https://www.coinspot.com.au?affiliate=HHGC1\",\"https://hitbtc.com/?ref_id=5a618558a8c17\",\"https://ref.nordvpn.com/?id=533795790\",\"https://gate.io/signup/1189157\",\"https://www.altcoin.io?kid=MA46T\",\"https://www.bitmex.com/register/IKhyNY\",\"https://www.quadrigacx.com/?ref=s2z3kcinbqi7xtunkzs2uh7g\",\"https://3commas.io/?c=qlf_slack\",\"https://via.world/\",\"https://tradedash.io/\"],\"app\":\"steemit/0.1\",\"format\":\"html\"}"
    }
  ]
}
2018/06/14 11:13:18
voterubg
authorjaffasoft
permlinkunlimited-crypto-buy-and-sell-layers-break-even-google-sheet
weight100 (1.00%)
Transaction InfoBlock #23313031/Trx 2c112248cf146ae44ebf519f4da270b48c81d925
View Raw JSON Data
{
  "trx_id": "2c112248cf146ae44ebf519f4da270b48c81d925",
  "block": 23313031,
  "trx_in_block": 39,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-14T11:13:18",
  "op": [
    "vote",
    {
      "voter": "ubg",
      "author": "jaffasoft",
      "permlink": "unlimited-crypto-buy-and-sell-layers-break-even-google-sheet",
      "weight": 100
    }
  ]
}
2018/06/14 11:12:18
parent author
parent permlinkqfl
authorjaffasoft
permlinkunlimited-crypto-buy-and-sell-layers-break-even-google-sheet
titleUnlimited Crypto Buy & Sell Layers Break-even Google Sheet
body<html> <h2><br></h2> <h2>How to know how many crypto coins to sell "right now" so you break-even?&nbsp;</h2> <h2><br></h2> <h2>I put a formula into a simple easy to use Google sheet!</h2> <p><a href="https://docs.google.com/spreadsheets/d/1IT-M1FWxr6yzZ-Z7uMAXzJf1ggH_Uk-CQfAsNUT9GF8/edit?usp=sharing">Here is the Google sheet straight up so you can make a copy and use yourself.</a> &nbsp;</p> <p><br></p> <p><br></p> <p>The goal of this sheet is to knowing quickly how many coins to sell "right now" to break-even. Accurately!&nbsp;</p> <p><br></p> <h2>I will run through an example:</h2> <p>Say you have bought EOS/USDT and layered in some buys as the panic price dropped:</p> <p>Buy layer 1). 10 &nbsp;coins @ price 20</p> <p>Buy layer 2). 10 coins @ price 18.53</p> <p>Buy layer 3). 30 coins @ price 17.26</p> <p>Buy layer 4). 100 coins @ price 17</p> <p><br></p> <p>The price starts to rise and as its bouncing up to your base you made a couple of sell orders at prices 22.6 and 23.4.</p> <p>Sell layer 1). 60 coins @ price 22.6</p> <p>Sell layer 2). 23 coins @ price 23.4</p> <p><img src="https://i.imgur.com/PFvDrNT.png" width="1017" height="431"/></p> <p>Now.... you think to yourself, "<em>how in the freaken hell do I work out how many coins to sell if I want to break-even right now at the price the chart is at</em>"? Your buy fee is 0.1% and the same for the sell fee. This is where the power of Google sheets comes in handy and i recommend it as a traders tool that you have and why using sheets is so awesome plus having an accurate formula that works it out quick and easy and the ability to handle unlimited buy and sell layers. Some people use guess work and i guess that's ok to get a ballpark figure. But it can be done so you absolutely know... so why not. At a quick glance the sheet will show you just how many coins to sell using the current price! There is another post here that goes into more detail about <a href="https://steemit.com/trading/@jaffasoft/cryptocurrency-break-even-point-google-sheet-formula-for-dummies">break-even</a>.</p> <p><img src="https://i.imgur.com/QpVw3qQ.png" width="1018" height="393"/></p> <p>So you key in the next sell quantity cell in your Goggle sheet 22.92964214&nbsp;</p> <p>and Sell layer 3). 22.92964214 coins @ price 24&nbsp;</p> <p>Notice the profit in the sheet now turns to $0.00% and the percent is -0.00%. That's because you have now now broken even. You have recovered the total principle that you spent on all the buy layers from 1 to 4. The principle is the total amount of FIAT you have spent to buy all the coins.&nbsp;</p> <p><br></p> <p>Or you might just round the amount up to 23 coins and go to the exchange and sell that amount.&nbsp;It wont be exactly exact but it will be very close quick and easy to do and you know it definitely covers what you outlaid (the principle). Plus some exchanges only take some orders with two decimal places. Then simply type in 23 into the next cell column in the sheet and it will continue calculating as normal.&nbsp;</p> <p><br></p> <p>If you're using the QFL trading method, at this point your trade is complete (for now anyway). What you have left is what Luc describes as "free coins". I've put a link to Lucs steemit blog down a little lower so you can clarify and learn about the method straight from the horses mouth.&nbsp;</p> <h2><strong>Selling 30% in the future when you get that "Hot Potato" feeling.&nbsp;</strong></h2> <p>Fast forward a fews days/weeks/months/years and EOS has mooned to 100-200 or 300 or maybe it's just 50, maybe it's gone to 1000 who knows. Nothing surprises me in crypto anymore. For example we'll say it reached all three prices at various different all time highs in the market. This is where Luc describes getting that "Hot Potato" feeling and selling 30% of the free coins you are holding in a wallet. The sheet calculates for you what amount of coins to sell.&nbsp;You might even sell them all when the market goes crazy high like when Bitcoin reached $20,000 in Dec 2017.&nbsp;</p> <p><br></p> <p>Sell layer 4). (in the future sell 30%) 11.12110736 coins @ price of 50</p> <p>Sell layer 5). (further in the future sell another 30%) 7.78477515 coins @ price of 100</p> <p>Sell layer 6). (even further in the future sell another 30%) 5.44934261 coins @ price of 200</p> <p>Again as you sell these you might round down and or up for 11, 8 and 6 coins perhaps.&nbsp;</p> <p><img src="https://i.imgur.com/T6ioEcM.png" width="1021" height="427"/></p> <p>&nbsp;You might wander why sell the coins instead just leave them to grow? Well, with the nature of crypto and it being so volatile meaning it can go up and down dramatically by large percentages in a relatively short period of time. It makes sense to sell when you feel the coin has gone pretty high in price and might be due to turn and drop down again. The consolation prize is that you can invest that money back into another trade and start all over again or go and spend some money on something.&nbsp;</p> <p><br></p> <p><br></p> <p>When you have the sheet open and doing this it all happens quickly though a trade may take days weeks months and or even years, so you can go back and open the sheet and you will not have forgotten what you did. Good financial management!&nbsp;</p> <p>When you open the sheet there is also some columns that you can open if you want to see the buy sell fees and some other details to the right i have set them to be out of site and simple by hiding those columns.&nbsp;By all means open those columns up (I usually do) to look at the buy fee details etc.&nbsp;</p> <p><br></p> <p>A trick to copy and pasting numbers in google sheets which you will find you need to do quite often when using these sheets. Is to use the paste special so that when you copy &amp; paste the numbers from one cell to another it does not paste the formula and bugger up your sheet. So to copy a cell copy as normal (Command C) and but you go to the menu and special paste it. So it pastes the values only not the formula! On mac I use Shift Command V. I'm not sure of windows but just have a look at the menu in Google sheets. Here is a screen shot of the menu for special paste. I often copy &amp; paste special the break-even amount into the next sell layer.</p> <p><img src="https://i.imgur.com/nAoxsDa.png" width="1212" height="563"/></p> <p><br></p> <p>And that's about it. I am doing a series of spreadsheets. So there is a few others to check out in my blog.&nbsp;</p> <p><br></p> <p>All the information and videos you need to learn about the QFL trading methodology is here:</p> <p><a href="https://steemit.com/@quickfingersluc">QuickFingersLuc</a></p> <h1><strong>Some other helpful links.</strong></h1> <p>If you're thinking of signing up to any exchanges you may find my below affiliate links beneficial for you:</p> <p>An Australian crypto exchange. <a href="https://www.independentreserve.com?invite=YDMBRC">Independent Reserve</a>&nbsp;</p> <p>A UI trading platform. <a href="https://www.coinigy.com/?r=e2347957">Coinigy</a></p> <p>A crypto game. <a href="http://my.fishbank.io/go/1603">Fishbank</a></p> <p>A popular trading exchange. <a href="https://www.binance.com/?ref=11230913">Binance</a></p> <p>Popular exchange for small account building. <a href="https://www.cryptopia.co.nz/Register?referrer=Jaffasoft">Cryptobia</a></p> <p>Popular Aussie exchange for mums and dads easy crypto trading. <a href="https://www.coinspot.com.au?affiliate=HHGC1">Coinspot</a></p> <p>Popular exchange for small account building trading. <a href="https://hitbtc.com/?ref_id=5a618558a8c17">HitBTC</a></p> <p>VPN Virtual Private Network to protect you privacy when trading. <a href="https://ref.nordvpn.com/?id=533795790">NordVPN</a></p> <p>Exchange with a lot of USDT trading pairs. <a href="https://gate.io/signup/1189157">Gate</a></p> <p>Another exchange. <a href="https://www.altcoin.io?kid=MA46T">AltCoin</a>&nbsp;</p> <p>Another exchange. <a href="https://www.bitmex.com/register/IKhyNY">BitMEX</a>&nbsp;</p> <p>Another exchange. <a href="https://www.quadrigacx.com/?ref=s2z3kcinbqi7xtunkzs2uh7g">Quadrigacx</a></p> <p><a href="https://3commas.io/?c=qlf_slack">Trading Bot does trades for you.</a></p> <p><br></p> <p><br></p> <p>I also recommend some up and coming trading platforms to keep an eye on. They are currently free to use while in Beta:</p> <p>&nbsp;<a href="https://via.world/">https://via.world/</a></p> <p>&nbsp;<a href="https://tradedash.io/">https://tradedash.io/</a></p> <p><br></p> </html>
json metadata{"tags":["trading","finance","exchange","cryptocurrency","qfl"],"image":["https://i.imgur.com/PFvDrNT.png","https://i.imgur.com/QpVw3qQ.png","https://i.imgur.com/T6ioEcM.png","https://i.imgur.com/nAoxsDa.png"],"links":["https://docs.google.com/spreadsheets/d/1IT-M1FWxr6yzZ-Z7uMAXzJf1ggH_Uk-CQfAsNUT9GF8/edit?usp=sharing","https://steemit.com/trading/@jaffasoft/cryptocurrency-break-even-point-google-sheet-formula-for-dummies","https://steemit.com/@quickfingersluc","https://www.independentreserve.com?invite=YDMBRC","https://www.coinigy.com/?r=e2347957","http://my.fishbank.io/go/1603","https://www.binance.com/?ref=11230913","https://www.cryptopia.co.nz/Register?referrer=Jaffasoft","https://www.coinspot.com.au?affiliate=HHGC1","https://hitbtc.com/?ref_id=5a618558a8c17","https://ref.nordvpn.com/?id=533795790","https://gate.io/signup/1189157","https://www.altcoin.io?kid=MA46T","https://www.bitmex.com/register/IKhyNY","https://www.quadrigacx.com/?ref=s2z3kcinbqi7xtunkzs2uh7g","https://3commas.io/?c=qlf_slack","https://via.world/","https://tradedash.io/"],"app":"steemit/0.1","format":"html"}
Transaction InfoBlock #23313011/Trx f561935cef6076604b39f6c99de6e85e4cd7e8be
View Raw JSON Data
{
  "trx_id": "f561935cef6076604b39f6c99de6e85e4cd7e8be",
  "block": 23313011,
  "trx_in_block": 22,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-14T11:12:18",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "qfl",
      "author": "jaffasoft",
      "permlink": "unlimited-crypto-buy-and-sell-layers-break-even-google-sheet",
      "title": "Unlimited Crypto Buy & Sell Layers Break-even Google Sheet",
      "body": "<html>\n<h2><br></h2>\n<h2>How to know how many crypto coins to sell \"right now\" so you break-even?&nbsp;</h2>\n<h2><br></h2>\n<h2>I put a formula into a simple easy to use Google sheet!</h2>\n<p><a href=\"https://docs.google.com/spreadsheets/d/1IT-M1FWxr6yzZ-Z7uMAXzJf1ggH_Uk-CQfAsNUT9GF8/edit?usp=sharing\">Here is the Google sheet straight up so you can make a copy and use yourself.</a> &nbsp;</p>\n<p><br></p>\n<p><br></p>\n<p>The goal of this sheet is to knowing quickly how many coins to sell \"right now\" to break-even. Accurately!&nbsp;</p>\n<p><br></p>\n<h2>I will run through an example:</h2>\n<p>Say you have bought EOS/USDT and layered in some buys as the panic price dropped:</p>\n<p>Buy layer 1). 10 &nbsp;coins @ price 20</p>\n<p>Buy layer 2). 10 coins @ price 18.53</p>\n<p>Buy layer 3). 30 coins @ price 17.26</p>\n<p>Buy layer 4). 100 coins @ price 17</p>\n<p><br></p>\n<p>The price starts to rise and as its bouncing up to your base you made a couple of sell orders at prices 22.6 and 23.4.</p>\n<p>Sell layer 1). 60 coins @ price 22.6</p>\n<p>Sell layer 2). 23 coins @ price 23.4</p>\n<p><img src=\"https://i.imgur.com/PFvDrNT.png\" width=\"1017\" height=\"431\"/></p>\n<p>Now.... you think to yourself, \"<em>how in the freaken hell do I work out how many coins to sell if I want to break-even right now at the price the chart is at</em>\"? Your buy fee is 0.1% and the same for the sell fee. This is where the power of Google sheets comes in handy and i recommend it as a traders tool that you have and why using sheets is so awesome plus having an accurate formula that works it out quick and easy and the ability to handle unlimited buy and sell layers. Some people use guess work and i guess that's ok to get a ballpark figure. But it can be done so you absolutely know... so why not. At a quick glance the sheet will show you just how many coins to sell using the current price! There is another post here that goes into more detail about <a href=\"https://steemit.com/trading/@jaffasoft/cryptocurrency-break-even-point-google-sheet-formula-for-dummies\">break-even</a>.</p>\n<p><img src=\"https://i.imgur.com/QpVw3qQ.png\" width=\"1018\" height=\"393\"/></p>\n<p>So you key in the next sell quantity cell in your Goggle sheet 22.92964214&nbsp;</p>\n<p>and Sell layer 3). 22.92964214 coins @ price 24&nbsp;</p>\n<p>Notice the profit in the sheet now turns to $0.00% and the percent is -0.00%. That's because you have now now broken even. You have recovered the total principle that you spent on all the buy layers from 1 to 4. The principle is the total amount of FIAT you have spent to buy all the coins.&nbsp;</p>\n<p><br></p>\n<p>Or you might just round the amount up to 23 coins and go to the exchange and sell that amount.&nbsp;It wont be exactly exact but it will be very close quick and easy to do and you know it definitely covers what you outlaid (the principle). Plus some exchanges only take some orders with two decimal places. Then simply type in 23 into the next cell column in the sheet and it will continue calculating as normal.&nbsp;</p>\n<p><br></p>\n<p>If you're using the QFL trading method, at this point your trade is complete (for now anyway). What you have left is what Luc describes as \"free coins\". I've put a link to Lucs steemit blog down a little lower so you can clarify and learn about the method straight from the horses mouth.&nbsp;</p>\n<h2><strong>Selling 30% in the future when you get that \"Hot Potato\" feeling.&nbsp;</strong></h2>\n<p>Fast forward a fews days/weeks/months/years and EOS has mooned to 100-200 or 300 or maybe it's just 50, maybe it's gone to 1000 who knows. Nothing surprises me in crypto anymore. For example we'll say it reached all three prices at various different all time highs in the market. This is where Luc describes getting that \"Hot Potato\" feeling and selling 30% of the free coins you are holding in a wallet. The sheet calculates for you what amount of coins to sell.&nbsp;You might even sell them all when the market goes crazy high like when Bitcoin reached $20,000 in Dec 2017.&nbsp;</p>\n<p><br></p>\n<p>Sell layer 4). (in the future sell 30%) 11.12110736 coins @ price of 50</p>\n<p>Sell layer 5). (further in the future sell another 30%) 7.78477515 coins @ price of 100</p>\n<p>Sell layer 6). (even further in the future sell another 30%) 5.44934261 coins @ price of 200</p>\n<p>Again as you sell these you might round down and or up for 11, 8 and 6 coins perhaps.&nbsp;</p>\n<p><img src=\"https://i.imgur.com/T6ioEcM.png\" width=\"1021\" height=\"427\"/></p>\n<p>&nbsp;You might wander why sell the coins instead just leave them to grow? Well, with the nature of crypto and it being so volatile meaning it can go up and down dramatically by large percentages in a relatively short period of time. It makes sense to sell when you feel the coin has gone pretty high in price and might be due to turn and drop down again. The consolation prize is that you can invest that money back into another trade and start all over again or go and spend some money on something.&nbsp;</p>\n<p><br></p>\n<p><br></p>\n<p>When you have the sheet open and doing this it all happens quickly though a trade may take days weeks months and or even years, so you can go back and open the sheet and you will not have forgotten what you did. Good financial management!&nbsp;</p>\n<p>When you open the sheet there is also some columns that you can open if you want to see the buy sell fees and some other details to the right i have set them to be out of site and simple by hiding those columns.&nbsp;By all means open those columns up (I usually do) to look at the buy fee details etc.&nbsp;</p>\n<p><br></p>\n<p>A trick to copy and pasting numbers in google sheets which you will find you need to do quite often when using these sheets. Is to use the paste special so that when you copy &amp; paste the numbers from one cell to another it does not paste the formula and bugger up your sheet. So to copy a cell copy as normal (Command C) and but you go to the menu and special paste it. So it pastes the values only not the formula! On mac I use Shift Command V. I'm not sure of windows but just have a look at the menu in Google sheets. Here is a screen shot of the menu for special paste. I often copy &amp; paste special the break-even amount into the next sell layer.</p>\n<p><img src=\"https://i.imgur.com/nAoxsDa.png\" width=\"1212\" height=\"563\"/></p>\n<p><br></p>\n<p>And that's about it. I am doing a series of spreadsheets. So there is a few others to check out in my blog.&nbsp;</p>\n<p><br></p>\n<p>All the information and videos you need to learn about the QFL trading methodology is here:</p>\n<p><a href=\"https://steemit.com/@quickfingersluc\">QuickFingersLuc</a></p>\n<h1><strong>Some other helpful links.</strong></h1>\n<p>If you're thinking of signing up to any exchanges you may find my below affiliate links beneficial for you:</p>\n<p>An Australian crypto exchange. <a href=\"https://www.independentreserve.com?invite=YDMBRC\">Independent Reserve</a>&nbsp;</p>\n<p>A UI trading platform. <a href=\"https://www.coinigy.com/?r=e2347957\">Coinigy</a></p>\n<p>A crypto game. <a href=\"http://my.fishbank.io/go/1603\">Fishbank</a></p>\n<p>A popular trading exchange. <a href=\"https://www.binance.com/?ref=11230913\">Binance</a></p>\n<p>Popular exchange for small account building. <a href=\"https://www.cryptopia.co.nz/Register?referrer=Jaffasoft\">Cryptobia</a></p>\n<p>Popular Aussie exchange for mums and dads easy crypto trading. <a href=\"https://www.coinspot.com.au?affiliate=HHGC1\">Coinspot</a></p>\n<p>Popular exchange for small account building trading. <a href=\"https://hitbtc.com/?ref_id=5a618558a8c17\">HitBTC</a></p>\n<p>VPN Virtual Private Network to protect you privacy when trading. <a href=\"https://ref.nordvpn.com/?id=533795790\">NordVPN</a></p>\n<p>Exchange with a lot of USDT trading pairs. <a href=\"https://gate.io/signup/1189157\">Gate</a></p>\n<p>Another exchange. <a href=\"https://www.altcoin.io?kid=MA46T\">AltCoin</a>&nbsp;</p>\n<p>Another exchange. <a href=\"https://www.bitmex.com/register/IKhyNY\">BitMEX</a>&nbsp;</p>\n<p>Another exchange. <a href=\"https://www.quadrigacx.com/?ref=s2z3kcinbqi7xtunkzs2uh7g\">Quadrigacx</a></p>\n<p><a href=\"https://3commas.io/?c=qlf_slack\">Trading Bot does trades for you.</a></p>\n<p><br></p>\n<p><br></p>\n<p>I also recommend some up and coming trading platforms to keep an eye on. They are currently free to use while in Beta:</p>\n<p>&nbsp;<a href=\"https://via.world/\">https://via.world/</a></p>\n<p>&nbsp;<a href=\"https://tradedash.io/\">https://tradedash.io/</a></p>\n<p><br></p>\n</html>",
      "json_metadata": "{\"tags\":[\"trading\",\"finance\",\"exchange\",\"cryptocurrency\",\"qfl\"],\"image\":[\"https://i.imgur.com/PFvDrNT.png\",\"https://i.imgur.com/QpVw3qQ.png\",\"https://i.imgur.com/T6ioEcM.png\",\"https://i.imgur.com/nAoxsDa.png\"],\"links\":[\"https://docs.google.com/spreadsheets/d/1IT-M1FWxr6yzZ-Z7uMAXzJf1ggH_Uk-CQfAsNUT9GF8/edit?usp=sharing\",\"https://steemit.com/trading/@jaffasoft/cryptocurrency-break-even-point-google-sheet-formula-for-dummies\",\"https://steemit.com/@quickfingersluc\",\"https://www.independentreserve.com?invite=YDMBRC\",\"https://www.coinigy.com/?r=e2347957\",\"http://my.fishbank.io/go/1603\",\"https://www.binance.com/?ref=11230913\",\"https://www.cryptopia.co.nz/Register?referrer=Jaffasoft\",\"https://www.coinspot.com.au?affiliate=HHGC1\",\"https://hitbtc.com/?ref_id=5a618558a8c17\",\"https://ref.nordvpn.com/?id=533795790\",\"https://gate.io/signup/1189157\",\"https://www.altcoin.io?kid=MA46T\",\"https://www.bitmex.com/register/IKhyNY\",\"https://www.quadrigacx.com/?ref=s2z3kcinbqi7xtunkzs2uh7g\",\"https://3commas.io/?c=qlf_slack\",\"https://via.world/\",\"https://tradedash.io/\"],\"app\":\"steemit/0.1\",\"format\":\"html\"}"
    }
  ]
}
2018/06/14 11:09:45
parent author
parent permlinkqfl
authorjaffasoft
permlinkunlimited-crypto-buy-and-sell-layers-break-even-google-sheet
titleUnlimited Crypto Buy & Sell Layers Break-even Google Sheet
body@@ -442,28 +442,30 @@ eet -wa +i s to -make knowing +quickly how @@ -512,174 +512,82 @@ even - quick &amp; easy. All you have to do is enter the exchanges buy &amp; sell fee percent and the buy &amp; sell prices and quantities bought. That's it!%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p +. Accurately!&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Ch2%3EI will run through an example:%3C/h2 %3E%0A%3Cp @@ -1220,19 +1220,17 @@ hell do -you +I work ou @@ -1257,20 +1257,13 @@ sell -%3C/em%3E if -you +I wan @@ -1316,16 +1316,21 @@ rt is at +%3C/em%3E %22? Your @@ -1469,16 +1469,21 @@ rs tool +that you have @@ -1567,16 +1567,87 @@ s it out + quick and easy and the ability to handle unlimited buy and sell layers . Some p @@ -2392,21 +2392,27 @@ you -ar +hav e now -break +now broken eve @@ -3083,16 +3083,17 @@ g method +, at this @@ -3130,16 +3130,23 @@ (for now + anyway ). What @@ -3266,21 +3266,50 @@ you can -learn +clarify and learn about the method straigh @@ -3905,32 +3905,145 @@ s to sell.&nbsp; +You might even sell them all when the market goes crazy high like when Bitcoin reached $20,000 in Dec 2017.&nbsp; %3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E @@ -4872,17 +4872,17 @@ tion pri -s +z e is tha @@ -6453,16 +6453,17 @@ ew other - +s to chec
json metadata{"tags":["qfl","breakeven","trading","sheet","break-even"],"image":["https://i.imgur.com/PFvDrNT.png","https://i.imgur.com/QpVw3qQ.png","https://i.imgur.com/T6ioEcM.png","https://i.imgur.com/nAoxsDa.png"],"links":["https://docs.google.com/spreadsheets/d/1IT-M1FWxr6yzZ-Z7uMAXzJf1ggH_Uk-CQfAsNUT9GF8/edit?usp=sharing","https://steemit.com/trading/@jaffasoft/cryptocurrency-break-even-point-google-sheet-formula-for-dummies","https://steemit.com/@quickfingersluc","https://www.independentreserve.com?invite=YDMBRC","https://www.coinigy.com/?r=e2347957","http://my.fishbank.io/go/1603","https://www.binance.com/?ref=11230913","https://www.cryptopia.co.nz/Register?referrer=Jaffasoft","https://www.coinspot.com.au?affiliate=HHGC1","https://hitbtc.com/?ref_id=5a618558a8c17","https://ref.nordvpn.com/?id=533795790","https://gate.io/signup/1189157","https://www.altcoin.io?kid=MA46T","https://www.bitmex.com/register/IKhyNY","https://www.quadrigacx.com/?ref=s2z3kcinbqi7xtunkzs2uh7g","https://3commas.io/?c=qlf_slack","https://via.world/","https://tradedash.io/"],"app":"steemit/0.1","format":"html"}
Transaction InfoBlock #23312960/Trx 59d40edd0575e85f6627f71c46a8e9b1a562a0b4
View Raw JSON Data
{
  "trx_id": "59d40edd0575e85f6627f71c46a8e9b1a562a0b4",
  "block": 23312960,
  "trx_in_block": 29,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-14T11:09:45",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "qfl",
      "author": "jaffasoft",
      "permlink": "unlimited-crypto-buy-and-sell-layers-break-even-google-sheet",
      "title": "Unlimited Crypto Buy & Sell Layers Break-even Google Sheet",
      "body": "@@ -442,28 +442,30 @@\n eet \n-wa\n+i\n s to \n-make \n knowing \n+quickly \n how \n@@ -512,174 +512,82 @@\n even\n- quick &amp; easy. All you have to do is enter the exchanges buy &amp; sell fee percent and the buy &amp; sell prices and quantities bought. That's it!%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p\n+. Accurately!&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Ch2%3EI will run through an example:%3C/h2\n %3E%0A%3Cp\n@@ -1220,19 +1220,17 @@\n hell do \n-you\n+I\n  work ou\n@@ -1257,20 +1257,13 @@\n sell\n-%3C/em%3E\n  if \n-you\n+I\n  wan\n@@ -1316,16 +1316,21 @@\n rt is at\n+%3C/em%3E\n %22? Your \n@@ -1469,16 +1469,21 @@\n rs tool \n+that \n you have\n@@ -1567,16 +1567,87 @@\n s it out\n+ quick and easy and the ability to handle unlimited buy and sell layers\n . Some p\n@@ -2392,21 +2392,27 @@\n you \n-ar\n+hav\n e now \n-break\n+now broken\n  eve\n@@ -3083,16 +3083,17 @@\n g method\n+,\n  at this\n@@ -3130,16 +3130,23 @@\n (for now\n+ anyway\n ). What \n@@ -3266,21 +3266,50 @@\n you can \n-learn\n+clarify and learn about the method\n  straigh\n@@ -3905,32 +3905,145 @@\n s to sell.&nbsp;\n+You might even sell them all when the market goes crazy high like when Bitcoin reached $20,000 in Dec 2017.&nbsp;\n %3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E\n@@ -4872,17 +4872,17 @@\n tion pri\n-s\n+z\n e is tha\n@@ -6453,16 +6453,17 @@\n ew other\n-\n \n+s\n  to chec\n",
      "json_metadata": "{\"tags\":[\"qfl\",\"breakeven\",\"trading\",\"sheet\",\"break-even\"],\"image\":[\"https://i.imgur.com/PFvDrNT.png\",\"https://i.imgur.com/QpVw3qQ.png\",\"https://i.imgur.com/T6ioEcM.png\",\"https://i.imgur.com/nAoxsDa.png\"],\"links\":[\"https://docs.google.com/spreadsheets/d/1IT-M1FWxr6yzZ-Z7uMAXzJf1ggH_Uk-CQfAsNUT9GF8/edit?usp=sharing\",\"https://steemit.com/trading/@jaffasoft/cryptocurrency-break-even-point-google-sheet-formula-for-dummies\",\"https://steemit.com/@quickfingersluc\",\"https://www.independentreserve.com?invite=YDMBRC\",\"https://www.coinigy.com/?r=e2347957\",\"http://my.fishbank.io/go/1603\",\"https://www.binance.com/?ref=11230913\",\"https://www.cryptopia.co.nz/Register?referrer=Jaffasoft\",\"https://www.coinspot.com.au?affiliate=HHGC1\",\"https://hitbtc.com/?ref_id=5a618558a8c17\",\"https://ref.nordvpn.com/?id=533795790\",\"https://gate.io/signup/1189157\",\"https://www.altcoin.io?kid=MA46T\",\"https://www.bitmex.com/register/IKhyNY\",\"https://www.quadrigacx.com/?ref=s2z3kcinbqi7xtunkzs2uh7g\",\"https://3commas.io/?c=qlf_slack\",\"https://via.world/\",\"https://tradedash.io/\"],\"app\":\"steemit/0.1\",\"format\":\"html\"}"
    }
  ]
}
2018/06/14 10:46:45
voterhackerzizon
authorjaffasoft
permlinkunlimited-crypto-buy-and-sell-layers-break-even-google-sheet
weight100 (1.00%)
Transaction InfoBlock #23312500/Trx 8a17dc9619ebced43a41b1ee0694cbcbe9019b66
View Raw JSON Data
{
  "trx_id": "8a17dc9619ebced43a41b1ee0694cbcbe9019b66",
  "block": 23312500,
  "trx_in_block": 79,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-14T10:46:45",
  "op": [
    "vote",
    {
      "voter": "hackerzizon",
      "author": "jaffasoft",
      "permlink": "unlimited-crypto-buy-and-sell-layers-break-even-google-sheet",
      "weight": 100
    }
  ]
}
2018/06/14 10:46:15
parent author
parent permlinkqfl
authorjaffasoft
permlinkunlimited-crypto-buy-and-sell-layers-break-even-google-sheet
titleUnlimited Crypto Buy & Sell Layers Break-even Google Sheet
body@@ -60,16 +60,17 @@ to sell +%22 right no @@ -70,16 +70,17 @@ ight now +%22 so you @@ -93,12 +93,59 @@ even -, +?&nbsp;%3C/h2%3E%0A%3Ch2%3E%3Cbr%3E%3C/h2%3E%0A%3Ch2%3EI put a formula in +to a s @@ -395,1769 +395,274 @@ %0A%3Cp%3E -All the information and videos you need to learn about the QFL trading method is here:%3C/p%3E%0A%3Cp%3E%3Ca href=%22https://steemit.com/@quickfingersluc%22%3EQuickFingersLuc%3C/a%3E%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EI did a post about the formula i used to work out what break-even point is in an advanced crypto trading spreadsheet designed specifically for the trading strategy and methodology of QFL because i noticed ways around that people were doing it incorrect! Where you buy a specific coin at various prices and various amounts, during a panic unfolding in the market. Normally increasing the buy amount as the price drops lower under a base in a safe cycle.&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EThere is an awful lot in the sheet which is great for those that like to see what is happening with the math for every aspect of the trade. Individual layered buy fees, sell fees, profit &amp; lose, allocation of funds down layers, amounts bought, sold, free coins, how much to sell to break-even %22now%22 etc and many many other variables. But it could be a bit tricky to use for a newbie. So i did a challenge for myself to build a new sheet and break it down to as elegant and simple as i could get it. &nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EThe main reason for the detailed advanced sheet was also a stepping stone for me to learn all about how crypto is calculated and the math. I like to dig deep into details of how things work and crypto was all new to me.&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3ESo whats this simple sheet for? All you have to do is enter the buy, sell and quantities. You might ask why do this when there are other sheets out there already doing this? I could not find a sheet out there that calculates the amount of coins you need to sell to break-even correctly. So i built my break-even formula in.&nbsp; +%3Cbr%3E%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EThe goal of this sheet was to make knowing how many coins to sell %22right now%22 to break-even quick &amp; easy. All you have to do is enter the exchanges buy &amp; sell fee percent and the buy &amp; sell prices and quantities bought. That's it! %3C/p%3E @@ -681,21 +681,8 @@ %0A%3Cp%3E -For example. Say @@ -718,19 +718,17 @@ layered -dow +i n some b @@ -738,12 +738,31 @@ as -such +the panic price dropped :%3C/p @@ -782,18 +782,16 @@ r 1). 10 -00 &nbsp;c @@ -829,18 +829,16 @@ r 2). 10 -00 coins @ @@ -873,18 +873,16 @@ r 3). 30 -00 coins @ @@ -918,18 +918,16 @@ 4). 100 -00 coins @ @@ -1004,15 +1004,31 @@ ing +up to your base you ma -k +d e a @@ -1052,16 +1052,23 @@ ders at +prices 22.6 and @@ -1174,27 +1174,121 @@ %3Cp%3E%3C -br%3E%3C/p%3E%0A%3Cp%3ENow.... +img src=%22https://i.imgur.com/PFvDrNT.png%22 width=%221017%22 height=%22431%22/%3E%3C/p%3E%0A%3Cp%3ENow.... you think to yourself, %22%3Cem%3E how @@ -1345,16 +1345,21 @@ to sell +%3C/em%3E if you @@ -1386,16 +1386,46 @@ ight now + at the price the chart is at%22 ? Your b @@ -1524,149 +1524,562 @@ in -and why using sheets is so awesome. At a quick glance the sheet will show you just how many coins to sell based on what the current price is! +handy and i recommend it as a traders tool you have and why using sheets is so awesome plus having an accurate formula that works it out. Some people use guess work and i guess that's ok to get a ballpark figure. But it can be done so you absolutely know... so why not. At a quick glance the sheet will show you just how many coins to sell using the current price! There is another post here that goes into more detail about %3Ca href=%22https://steemit.com/trading/@jaffasoft/cryptocurrency-break-even-point-google-sheet-formula-for-dummies%22%3Ebreak-even%3C/a%3E. %3C/p%3E @@ -2116,15 +2116,15 @@ com/ -4OwH6Zv +QpVw3qQ .png @@ -2137,11 +2137,11 @@ h=%221 -374 +018 %22 he @@ -2150,11 +2150,11 @@ ht=%22 -529 +393 %22/%3E%3C @@ -2227,20 +2227,19 @@ eet -15.41462713. +22.92964214 &nbs @@ -2240,32 +2240,36 @@ 14&nbsp;%3C/p%3E%0A%3Cp%3E +and Sell layer 3). 1 @@ -2271,19 +2271,19 @@ 3). -15.41462713 +22.92964214 coi @@ -2313,187 +2313,1113 @@ %0A%3Cp%3E -Or you might just round it up to 16 and go to the exchange and sell that amount.&nbsp;%3C/p%3E%0A%3Cp%3E%3Cimg src=%22https://i.imgur.com/hfOjRb1.png%22 width=%221263%22 height=%22522%22/%3E%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p +Notice the profit in the sheet now turns to $0.00%25 and the percent is -0.00%25. That's because you are now break even. You have recovered the total principle that you spent on all the buy layers from 1 to 4. The principle is the total amount of FIAT you have spent to buy all the coins.&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EOr you might just round the amount up to 23 coins and go to the exchange and sell that amount.&nbsp;It wont be exactly exact but it will be very close quick and easy to do and you know it definitely covers what you outlaid (the principle). Plus some exchanges only take some orders with two decimal places. Then simply type in 23 into the next cell column in the sheet and it will continue calculating as normal.&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EIf you're using the QFL trading method at this point your trade is complete (for now). What you have left is what Luc describes as %22free coins%22. I've put a link to Lucs steemit blog down a little lower so you can learn straight from the horses mouth.&nbsp;%3C/p%3E%0A%3Ch2%3E%3Cstrong%3ESelling 30%25 in the future when you get that %22Hot Potato%22 feeling.&nbsp;%3C/strong%3E%3C/h2 %3E%0A%3Cp @@ -3439,16 +3439,21 @@ a fews +days/ weeks/mo @@ -3613,14 +3613,8 @@ mple -s sack we' @@ -3717,50 +3717,29 @@ ere -according to Lucs methodology when you get +Luc describes getting tha @@ -3765,16 +3765,19 @@ ing -you +and sell +ing 30%25 @@ -3953,17 +3953,17 @@ %25) 1 -0.6756118 +1.1211073 6 co @@ -4034,23 +4034,31 @@ ell -30%25) 7.47292830 +another 30%25) 7.78477515 coi @@ -4134,17 +4134,31 @@ ell -30%25) 2.24 +another 30%25) 5.44934261 coi @@ -4174,36 +4174,123 @@ e of 200%3C/p%3E%0A%3Cp%3E -%3Cbr%3E +Again as you sell these you might round down and or up for 11, 8 and 6 coins perhaps.&nbsp; %3C/p%3E%0A%3Cp%3E%3Cimg src @@ -4315,15 +4315,15 @@ com/ -6oJUsa3 +T6ioEcM .png @@ -4336,11 +4336,11 @@ h=%221 -375 +021 %22 he @@ -4349,11 +4349,11 @@ ht=%22 -546 +427 %22/%3E%3C @@ -4718,40 +4718,8 @@ ain. - The market does goes in cycles. The @@ -4731,16 +4731,22 @@ olation +prise is that @@ -4830,65 +4830,41 @@ go -buy an island and enjoy some time on the beach in the sun +and spend some money on something .&nb @@ -5140,60 +5140,14 @@ ent! - So to grab your copy of the sheet here is the link: +&nbsp; %3C/p%3E @@ -5359,32 +5359,123 @@ e columns.&nbsp; +By all means open those columns up (I usually do) to look at the buy fee details etc.&nbsp; %3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E @@ -6230,27 +6230,320 @@ %3Cbr%3E%3C/p%3E%0A%3Cp%3E -%3Cbr +And that's about it. I am doing a series of spreadsheets. So there is a few other to check out in my blog.&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EAll the information and videos you need to learn about the QFL trading methodology is here:%3C/p%3E%0A%3Cp%3E%3Ca href=%22https://steemit.com/@quickfingersluc%22%3EQuickFingersLuc%3C/a %3E%3C/p%3E%0A%3Ch1%3E%3Cs @@ -6553,16 +6553,22 @@ ng%3ESome +other helpful @@ -8222,23 +8222,30 @@ ile -being in Beta -. +:%3C/p%3E%0A%3Cp%3E&nbsp; %3Ca h @@ -8299,20 +8299,22 @@ %3C/p%3E%0A%3Cp%3E -and +&nbsp; %3Ca href=
json metadata{"tags":["qfl","breakeven","trading","sheet"],"image":["https://i.imgur.com/PFvDrNT.png","https://i.imgur.com/QpVw3qQ.png","https://i.imgur.com/T6ioEcM.png","https://i.imgur.com/nAoxsDa.png"],"links":["https://docs.google.com/spreadsheets/d/1IT-M1FWxr6yzZ-Z7uMAXzJf1ggH_Uk-CQfAsNUT9GF8/edit?usp=sharing","https://steemit.com/trading/@jaffasoft/cryptocurrency-break-even-point-google-sheet-formula-for-dummies","https://steemit.com/@quickfingersluc","https://www.independentreserve.com?invite=YDMBRC","https://www.coinigy.com/?r=e2347957","http://my.fishbank.io/go/1603","https://www.binance.com/?ref=11230913","https://www.cryptopia.co.nz/Register?referrer=Jaffasoft","https://www.coinspot.com.au?affiliate=HHGC1","https://hitbtc.com/?ref_id=5a618558a8c17","https://ref.nordvpn.com/?id=533795790","https://gate.io/signup/1189157","https://www.altcoin.io?kid=MA46T","https://www.bitmex.com/register/IKhyNY","https://www.quadrigacx.com/?ref=s2z3kcinbqi7xtunkzs2uh7g","https://3commas.io/?c=qlf_slack","https://via.world/","https://tradedash.io/"],"app":"steemit/0.1","format":"html"}
Transaction InfoBlock #23312490/Trx c0896aadd909709fbdc7cce3965121065a2c5447
View Raw JSON Data
{
  "trx_id": "c0896aadd909709fbdc7cce3965121065a2c5447",
  "block": 23312490,
  "trx_in_block": 36,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-14T10:46:15",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "qfl",
      "author": "jaffasoft",
      "permlink": "unlimited-crypto-buy-and-sell-layers-break-even-google-sheet",
      "title": "Unlimited Crypto Buy & Sell Layers Break-even Google Sheet",
      "body": "@@ -60,16 +60,17 @@\n to sell \n+%22\n right no\n@@ -70,16 +70,17 @@\n ight now\n+%22\n  so you \n@@ -93,12 +93,59 @@\n even\n-,\n+?&nbsp;%3C/h2%3E%0A%3Ch2%3E%3Cbr%3E%3C/h2%3E%0A%3Ch2%3EI put a formula\n  in\n+to\n  a s\n@@ -395,1769 +395,274 @@\n %0A%3Cp%3E\n-All the information and videos you need to learn about the QFL trading method is here:%3C/p%3E%0A%3Cp%3E%3Ca href=%22https://steemit.com/@quickfingersluc%22%3EQuickFingersLuc%3C/a%3E%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EI did a post about the formula i used to work out what break-even point is in an advanced crypto trading spreadsheet designed specifically for the trading strategy and methodology of QFL because i noticed ways around that people were doing it incorrect! Where you buy a specific coin at various prices and various amounts, during a panic unfolding in the market. Normally increasing the buy amount as the price drops lower under a base in a safe cycle.&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EThere is an awful lot in the sheet which is great for those that like to see what is happening with the math for every aspect of the trade. Individual layered buy fees, sell fees, profit &amp; lose, allocation of funds down layers, amounts bought, sold, free coins, how much to sell to break-even %22now%22 etc and many many other variables. But it could be a bit tricky to use for a newbie. So i did a challenge for myself to build a new sheet and break it down to as elegant and simple as i could get it. &nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EThe main reason for the detailed advanced sheet was also a stepping stone for me to learn all about how crypto is calculated and the math. I like to dig deep into details of how things work and crypto was all new to me.&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3ESo whats this simple sheet for? All you have to do is enter the buy, sell and quantities. You might ask why do this when there are other sheets out there already doing this? I could not find a sheet out there that calculates the amount of coins you need to sell to break-even correctly. So i built my break-even formula in.&nbsp;\n+%3Cbr%3E%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EThe goal of this sheet was to make knowing how many coins to sell %22right now%22 to break-even quick &amp; easy. All you have to do is enter the exchanges buy &amp; sell fee percent and the buy &amp; sell prices and quantities bought. That's it!\n %3C/p%3E\n@@ -681,21 +681,8 @@\n %0A%3Cp%3E\n-For example. \n Say \n@@ -718,19 +718,17 @@\n layered \n-dow\n+i\n n some b\n@@ -738,12 +738,31 @@\n  as \n-such\n+the panic price dropped\n :%3C/p\n@@ -782,18 +782,16 @@\n r 1). 10\n-00\n  &nbsp;c\n@@ -829,18 +829,16 @@\n r 2). 10\n-00\n  coins @\n@@ -873,18 +873,16 @@\n r 3). 30\n-00\n  coins @\n@@ -918,18 +918,16 @@\n  4). 100\n-00\n  coins @\n@@ -1004,15 +1004,31 @@\n ing \n+up to your base \n you ma\n-k\n+d\n e a \n@@ -1052,16 +1052,23 @@\n ders at \n+prices \n 22.6 and\n@@ -1174,27 +1174,121 @@\n %3Cp%3E%3C\n-br%3E%3C/p%3E%0A%3Cp%3ENow.... \n+img src=%22https://i.imgur.com/PFvDrNT.png%22 width=%221017%22 height=%22431%22/%3E%3C/p%3E%0A%3Cp%3ENow.... you think to yourself, %22%3Cem%3E\n how \n@@ -1345,16 +1345,21 @@\n  to sell\n+%3C/em%3E\n  if you \n@@ -1386,16 +1386,46 @@\n ight now\n+ at the price the chart is at%22\n ? Your b\n@@ -1524,149 +1524,562 @@\n  in \n-and why using sheets is so awesome. At a quick glance the sheet will show you just how many coins to sell based on what the current price is!\n+handy and i recommend it as a traders tool you have and why using sheets is so awesome plus having an accurate formula that works it out. Some people use guess work and i guess that's ok to get a ballpark figure. But it can be done so you absolutely know... so why not. At a quick glance the sheet will show you just how many coins to sell using the current price! There is another post here that goes into more detail about %3Ca href=%22https://steemit.com/trading/@jaffasoft/cryptocurrency-break-even-point-google-sheet-formula-for-dummies%22%3Ebreak-even%3C/a%3E.\n %3C/p%3E\n@@ -2116,15 +2116,15 @@\n com/\n-4OwH6Zv\n+QpVw3qQ\n .png\n@@ -2137,11 +2137,11 @@\n h=%221\n-374\n+018\n %22 he\n@@ -2150,11 +2150,11 @@\n ht=%22\n-529\n+393\n %22/%3E%3C\n@@ -2227,20 +2227,19 @@\n eet \n-15.41462713.\n+22.92964214\n &nbs\n@@ -2240,32 +2240,36 @@\n 14&nbsp;%3C/p%3E%0A%3Cp%3E\n+and \n Sell layer 3). 1\n@@ -2271,19 +2271,19 @@\n 3). \n-15.41462713\n+22.92964214\n  coi\n@@ -2313,187 +2313,1113 @@\n %0A%3Cp%3E\n-Or you might just round it up to 16 and go to the exchange and sell that amount.&nbsp;%3C/p%3E%0A%3Cp%3E%3Cimg src=%22https://i.imgur.com/hfOjRb1.png%22 width=%221263%22 height=%22522%22/%3E%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p\n+Notice the profit in the sheet now turns to $0.00%25 and the percent is -0.00%25. That's because you are now break even. You have recovered the total principle that you spent on all the buy layers from 1 to 4. The principle is the total amount of FIAT you have spent to buy all the coins.&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EOr you might just round the amount up to 23 coins and go to the exchange and sell that amount.&nbsp;It wont be exactly exact but it will be very close quick and easy to do and you know it definitely covers what you outlaid (the principle). Plus some exchanges only take some orders with two decimal places. Then simply type in 23 into the next cell column in the sheet and it will continue calculating as normal.&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EIf you're using the QFL trading method at this point your trade is complete (for now). What you have left is what Luc describes as %22free coins%22. I've put a link to Lucs steemit blog down a little lower so you can learn straight from the horses mouth.&nbsp;%3C/p%3E%0A%3Ch2%3E%3Cstrong%3ESelling 30%25 in the future when you get that %22Hot Potato%22 feeling.&nbsp;%3C/strong%3E%3C/h2\n %3E%0A%3Cp\n@@ -3439,16 +3439,21 @@\n  a fews \n+days/\n weeks/mo\n@@ -3613,14 +3613,8 @@\n mple\n-s sack\n  we'\n@@ -3717,50 +3717,29 @@\n ere \n-according to Lucs methodology when you get\n+Luc describes getting\n  tha\n@@ -3765,16 +3765,19 @@\n ing \n-you\n+and\n  sell\n+ing\n  30%25\n@@ -3953,17 +3953,17 @@\n %25) 1\n-0.6756118\n+1.1211073\n 6 co\n@@ -4034,23 +4034,31 @@\n ell \n-30%25) 7.47292830\n+another 30%25) 7.78477515\n  coi\n@@ -4134,17 +4134,31 @@\n ell \n-30%25) 2.24\n+another 30%25) 5.44934261\n  coi\n@@ -4174,36 +4174,123 @@\n e of 200%3C/p%3E%0A%3Cp%3E\n-%3Cbr%3E\n+Again as you sell these you might round down and or up for 11, 8 and 6 coins perhaps.&nbsp;\n %3C/p%3E%0A%3Cp%3E%3Cimg src\n@@ -4315,15 +4315,15 @@\n com/\n-6oJUsa3\n+T6ioEcM\n .png\n@@ -4336,11 +4336,11 @@\n h=%221\n-375\n+021\n %22 he\n@@ -4349,11 +4349,11 @@\n ht=%22\n-546\n+427\n %22/%3E%3C\n@@ -4718,40 +4718,8 @@\n ain.\n- The market does goes in cycles.\n  The\n@@ -4731,16 +4731,22 @@\n olation \n+prise \n is that \n@@ -4830,65 +4830,41 @@\n  go \n-buy an island and enjoy some time on the beach in the sun\n+and spend some money on something\n .&nb\n@@ -5140,60 +5140,14 @@\n ent!\n- So to grab your copy of the sheet here is the link:\n+&nbsp;\n %3C/p%3E\n@@ -5359,32 +5359,123 @@\n e columns.&nbsp;\n+By all means open those columns up (I usually do) to look at the buy fee details etc.&nbsp;\n %3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E\n@@ -6230,27 +6230,320 @@\n %3Cbr%3E%3C/p%3E%0A%3Cp%3E\n-%3Cbr\n+And that's about it. I am doing a series of spreadsheets. So there is a few other to check out in my blog.&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EAll the information and videos you need to learn about the QFL trading methodology is here:%3C/p%3E%0A%3Cp%3E%3Ca href=%22https://steemit.com/@quickfingersluc%22%3EQuickFingersLuc%3C/a\n %3E%3C/p%3E%0A%3Ch1%3E%3Cs\n@@ -6553,16 +6553,22 @@\n ng%3ESome \n+other \n helpful \n@@ -8222,23 +8222,30 @@\n ile \n-being \n in Beta\n-. \n+:%3C/p%3E%0A%3Cp%3E&nbsp;\n %3Ca h\n@@ -8299,20 +8299,22 @@\n %3C/p%3E%0A%3Cp%3E\n-and \n+&nbsp;\n %3Ca href=\n",
      "json_metadata": "{\"tags\":[\"qfl\",\"breakeven\",\"trading\",\"sheet\"],\"image\":[\"https://i.imgur.com/PFvDrNT.png\",\"https://i.imgur.com/QpVw3qQ.png\",\"https://i.imgur.com/T6ioEcM.png\",\"https://i.imgur.com/nAoxsDa.png\"],\"links\":[\"https://docs.google.com/spreadsheets/d/1IT-M1FWxr6yzZ-Z7uMAXzJf1ggH_Uk-CQfAsNUT9GF8/edit?usp=sharing\",\"https://steemit.com/trading/@jaffasoft/cryptocurrency-break-even-point-google-sheet-formula-for-dummies\",\"https://steemit.com/@quickfingersluc\",\"https://www.independentreserve.com?invite=YDMBRC\",\"https://www.coinigy.com/?r=e2347957\",\"http://my.fishbank.io/go/1603\",\"https://www.binance.com/?ref=11230913\",\"https://www.cryptopia.co.nz/Register?referrer=Jaffasoft\",\"https://www.coinspot.com.au?affiliate=HHGC1\",\"https://hitbtc.com/?ref_id=5a618558a8c17\",\"https://ref.nordvpn.com/?id=533795790\",\"https://gate.io/signup/1189157\",\"https://www.altcoin.io?kid=MA46T\",\"https://www.bitmex.com/register/IKhyNY\",\"https://www.quadrigacx.com/?ref=s2z3kcinbqi7xtunkzs2uh7g\",\"https://3commas.io/?c=qlf_slack\",\"https://via.world/\",\"https://tradedash.io/\"],\"app\":\"steemit/0.1\",\"format\":\"html\"}"
    }
  ]
}
2018/06/12 23:08:12
parent author
parent permlinkqfl
authorjaffasoft
permlinkunlimited-crypto-buy-and-sell-layers-break-even-google-sheet
titleUnlimited Crypto Buy & Sell Layers Break-even Google Sheet
body<html> <h2><br></h2> <h2>How to know how many crypto coins to sell right now so you break-even, in a simple easy to use Google sheet!</h2> <p><a href="https://docs.google.com/spreadsheets/d/1IT-M1FWxr6yzZ-Z7uMAXzJf1ggH_Uk-CQfAsNUT9GF8/edit?usp=sharing">Here is the Google sheet straight up so you can make a copy and use yourself.</a> &nbsp;</p> <p>All the information and videos you need to learn about the QFL trading method is here:</p> <p><a href="https://steemit.com/@quickfingersluc">QuickFingersLuc</a></p> <p><br></p> <p>I did a post about the formula i used to work out what break-even point is in an advanced crypto trading spreadsheet designed specifically for the trading strategy and methodology of QFL because i noticed ways around that people were doing it incorrect! Where you buy a specific coin at various prices and various amounts, during a panic unfolding in the market. Normally increasing the buy amount as the price drops lower under a base in a safe cycle.&nbsp;</p> <p><br></p> <p>There is an awful lot in the sheet which is great for those that like to see what is happening with the math for every aspect of the trade. Individual layered buy fees, sell fees, profit &amp; lose, allocation of funds down layers, amounts bought, sold, free coins, how much to sell to break-even "now" etc and many many other variables. But it could be a bit tricky to use for a newbie. So i did a challenge for myself to build a new sheet and break it down to as elegant and simple as i could get it. &nbsp;</p> <p><br></p> <p>The main reason for the detailed advanced sheet was also a stepping stone for me to learn all about how crypto is calculated and the math. I like to dig deep into details of how things work and crypto was all new to me.&nbsp;</p> <p><br></p> <p>So whats this simple sheet for? All you have to do is enter the buy, sell and quantities. You might ask why do this when there are other sheets out there already doing this? I could not find a sheet out there that calculates the amount of coins you need to sell to break-even correctly. So i built my break-even formula in.&nbsp;</p> <p><br></p> <p>For example. Say you have bought EOS/USDT and layered down some buys as such:</p> <p>Buy layer 1). 1000 &nbsp;coins @ price 20</p> <p>Buy layer 2). 1000 coins @ price 18.53</p> <p>Buy layer 3). 3000 coins @ price 17.26</p> <p>Buy layer 4). 10000 coins @ price 17</p> <p><br></p> <p>The price starts to rise and as its bouncing you make a couple of sell orders at 22.6 and 23.4.</p> <p>Sell layer 1). 60 coins @ price 22.6</p> <p>Sell layer 2). 23 coins @ price 23.4</p> <p><br></p> <p>Now.... how in the freaken hell do you work out how many coins to sell if you want to break-even right now? Your buy fee is 0.1% and the same for the sell fee. This is where the power of Google sheets comes in and why using sheets is so awesome. At a quick glance the sheet will show you just how many coins to sell based on what the current price is!</p> <p><img src="https://i.imgur.com/4OwH6Zv.png" width="1374" height="529"/></p> <p>So you key in the next sell quantity cell in your Goggle sheet 15.41462713.&nbsp;</p> <p>Sell layer 3). 15.41462713 coins @ price 24&nbsp;</p> <p>Or you might just round it up to 16 and go to the exchange and sell that amount.&nbsp;</p> <p><img src="https://i.imgur.com/hfOjRb1.png" width="1263" height="522"/></p> <p><br></p> <p>Fast forward a fews weeks/months/years and EOS has mooned to 100-200 or 300 or maybe it's just 50, maybe it's gone to 1000 who knows. Nothing surprises me in crypto anymore. For examples sack we'll say it reached all three prices at various different all time highs in the market. This is where according to Lucs methodology when you get that "Hot Potato" feeling you sell 30% of the free coins you are holding in a wallet. The sheet calculates for you what amount of coins to sell.&nbsp;</p> <p><br></p> <p>Sell layer 4). (in the future sell 30%) 10.67561186 coins @ price of 50</p> <p>Sell layer 5). (further in the future sell 30%) 7.47292830 coins @ price of 100</p> <p>Sell layer 6). (even further in the future sell 30%) 2.24 coins @ price of 200</p> <p><br></p> <p><img src="https://i.imgur.com/6oJUsa3.png" width="1375" height="546"/></p> <p>&nbsp;You might wander why sell the coins instead just leave them to grow? Well, with the nature of crypto and it being so volatile meaning it can go up and down dramatically by large percentages in a relatively short period of time. It makes sense to sell when you feel the coin has gone pretty high in price and might be due to turn and drop down again. The market does goes in cycles. The consolation is that you can invest that money back into another trade and start all over again or go buy an island and enjoy some time on the beach in the sun.&nbsp;</p> <p><br></p> <p><br></p> <p>When you have the sheet open and doing this it all happens quickly though a trade may take days weeks months and or even years, so you can go back and open the sheet and you will not have forgotten what you did. Good financial management! So to grab your copy of the sheet here is the link:</p> <p>When you open the sheet there is also some columns that you can open if you want to see the buy sell fees and some other details to the right i have set them to be out of site and simple by hiding those columns.&nbsp;</p> <p><br></p> <p>A trick to copy and pasting numbers in google sheets which you will find you need to do quite often when using these sheets. Is to use the paste special so that when you copy &amp; paste the numbers from one cell to another it does not paste the formula and bugger up your sheet. So to copy a cell copy as normal (Command C) and but you go to the menu and special paste it. So it pastes the values only not the formula! On mac I use Shift Command V. I'm not sure of windows but just have a look at the menu in Google sheets. Here is a screen shot of the menu for special paste. I often copy &amp; paste special the break-even amount into the next sell layer.</p> <p><img src="https://i.imgur.com/nAoxsDa.png" width="1212" height="563"/></p> <p><br></p> <p><br></p> <h1><strong>Some helpful links.</strong></h1> <p>If you're thinking of signing up to any exchanges you may find my below affiliate links beneficial for you:</p> <p>An Australian crypto exchange. <a href="https://www.independentreserve.com?invite=YDMBRC">Independent Reserve</a>&nbsp;</p> <p>A UI trading platform. <a href="https://www.coinigy.com/?r=e2347957">Coinigy</a></p> <p>A crypto game. <a href="http://my.fishbank.io/go/1603">Fishbank</a></p> <p>A popular trading exchange. <a href="https://www.binance.com/?ref=11230913">Binance</a></p> <p>Popular exchange for small account building. <a href="https://www.cryptopia.co.nz/Register?referrer=Jaffasoft">Cryptobia</a></p> <p>Popular Aussie exchange for mums and dads easy crypto trading. <a href="https://www.coinspot.com.au?affiliate=HHGC1">Coinspot</a></p> <p>Popular exchange for small account building trading. <a href="https://hitbtc.com/?ref_id=5a618558a8c17">HitBTC</a></p> <p>VPN Virtual Private Network to protect you privacy when trading. <a href="https://ref.nordvpn.com/?id=533795790">NordVPN</a></p> <p>Exchange with a lot of USDT trading pairs. <a href="https://gate.io/signup/1189157">Gate</a></p> <p>Another exchange. <a href="https://www.altcoin.io?kid=MA46T">AltCoin</a>&nbsp;</p> <p>Another exchange. <a href="https://www.bitmex.com/register/IKhyNY">BitMEX</a>&nbsp;</p> <p>Another exchange. <a href="https://www.quadrigacx.com/?ref=s2z3kcinbqi7xtunkzs2uh7g">Quadrigacx</a></p> <p><a href="https://3commas.io/?c=qlf_slack">Trading Bot does trades for you.</a></p> <p><br></p> <p><br></p> <p>I also recommend some up and coming trading platforms to keep an eye on. They are currently free to use while being in Beta. <a href="https://via.world/">https://via.world/</a></p> <p>and <a href="https://tradedash.io/">https://tradedash.io/</a></p> <p><br></p> </html>
json metadata{"tags":["qfl","breakeven","trading","sheet"],"image":["https://i.imgur.com/4OwH6Zv.png","https://i.imgur.com/hfOjRb1.png","https://i.imgur.com/6oJUsa3.png","https://i.imgur.com/nAoxsDa.png"],"links":["https://docs.google.com/spreadsheets/d/1IT-M1FWxr6yzZ-Z7uMAXzJf1ggH_Uk-CQfAsNUT9GF8/edit?usp=sharing","https://steemit.com/@quickfingersluc","https://www.independentreserve.com?invite=YDMBRC","https://www.coinigy.com/?r=e2347957","http://my.fishbank.io/go/1603","https://www.binance.com/?ref=11230913","https://www.cryptopia.co.nz/Register?referrer=Jaffasoft","https://www.coinspot.com.au?affiliate=HHGC1","https://hitbtc.com/?ref_id=5a618558a8c17","https://ref.nordvpn.com/?id=533795790","https://gate.io/signup/1189157","https://www.altcoin.io?kid=MA46T","https://www.bitmex.com/register/IKhyNY","https://www.quadrigacx.com/?ref=s2z3kcinbqi7xtunkzs2uh7g","https://3commas.io/?c=qlf_slack","https://via.world/","https://tradedash.io/"],"app":"steemit/0.1","format":"html"}
Transaction InfoBlock #23269741/Trx 7c4be3a3067a91ac50e3ab34ac80fcc5433afc24
View Raw JSON Data
{
  "trx_id": "7c4be3a3067a91ac50e3ab34ac80fcc5433afc24",
  "block": 23269741,
  "trx_in_block": 19,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-12T23:08:12",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "qfl",
      "author": "jaffasoft",
      "permlink": "unlimited-crypto-buy-and-sell-layers-break-even-google-sheet",
      "title": "Unlimited Crypto Buy & Sell Layers Break-even Google Sheet",
      "body": "<html>\n<h2><br></h2>\n<h2>How to know how many crypto coins to sell right now so you break-even, in a simple easy to use Google sheet!</h2>\n<p><a href=\"https://docs.google.com/spreadsheets/d/1IT-M1FWxr6yzZ-Z7uMAXzJf1ggH_Uk-CQfAsNUT9GF8/edit?usp=sharing\">Here is the Google sheet straight up so you can make a copy and use yourself.</a> &nbsp;</p>\n<p>All the information and videos you need to learn about the QFL trading method is here:</p>\n<p><a href=\"https://steemit.com/@quickfingersluc\">QuickFingersLuc</a></p>\n<p><br></p>\n<p>I did a post about the formula i used to work out what break-even point is in an advanced crypto trading spreadsheet designed specifically for the trading strategy and methodology of QFL because i noticed ways around that people were doing it incorrect! Where you buy a specific coin at various prices and various amounts, during a panic unfolding in the market. Normally increasing the buy amount as the price drops lower under a base in a safe cycle.&nbsp;</p>\n<p><br></p>\n<p>There is an awful lot in the sheet which is great for those that like to see what is happening with the math for every aspect of the trade. Individual layered buy fees, sell fees, profit &amp; lose, allocation of funds down layers, amounts bought, sold, free coins, how much to sell to break-even \"now\" etc and many many other variables. But it could be a bit tricky to use for a newbie. So i did a challenge for myself to build a new sheet and break it down to as elegant and simple as i could get it. &nbsp;</p>\n<p><br></p>\n<p>The main reason for the detailed advanced sheet was also a stepping stone for me to learn all about how crypto is calculated and the math. I like to dig deep into details of how things work and crypto was all new to me.&nbsp;</p>\n<p><br></p>\n<p>So whats this simple sheet for? All you have to do is enter the buy, sell and quantities. You might ask why do this when there are other sheets out there already doing this? I could not find a sheet out there that calculates the amount of coins you need to sell to break-even correctly. So i built my break-even formula in.&nbsp;</p>\n<p><br></p>\n<p>For example. Say you have bought EOS/USDT and layered down some buys as such:</p>\n<p>Buy layer 1). 1000 &nbsp;coins @ price 20</p>\n<p>Buy layer 2). 1000 coins @ price 18.53</p>\n<p>Buy layer 3). 3000 coins @ price 17.26</p>\n<p>Buy layer 4). 10000 coins @ price 17</p>\n<p><br></p>\n<p>The price starts to rise and as its bouncing you make a couple of sell orders at 22.6 and 23.4.</p>\n<p>Sell layer 1). 60 coins @ price 22.6</p>\n<p>Sell layer 2). 23 coins @ price 23.4</p>\n<p><br></p>\n<p>Now.... how in the freaken hell do you work out how many coins to sell if you want to break-even right now? Your buy fee is 0.1% and the same for the sell fee. This is where the power of Google sheets comes in and why using sheets is so awesome. At a quick glance the sheet will show you just how many coins to sell based on what the current price is!</p>\n<p><img src=\"https://i.imgur.com/4OwH6Zv.png\" width=\"1374\" height=\"529\"/></p>\n<p>So you key in the next sell quantity cell in your Goggle sheet 15.41462713.&nbsp;</p>\n<p>Sell layer 3). 15.41462713 coins @ price 24&nbsp;</p>\n<p>Or you might just round it up to 16 and go to the exchange and sell that amount.&nbsp;</p>\n<p><img src=\"https://i.imgur.com/hfOjRb1.png\" width=\"1263\" height=\"522\"/></p>\n<p><br></p>\n<p>Fast forward a fews weeks/months/years and EOS has mooned to 100-200 or 300 or maybe it's just 50, maybe it's gone to 1000 who knows. Nothing surprises me in crypto anymore. For examples sack we'll say it reached all three prices at various different all time highs in the market. This is where according to Lucs methodology when you get that \"Hot Potato\" feeling you sell 30% of the free coins you are holding in a wallet. The sheet calculates for you what amount of coins to sell.&nbsp;</p>\n<p><br></p>\n<p>Sell layer 4). (in the future sell 30%) 10.67561186 coins @ price of 50</p>\n<p>Sell layer 5). (further in the future sell 30%) 7.47292830 coins @ price of 100</p>\n<p>Sell layer 6). (even further in the future sell 30%) 2.24 coins @ price of 200</p>\n<p><br></p>\n<p><img src=\"https://i.imgur.com/6oJUsa3.png\" width=\"1375\" height=\"546\"/></p>\n<p>&nbsp;You might wander why sell the coins instead just leave them to grow? Well, with the nature of crypto and it being so volatile meaning it can go up and down dramatically by large percentages in a relatively short period of time. It makes sense to sell when you feel the coin has gone pretty high in price and might be due to turn and drop down again. The market does goes in cycles. The consolation is that you can invest that money back into another trade and start all over again or go buy an island and enjoy some time on the beach in the sun.&nbsp;</p>\n<p><br></p>\n<p><br></p>\n<p>When you have the sheet open and doing this it all happens quickly though a trade may take days weeks months and or even years, so you can go back and open the sheet and you will not have forgotten what you did. Good financial management! So to grab your copy of the sheet here is the link:</p>\n<p>When you open the sheet there is also some columns that you can open if you want to see the buy sell fees and some other details to the right i have set them to be out of site and simple by hiding those columns.&nbsp;</p>\n<p><br></p>\n<p>A trick to copy and pasting numbers in google sheets which you will find you need to do quite often when using these sheets. Is to use the paste special so that when you copy &amp; paste the numbers from one cell to another it does not paste the formula and bugger up your sheet. So to copy a cell copy as normal (Command C) and but you go to the menu and special paste it. So it pastes the values only not the formula! On mac I use Shift Command V. I'm not sure of windows but just have a look at the menu in Google sheets. Here is a screen shot of the menu for special paste. I often copy &amp; paste special the break-even amount into the next sell layer.</p>\n<p><img src=\"https://i.imgur.com/nAoxsDa.png\" width=\"1212\" height=\"563\"/></p>\n<p><br></p>\n<p><br></p>\n<h1><strong>Some helpful links.</strong></h1>\n<p>If you're thinking of signing up to any exchanges you may find my below affiliate links beneficial for you:</p>\n<p>An Australian crypto exchange. <a href=\"https://www.independentreserve.com?invite=YDMBRC\">Independent Reserve</a>&nbsp;</p>\n<p>A UI trading platform. <a href=\"https://www.coinigy.com/?r=e2347957\">Coinigy</a></p>\n<p>A crypto game. <a href=\"http://my.fishbank.io/go/1603\">Fishbank</a></p>\n<p>A popular trading exchange. <a href=\"https://www.binance.com/?ref=11230913\">Binance</a></p>\n<p>Popular exchange for small account building. <a href=\"https://www.cryptopia.co.nz/Register?referrer=Jaffasoft\">Cryptobia</a></p>\n<p>Popular Aussie exchange for mums and dads easy crypto trading. <a href=\"https://www.coinspot.com.au?affiliate=HHGC1\">Coinspot</a></p>\n<p>Popular exchange for small account building trading. <a href=\"https://hitbtc.com/?ref_id=5a618558a8c17\">HitBTC</a></p>\n<p>VPN Virtual Private Network to protect you privacy when trading. <a href=\"https://ref.nordvpn.com/?id=533795790\">NordVPN</a></p>\n<p>Exchange with a lot of USDT trading pairs. <a href=\"https://gate.io/signup/1189157\">Gate</a></p>\n<p>Another exchange. <a href=\"https://www.altcoin.io?kid=MA46T\">AltCoin</a>&nbsp;</p>\n<p>Another exchange. <a href=\"https://www.bitmex.com/register/IKhyNY\">BitMEX</a>&nbsp;</p>\n<p>Another exchange. <a href=\"https://www.quadrigacx.com/?ref=s2z3kcinbqi7xtunkzs2uh7g\">Quadrigacx</a></p>\n<p><a href=\"https://3commas.io/?c=qlf_slack\">Trading Bot does trades for you.</a></p>\n<p><br></p>\n<p><br></p>\n<p>I also recommend some up and coming trading platforms to keep an eye on. They are currently free to use while being in Beta. <a href=\"https://via.world/\">https://via.world/</a></p>\n<p>and <a href=\"https://tradedash.io/\">https://tradedash.io/</a></p>\n<p><br></p>\n</html>",
      "json_metadata": "{\"tags\":[\"qfl\",\"breakeven\",\"trading\",\"sheet\"],\"image\":[\"https://i.imgur.com/4OwH6Zv.png\",\"https://i.imgur.com/hfOjRb1.png\",\"https://i.imgur.com/6oJUsa3.png\",\"https://i.imgur.com/nAoxsDa.png\"],\"links\":[\"https://docs.google.com/spreadsheets/d/1IT-M1FWxr6yzZ-Z7uMAXzJf1ggH_Uk-CQfAsNUT9GF8/edit?usp=sharing\",\"https://steemit.com/@quickfingersluc\",\"https://www.independentreserve.com?invite=YDMBRC\",\"https://www.coinigy.com/?r=e2347957\",\"http://my.fishbank.io/go/1603\",\"https://www.binance.com/?ref=11230913\",\"https://www.cryptopia.co.nz/Register?referrer=Jaffasoft\",\"https://www.coinspot.com.au?affiliate=HHGC1\",\"https://hitbtc.com/?ref_id=5a618558a8c17\",\"https://ref.nordvpn.com/?id=533795790\",\"https://gate.io/signup/1189157\",\"https://www.altcoin.io?kid=MA46T\",\"https://www.bitmex.com/register/IKhyNY\",\"https://www.quadrigacx.com/?ref=s2z3kcinbqi7xtunkzs2uh7g\",\"https://3commas.io/?c=qlf_slack\",\"https://via.world/\",\"https://tradedash.io/\"],\"app\":\"steemit/0.1\",\"format\":\"html\"}"
    }
  ]
}
2018/06/06 13:45:36
parent authorjaffasoft
parent permlinkcryptocurrency-break-even-point-google-sheet-formula-for-dummies
authorsteemitboard
permlinksteemitboard-notify-jaffasoft-20180606t134536000z
title
bodyCongratulations @jaffasoft! You have completed some achievement on Steemit and have been rewarded with new badge(s) : [![](https://steemitimages.com/70x70/http://steemitboard.com/notifications/firstpost.png)](http://steemitboard.com/@jaffasoft) You published your First Post [![](https://steemitimages.com/70x70/http://steemitboard.com/notifications/firstvoted.png)](http://steemitboard.com/@jaffasoft) You got a First Vote <sub>_Click on the badge to view your Board of Honor._</sub> <sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub> > Do you like [SteemitBoard's project](https://steemit.com/@steemitboard)? Then **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!
json metadata{"image":["https://steemitboard.com/img/notify.png"]}
Transaction InfoBlock #23086304/Trx bae9c9dd4fccd2d61f55c346aec42d2001309dd8
View Raw JSON Data
{
  "trx_id": "bae9c9dd4fccd2d61f55c346aec42d2001309dd8",
  "block": 23086304,
  "trx_in_block": 11,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-06T13:45:36",
  "op": [
    "comment",
    {
      "parent_author": "jaffasoft",
      "parent_permlink": "cryptocurrency-break-even-point-google-sheet-formula-for-dummies",
      "author": "steemitboard",
      "permlink": "steemitboard-notify-jaffasoft-20180606t134536000z",
      "title": "",
      "body": "Congratulations @jaffasoft! You have completed some achievement on Steemit and have been rewarded with new badge(s) :\n\n[![](https://steemitimages.com/70x70/http://steemitboard.com/notifications/firstpost.png)](http://steemitboard.com/@jaffasoft) You published your First Post\n[![](https://steemitimages.com/70x70/http://steemitboard.com/notifications/firstvoted.png)](http://steemitboard.com/@jaffasoft) You got a First Vote\n\n<sub>_Click on the badge to view your Board of Honor._</sub>\n<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>\n\n\n\n> Do you like [SteemitBoard's project](https://steemit.com/@steemitboard)? Then **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}"
    }
  ]
}
2018/06/06 03:13:51
parent author
parent permlinktrading
authorjaffasoft
permlinkcryptocurrency-break-even-point-google-sheet-formula-for-dummies
titleCryptocurrency Break-even Point Google Sheet Formula for Dummies
body@@ -82,14 +82,22 @@ for -anyone +crypto traders fee @@ -158,45 +158,939 @@ oint - in your crypto trading. &nbsp;&nbsp; +.%3C/p%3E%0A%3Cp%3E%3Cstrong%3EFirst what is break-even?%3C/strong%3E&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EIf you walked into a crypto exchange and you had $10 in your pocket and you bought $10 worth of Bitcoin and Bitcoin went up and is now worth $20. You might want to get that $10 back. So you should sell enough so that it also covers for both the buy and sell fees and you get back the exact $10 back in your pocket that you started with. You have not won, you have not lost, you have broken even! That $10 is called the principle and is an accounting term. Because your little bit of Bitcoin is worth $20 you still have about $10 worth left on the exchange (minus the fees paid). You have taken the $10 out that you risked in the first place and now the price has gone up you have taken that $10 principle back out. And you have your winnings still in the exchange to rise or fall in the future. This profit it what we call %22FREE coins%22.&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E %3C/p%3E @@ -1390,30 +1390,136 @@ %0A%3Cp%3E -What Google sheet cell +%3Cbr%3E%3C/p%3E%0A%3Cp%3E%3Cstrong%3EThe Formula:%3C/strong%3E%3C/p%3E%0A%3Cp%3ECopy &amp; paste this code onto any single Google sheet cell formula bar and it wil @@ -1598,32 +1598,40 @@ n.&nbsp;%3C/p%3E%0A%3Cp%3E +%3Cstrong%3E =SUM(1/(1-.1%25)*( @@ -1654,24 +1654,33 @@ )*.1%25)/30)%3C/ +strong%3E%3C/ p%3E%0A%3Cp%3EThe sa @@ -1743,32 +1743,40 @@ t.&nbsp;%3C/p%3E%0A%3Cp%3E +%3Cstrong%3E =SUM(1/(1-sell_p @@ -1841,24 +1841,33 @@ ent_price)%3C/ +strong%3E%3C/ p%3E%0A%3Cp%3E... an @@ -2143,16 +2143,24 @@ %3C/p%3E%0A%3Cp%3E +%3Cstrong%3E Basic st @@ -2165,16 +2165,25 @@ steps:%3C/ +strong%3E%3C/ p%3E%0A%3Col%3E%0A @@ -2521,24 +2521,36 @@ %3Cp%3E%3Cbr%3E%3C/p%3E%0A +%3Cp%3E%3Cbr%3E%3C/p%3E%0A %3Cp%3EIt took m @@ -2819,24 +2819,48 @@ %3Cp%3E%3Cbr%3E%3C/p%3E%0A +%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A %3Cp%3EI searche @@ -3708,32 +3708,40 @@ l.&nbsp;%3C/p%3E%0A%3Cp%3E +%3Cstrong%3E Example 1).%3C/p%3E%0A @@ -3737,21 +3737,38 @@ le 1).%3C/ -p%3E%0A%3Cp +strong%3E%3C/p%3E%0A%3Cp%3E%3Cstrong %3E=SUM(1/ @@ -3800,16 +3800,25 @@ 2)/F2)%3C/ +strong%3E%3C/ p%3E%0A%3Cp%3EWh @@ -4471,32 +4471,40 @@ answer.%3C/p%3E%0A%3Cp%3E +%3Cstrong%3E =SUM(1/(1-.1%25)*( @@ -4531,21 +4531,38 @@ %25)/30)%3C/ -p%3E%0A%3Cp +strong%3E%3C/p%3E%0A%3Cp%3E%3Cstrong %3E=SUM(1/ @@ -4640,16 +4640,25 @@ price)%3C/ +strong%3E%3C/ p%3E%0A%3Cp%3E%3Cb @@ -5171,32 +5171,40 @@ p%3E&nbsp;%3C/p%3E%0A%3Cp%3E +%3Cstrong%3E Example 2).%3C/p%3E%0A @@ -5196,24 +5196,33 @@ xample 2).%3C/ +strong%3E%3C/ p%3E%0A%3Cp%3EAnothe @@ -5857,32 +5857,40 @@ e.&nbsp;%3C/p%3E%0A%3Cp%3E +%3Cstrong%3E Example 3).%3C/p%3E%0A @@ -5882,24 +5882,33 @@ xample 3).%3C/ +strong%3E%3C/ p%3E%0A%3Cp%3EThis i @@ -6010,16 +6010,195 @@ %3C/p%3E%0A%3Cp%3E +Often the fee isn't even added and is done fast. In theory slowly over a lot of trades you would wither away at the principle and have none left eventually. &nbsp;%3C/p%3E%0A%3Cp%3E%3Cstrong%3E Example @@ -6202,16 +6202,25 @@ le 4).%3C/ +strong%3E%3C/ p%3E%0A%3Cp%3ESo @@ -6924,32 +6924,40 @@ %3C/p%3E%0A%3Col%3E%0A %3Cli%3E +%3Cstrong%3E Example $0.00 (c @@ -6965,16 +6965,25 @@ rrect)%3C/ +strong%3E%3C/ li%3E%0A %3Cl @@ -6976,32 +6976,40 @@ ong%3E%3C/li%3E%0A %3Cli%3E +%3Cstrong%3E Example -$2,000. @@ -7008,24 +7008,33 @@ -$2,000.00%3C/ +strong%3E%3C/ li%3E%0A %3Cli%3EEx @@ -7023,32 +7023,40 @@ ong%3E%3C/li%3E%0A %3Cli%3E +%3Cstrong%3E Example &nbsp;-$ @@ -7061,24 +7061,33 @@ -$1,001.00%3C/ +strong%3E%3C/ li%3E%0A %3Cli%3EEx @@ -7084,16 +7084,24 @@ %3E%0A %3Cli%3E +%3Cstrong%3E Example @@ -7114,16 +7114,25 @@ -$1.00%3C/ +strong%3E%3C/ li%3E%0A%3C/ol
json metadata{"tags":["trading","breakeven","formula","calculator","bitcoin"],"image":["https://i.imgur.com/RYFCDtN.png","https://i.imgur.com/6Zqpnw4.png","https://i.imgur.com/IJPJOED.png","https://i.imgur.com/HZUPXRx.png"],"links":["https://docs.google.com/spreadsheets/d/1zuZE4E4Ze8-qu5p7wpIRL5r7lDvccQMUNmP3hPrRjok/edit?usp=sharing"],"app":"steemit/0.1","format":"html"}
Transaction InfoBlock #23073672/Trx 48cb82f24247f258f629f9fd5f0e5ce5d9779f09
View Raw JSON Data
{
  "trx_id": "48cb82f24247f258f629f9fd5f0e5ce5d9779f09",
  "block": 23073672,
  "trx_in_block": 4,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-06T03:13:51",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "trading",
      "author": "jaffasoft",
      "permlink": "cryptocurrency-break-even-point-google-sheet-formula-for-dummies",
      "title": "Cryptocurrency Break-even Point Google Sheet Formula for Dummies",
      "body": "@@ -82,14 +82,22 @@\n for \n-anyone\n+crypto traders\n  fee\n@@ -158,45 +158,939 @@\n oint\n- in your crypto trading. &nbsp;&nbsp;\n+.%3C/p%3E%0A%3Cp%3E%3Cstrong%3EFirst what is break-even?%3C/strong%3E&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3EIf you walked into a crypto exchange and you had $10 in your pocket and you bought $10 worth of Bitcoin and Bitcoin went up and is now worth $20. You might want to get that $10 back. So you should sell enough so that it also covers for both the buy and sell fees and you get back the exact $10 back in your pocket that you started with. You have not won, you have not lost, you have broken even! That $10 is called the principle and is an accounting term. Because your little bit of Bitcoin is worth $20 you still have about $10 worth left on the exchange (minus the fees paid). You have taken the $10 out that you risked in the first place and now the price has gone up you have taken that $10 principle back out. And you have your winnings still in the exchange to rise or fall in the future. This profit it what we call %22FREE coins%22.&nbsp;%3C/p%3E%0A%3Cp%3E%3Cbr%3E\n %3C/p%3E\n@@ -1390,30 +1390,136 @@\n %0A%3Cp%3E\n-What Google sheet cell\n+%3Cbr%3E%3C/p%3E%0A%3Cp%3E%3Cstrong%3EThe Formula:%3C/strong%3E%3C/p%3E%0A%3Cp%3ECopy &amp; paste this code onto any single Google sheet cell formula bar and it\n  wil\n@@ -1598,32 +1598,40 @@\n n.&nbsp;%3C/p%3E%0A%3Cp%3E\n+%3Cstrong%3E\n =SUM(1/(1-.1%25)*(\n@@ -1654,24 +1654,33 @@\n )*.1%25)/30)%3C/\n+strong%3E%3C/\n p%3E%0A%3Cp%3EThe sa\n@@ -1743,32 +1743,40 @@\n t.&nbsp;%3C/p%3E%0A%3Cp%3E\n+%3Cstrong%3E\n =SUM(1/(1-sell_p\n@@ -1841,24 +1841,33 @@\n ent_price)%3C/\n+strong%3E%3C/\n p%3E%0A%3Cp%3E... an\n@@ -2143,16 +2143,24 @@\n %3C/p%3E%0A%3Cp%3E\n+%3Cstrong%3E\n Basic st\n@@ -2165,16 +2165,25 @@\n steps:%3C/\n+strong%3E%3C/\n p%3E%0A%3Col%3E%0A\n@@ -2521,24 +2521,36 @@\n %3Cp%3E%3Cbr%3E%3C/p%3E%0A\n+%3Cp%3E%3Cbr%3E%3C/p%3E%0A\n %3Cp%3EIt took m\n@@ -2819,24 +2819,48 @@\n %3Cp%3E%3Cbr%3E%3C/p%3E%0A\n+%3Cp%3E%3Cbr%3E%3C/p%3E%0A%3Cp%3E%3Cbr%3E%3C/p%3E%0A\n %3Cp%3EI searche\n@@ -3708,32 +3708,40 @@\n l.&nbsp;%3C/p%3E%0A%3Cp%3E\n+%3Cstrong%3E\n Example 1).%3C/p%3E%0A\n@@ -3737,21 +3737,38 @@\n le 1).%3C/\n-p%3E%0A%3Cp\n+strong%3E%3C/p%3E%0A%3Cp%3E%3Cstrong\n %3E=SUM(1/\n@@ -3800,16 +3800,25 @@\n 2)/F2)%3C/\n+strong%3E%3C/\n p%3E%0A%3Cp%3EWh\n@@ -4471,32 +4471,40 @@\n  answer.%3C/p%3E%0A%3Cp%3E\n+%3Cstrong%3E\n =SUM(1/(1-.1%25)*(\n@@ -4531,21 +4531,38 @@\n %25)/30)%3C/\n-p%3E%0A%3Cp\n+strong%3E%3C/p%3E%0A%3Cp%3E%3Cstrong\n %3E=SUM(1/\n@@ -4640,16 +4640,25 @@\n price)%3C/\n+strong%3E%3C/\n p%3E%0A%3Cp%3E%3Cb\n@@ -5171,32 +5171,40 @@\n p%3E&nbsp;%3C/p%3E%0A%3Cp%3E\n+%3Cstrong%3E\n Example 2).%3C/p%3E%0A\n@@ -5196,24 +5196,33 @@\n xample 2).%3C/\n+strong%3E%3C/\n p%3E%0A%3Cp%3EAnothe\n@@ -5857,32 +5857,40 @@\n e.&nbsp;%3C/p%3E%0A%3Cp%3E\n+%3Cstrong%3E\n Example 3).%3C/p%3E%0A\n@@ -5882,24 +5882,33 @@\n xample 3).%3C/\n+strong%3E%3C/\n p%3E%0A%3Cp%3EThis i\n@@ -6010,16 +6010,195 @@\n %3C/p%3E%0A%3Cp%3E\n+Often the fee isn't even added and is done fast. In theory slowly over a lot of trades you would wither away at the principle and have none left eventually. &nbsp;%3C/p%3E%0A%3Cp%3E%3Cstrong%3E\n Example \n@@ -6202,16 +6202,25 @@\n le 4).%3C/\n+strong%3E%3C/\n p%3E%0A%3Cp%3ESo\n@@ -6924,32 +6924,40 @@\n %3C/p%3E%0A%3Col%3E%0A  %3Cli%3E\n+%3Cstrong%3E\n Example $0.00 (c\n@@ -6965,16 +6965,25 @@\n rrect)%3C/\n+strong%3E%3C/\n li%3E%0A  %3Cl\n@@ -6976,32 +6976,40 @@\n ong%3E%3C/li%3E%0A  %3Cli%3E\n+%3Cstrong%3E\n Example -$2,000.\n@@ -7008,24 +7008,33 @@\n -$2,000.00%3C/\n+strong%3E%3C/\n li%3E%0A  %3Cli%3EEx\n@@ -7023,32 +7023,40 @@\n ong%3E%3C/li%3E%0A  %3Cli%3E\n+%3Cstrong%3E\n Example &nbsp;-$\n@@ -7061,24 +7061,33 @@\n -$1,001.00%3C/\n+strong%3E%3C/\n li%3E%0A  %3Cli%3EEx\n@@ -7084,16 +7084,24 @@\n %3E%0A  %3Cli%3E\n+%3Cstrong%3E\n Example \n@@ -7114,16 +7114,25 @@\n -$1.00%3C/\n+strong%3E%3C/\n li%3E%0A%3C/ol\n",
      "json_metadata": "{\"tags\":[\"trading\",\"breakeven\",\"formula\",\"calculator\",\"bitcoin\"],\"image\":[\"https://i.imgur.com/RYFCDtN.png\",\"https://i.imgur.com/6Zqpnw4.png\",\"https://i.imgur.com/IJPJOED.png\",\"https://i.imgur.com/HZUPXRx.png\"],\"links\":[\"https://docs.google.com/spreadsheets/d/1zuZE4E4Ze8-qu5p7wpIRL5r7lDvccQMUNmP3hPrRjok/edit?usp=sharing\"],\"app\":\"steemit/0.1\",\"format\":\"html\"}"
    }
  ]
}
2018/06/05 14:00:12
parent author
parent permlinktrading
authorjaffasoft
permlinkcryptocurrency-break-even-point-google-sheet-formula-for-dummies
titleCryptocurrency Break-even Point Google Sheet Formula for Dummies
body@@ -5308,17 +5308,16 @@ down -$2 -0 ,000.&nb @@ -8283,14 +8283,13 @@ ed? -Or can +Can I imp @@ -8298,20 +8298,28 @@ ve on an -d or +ything or do you kno @@ -8343,21 +8343,17 @@ do this - then +? I look @@ -8385,18 +8385,21 @@ omments -of +about various @@ -8428,16 +8428,21 @@ bsp;I'm +also interest @@ -8492,14 +8492,12 @@ and -or way +s tha
json metadata{"tags":["trading","breakeven","formula","calculator","bitcoin"],"image":["https://i.imgur.com/RYFCDtN.png","https://i.imgur.com/6Zqpnw4.png","https://i.imgur.com/IJPJOED.png","https://i.imgur.com/HZUPXRx.png"],"links":["https://docs.google.com/spreadsheets/d/1zuZE4E4Ze8-qu5p7wpIRL5r7lDvccQMUNmP3hPrRjok/edit?usp=sharing"],"app":"steemit/0.1","format":"html"}
Transaction InfoBlock #23057805/Trx 10e797a70fb69cd4e99dee82cb3f03d0278fc938
View Raw JSON Data
{
  "trx_id": "10e797a70fb69cd4e99dee82cb3f03d0278fc938",
  "block": 23057805,
  "trx_in_block": 130,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-05T14:00:12",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "trading",
      "author": "jaffasoft",
      "permlink": "cryptocurrency-break-even-point-google-sheet-formula-for-dummies",
      "title": "Cryptocurrency Break-even Point Google Sheet Formula for Dummies",
      "body": "@@ -5308,17 +5308,16 @@\n down -$2\n-0\n ,000.&nb\n@@ -8283,14 +8283,13 @@\n ed? \n-Or can\n+Can I\n  imp\n@@ -8298,20 +8298,28 @@\n ve on an\n-d or\n+ything or do\n  you kno\n@@ -8343,21 +8343,17 @@\n  do this\n- then\n+?\n  I look \n@@ -8385,18 +8385,21 @@\n omments \n-of\n+about\n  various\n@@ -8428,16 +8428,21 @@\n bsp;I'm \n+also \n interest\n@@ -8492,14 +8492,12 @@\n and \n-or \n way\n+s\n  tha\n",
      "json_metadata": "{\"tags\":[\"trading\",\"breakeven\",\"formula\",\"calculator\",\"bitcoin\"],\"image\":[\"https://i.imgur.com/RYFCDtN.png\",\"https://i.imgur.com/6Zqpnw4.png\",\"https://i.imgur.com/IJPJOED.png\",\"https://i.imgur.com/HZUPXRx.png\"],\"links\":[\"https://docs.google.com/spreadsheets/d/1zuZE4E4Ze8-qu5p7wpIRL5r7lDvccQMUNmP3hPrRjok/edit?usp=sharing\"],\"app\":\"steemit/0.1\",\"format\":\"html\"}"
    }
  ]
}
jaffasoftupdated their account properties
2018/06/05 13:38:24
accountjaffasoft
memo keySTM5MUBdSHD5qvSjzNR5kC6D59ggaR77T5agWDtua44eUvGPfXMZg
json metadata{"profile":{"name":"Jaffasoft","about":"Hippie ","location":"Northern Rivers, NSW,Australia","profile_image":"https://cdn.steemitimages.com/DQmYTmKpNnfycnRmmNhUghdPZFW2FBKBsjJB45ppjjK4VEk/Screen%20Shot%202018-01-22%20at%2011.07.21%20pm.png"}}
Transaction InfoBlock #23057369/Trx 1d58471d93028be06e200e92a826bcb7d0c3087d
View Raw JSON Data
{
  "trx_id": "1d58471d93028be06e200e92a826bcb7d0c3087d",
  "block": 23057369,
  "trx_in_block": 10,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-05T13:38:24",
  "op": [
    "account_update",
    {
      "account": "jaffasoft",
      "memo_key": "STM5MUBdSHD5qvSjzNR5kC6D59ggaR77T5agWDtua44eUvGPfXMZg",
      "json_metadata": "{\"profile\":{\"name\":\"Jaffasoft\",\"about\":\"Hippie \",\"location\":\"Northern Rivers, NSW,Australia\",\"profile_image\":\"https://cdn.steemitimages.com/DQmYTmKpNnfycnRmmNhUghdPZFW2FBKBsjJB45ppjjK4VEk/Screen%20Shot%202018-01-22%20at%2011.07.21%20pm.png\"}}"
    }
  ]
}
2018/06/05 13:34:30
voterax3
authorjaffasoft
permlinkcryptocurrency-break-even-point-google-sheet-formula-for-dummies
weight100 (1.00%)
Transaction InfoBlock #23057291/Trx 41eb0a475c59f2b9b54a04ca26b6c0e30a23cb94
View Raw JSON Data
{
  "trx_id": "41eb0a475c59f2b9b54a04ca26b6c0e30a23cb94",
  "block": 23057291,
  "trx_in_block": 25,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-05T13:34:30",
  "op": [
    "vote",
    {
      "voter": "ax3",
      "author": "jaffasoft",
      "permlink": "cryptocurrency-break-even-point-google-sheet-formula-for-dummies",
      "weight": 100
    }
  ]
}
2018/06/05 13:34:21
parent author
parent permlinktrading
authorjaffasoft
permlinkcryptocurrency-break-even-point-google-sheet-formula-for-dummies
titleCryptocurrency Break-even Point Google Sheet Formula for Dummies
body<html> <p>I'm dumb so this is the simple easy Google sheet and formula explained for anyone feeling a little lost about how to calculate break-even point in your crypto trading. &nbsp;&nbsp;</p> <p>Here's the formula if you're in a hurry and can't be bothered reading. This world is full of to much information. Dump this on a Google sheet cell and it's good to go. I don't use excel. Maybe you can adapt it and post some excel formulas in the comments section below to help people!?</p> <p>What Google sheet cell will tell you how many coins to sell at the exchange (exactly) to break-even.&nbsp;</p> <p>=SUM(1/(1-.1%)*((100*20)+(100*20)*.1%)/30)</p> <p>The same formula as above explaining what the numbers represent.&nbsp;</p> <p>=SUM(1/(1-sell_percent_fee)*((qty*price)+(qty*price)*buy_percent_fee)/current_price)</p> <p>... and here in use in an actual example Google sheet screenshot.&nbsp;</p> <p><img src="https://i.imgur.com/RYFCDtN.png" width="1393" height="215"/></p> <p>Here is the link to the Google sheet to make a copy with and learn the formulas and adapt it to your own sheets:&nbsp;</p> <p>Basic steps:</p> <ol> <li>[Click link to open Google Sheet](https://docs.google.com/spreadsheets/d/1zuZE4E4Ze8-qu5p7wpIRL5r7lDvccQMUNmP3hPrRjok/edit?usp=sharing)</li> <li>In the Google Sheet goto top menu area and in File &gt; Make a copy....</li> <li>You should now have your own copy of these break-even examples to learn from.&nbsp;</li> </ol> <p><br></p> <p>It took me a long time to work this out so I hope you enjoy it. I done my head in a number of times and spent many late nights up working on this. I'm not that gifted as math but once i worked it all out i wanted to make a detailed post and share it for other.&nbsp;</p> <p><br></p> <p>I searched a lot of places and couldn't find any accurate answers anywhere. Something wasn't right about the formulas I was trying... they were not returning to zero! Most places around, the way people are calculating the crypto trade break-even point is close but inaccurate if you want it to be absolutely right and to break-even to exactly zero not a cent more, not a penny less. If you have a number of different buys it gets even more difficult to work out and track. For smaller trades it makes little difference, only a few cents in the dollar and people don't worry about it. It's not going to break the bank balance. But for larger trades it can be out by hundreds of dollars. If you want it to be right so that break even is ZERO every time this is the formula to get your head around!&nbsp;</p> <p>So this is it! Just dump this on your cell.&nbsp;</p> <p>Example 1).</p> <p>=SUM(1/(1-G2)*((C2*D2)+(C2*D2)*E2)/F2)</p> <p>Where G2 is the sell fee percentage charged by the exchange normally about .1%. C2 is the quantity of coins you bought, D2 the buy price, E2 the sell fee percentage charged at the exchange say .1% again. And F2 is the price at which the coin has reached on the chart when you decide you want to sell to get back the total amount of money you have put in the trade plus fees. This is called break-even.&nbsp;</p> <p>If you bought a quantity of 100 EOS/USDT coins at $20 and the coins price has gone to $30 how many coins do you sell to break even? This is the tricky question! If you put this formula on a cell in a Google sheet it will tell you the answer.</p> <p>=SUM(1/(1-.1%)*((100*20)+(100*20)*.1%)/30)</p> <p>=SUM(1/(1-sell_percent_fee)*((qty*price)+(qty*price)*buy_percent_fee)/current_price)</p> <p><br></p> <p>The answer should be 66.80013347. You might decide to just round it up in your head quickly to 67 and sell that many at the exchange. Binance exchange expect only two decimal places to sell coins amounts so you would round up to say 67 or 66.81. When you go to the exchange and sell this amount of coins you will not lose any money and you will not make any money you will be at true break even (zero) if you can put exactly 66.80013347 as seen in this particular example.&nbsp;</p> <p><br></p> <p>&nbsp;</p> <p>Example 2).</p> <p>Another simple way to reach ("close to") break even point is to add up the total amount you spent on your trade(s). Still using the above example I would have spent 100 EOS @ 20c = a total of $2000. Then just divide $2000/coin_current price. &nbsp;2000/30= 66.67. So you sell 66.67 coins of EOS.&nbsp;</p> <p><br></p> <p>See how the answer is a little less then the first example of 66.80013347 compared to 66.67 that's because the first example covers the buy fee and the sell fee and the formula of which it is calculated. OK, so you could add a buy and a sell fee and get "closer" but it still won't be exact as in the first example.&nbsp;</p> <p>Example 3).</p> <p>This is how most people do it, they will take the total spent. =SUM(2000+(2000*.1%))/30 = 66.73&nbsp;</p> <p>Example 4).</p> <p>Some might go as far as adding a sell fee and generally the way it's calculate it will be so close to correct that it will actually round to the right dollar amount for small transactions. I tested all four different ways as described here in this post and i have provided the sheet for you to make a copy. On a hypothetical transaction of one million the results of the second example is out by -$2,000. So using that way when you think you have broken even would be down -$20,000.&nbsp;</p> <p><img src="https://i.imgur.com/6Zqpnw4.png" width="1398" height="210"/></p> <p><br></p> <p>I put a large amount in here because there is whales out there doing big trades and they might want to know.&nbsp;</p> <ol> <li>Example $0.00 (correct)</li> <li>Example -$2,000.00</li> <li>Example &nbsp;-$1,001.00</li> <li>Example &nbsp;-$1.00</li> </ol> <p>So there you have it.&nbsp;</p> <p><br></p> <p>To wind up the quickest way if you're in a hurry is to simply add up the total you have spent and add the fee and add the same fee amount again. So if you work out your fee is $20 double it to $40 and add that to your total spend and divide that by the coins current price to get the amount of coins to sell. It will only be out -$0.10c in the dollar in a trade up to $100,000 and that is nothing worth worrying about plus most common trades will be much less than this.&nbsp;</p> <p><img src="https://i.imgur.com/IJPJOED.png" width="1430" height="209"/></p> <p><br></p> <p>The reason i went into so much detail to do this was because i was making a Google sheet and wanting to track a QFL "Panic trade" 1 - 8 layered buys and 1 - 4 layered sells (to break-even), of various amounts, as the price was dropping and trying to determine what amount of coins to sell at the current price so that i was break-even and leave nothing but free coins in an offline wallet. If you are familiar with the QFL methodology i wanted to track "Hot potatoes" where you sell 30% at an all time high selling some of the FREE coins that use saved in a cold storage wallet after you had broke even!&nbsp;</p> <p><br></p> <p>My sheet kept not exactly equalling 0% or $0.00 dollars and each layer wasn't right. And because i intended to sell little bits as the price was rising (layering out with sells as the price is rises back to base!). It got all the more difficult to know. So each sell layer would calculate if you wanted to sell anything from 0-100% (of the total spent &amp; fees). If you selected 50% it should recover half of the total money i spent in the trade. Then 80% would be 80% of the 50% remaining principle (total money spent). That's a post for you to search out for and make a free copy of that sheet. I find it an educational and handy tool, i use it daily. Even if i do say so myself. I put months into building it and improving it.&nbsp;</p> <p><br></p> <p>The sheet become multifunctional and can be used for any trade in crypto from as little as one $5 trade to up to eight buy layers and eight sell layers. The first four of the sell layers works specifically on getting the total principle invested back covering all fees going in and out. As this is the risk money you have put in the trade. That break-even money that you recover from the trade can be used in other QFL panic and so the process repeats. &nbsp;</p> <p><img src="https://i.imgur.com/HZUPXRx.png" width="1432" height="776"/></p> <p><br></p> <p>Is there something I've missed? Or can improve on and or you know a better way to do this then I look forward to reading your comments of various ways to break even.&nbsp;I'm interested to know of any mistakes i may have made and or way that you calculate break-even.&nbsp;</p> <p><br></p> <p><br></p> <p>Crypto break-even formula for a Google sheet cell.&nbsp;</p> <blockquote>Jaffasoft ~ &nbsp;&nbsp;&nbsp;=SUM(1/(1-sell_percent_fee)*((qty*price)+(qty*price)*buy_percent_fee)/current_price)</blockquote> <p><br></p> <p><br></p> </html>
json metadata{"tags":["trading","breakeven","formula","calculator","bitcoin"],"image":["https://i.imgur.com/RYFCDtN.png","https://i.imgur.com/6Zqpnw4.png","https://i.imgur.com/IJPJOED.png","https://i.imgur.com/HZUPXRx.png"],"links":["https://docs.google.com/spreadsheets/d/1zuZE4E4Ze8-qu5p7wpIRL5r7lDvccQMUNmP3hPrRjok/edit?usp=sharing"],"app":"steemit/0.1","format":"html"}
Transaction InfoBlock #23057288/Trx b45e961451565969c24c565540390f8cb4504f95
View Raw JSON Data
{
  "trx_id": "b45e961451565969c24c565540390f8cb4504f95",
  "block": 23057288,
  "trx_in_block": 22,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-05T13:34:21",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "trading",
      "author": "jaffasoft",
      "permlink": "cryptocurrency-break-even-point-google-sheet-formula-for-dummies",
      "title": "Cryptocurrency Break-even Point Google Sheet Formula for Dummies",
      "body": "<html>\n<p>I'm dumb so this is the simple easy Google sheet and formula explained for anyone feeling a little lost about how to calculate break-even point in your crypto trading. &nbsp;&nbsp;</p>\n<p>Here's the formula if you're in a hurry and can't be bothered reading. This world is full of to much information. Dump this on a Google sheet cell and it's good to go. I don't use excel. Maybe you can adapt it and post some excel formulas in the comments section below to help people!?</p>\n<p>What Google sheet cell will tell you how many coins to sell at the exchange (exactly) to break-even.&nbsp;</p>\n<p>=SUM(1/(1-.1%)*((100*20)+(100*20)*.1%)/30)</p>\n<p>The same formula as above explaining what the numbers represent.&nbsp;</p>\n<p>=SUM(1/(1-sell_percent_fee)*((qty*price)+(qty*price)*buy_percent_fee)/current_price)</p>\n<p>... and here in use in an actual example Google sheet screenshot.&nbsp;</p>\n<p><img src=\"https://i.imgur.com/RYFCDtN.png\" width=\"1393\" height=\"215\"/></p>\n<p>Here is the link to the Google sheet to make a copy with and learn the formulas and adapt it to your own sheets:&nbsp;</p>\n<p>Basic steps:</p>\n<ol>\n  <li>[Click link to open Google Sheet](https://docs.google.com/spreadsheets/d/1zuZE4E4Ze8-qu5p7wpIRL5r7lDvccQMUNmP3hPrRjok/edit?usp=sharing)</li>\n  <li>In the Google Sheet goto top menu area and in File &gt; Make a copy....</li>\n  <li>You should now have your own copy of these break-even examples to learn from.&nbsp;</li>\n</ol>\n<p><br></p>\n<p>It took me a long time to work this out so I hope you enjoy it. I done my head in a number of times and spent many late nights up working on this. I'm not that gifted as math but once i worked it all out i wanted to make a detailed post and share it for other.&nbsp;</p>\n<p><br></p>\n<p>I searched a lot of places and couldn't find any accurate answers anywhere. Something wasn't right about the formulas I was trying... they were not returning to zero! Most places around, the way people are calculating the crypto trade break-even point is close but inaccurate if you want it to be absolutely right and to break-even to exactly zero not a cent more, not a penny less. If you have a number of different buys it gets even more difficult to work out and track. For smaller trades it makes little difference, only a few cents in the dollar and people don't worry about it. It's not going to break the bank balance. But for larger trades it can be out by hundreds of dollars. If you want it to be right so that break even is ZERO every time this is the formula to get your head around!&nbsp;</p>\n<p>So this is it! Just dump this on your cell.&nbsp;</p>\n<p>Example 1).</p>\n<p>=SUM(1/(1-G2)*((C2*D2)+(C2*D2)*E2)/F2)</p>\n<p>Where G2 is the sell fee percentage charged by the exchange normally about .1%. C2 is the quantity of coins you bought, D2 the buy price, E2 the sell fee percentage charged at the exchange say .1% again. And F2 is the price at which the coin has reached on the chart when you decide you want to sell to get back the total amount of money you have put in the trade plus fees. This is called break-even.&nbsp;</p>\n<p>If you bought a quantity of 100 EOS/USDT coins at $20 and the coins price has gone to $30 how many coins do you sell to break even? This is the tricky question! If you put this formula on a cell in a Google sheet it will tell you the answer.</p>\n<p>=SUM(1/(1-.1%)*((100*20)+(100*20)*.1%)/30)</p>\n<p>=SUM(1/(1-sell_percent_fee)*((qty*price)+(qty*price)*buy_percent_fee)/current_price)</p>\n<p><br></p>\n<p>The answer should be 66.80013347. You might decide to just round it up in your head quickly to 67 and sell that many at the exchange. Binance exchange expect only two decimal places to sell coins amounts so you would round up to say 67 or 66.81. When you go to the exchange and sell this amount of coins you will not lose any money and you will not make any money you will be at true break even (zero) if you can put exactly 66.80013347 as seen in this particular example.&nbsp;</p>\n<p><br></p>\n<p>&nbsp;</p>\n<p>Example 2).</p>\n<p>Another simple way to reach (\"close to\") break even point is to add up the total amount you spent on your trade(s). Still using the above example I would have spent 100 EOS @ 20c = a total of $2000. Then just divide $2000/coin_current price. &nbsp;2000/30= 66.67. So you sell 66.67 coins of EOS.&nbsp;</p>\n<p><br></p>\n<p>See how the answer is a little less then the first example of 66.80013347 compared to 66.67 that's because the first example covers the buy fee and the sell fee and the formula of which it is calculated. OK, so you could add a buy and a sell fee and get \"closer\" but it still won't be exact as in the first example.&nbsp;</p>\n<p>Example 3).</p>\n<p>This is how most people do it, they will take the total spent. =SUM(2000+(2000*.1%))/30 = 66.73&nbsp;</p>\n<p>Example 4).</p>\n<p>Some might go as far as adding a sell fee and generally the way it's calculate it will be so close to correct that it will actually round to the right dollar amount for small transactions. I tested all four different ways as described here in this post and i have provided the sheet for you to make a copy. On a hypothetical transaction of one million the results of the second example is out by -$2,000. So using that way when you think you have broken even would be down -$20,000.&nbsp;</p>\n<p><img src=\"https://i.imgur.com/6Zqpnw4.png\" width=\"1398\" height=\"210\"/></p>\n<p><br></p>\n<p>I put a large amount in here because there is whales out there doing big trades and they might want to know.&nbsp;</p>\n<ol>\n  <li>Example $0.00 (correct)</li>\n  <li>Example -$2,000.00</li>\n  <li>Example &nbsp;-$1,001.00</li>\n  <li>Example &nbsp;-$1.00</li>\n</ol>\n<p>So there you have it.&nbsp;</p>\n<p><br></p>\n<p>To wind up the quickest way if you're in a hurry is to simply add up the total you have spent and add the fee and add the same fee amount again. So if you work out your fee is $20 double it to $40 and add that to your total spend and divide that by the coins current price to get the amount of coins to sell. It will only be out -$0.10c in the dollar in a trade up to $100,000 and that is nothing worth worrying about plus most common trades will be much less than this.&nbsp;</p>\n<p><img src=\"https://i.imgur.com/IJPJOED.png\" width=\"1430\" height=\"209\"/></p>\n<p><br></p>\n<p>The reason i went into so much detail to do this was because i was making a Google sheet and wanting to track a QFL \"Panic trade\" 1 - 8 layered buys and 1 - 4 layered sells (to break-even), of various amounts, as the price was dropping and trying to determine what amount of coins to sell at the current price so that i was break-even and leave nothing but free coins in an offline wallet. If you are familiar with the QFL methodology i wanted to track \"Hot potatoes\" where you sell 30% at an all time high selling some of the FREE coins that use saved in a cold storage wallet after you had broke even!&nbsp;</p>\n<p><br></p>\n<p>My sheet kept not exactly equalling 0% or $0.00 dollars and each layer wasn't right. And because i intended to sell little bits as the price was rising (layering out with sells as the price is rises back to base!). It got all the more difficult to know. So each sell layer would calculate if you wanted to sell anything from 0-100% (of the total spent &amp; fees). If you selected 50% it should recover half of the total money i spent in the trade. Then 80% would be 80% of the 50% remaining principle (total money spent). That's a post for you to search out for and make a free copy of that sheet. I find it an educational and handy tool, i use it daily. Even if i do say so myself. I put months into building it and improving it.&nbsp;</p>\n<p><br></p>\n<p>The sheet become multifunctional and can be used for any trade in crypto from as little as one $5 trade to up to eight buy layers and eight sell layers. The first four of the sell layers works specifically on getting the total principle invested back covering all fees going in and out. As this is the risk money you have put in the trade. That break-even money that you recover from the trade can be used in other QFL panic and so the process repeats. &nbsp;</p>\n<p><img src=\"https://i.imgur.com/HZUPXRx.png\" width=\"1432\" height=\"776\"/></p>\n<p><br></p>\n<p>Is there something I've missed? Or can improve on and or you know a better way to do this then I look forward to reading your comments of various ways to break even.&nbsp;I'm interested to know of any mistakes i may have made and or way that you calculate break-even.&nbsp;</p>\n<p><br></p>\n<p><br></p>\n<p>Crypto break-even formula for a Google sheet cell.&nbsp;</p>\n<blockquote>Jaffasoft ~ &nbsp;&nbsp;&nbsp;=SUM(1/(1-sell_percent_fee)*((qty*price)+(qty*price)*buy_percent_fee)/current_price)</blockquote>\n<p><br></p>\n<p><br></p>\n</html>",
      "json_metadata": "{\"tags\":[\"trading\",\"breakeven\",\"formula\",\"calculator\",\"bitcoin\"],\"image\":[\"https://i.imgur.com/RYFCDtN.png\",\"https://i.imgur.com/6Zqpnw4.png\",\"https://i.imgur.com/IJPJOED.png\",\"https://i.imgur.com/HZUPXRx.png\"],\"links\":[\"https://docs.google.com/spreadsheets/d/1zuZE4E4Ze8-qu5p7wpIRL5r7lDvccQMUNmP3hPrRjok/edit?usp=sharing\"],\"app\":\"steemit/0.1\",\"format\":\"html\"}"
    }
  ]
}
2018/06/04 08:07:45
voterjaffasoft
authoralcibiades
permlink8-mistakes-i-see-beginners-make-on-steemit
weight10000 (100.00%)
Transaction InfoBlock #23021973/Trx c76281dcb361ff5065fbe36944f5420f063a4033
View Raw JSON Data
{
  "trx_id": "c76281dcb361ff5065fbe36944f5420f063a4033",
  "block": 23021973,
  "trx_in_block": 9,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-04T08:07:45",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "alcibiades",
      "permlink": "8-mistakes-i-see-beginners-make-on-steemit",
      "weight": 10000
    }
  ]
}
2018/05/02 00:14:42
voterjaffasoft
authornipuna
permlinkre-quickfingersluc-have-you-tried-this-hd-trivia-game-yet-its-very-addictive-20180425t195030798z
weight10000 (100.00%)
Transaction InfoBlock #22062680/Trx 126fb9ef3510a8ca50a150fe4628a834720a407d
View Raw JSON Data
{
  "trx_id": "126fb9ef3510a8ca50a150fe4628a834720a407d",
  "block": 22062680,
  "trx_in_block": 40,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-05-02T00:14:42",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "nipuna",
      "permlink": "re-quickfingersluc-have-you-tried-this-hd-trivia-game-yet-its-very-addictive-20180425t195030798z",
      "weight": 10000
    }
  ]
}
2018/05/02 00:14:06
voterjaffasoft
authorquickfingersluc
permlinkhave-you-tried-this-hd-trivia-game-yet-its-very-addictive
weight10000 (100.00%)
Transaction InfoBlock #22062668/Trx d0b60e1ec1d4f045fce3c9f2d1a1e31f4861465b
View Raw JSON Data
{
  "trx_id": "d0b60e1ec1d4f045fce3c9f2d1a1e31f4861465b",
  "block": 22062668,
  "trx_in_block": 10,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-05-02T00:14:06",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "have-you-tried-this-hd-trivia-game-yet-its-very-addictive",
      "weight": 10000
    }
  ]
}
2018/05/02 00:13:51
voterjaffasoft
authorquickfingersluc
permlinkshould-you-use-qfl-trading-methods-on-smaller-timeframes-to-daytrade
weight10000 (100.00%)
Transaction InfoBlock #22062663/Trx f50da9ed47671f817550c210a679198dc3b503ac
View Raw JSON Data
{
  "trx_id": "f50da9ed47671f817550c210a679198dc3b503ac",
  "block": 22062663,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-05-02T00:13:51",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "should-you-use-qfl-trading-methods-on-smaller-timeframes-to-daytrade",
      "weight": 10000
    }
  ]
}
2018/05/02 00:13:39
voterjaffasoft
authorquickfingersluc
permlinkfollow-up-video-my-thoughts-about-daytrading-and-account-building-trades
weight10000 (100.00%)
Transaction InfoBlock #22062659/Trx ff2ed002272ebdf8769c2f6b90e761096d79a973
View Raw JSON Data
{
  "trx_id": "ff2ed002272ebdf8769c2f6b90e761096d79a973",
  "block": 22062659,
  "trx_in_block": 11,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-05-02T00:13:39",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "follow-up-video-my-thoughts-about-daytrading-and-account-building-trades",
      "weight": 10000
    }
  ]
}
steemdelegated 18.138 SP to @jaffasoft
2018/04/21 20:44:57
delegatorsteem
delegateejaffasoft
vesting shares29535.852266 VESTS
Transaction InfoBlock #21771187/Trx ec5f8ad1c5f67215e7d043f7e0e2fe532c685755
View Raw JSON Data
{
  "trx_id": "ec5f8ad1c5f67215e7d043f7e0e2fe532c685755",
  "block": 21771187,
  "trx_in_block": 21,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-04-21T20:44:57",
  "op": [
    "delegate_vesting_shares",
    {
      "delegator": "steem",
      "delegatee": "jaffasoft",
      "vesting_shares": "29535.852266 VESTS"
    }
  ]
}
2018/04/07 11:22:45
voterjaffasoft
authorquickfingersluc
permlinkis-there-a-fat-finger-scanner-out-there-yep
weight10000 (100.00%)
Transaction InfoBlock #21356804/Trx 3eab3b11a753396598ba2c72944122b52b953c23
View Raw JSON Data
{
  "trx_id": "3eab3b11a753396598ba2c72944122b52b953c23",
  "block": 21356804,
  "trx_in_block": 7,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-04-07T11:22:45",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "is-there-a-fat-finger-scanner-out-there-yep",
      "weight": 10000
    }
  ]
}
2018/04/03 19:28:54
voterjaffasoft
authorquickfingersluc
permlinkis-btc-grinding-lower-and-lower-driving-you-crazy
weight10000 (100.00%)
Transaction InfoBlock #21251340/Trx c38747535a9cdbba758e8d514ca264dcae538232
View Raw JSON Data
{
  "trx_id": "c38747535a9cdbba758e8d514ca264dcae538232",
  "block": 21251340,
  "trx_in_block": 48,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-04-03T19:28:54",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "is-btc-grinding-lower-and-lower-driving-you-crazy",
      "weight": 10000
    }
  ]
}
2018/03/17 14:57:45
voterjaffasoft
authorquickfingersluc
permlinkwould-you-like-to-join-the-quickfingerstraders-slack-channel-it-is-open-again
weight10000 (100.00%)
Transaction InfoBlock #20757253/Trx 409a4a4777f5e3f84483eb0b83a6fdfed12008ef
View Raw JSON Data
{
  "trx_id": "409a4a4777f5e3f84483eb0b83a6fdfed12008ef",
  "block": 20757253,
  "trx_in_block": 47,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-17T14:57:45",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "would-you-like-to-join-the-quickfingerstraders-slack-channel-it-is-open-again",
      "weight": 10000
    }
  ]
}
2018/03/01 10:31:03
voterjaffasoft
authorquickfingersluc
permlinkre-andressilvera-re-quickfingersluc-i-used-to-be-a-ink-portrait-artist-but-my-life-took-an-unexpected-turn-here-is-my-story-20160815t171908232z
weight10000 (100.00%)
Transaction InfoBlock #20291638/Trx c3bce3701e5b5a11e5f891ccb6e1616b95486992
View Raw JSON Data
{
  "trx_id": "c3bce3701e5b5a11e5f891ccb6e1616b95486992",
  "block": 20291638,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-01T10:31:03",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "re-andressilvera-re-quickfingersluc-i-used-to-be-a-ink-portrait-artist-but-my-life-took-an-unexpected-turn-here-is-my-story-20160815t171908232z",
      "weight": 10000
    }
  ]
}
2018/03/01 10:30:54
voterjaffasoft
authorquickfingersluc
permlinkre-lauralemons-re-quickfingersluc-i-used-to-be-a-ink-portrait-artist-but-my-life-took-an-unexpected-turn-here-is-my-story-20160816t133001785z
weight10000 (100.00%)
Transaction InfoBlock #20291635/Trx 25b426b5737aec335077335e5cee25c0f0bc6d53
View Raw JSON Data
{
  "trx_id": "25b426b5737aec335077335e5cee25c0f0bc6d53",
  "block": 20291635,
  "trx_in_block": 57,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-01T10:30:54",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "re-lauralemons-re-quickfingersluc-i-used-to-be-a-ink-portrait-artist-but-my-life-took-an-unexpected-turn-here-is-my-story-20160816t133001785z",
      "weight": 10000
    }
  ]
}
2018/03/01 10:30:48
voterjaffasoft
authorintelliguy
permlinkre-quickfingersluc-i-used-to-be-a-ink-portrait-artist-but-my-life-took-an-unexpected-turn-here-is-my-story-20160815t214344449z
weight10000 (100.00%)
Transaction InfoBlock #20291633/Trx 50d7f858a516fcc8ace2117caeb96166fc9471b7
View Raw JSON Data
{
  "trx_id": "50d7f858a516fcc8ace2117caeb96166fc9471b7",
  "block": 20291633,
  "trx_in_block": 12,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-01T10:30:48",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "intelliguy",
      "permlink": "re-quickfingersluc-i-used-to-be-a-ink-portrait-artist-but-my-life-took-an-unexpected-turn-here-is-my-story-20160815t214344449z",
      "weight": 10000
    }
  ]
}
2018/02/28 08:08:42
voterjaffasoft
authorxineohp86
permlinkre-dobe4ever-i-trade-altcoins-vs-btc-only-not-vs-usd-here-is-why-20171123t152030714z
weight10000 (100.00%)
Transaction InfoBlock #20260012/Trx 02c4d26cde2b114b845d376210626c65beed19c9
View Raw JSON Data
{
  "trx_id": "02c4d26cde2b114b845d376210626c65beed19c9",
  "block": 20260012,
  "trx_in_block": 20,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-28T08:08:42",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "xineohp86",
      "permlink": "re-dobe4ever-i-trade-altcoins-vs-btc-only-not-vs-usd-here-is-why-20171123t152030714z",
      "weight": 10000
    }
  ]
}
2018/02/28 07:57:51
voterjaffasoft
authordobe4ever
permlinki-trade-altcoins-vs-btc-only-not-vs-usd-here-is-why
weight10000 (100.00%)
Transaction InfoBlock #20259795/Trx c86423fd0e7d729cad76e6fb199de83a033eecff
View Raw JSON Data
{
  "trx_id": "c86423fd0e7d729cad76e6fb199de83a033eecff",
  "block": 20259795,
  "trx_in_block": 42,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-28T07:57:51",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "dobe4ever",
      "permlink": "i-trade-altcoins-vs-btc-only-not-vs-usd-here-is-why",
      "weight": 10000
    }
  ]
}
2018/02/20 10:37:21
parent authorquickfingersluc
parent permlinkre-robinjohnston-re-robinjohnston-re-quickfingersluc-how-do-i-collect-free-coins-how-can-anyone-grow-a-small-account-20180218t023223534z
authorjaffasoft
permlinkre-quickfingersluc-re-robinjohnston-re-robinjohnston-re-quickfingersluc-how-do-i-collect-free-coins-how-can-anyone-grow-a-small-account-20180220t113732511z
title
bodySomething to consider when I recently saw the future of trading directly from Hard Wallets on decentralized exchanges. It is some time off until Tezor will be used on some, but I like the Tezor concept the most. These two popular ones are a bit like Holden or Ford. But Ledger can be used now in places like this buy DIA, MKR. https://app.paradex.io/ I may buy both and have the best of both worlds :)!
json metadata{"tags":["trading"],"links":["https://app.paradex.io/"],"app":"steemit/0.1"}
Transaction InfoBlock #20032785/Trx 6afe1bf3ddd911fe6e935ac1b5ed2b50953bb758
View Raw JSON Data
{
  "trx_id": "6afe1bf3ddd911fe6e935ac1b5ed2b50953bb758",
  "block": 20032785,
  "trx_in_block": 15,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-20T10:37:21",
  "op": [
    "comment",
    {
      "parent_author": "quickfingersluc",
      "parent_permlink": "re-robinjohnston-re-robinjohnston-re-quickfingersluc-how-do-i-collect-free-coins-how-can-anyone-grow-a-small-account-20180218t023223534z",
      "author": "jaffasoft",
      "permlink": "re-quickfingersluc-re-robinjohnston-re-robinjohnston-re-quickfingersluc-how-do-i-collect-free-coins-how-can-anyone-grow-a-small-account-20180220t113732511z",
      "title": "",
      "body": "Something to consider when I recently saw the future of trading directly from Hard Wallets on decentralized exchanges. It is some time off until Tezor will be used on some, but I like the Tezor concept the most. These two popular ones are a bit like Holden or Ford. But Ledger can be used now in places like this buy DIA, MKR. https://app.paradex.io/ I may buy both and have the best of both worlds :)!",
      "json_metadata": "{\"tags\":[\"trading\"],\"links\":[\"https://app.paradex.io/\"],\"app\":\"steemit/0.1\"}"
    }
  ]
}
2018/02/18 02:33:27
voterjaffasoft
authorquickfingersluc
permlinkre-robinjohnston-re-robinjohnston-re-quickfingersluc-how-do-i-collect-free-coins-how-can-anyone-grow-a-small-account-20180218t023223534z
weight10000 (100.00%)
Transaction InfoBlock #19965534/Trx 5e092efa84da72697293ea77f2c1b8fb186ceecd
View Raw JSON Data
{
  "trx_id": "5e092efa84da72697293ea77f2c1b8fb186ceecd",
  "block": 19965534,
  "trx_in_block": 25,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-18T02:33:27",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "re-robinjohnston-re-robinjohnston-re-quickfingersluc-how-do-i-collect-free-coins-how-can-anyone-grow-a-small-account-20180218t023223534z",
      "weight": 10000
    }
  ]
}
2018/02/18 02:33:18
voterjaffasoft
authorquickfingersluc
permlinkre-myinfinityincome-re-quickfingersluc-how-do-i-collect-free-coins-how-can-anyone-grow-a-small-account-20180218t022920383z
weight10000 (100.00%)
Transaction InfoBlock #19965531/Trx 8a0fac58af936d4df28d375e2843448f4a2738f5
View Raw JSON Data
{
  "trx_id": "8a0fac58af936d4df28d375e2843448f4a2738f5",
  "block": 19965531,
  "trx_in_block": 59,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-18T02:33:18",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "re-myinfinityincome-re-quickfingersluc-how-do-i-collect-free-coins-how-can-anyone-grow-a-small-account-20180218t022920383z",
      "weight": 10000
    }
  ]
}
2018/02/18 02:32:48
voterjaffasoft
authorquickfingersluc
permlinkhow-do-i-collect-free-coins-how-can-anyone-grow-a-small-account
weight10000 (100.00%)
Transaction InfoBlock #19965521/Trx 149ea70a97b8f71ee221b887e121562f81fbb846
View Raw JSON Data
{
  "trx_id": "149ea70a97b8f71ee221b887e121562f81fbb846",
  "block": 19965521,
  "trx_in_block": 43,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-18T02:32:48",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "how-do-i-collect-free-coins-how-can-anyone-grow-a-small-account",
      "weight": 10000
    }
  ]
}
2018/01/24 12:00:27
required auths[]
required posting auths["jaffasoft"]
idfollow
json["follow",{"follower":"jaffasoft","following":"czbinance","what":["blog"]}]
Transaction InfoBlock #19257737/Trx c666b9e59b9d9b07183b9d9bc8cab7666096d6af
View Raw JSON Data
{
  "trx_id": "c666b9e59b9d9b07183b9d9bc8cab7666096d6af",
  "block": 19257737,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-01-24T12:00:27",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "jaffasoft"
      ],
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"jaffasoft\",\"following\":\"czbinance\",\"what\":[\"blog\"]}]"
    }
  ]
}
2018/01/24 05:43:39
voterjaffasoft
authorczbinance
permlinksecuring-your-trading-account
weight10000 (100.00%)
Transaction InfoBlock #19250203/Trx e4ff0d73630e61a6a5f48dee58a12426f8c2c143
View Raw JSON Data
{
  "trx_id": "e4ff0d73630e61a6a5f48dee58a12426f8c2c143",
  "block": 19250203,
  "trx_in_block": 19,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-01-24T05:43:39",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "czbinance",
      "permlink": "securing-your-trading-account",
      "weight": 10000
    }
  ]
}
2018/01/24 05:06:54
voterjaffasoft
authorcryptoiskey
permlinkre-willsann-re-cryptoiskey-bittrex-update-probably-my-fault-20170726t023121260z
weight10000 (100.00%)
Transaction InfoBlock #19249468/Trx 85744a5a87ea6861838f1786fc8ae5725f02a780
View Raw JSON Data
{
  "trx_id": "85744a5a87ea6861838f1786fc8ae5725f02a780",
  "block": 19249468,
  "trx_in_block": 4,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-01-24T05:06:54",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "cryptoiskey",
      "permlink": "re-willsann-re-cryptoiskey-bittrex-update-probably-my-fault-20170726t023121260z",
      "weight": 10000
    }
  ]
}
2018/01/24 04:42:12
voterjaffasoft
authorcryptoiskey
permlinkbittrex-update-probably-my-fault
weight10000 (100.00%)
Transaction InfoBlock #19248974/Trx fd554597ce2867732ea997e64807417cc8b3e5fb
View Raw JSON Data
{
  "trx_id": "fd554597ce2867732ea997e64807417cc8b3e5fb",
  "block": 19248974,
  "trx_in_block": 23,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-01-24T04:42:12",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "cryptoiskey",
      "permlink": "bittrex-update-probably-my-fault",
      "weight": 10000
    }
  ]
}
2018/01/21 10:37:15
required auths[]
required posting auths["jaffasoft"]
idfollow
json["follow",{"follower":"jaffasoft","following":"brandneweyes","what":["blog"]}]
Transaction InfoBlock #19169707/Trx 6a53a0ea3078f8c7b000593c47959f819cee3d21
View Raw JSON Data
{
  "trx_id": "6a53a0ea3078f8c7b000593c47959f819cee3d21",
  "block": 19169707,
  "trx_in_block": 13,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-01-21T10:37:15",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "jaffasoft"
      ],
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"jaffasoft\",\"following\":\"brandneweyes\",\"what\":[\"blog\"]}]"
    }
  ]
}
2018/01/09 12:17:00
required auths[]
required posting auths["jaffasoft"]
idfollow
json["follow",{"follower":"jaffasoft","following":"dmae","what":["blog"]}]
Transaction InfoBlock #18826332/Trx ab132c549caeab7402993483b4558bd84d9257ec
View Raw JSON Data
{
  "trx_id": "ab132c549caeab7402993483b4558bd84d9257ec",
  "block": 18826332,
  "trx_in_block": 34,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-01-09T12:17:00",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "jaffasoft"
      ],
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"jaffasoft\",\"following\":\"dmae\",\"what\":[\"blog\"]}]"
    }
  ]
}
2017/12/29 04:17:27
required auths[]
required posting auths["jaffasoft"]
idfollow
json["follow",{"follower":"jaffasoft","following":"bitcoinmeister","what":["blog"]}]
Transaction InfoBlock #18500343/Trx 884f0d87e8587e9099253f01b837556f586eab38
View Raw JSON Data
{
  "trx_id": "884f0d87e8587e9099253f01b837556f586eab38",
  "block": 18500343,
  "trx_in_block": 8,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-29T04:17:27",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "jaffasoft"
      ],
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"jaffasoft\",\"following\":\"bitcoinmeister\",\"what\":[\"blog\"]}]"
    }
  ]
}
2017/12/29 04:10:45
voterjaffasoft
authorihopeyouneverdie
permlinkzclassic-holders-will-get-bitcoin-private-btcp-after-the-fork
weight10000 (100.00%)
Transaction InfoBlock #18500209/Trx 689f0493cab570722f77e786ad9b369bb3f32c33
View Raw JSON Data
{
  "trx_id": "689f0493cab570722f77e786ad9b369bb3f32c33",
  "block": 18500209,
  "trx_in_block": 42,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-29T04:10:45",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "ihopeyouneverdie",
      "permlink": "zclassic-holders-will-get-bitcoin-private-btcp-after-the-fork",
      "weight": 10000
    }
  ]
}
2017/12/29 04:10:33
required auths[]
required posting auths["jaffasoft"]
idfollow
json["follow",{"follower":"jaffasoft","following":"ihopeyouneverdie","what":["blog"]}]
Transaction InfoBlock #18500205/Trx 433568ce9112aeec3352e9b2fd0466e5395b9929
View Raw JSON Data
{
  "trx_id": "433568ce9112aeec3352e9b2fd0466e5395b9929",
  "block": 18500205,
  "trx_in_block": 21,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-29T04:10:33",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "jaffasoft"
      ],
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"jaffasoft\",\"following\":\"ihopeyouneverdie\",\"what\":[\"blog\"]}]"
    }
  ]
}
2017/12/27 11:46:27
parent authorquickfingersluc
parent permlinkre-tusharranjan-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171226t000015901z
authorjaffasoft
permlinkre-quickfingersluc-re-tusharranjan-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171227t124623623z
title
bodyThanks for everything you're doing i upvoted hundreds a posts :). It's dropped to .0175 now! https://www.coinigy.com/s/i/5a438767af409/
json metadata{"tags":["trading"],"links":["https://www.coinigy.com/s/i/5a438767af409/"],"app":"steemit/0.1"}
Transaction InfoBlock #18451745/Trx dde69be65f93c002fa4f4657a9010dffc2065223
View Raw JSON Data
{
  "trx_id": "dde69be65f93c002fa4f4657a9010dffc2065223",
  "block": 18451745,
  "trx_in_block": 29,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-27T11:46:27",
  "op": [
    "comment",
    {
      "parent_author": "quickfingersluc",
      "parent_permlink": "re-tusharranjan-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171226t000015901z",
      "author": "jaffasoft",
      "permlink": "re-quickfingersluc-re-tusharranjan-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171227t124623623z",
      "title": "",
      "body": "Thanks for everything you're doing i upvoted hundreds a posts :). It's dropped to .0175 now! https://www.coinigy.com/s/i/5a438767af409/",
      "json_metadata": "{\"tags\":[\"trading\"],\"links\":[\"https://www.coinigy.com/s/i/5a438767af409/\"],\"app\":\"steemit/0.1\"}"
    }
  ]
}
2017/12/27 11:26:12
voterjaffasoft
authorquickfingersluc
permlinkre-we1ss-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171224t144207358z
weight10000 (100.00%)
Transaction InfoBlock #18451340/Trx 0e60bf6caa2fb23ae09a3c6e7008c9336567cf75
View Raw JSON Data
{
  "trx_id": "0e60bf6caa2fb23ae09a3c6e7008c9336567cf75",
  "block": 18451340,
  "trx_in_block": 29,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-27T11:26:12",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "re-we1ss-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171224t144207358z",
      "weight": 10000
    }
  ]
}
2017/12/27 11:26:09
voterjaffasoft
authorquickfingersluc
permlinkre-singingsteve-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171224t144046476z
weight10000 (100.00%)
Transaction InfoBlock #18451339/Trx 2263fc70d151ed44521a725e22d05b55566e14e8
View Raw JSON Data
{
  "trx_id": "2263fc70d151ed44521a725e22d05b55566e14e8",
  "block": 18451339,
  "trx_in_block": 10,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-27T11:26:09",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "re-singingsteve-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171224t144046476z",
      "weight": 10000
    }
  ]
}
2017/12/27 11:26:03
voterjaffasoft
authorquickfingersluc
permlinkre-tusharranjan-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171226t144905258z
weight10000 (100.00%)
Transaction InfoBlock #18451337/Trx 0d1ad3567a72f616f9fc997e972534c1f12f3305
View Raw JSON Data
{
  "trx_id": "0d1ad3567a72f616f9fc997e972534c1f12f3305",
  "block": 18451337,
  "trx_in_block": 28,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-27T11:26:03",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "re-tusharranjan-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171226t144905258z",
      "weight": 10000
    }
  ]
}
2017/12/27 11:26:00
voterjaffasoft
authorquickfingersluc
permlinkre-cantestogo-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171225t234303234z
weight10000 (100.00%)
Transaction InfoBlock #18451336/Trx 9160c914df32fbef30864bc41090b312c1134967
View Raw JSON Data
{
  "trx_id": "9160c914df32fbef30864bc41090b312c1134967",
  "block": 18451336,
  "trx_in_block": 8,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-27T11:26:00",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "re-cantestogo-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171225t234303234z",
      "weight": 10000
    }
  ]
}
2017/12/27 11:25:54
voterjaffasoft
authorquickfingersluc
permlinkre-t4al-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171226t002242962z
weight10000 (100.00%)
Transaction InfoBlock #18451334/Trx 79590e48e8db78a841f4a447e5be78407a908028
View Raw JSON Data
{
  "trx_id": "79590e48e8db78a841f4a447e5be78407a908028",
  "block": 18451334,
  "trx_in_block": 18,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-27T11:25:54",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "re-t4al-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171226t002242962z",
      "weight": 10000
    }
  ]
}
2017/12/27 11:25:48
voterjaffasoft
authorquickfingersluc
permlinkre-cantestogo-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171226t000202522z
weight10000 (100.00%)
Transaction InfoBlock #18451332/Trx cc2f19e0bc51039d356c1eae9d452252811d4975
View Raw JSON Data
{
  "trx_id": "cc2f19e0bc51039d356c1eae9d452252811d4975",
  "block": 18451332,
  "trx_in_block": 25,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-27T11:25:48",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "re-cantestogo-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171226t000202522z",
      "weight": 10000
    }
  ]
}
2017/12/27 11:25:45
voterjaffasoft
authorquickfingersluc
permlinkre-terryj-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171226t001726212z
weight10000 (100.00%)
Transaction InfoBlock #18451331/Trx e86d8849aef21bafc2ae8c4b8f695cb64974a31b
View Raw JSON Data
{
  "trx_id": "e86d8849aef21bafc2ae8c4b8f695cb64974a31b",
  "block": 18451331,
  "trx_in_block": 7,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-27T11:25:45",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "re-terryj-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171226t001726212z",
      "weight": 10000
    }
  ]
}
2017/12/27 11:25:42
voterjaffasoft
authorquickfingersluc
permlinkre-tusharranjan-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171226t000015901z
weight10000 (100.00%)
Transaction InfoBlock #18451330/Trx 13a27b5b1549b61ff4fcd5b1952323b525bad81f
View Raw JSON Data
{
  "trx_id": "13a27b5b1549b61ff4fcd5b1952323b525bad81f",
  "block": 18451330,
  "trx_in_block": 8,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-27T11:25:42",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "re-tusharranjan-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171226t000015901z",
      "weight": 10000
    }
  ]
}
2017/12/27 11:25:36
voterjaffasoft
authorquickfingersluc
permlinkre-travissanders-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171226t001604192z
weight10000 (100.00%)
Transaction InfoBlock #18451328/Trx 00718376d7156047914382731da286db3aaa4aa2
View Raw JSON Data
{
  "trx_id": "00718376d7156047914382731da286db3aaa4aa2",
  "block": 18451328,
  "trx_in_block": 20,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2017-12-27T11:25:36",
  "op": [
    "vote",
    {
      "voter": "jaffasoft",
      "author": "quickfingersluc",
      "permlink": "re-travissanders-re-quickfingersluc-lets-look-at-my-recent-trades-and-where-will-i-buy-btc-bch-eth-next-wheres-the-bottom-20171226t001604192z",
      "weight": 10000
    }
  ]
}

Account Metadata

POSTING JSON METADATA
profile{"name":"Jaffasoft","about":"Hippie ","location":"Northern Rivers, NSW,Australia","profile_image":"https://cdn.steemitimages.com/DQmYTmKpNnfycnRmmNhUghdPZFW2FBKBsjJB45ppjjK4VEk/Screen%20Shot%202018-01-22%20at%2011.07.21%20pm.png"}
JSON METADATA
profile{"name":"Jaffasoft","about":"Hippie ","location":"Northern Rivers, NSW,Australia","profile_image":"https://cdn.steemitimages.com/DQmYTmKpNnfycnRmmNhUghdPZFW2FBKBsjJB45ppjjK4VEk/Screen%20Shot%202018-01-22%20at%2011.07.21%20pm.png"}
{
  "posting_json_metadata": {
    "profile": {
      "name": "Jaffasoft",
      "about": "Hippie ",
      "location": "Northern Rivers, NSW,Australia",
      "profile_image": "https://cdn.steemitimages.com/DQmYTmKpNnfycnRmmNhUghdPZFW2FBKBsjJB45ppjjK4VEk/Screen%20Shot%202018-01-22%20at%2011.07.21%20pm.png"
    }
  },
  "json_metadata": {
    "profile": {
      "name": "Jaffasoft",
      "about": "Hippie ",
      "location": "Northern Rivers, NSW,Australia",
      "profile_image": "https://cdn.steemitimages.com/DQmYTmKpNnfycnRmmNhUghdPZFW2FBKBsjJB45ppjjK4VEk/Screen%20Shot%202018-01-22%20at%2011.07.21%20pm.png"
    }
  }
}

Auth Keys

Owner
Single Signature
Public Keys
STM7gYgnDqAmqJYErAhhK23SeATVUsTqWtSjJ1U9cjEG6G4FWHeQq1/1
Active
Single Signature
Public Keys
STM59mYDKWm3dQ4AfPrUxLdrBz7mBsJTHi4m1RRNUXaYJT1KyYv5Y1/1
Posting
Single Signature
Public Keys
STM8eienpyJ5Lqc31ZAQyHGELGPMF2ARpJN2i7H8Cg5C8CVAn45ah1/1
Memo
STM5MUBdSHD5qvSjzNR5kC6D59ggaR77T5agWDtua44eUvGPfXMZg
{
  "owner": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM7gYgnDqAmqJYErAhhK23SeATVUsTqWtSjJ1U9cjEG6G4FWHeQq",
        1
      ]
    ]
  },
  "active": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM59mYDKWm3dQ4AfPrUxLdrBz7mBsJTHi4m1RRNUXaYJT1KyYv5Y",
        1
      ]
    ]
  },
  "posting": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM8eienpyJ5Lqc31ZAQyHGELGPMF2ARpJN2i7H8Cg5C8CVAn45ah",
        1
      ]
    ]
  },
  "memo": "STM5MUBdSHD5qvSjzNR5kC6D59ggaR77T5agWDtua44eUvGPfXMZg"
}

Witness Votes

0 / 30
No active witness votes.
[]