I've spent about 100 hours trying to figure out how to do this and I finally admit defeat.
I've tried the CMC API, Coingecko API, IMPORTXML, about 50 other things that chatgpt has instructed me to do and nothing I do works. GOOGLEFINANCE is useless because it only gives you 4 cryptos. Even just copy pasting everything from chatgpt straight into my sheet 100 different ways simply doesn't work. I get an error or #VALUE or something and I just can't understand how this can possibly be so complicated. Like just give me the Solana price in a Google Sheets cell! Am I crazy? I don't consider myself a stupid person, but it seems maybe I might be since this supposedly simple task is taking me longer to accomplish than my university degree.
The only method that does work is using a Google Sheets extension that I have to pay for (which I don't mind at all) but just in the spirit of finishing what I started can someone please show me how this can be done.
[link] [comments]

You can get bonuses upto $100 FREE BONUS when you:
π° Install these recommended apps:
π² SocialGood - 100% Crypto Back on Everyday Shopping
π² xPortal - The DeFi For The Next Billion
π² CryptoTab Browser - Lightweight, fast, and ready to mine!
π° Register on these recommended exchanges:
π‘ Binanceπ‘ Bitfinexπ‘ Bitmartπ‘ Bittrexπ‘ Bitget
π‘ CoinExπ‘ Crypto.comπ‘ Gate.ioπ‘ Huobiπ‘ Kucoin.
Comments