![]() If you know a way please leave a comment. I can't seem to figure out a way for it to have the same format - it looks like raw data but totally comprehensible. Use CoinMarketCap to connect your excel file to live Bitcoin and ALT coin prices. Click - Data - Get External Data - Run Web Query - (Pick the API file you saved in the first step) - click ok.Save the API link as plain text - make sure it has the. ![]() The steps should be similar for all platforms and Excel versions but this is specifically for a Mac Excel 2016. ![]() Although, for this you would need an API link from the website that you're trying to pull the data from. This could be helpful with websites such as where you can pull all the coin data from the website and have it update automatically in your file if you're using that data for statistics, algorithms, and etc.Īfter doing some research I figured out a way to do so in Excel. I thought I could do the same with Excel but unfortunately that did not work. For example, CryptoCompare and CoinMarketCaps APIs. One day one of my co-workers showed me a formula where you could pull data from different websites, that contained lists and tables and have it update it automatically in Google Sheets. One notable difference between Nomics API and competition is that the Nomics product has no rate limits. I have been doing quite a bit of data entry work at my internship using excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |