Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Best website to keep track of your cryptos
#21
CTA Google, Facebook, Apple, NSA, PET, KGB, MI5, CIA and Microsoft already knows your personal data. What do you like to buy. What is your prefered woman. What is your prefered car. Where do you travel. etc...
Cardano is the most promising 3 gen. crypto right now.


Reply
#22
Yes... Big Brother is becoming a reality!
Reply
#23
(2017-12-13, 02:26 PM)cta102 Wrote: I tried it on Google Sheets that Hugues sent me and it does not refresh.

Hugues, I looked up LibreOfiice and it is free download, so why not make my blank sheet in LibreOfiice and I will use it that way

Thanks

I also would prefer to keep it away from Google. They know too much about us already.

LibreOffice would be on my PC and not in 'cloud'

Yes libreoffice is free.
I will make you a blank sheet in libreoffice.
Mine is perfectly running. Just give me a few days. I have to make some adjustments and change the refresh time to 5 minutes instead of 60 sec. If coinmarketcao does it each 5 minutes it has no use to do a refresh at 1 min.
What is this thing that builds our dreams, yet slips away from us?

Reply
#24
Hugues, you are the professor on this site.

Thanks, Merci, Gracias, Danke
Reply
#25
(2017-12-14, 03:16 AM)cta102 Wrote: Hugues, you are the professor on this site.

Thanks, Merci, Gracias, Danke
You forgot Danish: tak Big Grin
What is this thing that builds our dreams, yet slips away from us?

Reply
#26
Yes Hugues.

Tak!
Cardano is the most promising 3 gen. crypto right now.


Reply
#27
Sorry guys, my Danish is non existent
Reply
#28
Hugues sent me the spreadsheet with the list of coins that Carsten and I asked for (maybe 10)

It works perfectly in LibreOffice, which is a free download.

So if interested..download LibreOffice and he or I can send you the template to use.

It has current price, %change in 24 hours, # coins outstanding, market cap, and 24 hours sales...all updated automatically when you open the spreadsheet.

Thanks Hugues..nice piece of computer wizardry.

BTW .. he will add C20 when it starts trading
Reply
#29
Super great CTA.

In the meantime I tried to refresh Google Sheets. I found out that if you add a row before the first row it updates. I therefore created a script that insert a row and remove it again. It forces an update. Not super elegant but works for now. The advantage of Google sheets is that's is online and can run on any device.

Here is the script for inspiration. The last one with the date is just to see something is happening. You may want to format the date cell to whatever format you like.:

function onOpen() {
createTimeDrivenTriggers();
}

function createTimeDrivenTriggers() {
// Trigger every minute
ScriptApp.newTrigger('refresh')
.timeBased()
.everyMinutes(1)
.create();
}

function refresh() {
SpreadsheetApp.getActiveSheet().insertRowBefore(1);
SpreadsheetApp.getActiveSheet().deleteRow(1);
SpreadsheetApp.getActiveSheet().getRange('G1').setValue(new Date());
}
Cardano is the most promising 3 gen. crypto right now.


Reply
#30
And the disadvantage is that it is Google
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)