r/cryptosheets • • Jan 26 '18

Help Request How can I render numbers from the rates sheet using commas instead of periods?

0 Upvotes

Right now the rates are getting pulled in looking like so 0.00254607, where I would need a comma instead of the period so it's like 0,00254607.

I'm pretty basic with sheets, but what's the easiest way to do this? I've selected the entire column returning price and tried to change the text format to financial, but it looks like the script it overwriting the ability to do so.


r/cryptosheets • • May 09 '21

Help Request How do I get a simple price prediction?

1 Upvotes

So lets say I just want to get a simple prediction from any source of what bitcoin will be at the end of 2021 and at the end of 2025. This should be possible but cryptosheets is so advanced and the templates really does not make sense to me and I have no idea where to start.

I just want 3 columns like:

Currency - 2021 - 2025
BTC - 50k - 100k

Help please!


r/cryptosheets • • Oct 21 '20

VERY IMPRESSIVE!

1 Upvotes

I started using Cryptosheets today. Very simple to use. Great customer support. I got instant answer from the live chat, and they were really, really patient and helpful!


r/cryptosheets • • May 13 '21

shitcoineasypumprelease

0 Upvotes

HI GUYSSSSS if you can’t find mew good cryptos in this channel you will be able find them and you will also be able do pumps. Here’s the link https://t.me/ShitcoinEasypumpRelease


r/cryptosheets • • Jan 05 '18

Easy guide (I hope) to create a Portfolio Tracker

5 Upvotes

Ok, so after "the geeks" released Version 1.0 of the script, I though it was time to create a guide of how to create a portfolio Tracker.

I was thinking about adding it here as a full post as well, but as I know this is just a "beta" version of the guide, I added it to the github repository as a Wiki page (not sure if we will leave it there or moved somewhere else, but will edit this post if that happens)

Easy guide (I hope) to create a Portfolio Tracker

Please, as always, feel free to ask questions and point out mistakes/errors so we can correct them


r/cryptosheets • • Dec 12 '24

Cryptosheets down for days now?

7 Upvotes

The dataset is too large or took too long to return. Upgrade your plan to make larger requests.

What am I even paying for at this stage!? This has been a relatively common occurrence for the last few months, but haven't been able to use the add-in to query prices for two full days now.

Is this an isolated issue on my side or is it widespread?


r/cryptosheets • • Jan 11 '18

Timeout/Unexpected Errors Line 204

1 Upvotes

Hi everyone I'm using cad as my target currency and I keep getting emails that the sheet is timing out.

Timeout: https://api.coinmarketcap.com/v1/ticker/?limit=0&convert=cad (line 204, file "Code")

Any ideas on what I'm doing wrong?


r/cryptosheets • • Jan 04 '18

Fetching rates from specific exchanges

3 Upvotes

First of all, thanks so much for your time (creator + the ones that is helping), this saves a lot of time. So again, thank you. I know that you guys have a lot of messages and people asking stuff, so I will patiently wait for an answer to my feature request.

I have been creating my own sheet since a couple of days when I found this. Thing is, I use multiple exchanges for different alts etc based on the best rates. For instance you can sell ETH at a higher rate on cex.io compared to bitstamp.

In my sheet I would like the possibility of fetching rates from a certain exchange for a specific pairing, like ICX-BTC from binance, or XLM-ETH from hitbtc, and so on.

I know these rates are available through coinmarketcap, I just dont know how to wizardify your code to bend it to my needs.

Meanwhile I will manually add rates, since I need them to display the current value from specific exchanges.


r/cryptosheets • • Jan 11 '18

cryptoID Blockchain Explorer - More Coin API's

1 Upvotes

Found cryptoID Explorer while I was searching for one that would do LTC. Here is how I did LTC (essentially copied VTC) https://chainz.cryptoid.info/

cryptoID API Info: https://chainz.cryptoid.info/api.dws

Under the Wallet Balance Configuration

// ===== LTC wallet balances =======
// Add more as needed with different variable names
// Change the value in getRange() to match the cell in spreadsheet
// Change the value in setValue() to match the variable above
// =================================

// LTC Wallet Comment
var ltcWallet = getLtcBalance("LTC Wallet Here";
ssWallets.getRange('B8').setValue(ltcWallet);

Under the other functions near bottom

function getLtcBalance(ltcAddress) {

var url = 'https://chainz.cryptoid.info/ltc/api.dws?q=getbalance&a='+ltcAddress;
var response = UrlFetchApp.fetch(url, {'muteHttpExceptions': true});
var balance = response.getContentText();
//Pause to not trigger API limit for multiple wallets
Utilities.sleep(300);

return balance;
}

r/cryptosheets • • Jan 05 '18

script running but wrong values all over

3 Upvotes

Hi

I got the script running in no time with the great tutorial on github, but all the coins are showing wrong BTC/USD values.

USD values are correct for Bitcoin and some other majors, but all altcoins are valued 3 digit USD prices. Also all BTC prices are way off, like no altcoin below 1BTC, some even valued at 3 digit BTC price :D

EDIT: SOLVED - had to change google sheets to english because in germany we switched , and . in math


r/cryptosheets • • Jan 06 '18

[Suggestion/Request] Add ETH as base currency

4 Upvotes

Since I am trading a lot of ETH currency pairs (on etherdelta mainly) it is a pain the ass to convert all those transactions.

Is it possible to add ETH as main currency pair? This way one can calculate gains against ETH and not only BTC or USD.


r/cryptosheets • • Jan 12 '18

OpenWrt/Linux script

3 Upvotes

I've posted this in cryptocurrency i've not seen this thread, enjoy it ;) Hope you like it, i know its still not the best section, but i hope it helps you guys. Hey guys, for all linux users here's an example of my bin/sh script that i use in my openwrt(along with ssmtp and cron) router to send me a daily mail with the portfolio. I call this file "current" and is located in /etc/config/mailing/ Enjoy it.

#!/bin/sh
round()
{
   echo $(printf %.$2f $(echo "scale=$2;(((10^$2)*$1)+0.5)/(10^$2)" | bc))
};

#Coins amount/investment
valueintense=1500005
invest=1500
#intense, make a section like intense and a value for it for every other coin and simply add the echos in the end
intense=$(curl -k -s --retry 0 -B --retry-max-time 0 https://api.coinmarketcap.com/v1/ticker/intensecoin/?convert=EUR)
intenseeur=$(echo "$intense" | sed -n 's/.*"price_eur": "\(.*\)".*/\1/p')
intensebtc=$(echo "$intense" | sed -n 's/.*"price_btc": "\(.*\)".*/\1/p')
intense24=$(echo "$intense" | sed -n 's/.*"percent_change_24h": "\(.*\)".*/\1/p')
intense7d=$(echo "$intense" | sed -n 's/.*"percent_change_7d": "\(.*\)".*/\1/p')
var11=$(echo "$valueintense * $intenseeur" | bc)
var111=$(echo "$valueintense * $intensebtc" | bc)
#end intense

DATE=`date '+%Y-%m-%d %HH%M'`
echo "To: [email protected]"
echo "From: [email protected]"
echo "Subject: Daily Report "$DATE
echo ""
echo "FYI "$DATE":"
echo $valueintense" INTENSECOIN = "$(round $var11 2)"€ -> "$(round $var111 5)"BTC"
echo " "
echo "INTENSECOIN 24H: "$intense24"% | 7D: "$intense7d"%"
echo " "

num=$(echo "$var11" | bc)
#$var9+$var3+$var4+$var6+$var7+$var8 etc, add everything in num
btc=$(echo "$var111" | bc)
#$var91+$var31+$var41+$var61+$var71+$var81 add every bitcoin value in $btc
num2=$(echo "$num-$invest" | bc)
btc1=$(curl -k -s --retry 0 -B --retry-max-time 0 https://api.coinmarketcap.com/v1/ticker/bitcoin/?convert=EUR | sed -n 's/.*"price_eur": "\(.*\)".*/\1/p')
btc2=$(echo "$btc * $btc1" | bc)
num3=$(echo "$btc2-$invest" | bc)
echo "Total investment = "$invest"€"
echo "Total = "$(round $num 2)"€"
echo "Difference € = "$(round $num2 2)"€"
echo "BTC = "$(round $btc 5)"BTC -> "$(round $btc2 2)"€"
echo "Difference BTC = "$(round $num3 2)"€"

For the call script, located at /bin (i call this file mail, then i call it using cron, chmod +x of course):

#!/bin/sh
sh /etc/config/mailing/current > /etc/config/mailing/mail.txt
ssmtp [email protected] < /etc/config/mailing/mail.txt
rm /etc/config/mailing/mail.txt

Now if you're a soft heart, be carefully about sending a daily mail, maybe twice or three times a week, something like(cron): 0 19 * * 1,3,5 mail, also, this script could be transformed in a for function with an array, which i did not found the time to do, bah i did this script when i had 1 coin, now i got 12 and already added them there, so too lazy ahahaha


r/cryptosheets • • Jan 11 '18

Help Request CoinMarketCap API response is slow, halting refresh

1 Upvotes

In the last few days the CoinMarketCap API response got very slow, the API refresh halting with error when the script try to parse every coin.

I modified the code slightly, I moved myCoins variable out of getData() function and I parsing the coins one by one:

function getCoins() {
    var arr = [];
    
    for (var i = 0; i < myCoins.length; i++) {
        var url = 'https://api.coinmarketcap.com/v1/ticker/'+myCoins[i]+'/?convert='+targetCurrency;
        var response = UrlFetchApp.fetch(url, {'muteHttpExceptions': true});
        var json = response.getContentText();
        var data = JSON.parse(json);
        
        arr.push(data[0]);
    }

    return arr;
}

However this is also not starting many times, even if I set 5 minute interval between requests. I think it's not finishing the execution within 5 minutes and the next execution re-writing the previous one.

Is there a way to overcome the crappy slow CoinMarketCap API's limitations?


r/cryptosheets • • Jan 12 '18

Help Request Coinstats

1 Upvotes

Not sure if this is the best place for this, but since everyone here is probably as OCD about portfolio tracking as I am, perhaps you can help.

I want to use Coinstats (or Delta, if you vs convince me), but I want to know if I can sync it or export the data. I want to make sure if I lose my phone that I don't lose everything.

Thanks!


r/cryptosheets • • Jan 15 '18

Wallets sheet not converting to USD

1 Upvotes

I followed the CryptoSheets v1.0 guide and I only entered a BitCoin address for now. Screenshot of the code:

https://imgur.com/zCNSVp2

On the wallets page, it is only showing my BitCoin balance in bitcoin amount, not USD. My Wallets sheet looks like this:

https://imgur.com/XJTCwp6

Did I do something wrong or is the Wallets page supposed to look like this?

My Rates page looks correct, screenshot:

https://imgur.com/N37O84P

I did a little google search how to multiply two cells from different sheets, and I used the MULTIPLY operator so now my Wallets page looks like this:

https://imgur.com/OdYeKo9

Isn't this script(CryptoSheets v1.0) supposed to convert my wallet balance to USD after entering my wallet address?


r/cryptosheets • • Jan 08 '18

TypeError: Cannot read property "id" from undefined. (line 107, file "Code")

1 Upvotes

Followed the instructions as posted in github. Triggers were set as per instructuins but When running (step 7) getData, I am getting the following error: TypeError: Cannot read property "id" from undefined. (line 107, file "Code") Help? Did I miss a step?


r/cryptosheets • • Jan 04 '18

EUR value not reading correct

3 Upvotes

As already told I did some light code organisation so I can have standard USD and EUR since I mainly use EUR. In order to do that I just copy pasted this.

ssRates.getRange('G'+(c).toString()).setValue(myCoinsObj[myCoins[i]]['price_eur']);

I belive this is where it does the web readings? But the output looks like this (taking BTC as example). Price USD 15370.7 Price BTC 1.0 Price EUR 127.299.368.865

Having the issue with all the coin value readings in EUR. This problem consists with dircetly having it coded like this: ssRates.getRange('G'+(c).toString()).setValue(myCoinsObj[myCoins[i]]['price_eur']);

As well as this:

var targetCurrency = 'eur'

ssRates.getRange('Q'+(c).toString()).setValue(myCoinsObj[myCoins[i]]['price_' + targetCurrency]);

Thanks for your time! :)


r/cryptosheets • • Jan 10 '18

Currency Addition

2 Upvotes

Hi There - first off, Great tool!!! Thank you very much for sharing.

Has anyone thought about the addition of auto currency pulls - specifically around trade dates? The reason I ask this, is being in Australia, the CGT will be calculated from purchased (or sold) crypto, converted from ETH or BTC to USD, and then converted to AUD


r/cryptosheets • • Jan 24 '18

Portfolio in Google sheets using Telegram and IFTTT

3 Upvotes

I made a simple portfolio that works sending a message to the ifttt bot on telegram and returning a list with the coins and the current value.

So, I am looking for a good google sheet template to improve the look of my portfolio. Does anyone have a good one to use it?

How mine works:

  • I send a message with the trigger word to the bot: "ltc 1 150 coinbase"

  • It triggers an applet that create a row with the text ""ltc 1 150 coinbase January 10, 2018 at 11:00PM" (the date field is automatic). I also have a second sheet with a month report and a Total per coin and Total cells.

  • Any change to Total per coin and Total cells trigers another applet that check those specific cells and send it back through telegram. Because IFTTT only checks cells, I made a hidden cell with the concatenated list of coins and values.

So, hope you get the idea.


r/cryptosheets • • Jan 18 '18

Script stops getting values after coin 41

1 Upvotes

Edit: SOLVED CMC changed the ID of my 42nd coin in the list

Since yesterday the script stops after pulling data from the 41st coin in my list. did not change anything. what can I do?


r/cryptosheets • • Jan 26 '18

Suggestion Possible to add Price ETH to cryptosheets?

5 Upvotes

I've got a couple ICOs I'd like to track, but cryptosheets is only pulling in Price BTC. Any way to add ETH as well?


r/cryptosheets • • Jan 23 '18

Importing Total Market Cap

2 Upvotes

Hello! I'm having trouble importing total market cap. If I try to import global as one of my coins, it crashes the script.

Any help would be appreciated!

Thanks!


r/cryptosheets • • Jan 23 '18

Updating daily chart

1 Upvotes

Is their anyway that I can create a self running chart on google sheets that only graphs the last 10 entries but the last 10 entries get updated daily. I am trying to make a volatility chart for the last 10 days that automatically updates. Someone please help!


r/cryptosheets • • Jan 20 '18

getData no longer works in gsheets?

3 Upvotes

Hello

I had my sheet running for about two weeks now but last couple of days it stopped getting values from CMC I don't know why. I am getting this error

TypeError: Cannot read property "price_usd" from undefined. (line 120, file "Code")

What's the issue here? I didn't change anything.


r/cryptosheets • • Jan 19 '18

How to get 24h volume for a pair on Binance specifically with API?

1 Upvotes

Hey guys does anyone know how to grab the API 24H volume data for LTC/ETH for example for specifically, Binance? Would be highly appreciated!