RE: How To Use Blockfolio App Without Risking Losing Your Money by mainline2u

View this thread on: hive.blog | peakd.com | ecency.com

Viewing a response to: @blockchainttmft/how-to-use-blockfolio-app-without-risking-losing-your-money

bitcoin · @mainline2u · Aug 26 '17 (edited)

$0.22

In case you didn't know, you can now use Google Sheets formula to reflect the current crypto prices. 
Here is a sample:
=CRYPTOFINANCE("BTCUSD","price").
You can also replace "price" with "change", "marketcap",	"volume", "total_supply", and I think a couple other options as well.

Addendum: Also, on Google Sheets, under the "MENU / ADD-ONS" you need to activate "CRYPTOFINANCE" in order to use in Google Sheets. I think it has to be activated for each individual Sheet that uses "CRYPTOFINANCE" formulas. 
Happy Number Crunching!

👍 blockchainttmft, lorgen, oluebubesyd, lotap, dgatza, simonr4, finetuner, gensichen, ayishagisel, thetruth36, greezythumb

`author`	mainline2u
`permlink`	re-blockchainttmft-how-to-use-blockfolio-app-without-risking-losing-your-money-20170826t032751260z
`category`	bitcoin
`json_metadata`	{"tags":["bitcoin"],"app":"steemit/0.1"}
`created`	2017-08-26 03:27:54
`last_update`	2017-08-26 23:49:30
`depth`	1
`children`	6
`last_payout`	2017-09-02 03:27:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.164 HBD
`curator_payout_value`	0.054 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	531
`author_reputation`	6,848,554,346
`root_title`	"How To Use Blockfolio App Without Risking Losing Your Money"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	12,899,246
`net_rshares`	54,922,589,985
`author_curate_reward`	""

properties (23)vote details (11)

voter	rshares	pct
greezythumb	0	100%
thetruth36	0	1%
ayishagisel	0	100%
gensichen	0	100%
blockchainttmft	54,922,589,985	50%
finetuner	0	100%
simonr4	0	100%
dgatza	0	100%
lotap	0	100%
oluebubesyd	0	100%
lorgen	0	100%

@dgatza · Jan 9 '18

That's amazing, had no idea that Google Sheets was so extensible.  Thanks for the tip bud!

properties (22)

`author`	dgatza
`permlink`	re-mainline2u-re-blockchainttmft-how-to-use-blockfolio-app-without-risking-losing-your-money-20180109t232019084z
`category`	bitcoin
`json_metadata`	{"tags":["bitcoin"],"app":"steemit/0.1"}
`created`	2018-01-09 23:20:18
`last_update`	2018-01-09 23:20:18
`depth`	2
`children`	0
`last_payout`	2018-01-16 23:20:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	90
`author_reputation`	212,841,583
`root_title`	"How To Use Blockfolio App Without Risking Losing Your Money"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	28,358,935
`net_rshares`	0

@finetuner · Nov 30 '17

Thanks for that Google Sheet tip!

properties (22)

`author`	finetuner
`permlink`	re-mainline2u-re-blockchainttmft-how-to-use-blockfolio-app-without-risking-losing-your-money-20171130t100925089z
`category`	bitcoin
`json_metadata`	{"tags":["bitcoin"],"app":"steemit/0.1"}
`created`	2017-11-30 10:09:00
`last_update`	2017-11-30 10:09:00
`depth`	2
`children`	1
`last_payout`	2017-12-07 10:09:00
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	33
`author_reputation`	4,193,641,362
`root_title`	"How To Use Blockfolio App Without Risking Losing Your Money"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	21,977,834
`net_rshares`	0

@gensichen · Dec 12 '17

Excellent tip! Thank you!

properties (22)

`author`	gensichen
`permlink`	re-finetuner-re-mainline2u-re-blockchainttmft-how-to-use-blockfolio-app-without-risking-losing-your-money-20171212t120703563z
`category`	bitcoin
`json_metadata`	{"tags":["bitcoin"],"app":"steemit/0.1"}
`created`	2017-12-12 12:07:03
`last_update`	2017-12-12 12:07:03
`depth`	3
`children`	0
`last_payout`	2017-12-19 12:07:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	25
`author_reputation`	15,328,425
`root_title`	"How To Use Blockfolio App Without Risking Losing Your Money"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	23,230,245
`net_rshares`	0

@jmcatga91 · Jan 18 '18

I would like to recommend "Crypto Rewards" option of a spreadsheet tracker.   He has great explanations on his Youtube site and the link for his spread sheet is here:  https://www.youtube.com/watch?v=EtGaq4VJst4

properties (22)

`author`	jmcatga91
`permlink`	re-mainline2u-re-blockchainttmft-how-to-use-blockfolio-app-without-risking-losing-your-money-20180118t051211388z
`category`	bitcoin
`json_metadata`	{"tags":["bitcoin"],"image":["https://img.youtube.com/vi/EtGaq4VJst4/0.jpg"],"links":["https://www.youtube.com/watch?v=EtGaq4VJst4"],"app":"steemit/0.1"}
`created`	2018-01-18 05:12:09
`last_update`	2018-01-18 05:12:09
`depth`	2
`children`	0
`last_payout`	2018-01-25 05:12:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	211
`author_reputation`	0
`root_title`	"How To Use Blockfolio App Without Risking Losing Your Money"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	30,321,628
`net_rshares`	0

@simonr4 · Dec 31 '17

IMO, Google is the last entity I want knowing I am tracking BTC, ETH, etc.

properties (22)

`author`	simonr4
`permlink`	re-mainline2u-re-blockchainttmft-how-to-use-blockfolio-app-without-risking-losing-your-money-20171231t020854348z
`category`	bitcoin
`json_metadata`	{"tags":["bitcoin"],"app":"steemit/0.1"}
`created`	2017-12-31 02:08:54
`last_update`	2017-12-31 02:08:54
`depth`	2
`children`	1
`last_payout`	2018-01-07 02:08:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	74
`author_reputation`	82,246,594
`root_title`	"How To Use Blockfolio App Without Risking Losing Your Money"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	26,140,864
`net_rshares`	0

@djsimul · Jan 2 '18

Why the last? Seems there are way worse companies out there... Plus given how big Google is, I doubt they're interested in your portfolio, even if you had a $1mill worth of coins. I'm not too worried about Google. The information they collect on your everyday moves are way more valuable to them than what coins everyone owns. They're dealing with BILLIONS per day.

👍 quoteth-he

`author`	djsimul
`permlink`	re-simonr4-re-mainline2u-re-blockchainttmft-how-to-use-blockfolio-app-without-risking-losing-your-money-20180102t205313927z
`category`	bitcoin
`json_metadata`	{"tags":["bitcoin"],"app":"steemit/0.1"}
`created`	2018-01-02 20:53:12
`last_update`	2018-01-02 20:53:12
`depth`	3
`children`	0
`last_payout`	2018-01-09 20:53:12
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	365
`author_reputation`	237,589,511
`root_title`	"How To Use Blockfolio App Without Risking Losing Your Money"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	26,633,744
`net_rshares`	0
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
quoteth-he	0 B		0	100%