Bitcoin Forum
April 24, 2024, 10:15:14 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Bitcoin Forum > Alternate cryptocurrencies > Altcoin Discussion > Online spreadsheet with altcoins live data
Pages: [1] 2 »  All
« previous topic next topic »
  Print  
Author Topic: Online spreadsheet with altcoins live data  (Read 6793 times)
advanced (OP)
Sr. Member
****
Offline Offline

Activity: 267
Merit: 250


Woodwallets.io


View Profile WWW
December 12, 2013, 12:04:06 PM
Last edit: December 12, 2013, 02:00:51 PM by advanced
 #1
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 Wink

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
Bitmessage : BM-NAx31aEiqeq5zKUtxhKscXQ7Dwn1jJfR
1713953714
Hero Member
*
Offline Offline

Posts: 1713953714

View Profile Personal Message (Offline)

Ignore
1713953714
1713953714
Reply with quote  #2
1713953714
Report to moderator
1713953714
Hero Member
*
Offline Offline

Posts: 1713953714

View Profile Personal Message (Offline)

Ignore
1713953714
1713953714
Reply with quote  #2
1713953714
Report to moderator
"This isn't the kind of software where we can leave so many unresolved bugs that we need a tracker for them." -- Satoshi
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1713953714
Hero Member
*
Offline Offline

Posts: 1713953714

View Profile Personal Message (Offline)

Ignore
1713953714
1713953714
Reply with quote  #2
1713953714
Report to moderator
1713953714
Hero Member
*
Offline Offline

Posts: 1713953714

View Profile Personal Message (Offline)

Ignore
1713953714
1713953714
Reply with quote  #2
1713953714
Report to moderator
Cygnify
Full Member
***
Offline Offline

Activity: 140
Merit: 100


View Profile
December 12, 2013, 08:39:33 PM
 #2
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. Smiley
▓▓▓▓▓▓▓▓▓▓  ✔  ▶▶▶▶ Get Your Free Tokens Now ◀◀◀◀  First PoS Smart Contract Token
▓    PoSToken   ▓  ✔  Free Airdrop ●  No-ICO ●  100% Annual Interest First Year
▓▓▓▓▓▓▓▓▓▓  ✔  ANN ●  WebSite  ●  Twitter  ●  Slack  ●  Whitepaper
MisO69
Legendary
*
Offline Offline

Activity: 1946
Merit: 1005


My mule don't like people laughing


View Profile
December 12, 2013, 09:28:13 PM
 #3
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.
FrictionlessCoin
Legendary
*
Offline Offline

Activity: 868
Merit: 1000


Cryptotalk.org - Get paid for every post!


View Profile
December 12, 2013, 09:51:04 PM
 #4
reserved
 
                                . ██████████.
                              .████████████████.
                           .██████████████████████.
                        -█████████████████████████████
                     .██████████████████████████████████.
                  -█████████████████████████████████████████
               -███████████████████████████████████████████████
           .-█████████████████████████████████████████████████████.
        .████████████████████████████████████████████████████████████
       .██████████████████████████████████████████████████████████████.
       .██████████████████████████████████████████████████████████████.
       ..████████████████████████████████████████████████████████████..
       .   .██████████████████████████████████████████████████████.
       .      .████████████████████████████████████████████████.
       .       .██████████████████████████████████████████████
       .    ██████████████████████████████████████████████████████
       .█████████████████████████████████████████████████████████████.
        .███████████████████████████████████████████████████████████
           .█████████████████████████████████████████████████████
              .████████████████████████████████████████████████
                   ████████████████████████████████████████
                      ██████████████████████████████████
                          ██████████████████████████
                             ████████████████████
                               ████████████████
                                   █████████		.CryptoTalk.org.|.MAKE POSTS AND EARN BTC!.🏆
id10tothe9
Hero Member
*****
Offline Offline

Activity: 623
Merit: 500



View Profile
December 13, 2013, 07:58:37 AM
 #5
Quote from: MisO69 on December 12, 2013, 09:28:13 PM
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..
           ▀██▄ ▄██▀
            ▐█████▌
           ▄███▀███▄
         ▄████▄  ▀███▄
       ▄███▀ ▀██▄  ▀███▄
     ▄███▀  ▄█████▄  ▀███▄
   ▄███▀  ▄███▀ ▀███▄  ▀███▄
  ███▀  ▄████▌   ▐████▄  ▀███
 ███   ██▀  ██▄ ▄██  ▀██   ███
