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.
———————————————————————————————————-
My socials
Twitter: https://twitter.com/theheadstartup​…
Instagram: https://www.instagram.com/theheadstar​……
___________________________________________________________________
Educational content: