Crypto + US Stocks + Gold Tracker
Live portfolio tracker for crypto, US stocks, and gold
9 followers
Live portfolio tracker for crypto, US stocks, and gold
9 followers
A Google Sheet + Apps Script template that pulls live prices for crypto, US stocks, and gold into one place, in USD. Pro tier adds Telegram price alerts and a daily summary. No server, no subscription -- runs in your own Google account.
Would love to see support for custom moving averages or RSI calculations right in the sheet, since raw prices only get you so far when you're trying to spot trends. Could be a simple toggle in the Apps Script menu.
@sabri1384708 Just shipped this one — RSI and moving averages are now built in, no toggle needed, just new formulas: =CRYPTORSI("BTC"), =CRYPTOSMA("BTC", 20), =STOCKRSI("AAPL"), =STOCKSMA("AAPL", 50), =GOLDRSI(), =GOLDSMA(20). Same fallback sources as the price formulas. Thanks for the push, this made the product better.
Runs straight from my own Google account which I love, and the gold and crypto prices actually refresh without me poking anything. Would be nice to add more tickers beyond the default set but for a simple sheet it does exactly what it says.
@astambuse84875 Any standard US ticker already works, actually — STOCKPRICE() isn't a preset list either, it just pulls whatever ticker you give it via Stooq/Yahoo Finance, e.g. =STOCKPRICE("TSLA") or =STOCKPRICE("NVDA"). Also just added =STOCKRSI() and =STOCKSMA() for trend/momentum on any ticker. Thanks for trying it out!
Liked that it just lives in my own Google account, no extra login or subscription hassle. The Google Finance formulas are a nice touch, though I'd love to see more altcoins supported out of the box.
@ebubekirna9spz Good news — more altcoins already work today, no code changes needed! CRYPTOPRICE() isn't limited to a preset list, it pulls straight from Gate.io/KuCoin for any ticker they list, e.g. =CRYPTOPRICE("DOGE") or =CRYPTOPRICE("XRP"). Also just shipped =CRYPTORSI() and =CRYPTOSMA() for momentum/trend on any of those tickers too. Appreciate the feedback!
honestly love that everything runs straight from your own google account, no shady servers or subscriptions sitting in the background. the sheet layout looks clean and pulling crypto, stocks, and gold all in usd in one place is kind of brilliant for keeping things simple.
@asiyeenisoczbn Thank you, really glad it's landing well! If you ever want more than the price feed, I just added RSI and moving-average formulas too — happy to hear if there's anything else that would make it more useful for you.