김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용) by stylegold

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

kr-dev · @stylegold · May 30 '18 (edited)

$31.43

김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)

## CoinmarketCap관련 이슈 
현재 CoinmarketCap에서 Google 의 특정 IP에 대해서 Block처리를 해놓은 상태인것 같습니다. 
> The owner of this website (api.coinmarketcap.com) has banned you temporarily from accessing this website.

혹시 사용하실분들 중에서 CoinmarketCap 데이터가 에러가 나시는 분들은 조금 기다려주세요.
방법을 찾아서 업데이트 하도록 하겠습니다.^^

<br /><br />

----

<br /><br />


자주사용하던 가상화폐 관리용 Google Sheet에 에러가 발생해서 오랜만에 Google Script를 업데이트 했습니다. 


![savings-2789112_640.jpg](https://cdn.steemitimages.com/DQmXzJBdRAczzrCcBZHrurTqZ4Sp3kPXJhvAtLWq6dJMXED/savings-2789112_640.jpg)

## 업데이트 내용
* 김프계산기에 고팍스 거래소 추가 (@gopaxkr 형아 잘했지?ㅋㅋ)
* CoinmarketCap API v2로 적용

### 공유링크
https://docs.google.com/spreadsheets/d/17aqfcyiR-yuSu6zq_lrW4A-S5GjoH0a483B-pHUCZTk




<br/>

---

<br/>

## 사용법
1. 링크 접속
https://docs.google.com/spreadsheets/d/17aqfcyiR-yuSu6zq_lrW4A-S5GjoH0a483B-pHUCZTk

2. 파일 > 사본만들기 클릭
![](https://cdn.steemitimages.com/DQmRbFcsetgzc9Xa5A7EJ54VQ7WWM1rr3cGydcCPh4jUBTU/image.png)

3. Refresh > start 클릭
![](https://cdn.steemitimages.com/DQmcpkVGa1hhJHCzEks6JVpZR2k4Zpgwh2vQGguS2ACXnnw/image.png)

4. 권한 허가
![](https://steemitimages.com/DQmWbxRPfjfmmBUy1Gq6ctbU1N4DAFViM3BDPJRbeG1RAK4/image.png)

5. 로그인 및 권한 허용
![](https://steemitimages.com/DQmSgsd1MvUCkuqG6dSd7F6tn1UZ1RPVVCXVwbRyrhLcxh2/image.png)

6. 기존 데이터 삭제 후 사용

<br/>

---

<br/>


## 기능 

#### Sheet1. 김프계산기
거래소별 가상화폐 가격을 실시간으로 확인 할수 있습니다.

![](https://cdn.steemitimages.com/DQmYLwAyx7WqHWvxyBbMhq2kdCxMFECP45Uj76f3ZbhZKEZ/image.png)

* [다양한 거래소] 고팍스,  업비트, 코인원, 빗썸, 코빗, 코인네스트 ,  CoinmarketCap 지원
* [전일대비] 전일 대비 증가율 확인 가능
* [김프] CoinmarketCap와 국내거래소간의 김프를 확인

<br/>

#### Sheet2. 거래내역
거래소에서 가상화폐를 구매한 내역을 기록하면 됩니다. 

![](https://cdn.steemitimages.com/DQmeVYBh1agMh5JcWUEoxoCZSb5J5he8uXAicSdLcPu3f9U/image.png)

* [입력필드] 시트의 흰부분에만 값을 넣으면 되며, 회색영역은 자동 계산
* [매도기능] 보유중인 가상화폐를 매도를 하는 경우, 매도 수량에 값을 넣으면 **취소선**이 그어지며 **행이 회색**으로 변경
* [행별손익] 구매건별로 실시간 비교후, 마이너스 수익인경우 **행이 빨간색**으로 변경

<br/>

#### Sheet3. 통합수익률
거래내역의 모든 항목을 합쳐서 보여 줍니다.

![](https://cdn.steemitimages.com/DQmPd9EsR9ifZ1SAUQZF8RAJYoQ2SsMprWjMeyRvELWU5ct/image.png)

* [통합손익] 구매내역의 보유수량을 가상화폐별로 통합해서 수익률 계산
* [전체손익] 모든 가상화폐의 수익률 계산




----

https://steemitimages.com/DQma8V8FdUszSNnYfZC2dgq3FQ2iEaWXtrso2qrUwqpmATv/gsh-logo_steemit.png
> 오랜만에.. 아브라카다브라!!!

👍 arama, woo7739, pairplay-en, skan, aabahee, happyworkingmom, supergiant, armdown, momoggo, kimthewriter, fenrir78, fur2002ks, jamieinthedark, holic7, lalaflor, joeypark, cchyyy, kibumh, goodhello, happylazar, bumblebee2018, pairplay, greenswell, thegreatgatsby, clarkgold, glory7, lucky2, eunyx, ilovemylife, sitha, brainstormot, sadmt, gasigogi, knowkorea, osyvv, designkoi, yangmok701, kyle-event, onehand, thinky, mipha, heonbros, newbijohn, agawolf, hyunny, ttgamja, autokjk70, moulin-rouge, freegon, yunasdiy, oprth, scv, energizer000, kyeongah, icosession, qrwerq, amukae88, awesomesweet, mijang0260, gimmi0, jsj9346, choim, dorian-lee, jesusaddict, and 15 others

`author`	stylegold
`permlink`	google-sheet-gopax-coinmarketcap-api-v2
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev","kr","coinkorea","tooza"],"image":["https://cdn.steemitimages.com/DQmXzJBdRAczzrCcBZHrurTqZ4Sp3kPXJhvAtLWq6dJMXED/savings-2789112_640.jpg","https://cdn.steemitimages.com/DQmRbFcsetgzc9Xa5A7EJ54VQ7WWM1rr3cGydcCPh4jUBTU/image.png","https://cdn.steemitimages.com/DQmcpkVGa1hhJHCzEks6JVpZR2k4Zpgwh2vQGguS2ACXnnw/image.png","https://steemitimages.com/DQmWbxRPfjfmmBUy1Gq6ctbU1N4DAFViM3BDPJRbeG1RAK4/image.png","https://steemitimages.com/DQmSgsd1MvUCkuqG6dSd7F6tn1UZ1RPVVCXVwbRyrhLcxh2/image.png","https://cdn.steemitimages.com/DQmYLwAyx7WqHWvxyBbMhq2kdCxMFECP45Uj76f3ZbhZKEZ/image.png","https://cdn.steemitimages.com/DQmeVYBh1agMh5JcWUEoxoCZSb5J5he8uXAicSdLcPu3f9U/image.png","https://cdn.steemitimages.com/DQmPd9EsR9ifZ1SAUQZF8RAJYoQ2SsMprWjMeyRvELWU5ct/image.png","https://steemitimages.com/DQma8V8FdUszSNnYfZC2dgq3FQ2iEaWXtrso2qrUwqpmATv/gsh-logo_steemit.png"],"links":["https://docs.google.com/spreadsheets/d/17aqfcyiR-yuSu6zq_lrW4A-S5GjoH0a483B-pHUCZTk"],"app":"steemit/0.1","format":"markdown","users":["gopaxkr"]}
`created`	2018-05-25 07:05:30
`last_update`	2018-05-30 10:58:54
`depth`	0
`children`	69
`last_payout`	2018-06-01 07:05:30
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	25.002 HBD
`curator_payout_value`	6.426 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	2,218
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,589,729
`net_rshares`	8,318,175,782,006
`author_curate_reward`	""

properties (23)vote details (79)

voter	rshares	pct
woo7739	1,433,183,120,217	50%
arama	1,883,928,147,929	53%
skan	462,434,253,649	3.6%
holic7	139,507,282,130	17%
happyworkingmom	293,171,199,633	40%
clarkgold	57,625,736,325	20%
fur2002ks	172,938,826,459	15%
agawolf	7,377,152,542	1%
ilovemylife	38,258,184,178	14%
wabangcute	786,105,196	20%
minampusan	883,506,024	20%
tomkim1981	259,295,531	100%
yangmok701	14,377,679,835	11%
heonbros	8,540,876,116	100%
designkoi	15,658,182,986	31%
kimthewriter	201,981,475,372	20%
h-jin	518,838,467	100%
goodhello	90,006,677,344	30%
brainstormot	35,578,966,071	100%
happylazar	67,585,993,572	25%
supergiant	248,281,871,861	55%
gasigogi	21,629,978,232	100%
amukae88	2,665,514,530	100%
autokjk70	5,207,670,698	100%
jesusaddict	1,326,980,967	100%
greenswell	62,254,429,435	100%
fenrir78	189,054,720,780	100%
energizer000	4,112,842,658	20%
momoggo	204,268,180,114	20%
qrwerq	2,827,241,659	100%
yunasdiy	4,728,336,009	100%
tangle-hoon	406,545,256	100%
lalaflor	131,279,549,053	15%
onehand	12,244,946,820	3%
jsj9346	1,543,182,211	100%
awesomesweet	2,040,135,577	100%
joeypark	114,233,732,836	50%
sadmt	23,452,635,834	25%
mijang0260	1,816,309,096	20%
osyvv	20,472,782,018	100%
thegreatgatsby	59,713,395,500	30%
eunyx	41,098,456,858	20%
oprth	4,422,544,500	100%
sunstrip	1,075,951,469	20%
dorian-lee	1,369,166,843	25%
moulin-rouge	5,155,709,088	100%
armdown	209,594,994,371	100%
cristart	610,390,398	100%
gimmi0	1,756,380,008	20%
cchyyy	100,949,425,365	50%
bumblebee2018	67,073,659,591	50%
good21	1,188,365,289	100%
icosession	3,012,080,859	100%
minigate	589,339,016	100%
choim	1,505,845,285	15%
kyeongah	3,510,359,169	100%
scv	4,273,484,047	100%
thinky	11,054,409,960	100%
hyunny	6,783,728,252	100%
mipha	10,758,139,619	52%
jamieinthedark	152,300,282,663	15%
knowkorea	21,603,145,796	10%
kyle-event	12,437,721,613	20%
sitha	37,590,066,836	30%
kibumh	92,241,898,836	100%
taeyunlee	0	100%
aabahee	424,228,775,616	100%
newbijohn	7,984,139,741	20%
ttgamja	5,228,144,792	100%
lucky2	43,431,183,682	20%
freegon	4,850,230,168	100%
pairplay	64,968,180,401	4.5%
neoahava	612,957,966	100%
hyunkyuiii	379,929,906	100%
pairplay1	718,274,477	20%
windblow	405,795,866	100%
glory7	52,963,008,771	100%
pairplay-en	881,975,875,704	100%
samojoon	311,258,465	100%

@amukae88 · May 27 '18

좋은 시트 제공 감사합니다
그런데 저는 coinmarketcap 수치가 'type error:unfined에서 data 속성을 읽을 수 없습니다.' 가 뜨는데요
혹시 저 같은 에러가 있는 분 있을까요? ㅠㅠ

properties (22)

`author`	amukae88
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180527t021016709z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-27 02:13:42
`last_update`	2018-05-27 02:13:42
`depth`	1
`children`	2
`last_payout`	2018-06-03 02:13:42
`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`	115
`author_reputation`	1,518,777,728,550
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,884,015
`net_rshares`	0

@stylegold · May 27 '18

새로고침을 일정수준이상으로 하면 에러가 납니다.
데이터를 불러내는 함수 1일 호출수가 정해져 있거든요. 이부분은 다음 업데이트에서개선해 볼께요.
아마 하루지나면 잘 될겁니다.

👍 amukae88

`author`	stylegold
`permlink`	re-amukae88-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180527t023154223z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-27 02:31:54
`last_update`	2018-05-27 02:31:54
`depth`	2
`children`	1
`last_payout`	2018-06-03 02:31: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`	97
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,885,540
`net_rshares`	2,926,652,405
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
amukae88	0 B		2,926,652,405	100%

@amukae88 · May 29 '18

네 잘 됩니다 ㅎㅎ
감사합니다

properties (22)

`author`	amukae88
`permlink`	re-stylegold-re-amukae88-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180529t173110831z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-29 17:31:12
`last_update`	2018-05-29 17:31:12
`depth`	3
`children`	0
`last_payout`	2018-06-05 17:31: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`	16
`author_reputation`	1,518,777,728,550
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	58,310,642
`net_rshares`	0

@armdown · May 27 '18

고맙습니다.
그렇지 않아도 최근에 오류가 나서 어째야 하나 했었는데요.

properties (22)

`author`	armdown
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180527t050631960z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"community":"busy","app":"busy/2.4.0"}
`created`	2018-05-27 05:06:36
`last_update`	2018-05-27 05:06:36
`depth`	1
`children`	1
`last_payout`	2018-06-03 05:06:36
`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`	39
`author_reputation`	39,337,454,888,389
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,898,660
`net_rshares`	0

@stylegold · May 27 '18

앗 다행이네요. 불편한점 있으시면 언제든지 말씀해주세요.ㅋ

properties (22)

`author`	stylegold
`permlink`	re-armdown-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180527t061139891z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-27 06:14:42
`last_update`	2018-05-27 06:14:42
`depth`	2
`children`	0
`last_payout`	2018-06-03 06:14:42
`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`	32
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,904,361
`net_rshares`	0

@autokjk70 · May 26 '18

일단 리스팀부터 하고 정신차려 다시 볼께요~ㅎ
능
력
자
!

👍 bountyworks

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
bountyworks	0 B		102,929,967	1%

@stylegold · May 26 '18

히힛 감사합니다.!

properties (22)

`author`	stylegold
`permlink`	re-autokjk70-re-stylegold-2018526t144949834z-20180526t131806879z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-26 13:18:06
`last_update`	2018-05-26 13:18:06
`depth`	2
`children`	0
`last_payout`	2018-06-02 13:18:06
`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`	10
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,798,566
`net_rshares`	0

@ddllddll · May 25 '18

골드님 개발자이신 걸 자꾸 까먹어요ㅎㅎ

properties (22)

`author`	ddllddll
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t080455269z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 08:04:57
`last_update`	2018-05-25 08:04:57
`depth`	1
`children`	1
`last_payout`	2018-06-01 08:04:57
`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`	21
`author_reputation`	21,045,682,342,077
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,596,273
`net_rshares`	0

@stylegold · May 25 '18

하하.. 아마도 제가 개발 관련 포스팅을 거의 안해서 그런거겠죠.
아무래도 다른 사람들이 즐겁지 않을거라는 생각이 많은가봐요.

properties (22)

`author`	stylegold
`permlink`	re-ddllddll-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t095413620z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 09:54:12
`last_update`	2018-05-25 09:54:12
`depth`	2
`children`	0
`last_payout`	2018-06-01 09:54: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`	70
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,609,745
`net_rshares`	0

@designkoi · May 25 '18

모든 행이 빨간색으로 보일까봐..무서워서 못 깔겠네요 ㅋㅋㅋ ㅜㅜ

properties (22)

`author`	designkoi
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t101133122z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 10:11:39
`last_update`	2018-05-25 10:11:39
`depth`	1
`children`	1
`last_payout`	2018-06-01 10:11:39
`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`	36
`author_reputation`	20,036,112,929,182
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,611,854
`net_rshares`	0

@stylegold · May 25 '18

하하!! 그럼 그냥 김프계산기만 써보세요. 
거래소를 다 열지 않아도 되서 좋습니다.

properties (22)

`author`	stylegold
`permlink`	re-designkoi-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t101744555z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 10:17:45
`last_update`	2018-05-25 10:17:45
`depth`	2
`children`	0
`last_payout`	2018-06-01 10:17:45
`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`	47
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,612,599
`net_rshares`	0

@energizer000 · May 25 '18

돌아오자마자!! 넘 능력자 아이십니까?(평양말투) ㅎㅎ

properties (22)

`author`	energizer000
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t084934737z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 08:49:57
`last_update`	2018-05-25 08:49:57
`depth`	1
`children`	1
`last_payout`	2018-06-01 08:49:57
`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`	30
`author_reputation`	10,196,662,528,181
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,601,609
`net_rshares`	0

@stylegold · May 25 '18

하하..  이미 몇번 업데이트 한건데... 
매일쓰던 시세표가 깨져서 거의 반 강제로 코딩을 좀 했네요.ㅋㅋ
평양어까지 쓰실수 있으신건가요.ㅋㅋㅋㅋㅋ

properties (22)

`author`	stylegold
`permlink`	re-energizer000-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t095645638z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 09:56:45
`last_update`	2018-05-25 09:56:45
`depth`	2
`children`	0
`last_payout`	2018-06-01 09:56:45
`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`	83
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,610,047
`net_rshares`	0

@eunyx · May 25 '18

상당히 편리하고 유용한 기능입니다. 잘 쓰겠습니다.
펀디와 이오스닥에 관심이 많아서... 거래소에 캐셔레스트를 추가해 주시면 고맙겠습니다^^

properties (22)

`author`	eunyx
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t204537255z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"community":"busy","app":"busy/2.4.0"}
`created`	2018-05-25 20:45:36
`last_update`	2018-05-25 20:45:36
`depth`	1
`children`	2
`last_payout`	2018-06-01 20:45:36
`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`	78
`author_reputation`	5,327,071,188,566
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,699,205
`net_rshares`	0

@stylegold · May 26 '18

api를 한번 찾아볼께요. 의견 감사합니다.

properties (22)

`author`	stylegold
`permlink`	re-eunyx-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180526t030215348z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-26 03:02:15
`last_update`	2018-05-26 03:02:15
`depth`	2
`children`	1
`last_payout`	2018-06-02 03:02:15
`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`	24
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,738,020
`net_rshares`	0

@eunyx · May 26 '18

고맙습니다. 거래소 중 코인네스트는 재검토바랍니다. 역프로 호기심을 자극하지만, 일종의 사기 수법이라고 생각됩니다. 왜냐하면... 원화 입금이 막혀 있기 때문에 코네로 비트나 이더 같은 걸 보내서 팔아야 하는데, 그것들도 코네에서는 엄청 싸거든요. 결국. 역프로 사람을 꼬셔서 유인하고, 상대적으로 비싼 거래 수수료를 먹는 수법입니다. 코네가 사기 횡령 등으로 대표가 구속되었는데 역프로 유인하는 것도 결국 사기수법의 하나라고 생각합니다. 수고하십시요^^

properties (22)

`author`	eunyx
`permlink`	re-stylegold-re-eunyx-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180526t041229982z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"community":"busy","app":"busy/2.4.0"}
`created`	2018-05-26 04:12:27
`last_update`	2018-05-26 04:12:27
`depth`	3
`children`	0
`last_payout`	2018-06-02 04:12:27
`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`	254
`author_reputation`	5,327,071,188,566
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,744,681
`net_rshares`	0

@fenrir78 · May 25 '18

이런 능력자이신줄 몰랐습니다 ㅎㅎ 감사히 쓰겠습니다!!!

properties (22)

`author`	fenrir78
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t071050385z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"community":"busy","app":"busy/2.4.0"}
`created`	2018-05-25 07:10:51
`last_update`	2018-05-25 07:10:51
`depth`	1
`children`	1
`last_payout`	2018-06-01 07:10:51
`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`	31
`author_reputation`	438,129,541,905,139
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,590,330
`net_rshares`	0

@stylegold · May 25 '18

하하. 능력자는 아니고 개발자 입니다.ㅋㅋㅋ
칭찬과 풀봇 감~사합니다.^^

properties (22)

`author`	stylegold
`permlink`	re-fenrir78-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t072029590z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 07:20:30
`last_update`	2018-05-25 07:20:30
`depth`	2
`children`	0
`last_payout`	2018-06-01 07:20:30
`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`	41
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,591,464
`net_rshares`	0

@fur2002ks · May 25 '18

헉... 전 왜 몰랐죠? 이런 능력자일줄은...ㅎㅎ 저한테 숨기는 이유가 뭡니까? ㅋㅋㅋㅋ
슬~슬~ 시간이 다가옵니다! 불금 가즈아~~ ㅋㅋ

properties (22)

`author`	fur2002ks
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t074646395z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 07:46:51
`last_update`	2018-05-25 07:46:51
`depth`	1
`children`	1
`last_payout`	2018-06-01 07:46:51
`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`	78
`author_reputation`	215,309,454,101,823
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,594,285
`net_rshares`	0

@stylegold · May 25 '18

하하.. 숨길 의도는 없었습니다. ㅋㅋㅋ
지루한 개발 글을 잘 쓰다보니.. 그런거죠~.ㅋㅋㅋ
출근한지 하루만에 불금 좋다 가즈아~!

properties (22)

`author`	stylegold
`permlink`	re-fur2002ks-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t074828346z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 07:48:27
`last_update`	2018-05-25 07:48:27
`depth`	2
`children`	0
`last_payout`	2018-06-01 07:48:27
`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`	73
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,594,467
`net_rshares`	0

@gasigogi · May 26 '18

와~ 이건 정~~~말 멋진데요.
이렇게 좋은걸 그것도 무료로 사용할수 있다니...
갑자기 골드님을 존경의 모드로 보게되었습니다.ㅋㅋㅋ
저도 유용하게 잘 사용하도록 하겠습니다. 감사합니다.^^

properties (22)

`author`	gasigogi
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180526t065446526z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"community":"busy","app":"busy/2.4.0"}
`created`	2018-05-26 06:54:51
`last_update`	2018-05-26 06:54:51
`depth`	1
`children`	1
`last_payout`	2018-06-02 06:54:51
`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`	106
`author_reputation`	39,703,543,454,713
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,759,367
`net_rshares`	0

@stylegold · May 26 '18

이정도에 존경모드로 바뀌시면 안됩니다. 
스팀잇에는 훨~씬 능력자가 많으니까요.^^
감사합니다.

properties (22)

`author`	stylegold
`permlink`	re-gasigogi-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180526t131832919z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-26 13:18:33
`last_update`	2018-05-26 13:18:33
`depth`	2
`children`	0
`last_payout`	2018-06-02 13:18:33
`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`	53
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,798,626
`net_rshares`	0

@glory7 · May 25 '18

대단하십니다... 잘 써볼게요

properties (22)

`author`	glory7
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t085924931z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 08:59:27
`last_update`	2018-05-25 08:59:27
`depth`	1
`children`	1
`last_payout`	2018-06-01 08:59:27
`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`	16
`author_reputation`	420,998,392,418,509
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,602,721
`net_rshares`	0

@stylegold · May 25 '18

하하.. 대.. 단한건 아니고 그냥 그렇습니다.ㅋㅋ
마음껏 가져다 쓰시고 필요한거 있으시면 언제든지 질문 해주세요.

properties (22)

`author`	stylegold
`permlink`	re-glory7-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t095731828z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 09:57:30
`last_update`	2018-05-25 09:57:30
`depth`	2
`children`	0
`last_payout`	2018-06-01 09:57:30
`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`	64
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,610,111
`net_rshares`	0

@goodhello · May 26 '18

와우~ 전 엑셀로 대충 정리해서 썼는데 이거 사용해 보겠습니다~

감사합니다~

properties (22)

`author`	goodhello
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180526t000014714z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-26 00:00:15
`last_update`	2018-05-26 00:00:15
`depth`	1
`children`	1
`last_payout`	2018-06-02 00:00:15
`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`	43
`author_reputation`	430,635,914,360,128
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,720,908
`net_rshares`	0

@stylegold · May 26 '18 (edited)

실시간 거래소. 시세를 이용하시면 좀더 도움이 되실꺼예요 감사합니다.

properties (22)

`author`	stylegold
`permlink`	re-goodhello-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180526t030136993z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-26 03:01:36
`last_update`	2018-05-26 03:01:45
`depth`	2
`children`	0
`last_payout`	2018-06-02 03:01:36
`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`	38
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,737,965
`net_rshares`	0

@greenswell · May 26 '18

능력자님!!!
@gopaxkr 님 여기 풀봇 쏴주세요

properties (22)

`author`	greenswell
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180526t031639756z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"users":["gopaxkr"],"app":"steemit/0.1"}
`created`	2018-05-26 03:16:39
`last_update`	2018-05-26 03:16:39
`depth`	1
`children`	1
`last_payout`	2018-06-02 03:16:39
`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`	29
`author_reputation`	8,404,247,136,400
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,739,386
`net_rshares`	0

@stylegold · May 26 '18

ㅎ히하핫 제발--- 
감사합니다.

properties (22)

`author`	stylegold
`permlink`	re-greenswell-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180526t041445302z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-26 04:14:45
`last_update`	2018-05-26 04:14:45
`depth`	2
`children`	0
`last_payout`	2018-06-02 04:14:45
`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`	18
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,744,879
`net_rshares`	0

@happylazar · May 25 '18 (edited)

저도 만들어서 관리좀 해야겠네요

properties (22)

`author`	happylazar
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t075342548z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"community":"busy","app":"busy/2.4.0"}
`created`	2018-05-25 07:53:45
`last_update`	2018-05-25 07:54:12
`depth`	1
`children`	1
`last_payout`	2018-06-01 07:53:45
`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`	18
`author_reputation`	5,888,595,805,444
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,595,074
`net_rshares`	0

@stylegold · May 25 '18

관리를 하면 조금 더 효율적으로 사용할수 있답니다. 추천합니다.^^
제 시트는 마음껏 변경하시고 재배포 하셔도 됩니다.^^

properties (22)

`author`	stylegold
`permlink`	re-happylazar-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t095252994z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 09:52:54
`last_update`	2018-05-25 09:52:54
`depth`	2
`children`	0
`last_payout`	2018-06-01 09:52: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`	68
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,609,601
`net_rshares`	0

@heonbros · Jun 3 '18

원래 사용하고 있던 시트에 만들어주신 스크립트를 적용하고 싶은데 방법이 있는지 여쭤봅니다.

properties (22)

`author`	heonbros
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180603t050138566z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-06-03 05:01:39
`last_update`	2018-06-03 05:01:39
`depth`	1
`children`	0
`last_payout`	2018-06-10 05:01:39
`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`	50
`author_reputation`	6,768,850,447,196
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	59,000,116
`net_rshares`	0

@hyunkyuiii · May 25 '18

대단합니다!리스팀해놓고 써봐야겠어요!!

properties (22)

`author`	hyunkyuiii
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t074952314z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 07:49:54
`last_update`	2018-05-25 07:49:54
`depth`	1
`children`	1
`last_payout`	2018-06-01 07:49: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`	21
`author_reputation`	517,746,794,394
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,594,634
`net_rshares`	0

@stylegold · May 25 '18

대단은요 그냥 약간의 코드 수정을 했을뿐입니다.^^ 감사합니다.

properties (22)

`author`	stylegold
`permlink`	re-hyunkyuiii-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t075140440z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 07:51:39
`last_update`	2018-05-25 07:51:39
`depth`	2
`children`	0
`last_payout`	2018-06-01 07:51:39
`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`	35
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,594,852
`net_rshares`	0

@hyunny · May 25 '18

스팀잇엔참대단한분들이많으시다는...능력자골드님에엄지척합니다^^

properties (22)

`author`	hyunny
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t105045567z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 10:50:48
`last_update`	2018-05-25 10:50:48
`depth`	1
`children`	1
`last_payout`	2018-06-01 10:50:48
`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`	34
`author_reputation`	12,057,006,642,794
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,616,481
`net_rshares`	0

@stylegold · May 25 '18

앗!! 감사합니다. 근데 저는 아주 실력이 미약한데.ㅋㅋ

properties (22)

`author`	stylegold
`permlink`	re-hyunny-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t141729640z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 14:17:30
`last_update`	2018-05-25 14:17:30
`depth`	2
`children`	0
`last_payout`	2018-06-01 14:17:30
`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`	31
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,644,758
`net_rshares`	0

@joeypark · May 26 '18

아래 보상 거절 때문에 이 글에 보팅하고 갑니다 ^^

properties (22)

`author`	joeypark
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180526t121954570z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemkr/0.1"}
`created`	2018-05-26 12:19:54
`last_update`	2018-05-26 12:19:54
`depth`	1
`children`	1
`last_payout`	2018-06-02 12:19: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`	29
`author_reputation`	188,334,840,663,892
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,791,952
`net_rshares`	0

@stylegold · May 26 '18

앗 감사해요.^^ 큐레이팅 관련 해서는 그냥 댓글만 다셔도 됩니다.^^

properties (22)

`author`	stylegold
`permlink`	re-joeypark-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180526t131907805z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-26 13:19:09
`last_update`	2018-05-26 13:19:09
`depth`	2
`children`	0
`last_payout`	2018-06-02 13:19: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`	39
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,798,707
`net_rshares`	0

@moon9065 · May 25 '18

공부를  많이 해야겠어요~
제게는 많이 어려워요~
꾸준한  노력이 있으셔서  이렇게 능력자가 되셨겠죠?
부럽네요

properties (22)

`author`	moon9065
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t122450833z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 12:25:03
`last_update`	2018-05-25 12:25:03
`depth`	1
`children`	1
`last_payout`	2018-06-01 12:25: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`	62
`author_reputation`	638,725,310,383
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,628,565
`net_rshares`	0

@stylegold · May 25 '18

아.. 제가 설명이 너무 부족해서~^^
사용하실때 물어보시면 좀 더 알려드릴께요.ㅋㅋ

properties (22)

`author`	stylegold
`permlink`	re-moon9065-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t141753572z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 14:17:54
`last_update`	2018-05-25 14:17:54
`depth`	2
`children`	0
`last_payout`	2018-06-01 14:17: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`	47
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,644,802
`net_rshares`	0

@moulin-rouge · May 25 '18

와우~  정말 멋지네요~ !

properties (22)

`author`	moulin-rouge
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t075909653z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 07:59:09
`last_update`	2018-05-25 07:59:09
`depth`	1
`children`	1
`last_payout`	2018-06-01 07:59: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`	15
`author_reputation`	191,695,790,018
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,595,648
`net_rshares`	0

@stylegold · May 25 '18

감사합니다.^^ 강아지가 상당히 귀엽네요.~

properties (22)

`author`	stylegold
`permlink`	re-moulin-rouge-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t095316317z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 09:53:18
`last_update`	2018-05-25 09:53:18
`depth`	2
`children`	0
`last_payout`	2018-06-01 09:53: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`	24
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,609,639
`net_rshares`	0

@neoahava · May 27 '18

감사합니다. 
초보가 봐도 리스팀이 필요한 글이라 생각되어 긁어갑니다^^

properties (22)

`author`	neoahava
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180527t210550600z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-27 21:05:54
`last_update`	2018-05-27 21:05:54
`depth`	1
`children`	1
`last_payout`	2018-06-03 21:05: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`	40
`author_reputation`	54,658,015,608
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	58,005,369
`net_rshares`	0

@stylegold · May 28 '18

리스팀 감사합니다.

properties (22)

`author`	stylegold
`permlink`	re-neoahava-re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180528t014950661z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-28 01:49:51
`last_update`	2018-05-28 01:49:51
`depth`	2
`children`	0
`last_payout`	2018-06-04 01:49:51
`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`	10
`author_reputation`	16,670,352,484,704
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	58,033,511
`net_rshares`	0

@newbijohn · May 25 '18

와......구글시트내에서 거래소별 시세가 실시간 반영되는거에여???!!

properties (22)

`author`	newbijohn
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t072327770z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 07:23:27
`last_update`	2018-05-25 07:23:27
`depth`	1
`children`	4
`last_payout`	2018-06-01 07:23:27
`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`	40
`author_reputation`	72,450,120,773,132
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,591,772
`net_rshares`	0

@stylegold · May 25 '18

넵.. 그런 시트는 상당히 많아요.^^
그래도 국내 거래소들 거의 대부분을 모아놨으니 쓰시기 좋으실겁니다.^^

properties (22)

@newbijohn · May 25 '18

오......이런 능력자님... 대단합니다. 어떻게 연결하는지 포스팅함 하시면 좋을 듯 해요 ㅋㅋ

properties (22)

2 replies

@onehand · May 25 '18

오!? PC에 엑셀파일로 보관하고 있었는데, 구글 스프레드 시트가 이렇게도 활용할 수 있었군요.ㅎㅎ

properties (22)

@stylegold · May 25 '18

구글 프로그램의 스크립트를 사용하면 이런류의 작업외에도 훨~씬 많은 걸 할수 있답니다.
아예 새로운 프로그램을 만들어낼수 있구요.^^

properties (22)

@orange5008 · May 25 '18

공부의 끝이라는 건 없다고 생각하지만
이제 입문중인 저로선 매일 머리 속이
회오리바람 휭휭이네요^^
시작부터 탄탄하게!!감사합니다~

properties (22)

@stylegold · May 26 '18

첨엔 어렵지만 조금만 지나면익숙해질꺼예요
응원합니다.

properties (22)

@pairplay-en · May 26 '18

pairplay 가 kr-dev 컨텐츠를 응원합니다! :)

properties (22)

@stylegold · May 26 '18

와우 통큰지원 너무너무 감사합니다.

properties (22)

@pairplay · May 27 '18

pairplay 가 kr-dev 컨텐츠를 응원합니다! :)

properties (22)

@stylegold · May 27 '18

응원감사감사합니다.

properties (22)

@scv · May 25 '18

와~대단하세요.
엄청 바쁘실텐데...정말 놀랐어요.^^

properties (22)

@stylegold · May 25 '18

감사합니다.^^
아주 오래전 만들었던 것에 약간의 업데이트를 했을뿐 입니다.^^

properties (22)

@sitha · May 25 '18

역시 개발자님들은 상상하는 모든것을 만들죠!!
잘쓰겠습니다~

properties (22)

@stylegold · May 26 '18

ㅋㅋ 돈 되는것만 만드는 저같은 속된인간도 있어요ㅋㅋ

properties (22)

@supergiant · May 25 '18

구글시트로 시세를 조회하다니
제가 모르고 있던 기능이 많군요 ㅎㅎ

properties (22)

@stylegold · May 25 '18

구글시트로 할수 있는건 정말 어마어마하게 많답니다.^^
이렇게 매번 강한지원 감사합니다.^^

properties (22)

@tangle-hoon · May 26 '18

대박사건!!

오랜만에 주문을 읽었습니다.

오늘 하루 대박나기를 ^&^

properties (22)

@stylegold · May 26 '18

주문을 따라서 다함께 대박나길!

properties (22)

@thinky · May 26 '18

큐레이터 아닌 개발자로 인기가 치솟으셨네요. 나눠주셔 감사합니다^^

properties (22)

@stylegold · May 26 '18

그러게요. 임대스파덕분 아니겠습니까.^^

properties (22)

@thinky · May 27 '18

그럴리가요. 스파 반납하셔도 골드님의 인기는 계속될 거 같습니다. 여행 건강히 다녀오셔 반갑습니다 :)

properties (22)

@yangmok701 · May 25 '18

이런 놀라운 기능이 있었군요, 소개 감사합니다

properties (22)

@stylegold · May 25 '18

별말씀을요^^ 공유는 항상 필요하죠.

properties (22)

`author`	orange5008
`permlink`	re-stylegold-google-sheet-gopax-coinmarketcap-api-v2-20180525t221846207z
`category`	kr-dev
`json_metadata`	{"tags":["kr-dev"],"app":"steemit/0.1"}
`created`	2018-05-25 22:18:45
`last_update`	2018-05-25 22:18:45
`depth`	1
`children`	1
`last_payout`	2018-06-01 22:18:45
`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`	73
`author_reputation`	6,298,481,795,281
`root_title`	"김프계산기, 가상화폐 관리용 Google Sheet 업데이트 (고팍스 추가, CoinmarketCap API V2 적용)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	57,710,013
`net_rshares`	0