Check out https://cointracking.info
Does the job wonderfull for me!
Topic: Online spreadsheet with altcoins live data (Read 6852 times)
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.
Was anyone able to fix the google spreadsheet?
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
https://securisync.intermedia.net/us2/s/q06fxlAc7oDUEE9kU9D3eL001180dd
Tips are welcome too, if you care to share :O
Eth: 0x0568eb8c2b00ee1f2460dc7df30923cc09244ee7
BTC: 1APDCAHmQjSvtcMdhVaCiwzRNWTkiVcAUz
LTC: LPAimjN1z2iqCwLZ2Cxz1G6gUKygyvSNJz
By replacing the now() function for today() function the CoinmarketCapHTML tab is working, but the script also need to be fixed.
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 !
When I go to the demo, nothing works. Can someone resurrect this, or provide suggestions for a replacement?
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.
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?
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?
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..
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?
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
Step by step guide please.
Seems simple enough, but it is not running for some reason.
please read the github help
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?
Nice job. Very clever! 
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?
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
RESERVEDEDEDED
heheh I'm pretty new to the altcoin section and I'm not sure what RESERVED means.
RESERVEDEDEDED
hehe still trying but still not workin, can't put the function getLineOf(A3) into a "string" 
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?
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
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?
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?
Jump to: