CoinMarketCap is an online source of crypto market data, such as coin prices (current and historical), exchange information and lots more. I'm sure many of you understand that writing technical directions, such as this post, is much easier said than done lol.In this guide, we'll look at how to import cryptocurrency prices from the CoinMarketCap API to Airtable. If this post is too hard to follow, let me know and I will try and make a screen capture of the whole process. I will do my best to help everyone as much as I can, but I have finals next week so please bare with me. If you need help, please feel free to message me on Reddit If you are still worried about the contents, you can simply open it with "TextEdit.app" and it will show you the API link to. When you download them, do not change the extension. Please Note: The "iqy." files in the Google Drive are not executable.
*There may already be three files in there that are included with Office 2016 for Mac by defaultĨ.)Open a new Excel workbook and click "Data" on the very top (Not the "Data" in the ribbon!!ĩ.)Hover over "Get External Data" and select "Run Saved Query."ġ0.)From here, you should now see the coin ".iqy" files that you pasted earlierġ1.)Select one of the ".iqy" files and then press "Get Data"ġ3.)Repeat steps 9-12 for each coin you wish to addĬlick HERE for a screen capture from my Mac showing you what it looks like. *For my case, the folder is named "UBF8T346G9.Office"Ħ.)In the "User Content" folder, select the "Queries" folderħ.)Paste the ".iqy" files (Located HERE) inside the "Queries" folder Replace " UserNameHERE " with your usernameĤ.)Find the folder with ".Office" extension Users/UserNameHERE/Library/Group Containers/ There are terms in it that you may not understand until you follow the steps below. If you want to watch the video first, then go right ahead.
The other, with a video demonstrating how the portfolio works after setting it up. One, with the required external files needed for API requests from. I basically did a trial and error for a few days, and I finally got it to work! Included in this post are 2 separate links that take you to a public google drive (no sign in required): I really wanted to be able to see a breakdown per asset I had, as well as see how much it is all worth. Doing my research on the web, I was not able to find a definitive tutorial on how to get external data (in my case, crypto prices) in to excel so that I could create a portfolio of all my coins. Hey everyone! This is my first post so I am hoping it goes well.įor anyone with a Office 2016 for Mac, you may or may not already know how to do this.
0 kommentar(er)
