Steps

1. Obtaining a Coinmarketcap API Key
2. https://pro.coinmarketcap.com/v
3. Connecting Excel to the Coinmarketcap API
4. Ribbon > "Data" > "From Other Sources" > "From Web"
5. Select Advanced
6. Enter the following URL
7. https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest
8. Fill "HTTP request header parameters"
9. X-CMC_PRO_API_KEY _YOUR_PRO_CMC_KEY_
10. Change the request with what you want
11. For exemple, if you want to get BTC, ETH, FLIXX, EGLD, CRO, KCS, CHSB, PMON, POTS, SCV lastest prices and convert them in EUR
12. = Json.Document(Web.Contents("https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=BTC,ETH,FLIXX,EGLD,CRO,KCS,CHSB,PMON,POTS,SCV&convert=EUR",[Headers=[#"X-CMC_PRO_API_KEY"="_YOUR_PRO_CMC_KEY_"]]))
13. Click on time on "data"
14. Next expand the records by clicking on the column header, and select the columns you want to import, so only "quota" and deselect "Use original column name as prefix"
15. Do the same to be able to select "price"
16. Ribbon > "Close and Load to load the data as a table in Excel"
17. Ribbon > Connection Properties
18. Uncheck "Enable background refresh"
19. Uncheck "Refresh every"
20. Check "Refresh data when opening the file"
21. Uncheck "Remove data from the external data range before saving the workbook"
22. Check "Refresh this connection on Refresh All"
23. You must select the cells that you want to freeze, then copy and paste them in special mode 123 (number) which will remove the link with the values which are refreshed, while leaving the values
24. If necessary, remember to duplicate the cells before, so as not to lose the formulas