Bitcoin Forum

Hello crypters,
waiting for an official API of http://coinmarketcap.com, I created a google spreadsheet to track the price of alternative cryptocurrencies.

It scrapes the HTML every minute and it parses it, making sure that the coins  are always ordered the same way.

http://www.lize.it/up/altcoin_screenshot.png

You can see the source on github and follow the instruction to use it in your project ;)

https://github.com/adv0r/altcoin-google-spreadsheet (https://github.com/adv0r/altcoin-google-spreadsheet)

TIPS are welcome!

-  BTC   1NgDPjxNWxTUK9eUExEmAGj4mtiMLGFvYr
-  LTC   LhgAgfFCAo4J6pvg3iyG4eQF5syiEZcXMZ
-  NMC   N79FWuuHCcgNe2YPkenkdQrZXsksFxADuf
-  NVC   4Gprnc172MpPy5hENjdMxBoY6qaHbRMX7G
-  TRC   1DnvtbUEcUGsshAjfqhDf4YTUkHEgxeUci
-  PPC   PFRbFG4WmQPs12A7wGvQwtSXbhsnvZteoT
-  FTC   6vdoqHQohgsGXjzvU2JfArg4U1nGB2MZ53
-  XPM   AXFEykfvr8MJ6n7PdSoR94psQXtqvRaMkM
-  BQC   bMkJLYZsAMN2Si5D8RgQwiwHEbw4sGdMC5
-  MEC   MDbrBWar6ANtiEbhRdVqWyii2gGLAumVjR
-  SXC   S4fntfCLr1hWQZcXnYx9g4ZBZrp8H3zPfF
-  DVC   15YXWsAWNu4mf4Yc6BDZPXTp9PLrUB2dRW

You sir have just made my life so much easier, hoping I can plug it easily into the coins I already have that automatically work out value, value increase %, % of holdings, etc.

Will be fully automated now if this does what I think it can, not home at the moment.

Awesome, cheers!

Will be giving you a nice tip when I get it sussed. :)

I tried to get this going. When I get to the part about copying and pasting the code.gs into a new script. I get an error on saving. Syntax Error line 63.

reserved

same with me, it appears there are too many parentheses, not sure what to do with the last two..

and why when I use =ImportHtml("http://coinmarketcap.com/?"& year(now()) & month(now()) & day(now()) & hour(now()) ,"table",1) in my gdrive sheet, after a while it stops working?  :'(

Thank you cygnify ;) Just let me know if I can help!

Hi MisO69,
thank you for reporting the bug, I'll look into it and get back!

Not sure what does that mean  ???

I'm not sure why, I think it has something to do with how google apps manages multiple triggers.

Lets try to refresh those data every 5 minutes instead of every hour and see how that change.

I fixed the bug at line 63... Sorry, I think it was due to a copypaste issue.
https://github.com/adv0r/altcoin-google-spreadsheet/commit/02a136df291cc6569cc75d133566bfbb80d822eb (https://github.com/adv0r/altcoin-google-spreadsheet/commit/02a136df291cc6569cc75d133566bfbb80d822eb)
Thank you for letting me notice

that's awesome stuff, I never used scripts before but I'm starting to like it :D
how would you extract the value of a cell? I can tell him to =parseBtc("some cell") and =getLineOf("some cell")), but like when I get the line of a coin, how do i attach it to "D" so that I can tell him eg. =parseBtc(D3) to get the ltc value?

read up on the function INDIRECT

 8)

hehe still trying but still not workin, can't put the function getLineOf(A3) into a "string"  ::) ;D

RESERVEDEDEDED

heheh I'm pretty new to the altcoin section and I'm not sure what RESERVED means.

=parseBtc(INDIRECT(concatenate("D",getLineOf(B3)))) is the best I can do but still no success  :-\

Nice job.  Very clever!   :)

This is web 2.0. Why create context rich altcoin information when you can make a spreadsheet?

please read the github help ;)

I'm not sure what you are tring to accomplish. Create a new spreadsheet and share it with me so I can help you hands on when I have time

the INDIRECT command was not forwarding its return as a string somehow for the parseBtc command to process it, but I found a way around it thanks  ;)
anyway, the importHTML keeps falling out so I need to activate the command every time manually. don't know if it's just a google servers issue..

great job! however i'm unable to import in excel or even add my own coin quantity to a copy of the spreadsheet on google docs to keep them almost instantly updated .. since if i add the quantities i noted the spreadsheet stops updating. how to do?

Ok.  That sounds excellent.
How do I import just the constant updating price of Litecoin into one cell for my Excel 2010 spreadsheet?
Steps if possible please.  
I just wish to show my wife how this stuff could work.

Success & ease of implementation equals a BTC donation worth the price of a Starbucks Venti Cinnamon Dolce Crème Frappuccino.  ;D

Thanks in advance.

When I go to the demo, nothing works. Can someone resurrect this, or provide suggestions for a replacement?

I will take a look at this. This is definitely something that is from my interest too. This learnt me that there is a Coinmarketcap API. And this is something thta excites me !

By replacing the now() function for today() function the CoinmarketCapHTML tab is working, but the script also need to be fixed.

Hello folks.  Here's an Excel version I put together using COINMARKETCAP data for those that dislike/don't use Google:

https://securisync.intermedia.net/us2/s/q06fxlAc7oDUEE9kU9D3eL001180dd

Tips are welcome too, if you care to share :O

Eth:  0x0568eb8c2b00ee1f2460dc7df30923cc09244ee7
BTC: 1APDCAHmQjSvtcMdhVaCiwzRNWTkiVcAUz
LTC: LPAimjN1z2iqCwLZ2Cxz1G6gUKygyvSNJz

Was anyone able to fix the google spreadsheet?

I'd also be interested in seeing an update to the Google spreadsheet. I was only able to get as far as having CoinmarketCapHTML and CoinmarketCAPTemporized sheets working.

Check out https://cointracking.info (https://cointracking.info)
Does the job wonderfull for me!