███   ███  ███   ███  ███   ███
███   ███   ███████   ███   ███
 ███   ███▄▄       ▄▄███   ███
  ███▄   ▀▀█████████▀▀   ▄███
   ▀████▄▄           ▄▄████▀
      ▀▀███████████████▀▀		DeepOnion★  Anonymity Guaranteed
★  Anonymous and Untraceable
★  Guard Your Privacy		      ▄▄██████████▄▄
    ▄███▀▀      ▀▀█▀   ▄▄
   ███▀              ▄███
  ███              ▄███▀   ▄▄
 ███▌  ▄▄▄▄      ▄███▀   ▄███
▐███  ██████   ▄███▀   ▄███▀
███▌ ███  ███▄███▀   ▄███▀
███▌ ███   ████▀   ▄███▀
███▌  ███   █▀   ▄███▀  ███
▐███   ███     ▄███▀   ███
 ███▌   ███  ▄███▀     ███
  ███    ██████▀      ███
   ███▄             ▄███
    ▀███▄▄       ▄▄███▀
      ▀▀███████████▀▀
id10tothe9
Hero Member
*****
Offline Offline

Activity: 623
Merit: 500



View Profile
December 13, 2013, 09:23:20 AM
 #6
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?  Cry
           ▀██▄ ▄██▀
            ▐█████▌
           ▄███▀███▄
         ▄████▄  ▀███▄
       ▄███▀ ▀██▄  ▀███▄
     ▄███▀  ▄█████▄  ▀███▄
   ▄███▀  ▄███▀ ▀███▄  ▀███▄
  ███▀  ▄████▌   ▐████▄  ▀███
 ███   ██▀  ██▄ ▄██  ▀██   ███
███   ███  ███   ███  ███   ███
███   ███   ███████   ███   ███
 ███   ███▄▄       ▄▄███   ███
  ███▄   ▀▀█████████▀▀   ▄███
   ▀████▄▄           ▄▄████▀
      ▀▀███████████████▀▀		DeepOnion★  Anonymity Guaranteed
★  Anonymous and Untraceable
★  Guard Your Privacy		      ▄▄██████████▄▄
    ▄███▀▀      ▀▀█▀   ▄▄
   ███▀              ▄███
  ███              ▄███▀   ▄▄
 ███▌  ▄▄▄▄      ▄███▀   ▄███
▐███  ██████   ▄███▀   ▄███▀
███▌ ███  ███▄███▀   ▄███▀
███▌ ███   ████▀   ▄███▀
███▌  ███   █▀   ▄███▀  ███
▐███   ███     ▄███▀   ███
 ███▌   ███  ▄███▀     ███
  ███    ██████▀      ███
   ███▄             ▄███
    ▀███▄▄       ▄▄███▀
      ▀▀███████████▀▀
advanced (OP)
Sr. Member
****
Offline Offline

Activity: 267
Merit: 250


Woodwallets.io


View Profile WWW
December 13, 2013, 09:48:48 AM
 #7
Quote from: Cygnify on December 12, 2013, 08:39:33 PM
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. Smiley

Thank you cygnify Wink Just let me know if I can help!
Bitmessage : BM-NAx31aEiqeq5zKUtxhKscXQ7Dwn1jJfR
advanced (OP)
Sr. Member
****
Offline Offline

Activity: 267
Merit: 250


Woodwallets.io


View Profile WWW
December 13, 2013, 09:49:49 AM
 #8
Quote from: MisO69 on December 12, 2013, 09:28:13 PM
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!
Bitmessage : BM-NAx31aEiqeq5zKUtxhKscXQ7Dwn1jJfR
advanced (OP)
Sr. Member
****
Offline Offline

Activity: 267
Merit: 250


Woodwallets.io


View Profile WWW
December 13, 2013, 09:50:09 AM
 #9
Quote from: FrictionlessCoin on December 12, 2013, 09:51:04 PM
reserved

Not sure what does that mean  Huh
Bitmessage : BM-NAx31aEiqeq5zKUtxhKscXQ7Dwn1jJfR
advanced (OP)
Sr. Member
****
Offline Offline

Activity: 267
Merit: 250


Woodwallets.io


View Profile WWW
December 13, 2013, 09:54:08 AM
Last edit: December 13, 2013, 10:34:35 AM by advanced
 #10
Quote from: id10tothe9 on December 13, 2013, 09:23:20 AM
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?  Cry

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
Bitmessage : BM-NAx31aEiqeq5zKUtxhKscXQ7Dwn1jJfR
advanced (OP)
Sr. Member
****
Offline Offline

Activity: 267
Merit: 250


Woodwallets.io


View Profile WWW
December 13, 2013, 10:00:33 AM
 #11
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
Bitmessage : BM-NAx31aEiqeq5zKUtxhKscXQ7Dwn1jJfR
id10tothe9
Hero Member
*****
Offline Offline

Activity: 623
Merit: 500



View Profile
December 13, 2013, 10:29:28 AM
 #12
that's awesome stuff, I never used scripts before but I'm starting to like it Cheesy
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?
           ▀██▄ ▄██▀
            ▐█████▌
           ▄███▀███▄
         ▄████▄  ▀███▄
       ▄███▀ ▀██▄  ▀███▄
     ▄███▀  ▄█████▄  ▀███▄
   ▄███▀  ▄███▀ ▀███▄  ▀███▄
  ███▀  ▄████▌   ▐████▄  ▀███
 ███   ██▀  ██▄ ▄██  ▀██   ███
███   ███  ███   ███  ███   ███
███   ███   ███████   ███   ███
 ███   ███▄▄       ▄▄███   ███
  ███▄   ▀▀█████████▀▀   ▄███
   ▀████▄▄           ▄▄████▀
      ▀▀███████████████▀▀		DeepOnion★  Anonymity Guaranteed
★  Anonymous and Untraceable
★  Guard Your Privacy		      ▄▄██████████▄▄
    ▄███▀▀      ▀▀█▀   ▄▄
   ███▀              ▄███
  ███              ▄███▀   ▄▄
 ███▌  ▄▄▄▄      ▄███▀   ▄███
▐███  ██████   ▄███▀   ▄███▀
███▌ ███  ███▄███▀   ▄███▀
███▌ ███   ████▀   ▄███▀
███▌  ███   █▀   ▄███▀  ███
▐███   ███     ▄███▀   ███
 ███▌   ███  ▄███▀     ███
  ███    ██████▀      ███
   ███▄             ▄███
    ▀███▄▄       ▄▄███▀
      ▀▀███████████▀▀
advanced (OP)
Sr. Member
****
Offline Offline

Activity: 267
Merit: 250


Woodwallets.io


View Profile WWW
December 13, 2013, 10:36:51 AM
 #13
Quote from: id10tothe9 on December 13, 2013, 10:29:28 AM
that's awesome stuff, I never used scripts before but I'm starting to like it Cheesy
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

 Cool
Bitmessage : BM-NAx31aEiqeq5zKUtxhKscXQ7Dwn1jJfR
id10tothe9
Hero Member
*****
Offline Offline

Activity: 623
Merit: 500



View Profile
December 13, 2013, 11:07:43 AM
 #14
hehe still trying but still not workin, can't put the function getLineOf(A3) into a "string"  Roll Eyes Grin
           ▀██▄ ▄██▀
            ▐█████▌
           ▄███▀███▄
         ▄████▄  ▀███▄
       ▄███▀ ▀██▄  ▀███▄
     ▄███▀  ▄█████▄  ▀███▄
   ▄███▀  ▄███▀ ▀███▄  ▀███▄
  ███▀  ▄████▌   ▐████▄  ▀███
 ███   ██▀  ██▄ ▄██  ▀██   ███
███   ███  ███   ███  ███   ███
███   ███   ███████   ███   ███
 ███   ███▄▄       ▄▄███   ███
  ███▄   ▀▀█████████▀▀   ▄███
   ▀████▄▄           ▄▄████▀
      ▀▀███████████████▀▀		DeepOnion★  Anonymity Guaranteed
★  Anonymous and Untraceable
★  Guard Your Privacy		      ▄▄██████████▄▄
    ▄███▀▀      ▀▀█▀   ▄▄
   ███▀              ▄███
  ███              ▄███▀   ▄▄
 ███▌  ▄▄▄▄      ▄███▀   ▄███
▐███  ██████   ▄███▀   ▄███▀
███▌ ███  ███▄███▀   ▄███▀
███▌ ███   ████▀   ▄███▀
███▌  ███   █▀   ▄███▀  ███
▐███   ███     ▄███▀   ███
 ███▌   ███  ▄███▀     ███
  ███    ██████▀      ███
   ███▄             ▄███
    ▀███▄▄       ▄▄███▀
      ▀▀███████████▀▀
Dr.What
Newbie
*
Offline Offline

Activity: 42
Merit: 0


View Profile
December 13, 2013, 11:18:00 AM
 #15
RESERVEDEDEDED
advanced (OP)
Sr. Member
****
Offline Offline

Activity: 267
Merit: 250


Woodwallets.io


View Profile WWW
December 13, 2013, 11:24:06 AM
 #16
Quote from: Dr.What on December 13, 2013, 11:18:00 AM
RESERVEDEDEDED

heheh I'm pretty new to the altcoin section and I'm not sure what RESERVED means.
Bitmessage : BM-NAx31aEiqeq5zKUtxhKscXQ7Dwn1jJfR
id10tothe9
Hero Member
*****
Offline Offline

Activity: 623
Merit: 500



View Profile
December 13, 2013, 11:37:05 AM
 #17
Quote from: advanced on December 13, 2013, 10:36:51 AM
Quote from: id10tothe9 on December 13, 2013, 10:29:28 AM
that's awesome stuff, I never used scripts before but I'm starting to like it Cheesy
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

 Cool

=parseBtc(INDIRECT(concatenate("D",getLineOf(B3)))) is the best I can do but still no success  Undecided
           ▀██▄ ▄██▀
            ▐█████▌
           ▄███▀███▄
         ▄████▄  ▀███▄
       ▄███▀ ▀██▄  ▀███▄
     ▄███▀  ▄█████▄  ▀███▄
   ▄███▀  ▄███▀ ▀███▄  ▀███▄
  ███▀  ▄████▌   ▐████▄  ▀███
 ███   ██▀  ██▄ ▄██  ▀██   ███
███   ███  ███   ███  ███   ███
███   ███   ███████   ███   ███
 ███   ███▄▄       ▄▄███   ███
  ███▄   ▀▀█████████▀▀   ▄███
   ▀████▄▄           ▄▄████▀
      ▀▀███████████████▀▀		DeepOnion★  Anonymity Guaranteed
★  Anonymous and Untraceable
★  Guard Your Privacy		      ▄▄██████████▄▄
    ▄███▀▀      ▀▀█▀   ▄▄
   ███▀              ▄███
  ███              ▄███▀   ▄▄
 ███▌  ▄▄▄▄      ▄███▀   ▄███
▐███  ██████   ▄███▀   ▄███▀
███▌ ███  ███▄███▀   ▄███▀
███▌ ███   ████▀   ▄███▀
███▌  ███   █▀   ▄███▀  ███
▐███   ███     ▄███▀   ███
 ███▌   ███  ▄███▀     ███
  ███    ██████▀      ███
   ███▄             ▄███
    ▀███▄▄       ▄▄███▀
      ▀▀███████████▀▀
btcrich
Sr. Member
****
Offline Offline

Activity: 302
Merit: 250


View Profile
December 13, 2013, 11:48:53 AM
 #18
Nice job.  Very clever!   Smiley
Dr.What
Newbie
*
Offline Offline

Activity: 42
Merit: 0


View Profile
December 13, 2013, 12:02:43 PM
 #19
Quote from: advanced on December 13, 2013, 11:24:06 AM
Quote from: Dr.What on December 13, 2013, 11:18:00 AM
RESERVEDEDEDED

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

This is web 2.0. Why create context rich altcoin information when you can make a spreadsheet?
advanced (OP)
Sr. Member
****
Offline Offline

Activity: 267
Merit: 250


Woodwallets.io


View Profile WWW
December 13, 2013, 12:32:42 PM
 #20
Quote from: smaragda on December 13, 2013, 11:32:11 AM

Step by step guide please.   Huh

Seems simple enough, but it is not running for some reason.


please read the github help Wink
Bitmessage : BM-NAx31aEiqeq5zKUtxhKscXQ7Dwn1jJfR
Pages: [1] 2 »  All
  Print  
Bitcoin Forum > Alternate cryptocurrencies > Altcoin Discussion > Online spreadsheet with altcoins live data
 « previous topic next topic »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!