Is it possible to grab price data from cmc or any exchanges to a G. SPREADSHEET

[akamit]

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.

[bob123]

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

[akamit]

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.

[Xynerise]

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.

[akamit]

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.