Sheetji

Sheetji beautifies spreadsheets & puts you on track!
See an example crypto portfolio.

Progress Bar

0.33

Progress Circle

0.895

Open Emoji

Google Sheets Crypto Price Functions

function priceapi(crypto_id){
                var full_url = 'https://sheetji.com/api/crypto/price/'+ crypto_id;
                var response = UrlFetchApp.fetch(full_url);
                var data = JSON.parse(response.getContentText());
                return data['price'].replace('$','');
              }

              function price_history(crypto_id, date){
                var full_url = 'https://sheetji.com/api/crypto/history/'+ crypto_id +'/'+ date;
                var response = UrlFetchApp.fetch(full_url);
                var data = JSON.parse(response.getContentText());
                return data['price'].replace('$','');
              }
Crypto_id from Coingecko, example bitcoin. Date format MM-DD-YYYY.