Author

Topic: Is it possible to grab price data from cmc or any exchanges to a G. SPREADSHEET (Read 144 times)

hero member
Activity: 1484
Merit: 595
Tweak the instructions present here to fit your purposes:
https://medium.com/@CarpeCrypto/apis-google-sheets-picking-out-microcaps-made-easy-c1e847371af2
It's for Google Sheets, not Microsoft Excel.

Thanks for the link... I will check it.
sr. member
Activity: 322
Merit: 363
39twH4PSYgDSzU7sLnRoDfthR6gWYrrPoD
Tweak the instructions present here to fit your purposes:
https://medium.com/@CarpeCrypto/apis-google-sheets-picking-out-microcaps-made-easy-c1e847371af2
It's for Google Sheets, not Microsoft Excel.
hero member
Activity: 1484
Merit: 595
Thanks Bob for your prompt reply.

I checked both of your given links and it's something like rocket science for me, I can't do it!
I thought it will be something very easy and I can do it by myself but it's not. I'll get it done later by someone or by you if you want to do then.
legendary
Activity: 1624
Merit: 2481
Recently I made a portfolio and I'm wondering now if it is possible to grab current price of a certain coin/token from cmc or any exchange, so that the spreadsheet updates automatically.

This is indeed possible.
You can retreive the data thorugh an API (e.g. from CMC [1]).
You will be able to display the current price via the UrlFetchApp function [2]


[1] https://coinmarketcap.com/api/
[2] https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app
hero member
Activity: 1484
Merit: 595
I hope this is the right section to post this.

Recently I made a portfolio and I'm wondering now if it is possible to grab current price of a certain coin/token from cmc or any exchange, so that the spreadsheet updates automatically.

It may sound silly but I'm not a tech guy... so asked it here to learn about it.
Jump to: