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

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:
https://investingintheweb.com/blog/investment-protection/

Видео Real-time Crypto Prices on Google Sheets (explained simply) канала The Head Startup