Real-time Crypto Prices on Google Sheets (explained simply)

€100 Degiro Credit: https://bit.ly/3M0tf19 In this video I go through a tutorial on how to create a real time crypto price feed from coinmarketcap.com to google sheets. Google sheets is a great resource but their google finance formulas do not cover cryptocurrencies. Personally I like to analyse my entire portfolio in one place therefore it was annoying to have to constantly add in the prices of the crypto I hold manually. This solution is a free way to get around this problem using a formula to import the prices and then a quick macro to refresh the price that has been imported. Formulas: =IMPORTXML(B5,"//div[@class='priceValue ']") C3*GoogleFinance("CURRENCY:USDEUR") This video is for entertainment purposes only and not financial advice, if you are investing please seek advice from a professional. If you have any questions on the video please drop a comment and I will get back to you. Thank you for watching, if you would like to see further content like this please like the video and subscribe to my channel.