Keep track of Secret price in Excel and Google Sheets

If you use spreadsheets (Excel or Google Sheets) to manage your crypto portfolio, do check out Finsheet ( finsheet. io ), a website my friends and I started recently. To get latest quote of Secret, use this one simple function:

=FS_Latest(“HITBTC:SCRTUSDT”)

If you are a trader that needs intra-day data to do technical analysis or backtesting, this function will give you 1-minute price of Secret from the beginning of today (04/25/2022) until now:

=FS_CryptoCandles(“HITBTC:SCRTUSDT”, “1”, “04/25/2022”)

The website is completely free right now since we just launched. Really appreciate if you guys can check it out and let me know any feedback you may have. Thanks a lot.

2 Likes

Cool. I usually use =REGEXEXTRACT(ARRAYFORMULA(JOIN(CHAR(10),SPLIT(IMPORTDATA("https://api.coingecko.com/api/v3/simple/price?ids=secret&vs_currencies=USD")&CHAR(10),CHAR(10)))),"\d+\.\d+")

2 Likes