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
Thank you for letting me notice
Topic: Online spreadsheet with altcoins live data - page 2. (Read 6852 times)
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? 
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.
Code:
=ImportHtml("http://coinmarketcap.com/?"& year(now()) & month(now()) & day(now()) & hour(now()) & minute(now())*5,"table",1
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.
Hi MisO69,
thank you for reporting the bug, I'll look into it and get back!
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.
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.
Thank you cygnify
Just let me know if I can help! 
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?
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.
same with me, it appears there are too many parentheses, not sure what to do with the last two..
reserved
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.
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.
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.
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.
You can see the source on github and follow the instruction to use it in your project
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
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.
You can see the source on github and follow the instruction to use it in your project
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
Jump to: