Online spreadsheet with altcoins live data

[advanced]

that's awesome stuff, I never used scripts before but I'm starting to like it
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

 

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

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

[1714942785]

1714942785

[1714942785]

1714942785

[1714942785]

1714942785

[id10tothe9]

that's awesome stuff, I never used scripts before but I'm starting to like it
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

 

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

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..

[tex83rb]

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?

[suzukii]

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

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.  

Thanks in advance.

[inf1ux]

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

[Redrose]

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 !

[Snail2]

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

[gcxc]

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

[lifeiscrypto]

Was anyone able to fix the google spreadsheet?

[nwtrades]

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.

[The Flexican]

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