Title: Is it possible to grab price data from cmc or any exchanges to a G. SPREADSHEET Post by: akamit on February 28, 2018, 01:37:37 PM 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. Title: Re: Is it possible to grab price data from cmc or any exchanges to a G. SPREADSHEET Post by: bob123 on February 28, 2018, 02:16:49 PM 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/ (https://coinmarketcap.com/api/) [2] https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app (https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app) Title: Re: Is it possible to grab price data from cmc or any exchanges to a G. SPREADSHEET Post by: akamit on February 28, 2018, 05:36:32 PM 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. Title: Re: Is it possible to grab price data from cmc or any exchanges to a G. SPREADSHEET Post by: Xynerise on February 28, 2018, 05:52:18 PM 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. Title: Re: Is it possible to grab price data from cmc or any exchanges to a G. SPREADSHEET Post by: akamit on February 28, 2018, 05:55:13 PM 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. |