Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Best website to keep track of your cryptos
#31
Google, Apple, Facebook, Microsoft they are all the same!

Then use Zoho or similar https://www.zoho.eu/docs/office-suite.html#sheet
Cardano is the most promising 3 gen. crypto right now.


Reply
#32
For excel user, I did some research and found some interesting methods.
You can try with API from different websites that give crypto data.
This is for using the api from coinmarket:

https://api.coinmarketcap.com/v1/ticker/ this gives the whole bunch of cryptos
https://api.coinmarketcap.com/v1/ticker/ethereum/ for a specific ticker in this case ethereum
https://api.coinmarketcap.com/v1/ticker/...onvert=EUR to vonvert in this case to Euro

For more info go to the official documentation at https://coinmarketcap.com/api/

Getting Data Into Excel

To access the API from Excel, go to the Data tab and click the "Get Data" option. Go down to "From Other Sources" and over to "From Web".
[Image: image.png]
I suggest we are going to want to import data one coin at a time so that the relative cell index doesn't change when the coin rank based on market cap changes. There are other, more complicated, ways around this, but this is an easy method to use. Let's get some data for Ethereum. If you want a certain fiat conversion, you need to use one of the ticker URLs that had /?convert=EUR at the end:
[Image: image.png]
One of the things you would like to do is rename the Query.
[Image: image.png]
Now we need to hit the "To Table" convert option:
[Image: image.png]
Leaving these options at their defaults is good.
[Image: image.png]
I highly recommend renaming the entry to the name of the coin, underlined in red. Then we need to click the button with two outward arrows, squared in blue:
[Image: image.png]
Here we can check off which of the stats we actually want in our sheet. I like to create a separate page in my sheets file where I put tickers for all the coins I'm tracking, so import everything here since it's not going to get in the way.
[Image: image.png]
Now just hit "Close & Load" and your live data query will be put into a new sheet.
[Image: image.png]

This post is to large, therefor see next post to continue the rest of this small tutorial.

The rest of previous post:

From here, I go to the Design Tab and select a more aesthetically pleasing style.
[Image: image.png]
Once you're done moving your data where you want it and styling it out, we need to click in the query field and hit ctrl-a to select the entire thing. On the Design Tab, select the Properties option.
[Image: image.png]
Click the "Query Properties" button
[Image: image.png]
Here you can check off "Refresh every" and "Refresh data when opening the file" options. The fastest you can refresh your data is every 1 minute.
[Image: image.png]
Now hit OK a couple times and you're all set!
Just repeat this process for each coin you want to track, I know - it can take a while, but then they sky is the limit for what kind of analytics you create to help you keep your portfolio going.
What is this thing that builds our dreams, yet slips away from us?

Reply
#33
wow..thanks for effort Hugues. I may give it a try..just for fun of doing it.
Reply
#34
(2017-12-16, 03:25 PM)cta102 Wrote: wow..thanks for effort Hugues. I may give it a try..just for fun of doing it.

More than welcom CTA.

Here to help!
What is this thing that builds our dreams, yet slips away from us?

Reply
#35
What version Excel are you using?..I have old one 2007 and it does not look at all the same. I will update to the one you are using. Thanks
Reply
#36
(2017-12-16, 03:40 PM)cta102 Wrote: What version Excel are you using?..I have old one 2007 and it does not look at all the same. I will update to the one you are using. Thanks

I don't have excel. Otherwise I would have made you a turnkey template.
Sorry.
What is this thing that builds our dreams, yet slips away from us?

Reply
#37
That's the api I use for my app.

For Google sheets you can add a json extension and use the api .

Works fine.
Cardano is the most promising 3 gen. crypto right now.


Reply
#38
Great description Hugues
Cardano is the most promising 3 gen. crypto right now.


Reply
#39
(2017-12-16, 04:04 PM)Carsten Wrote: Great description Hugues

Well it costed me quite some time to gather all this information.
But that's me... I want to help all of you.

(2017-12-16, 04:03 PM)Carsten Wrote: That's the api I use for my app.

For Google sheets you can add a json extension and use the api .

Works fine.

I still ue your app several times a day.
I realy like it.
A few small adjustments to make but it is doing what it is supposed to do.

(2017-12-16, 03:40 PM)cta102 Wrote: What version Excel are you using?..I have old one 2007 and it does not look at all the same. I will update to the one you are using. Thanks

I will have a look if I can get hands on a pc with excel installed.
If I find one (perhaps my wifes pc), I will make you the sheet.
This is not a promisse.
I'll see what I can do.
What is this thing that builds our dreams, yet slips away from us?

Reply
#40
It's well explain here:
https://steemit.com/cryptocurrency/@toms...-and-stats
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)