Hello, today i wanted to make a little tool to help calculate the value of hive-engine accounts i mean hive-engine ect already make it well but well i don't really know why i do it that way, let's say it doesn't relate to the hive-engine noodes and can allow you to calculate easier with outside of hive wallet. Simply entre the number of token holded and it will calucalte by it self the total value of all the wallets.
I'm not a pro but i achieved to get the BTC/ETH/SOL value updated once an hour with a google fin function
=GOOGLEFINANCE(“ETHUSD”)
The tutorial i used sayed me to use this function ;
=GOOGLEFINANCE(“CURRENCY:LTCUSD”)
but this ain't working on the bellow of the image you can see another different way i tried to calculate the value but the code of coinmarket cap just don't work the same way as before so i cooked.
If you have any idea how i could import the prices of these crypto on my google sheet it would be lovely, maybe i will make it usable by anyone who want to use it if someone want to use it. Once it's fully working.