You may need to re-authorize your code to access your Google Sheet. Then select the option to attach a script.Back in your spreadsheet, now click on the three dots that show up in the upper right hand corner of the image whenever you mouse over it:.Whenever this function is executed, range A1 of the active sheet gets set to a random value with the Math.random() function. Type the following URL into your browser:įunction get_curr_coinmarketcap_price ( crypto_id, unused_param ) It will get you the exact same price you see on their website and should represent an average of the price across the exchanges they monitor.įirst, lets see how the API functions by getting ALL the latest price info. The CoinMarketCap API is actually really easy to use and they have a public API that doesn’t require authentication. And who knows maybe it’ll spark an interest in programming! Let's get started We are going to write a custom google sheets JavaScript function that will get us the latest prices for cryptocurrencies by using the Coin Market Cap API.Įven if you have no experience with programming this tutorial may be realitvely easy for you to follow. Today I’m going to show you something I actually use daily. Or because Google sheets allows you to extend it using a modern programming language, JavaScript, you can add really cool functionality that runs entirely within your Browser. You can have backend scripts running on a Linux server that connect to your sheet and dump the data you want into your sheet. There are so many cool use cases for Google Sheets because it has a robust front-end and back-end API. Learn to code, move those models out of Excel, and automate your data munging/computation so you can free your mind up for actual analysis.Įnough Ranting though and back to why Google Sheets is great! As a former financial analyst and reformed Excel Guru, I can say without a doubt but if you’re an analyst who is using Excel for anything more than displaying data, or basic math then you are behind the times. I actively try to get people away from Excel. To put it quite simple, Google sheets is amazing! Over the past year I have been getting really big into Cryptocurrencies.īeing a Software Engineer, I have tried to automate wherever possible my cryptocurrency analysis and so I have decided to create a series of blog posts to share some of those tools and also just general knowledge I have learned about the crypto space. Date Sat 27 January 2018 Modified Sat 27 January 2018 Tags cryptocurrencies
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |