r/cryptosheets • • Jan 03 '18

CryptoSheets v1.0

16 Upvotes

https://github.com/saitei/crypto-sheets/releases/tag/v1.0

Thanks to all the people that have helped so far (mentioned in acknowledgements, or check the issue/PR activity). It's been a huge relief with others stepping in to help people out with troubleshooting, as providing support and adding enhancements don't go hand-in-hand.

Create a post to get timely assistance.


Features

  • Instructions with images

  • Auto-populating Rates sheet based on list of currencies

    • Name

    • Symbol

    • Rank

    • Price USD

    • Price BTC

    • 24H Volume USD

    • Market Cap USD

    • Available Supply

    • Total Supply

    • Max Supply

    • % change (1hr, 24hr, 7d)

    • Last Updated

  • Added currency conversion

    • Price <currency>

    • 24 hour volume <currency>

    • Market cap <currency>

  • Added BCH/BTC wallet balances

  • Reduced API calls for rates (i.e. one call)

  • More thorough code comments


There will still be more in the works. The next target is to produce a good template that utilizes this data effectively. The tough part once you have your data sources is always how to make sense of it.

ᕕ( ᐛ )ᕗ


r/cryptosheets • • Aug 26 '25

Help Request Invoices?

Post image
8 Upvotes

Is this email legit?

Apologies but I'm gonna be a boomer about this and ask why is this being sent to us - in all caps - with an attachment if we are supposed to ignore it?

I don't know what you should do but this isn't it.


r/cryptosheets • • Mar 20 '21

My Google Sheets Realtime Crypto Price tracker (update every 1 minute)

8 Upvotes

I have made a personal tracking sheet for crypto price updated every 1 minute

time logged is GMT+7

https://docs.google.com/spreadsheets/d/1rMVsPado1L22DWb6lN4HHtyVMP9U4Mg-wsg0FU2nh8I


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 31 '18

Help Request Binance tracking in google sheet

7 Upvotes

So currently I have been tracking my portfolio on google sheets with https://coinmarketcap.com but Binance doesn’t translate to the same value on https://coinmarketcap.com. Is there anyway to track the prices on Binance?


r/cryptosheets • • Dec 27 '17

Frequently Asked Questions

7 Upvotes

Check out CryptoSheets v1.0-rc1 as it may solve most of your issues
https://www.reddit.com/r/cryptosheets/comments/7nswcl/cryptosheets_v10rc1/


  • I'm getting an error Cannot call method "getRange" of null

Make sure you have a sheet called Rates. This is not referring to the file name.

Look at the bottom of the window for a sheet called Rates. If it isn't there, create one.

  • What do I put in the getRate() function?

I see a lot of people putting the full api ticker URL in the field, but all you need is the value of id from the CoinMarketCap api ticker
This is the field to use

var QSH = getWebRate('qash');
var MOD = getWebRate('modum');
var WAX = getWebRate('wax');
var ARK = getRate('ark');
var BNB = getRate('binance-coin');
var BCH = getRate('bitcoin-cash');
var BTC = getRate('bitcoin');
var NEO = getRate('neo');
var OMG = getRate('omisego');
var REQ = getRate('request-network');
var XRB = getRate('raiblocks');
var WTC = getRate('walton');
var XMR = getRate('monero');

r/cryptosheets • • Feb 19 '18

For anyone who recently started getting the property error recently, it's likely because CoinMarketCap changed "raiblocks" ID to "nano"

6 Upvotes

I was getting an error when trying to run my getData script, and I figured out it's because the CoinMarketCap API now has "raiblocks" listed as "nano" for the ID. Check that if you are getting the same error.


r/cryptosheets • • Jan 03 '18

CryptoSheets v1.0-rc1

6 Upvotes

https://github.com/saitei/crypto-sheets/tree/develop

Thanks to all the people that have helped so far (mentioned in acknowledgements, or check the issue/PR activity). It's been a huge relief with others stepping in to help people out with troubleshooting, as providing support and adding enhancements don't go hand-in-hand.

This still isn't fully tested as I wanted to get these updates out ASAP, so leave any feedback or issues you're experiencing in this thread. Messaging me directly is not a good way to get timely assistance.

If everything is looking good after a day or so, I'll release this as v1.0.


Features

  • Instructions with images

  • Auto-populating Rates sheet based on list of currencies

    • Name

    • Symbol

    • Rank

    • Price USD

    • Price BTC

    • 24H Volume USD

    • Market Cap USD

    • Available Supply

    • Total Supply

    • Max Supply

    • % change (1hr, 24hr, 7d)

    • Last Updated

  • Added currency conversion

    • Price <currency>

    • 24 hour volume <currency>

    • Market cap <currency>

  • Added BCH/BTC wallet balances

  • Reduced API calls for rates (i.e. one call)

  • More thorough code comments


There will still be more in the works. My next target is to produce a good template that utilizes this data effectively. The tough part once you have your data sources is always how to make sense of it.

ᕕ( ᐛ )ᕗ


r/cryptosheets • • Dec 28 '17

Suggestion Improvements for automation

6 Upvotes

I made my own google sheets version and some improvements to the code to make it easier to add new coins. The values in the excel are just fictional, not my actual portfolio.

Ticker, name, market price (btc and usd), change (24h, 7d) are fetched from internet and only the blue columns needs to be entered manually. That is the quantity and buy prices. I mostly compare to btc as that is my main investment. The bitcoin buy price is in USD, all other alts in BTC. The two columns to the right are changes relative to btc.


r/cryptosheets • • May 18 '24

Can't install cryptosheets Addon for GoogleSheets

5 Upvotes

Hi,

I can't install/download the cryptosheets Addon for GoogleSheets. Anyone with the same problem?

I get the following error message (german):

It translates in "Page not found" Data can't be opened at the moment. Check the adress and try again.

Thank you for your help


r/cryptosheets • • Oct 27 '18

Long overdue update on Cryptosheets or how I learned to love the bed

5 Upvotes

Firstly, just wanted to apologize for mostly becoming a ghost after creating this tool. The same goes for NanoTwitch, and its lack of long overdue TLC. <edited for oversharing>. Just wanted people to know I haven't abandoned these projects mentally, but just haven't had the energy necessary to accomplish everything I'd like to with them.

With that out of the way...

There should will be some updates by the end of the month due to Coinmarketcap shutting down their old API. The way things are currently programmed has Cryptosheets pulling down all coin/token information at once (which won't work with their new API). Work needs to be done to migrate the data retrieval method to utilize "pagination", meaning that the script will make many smaller requests instead of one gigantic one. This technically isn't a problem at all, it's just something I've been putting off.

On top of that, Cryptosheets will begin to use Coingecko as its source of data in lieu of Coinmarketcap. To be perfectly honest, I had no objectively good reason to do so, and it has nothing to do with Coinmarketcap (I'll send them some flowers). Back in July '18, someone brought to my attention that Coinmarketcap would be shutting down their old API later in the year, so I created an issue on GitHub to track it. A bit later, one of the co-founders of Coingecko (TM Lee - /u/tmlee) posted in the thread offering their help/services, so I thought "why not? Let's do it." I've never once heard from Coinmarketcap (or know if I'm even on their radar) and just thought it was very nice/human for TM to drop in like that.

Now...back to the future! I honestly have no clue how many people have, or are currently using Cryptosheets (I'm not much into the whole tracking / gathering data on people thing), so please reach out with your opinions (whether good or bad), and please start/continue sharing ideas for what you'd like to get out of this tool (Creating issues on GitHub is best. Anyone can stop by and submit a bug/enhancement request). If you've been using the tool this long and have any development skills (even if you hate javascript as much as I do), then please consider lending those skills not only to me, but to the (errr, I'm guessing somewhere between 23 and 5 million) people that use Cryptosheets. I don't make money off of this, and only continue to [not] do [any work on] it [for months] because there are people that have truly been appreciative.

Here are some things I'd still like to add (or have other people add) to the product:

  • Historical data

  • On the surface it wouldn't be too hard, but taking it the next step to store portfolio data / transactions (that are automatically harvested from exchanges) takes it to another degree of difficulty. For those that aren't aware, Google Sheets and the App Scripts power it have data/usage limitations. I think the data storage would be the biggest hurdle with this and would probably require a mechanism to scrub older data over time to only keep records that directly pertain to a transaction. I'm sure there are even other possibilities I haven't thought of.

  • Streamlining data presentation / User Experience

  • Writing some functions to pull data into a spreadsheet is one thing, but the greatest challenge with any set of data is to derive meaningful/actionable insights from it. Someone on Gitter was just asking about integrating PowerBI with this data, which is a great idea! There's still the challenge of manipulating that data to make it more useful than a spreadsheet/graph, but it's the right idea. I'm sure people have already developed some really great ways to display/digest the data, but there's a lack of sharing those ideas between other users. I'm not sure of the best way to accomplish it, but I don't see why the community can't come together and create some interesting widgets / sheets, but more importantly distribute them easily. I'm all ears for any ideas.

  • Another avenue I looked into a while back was utilizing Google Sites. You can create a pre-formatted user experience, that then uses each users individual data to populate it. It would still allow you to keep your data private, but could increase enablement by adding a much more streamlined approach to managing/monitoring your portfolio. It made me excited enough that I've even been keeping a registered domain ready for it all this time.

  • More data feeds

  • These requests have come up since Cryptosheets launched, and they've always been valid in my mind. Provided there's a way to get the data, people should be able to pull information from any exchange / wallet they choose to. The matter of Google's usage limits would be a concern if people are pulling too many sources too often, but there should be the option at least. I've considered the idea of centralizing data somehow, but I need to look into whether Google still counts pulling from another Google source against a user's daily limit. If it does still count against the limit, we might as well continue to use external APIs

edited for oversharing

Time for bed! Keep in touch!

Twitter
Twitch
Insta


Update (Oct 31): Spent some time researching the different endpoints, and the size / type of data each returns. I want to make sure that there's at least feature parity with the previously used data and that it won't break Google App Scripts' limits. The coins/markets endpoint provides everything except price (BTC), percent change 1H, percent change 7D. I can extrapolate the last two from the sparklines data (and even put a nifty line chart in for each currency), but I'm somewhat bothered by there being 172 data points for 7 days of data. I don't want to present extrapolated data that may be false.

The other option I'm considering is an individual query against the coins endpoint for each currency a user specifies (instead of pulling down a massive amount of data for all coins), which would then have all the necessary data for parity along with a wealth of other information that could be tapped into. I think this would be the best approach but would require a lot more calls (especially depending on how many coins each user is tracking). I just need to do some testing to see what breaks App Scripts, and whether leveraging things like the CacheService would sidestep the user quotas until the data's parsed.

Looks like they pushed the API deadline back into December, so I've got a bit of headway but will try to not let that creep up. It should also give me time to add a solution that still uses Coinmarketcap in case users want that option.


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 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 • • Nov 13 '24

Datas from cryptosheets not in Live

4 Upvotes

datas about cs.exrate give me wrong prices...stron lag.

any idea? help?


r/cryptosheets • • Dec 27 '21

Happy Cakeday, r/cryptosheets! Today you're 4

4 Upvotes

Let's look back at some memorable moments and interesting insights from last year.

Your top 3 posts:


r/cryptosheets • • Jan 14 '19

Where are the updated sheets located?

4 Upvotes

My "getData" function is no longer working, and I'm wondering if I just have a really out of date version of CryptoSheets. Not sure how often these are updated/maintained, but is there a link to get the most up to date version?


r/cryptosheets • • Feb 14 '18

Twitter, Reddit, Telegram URLs for 1000+ cryptos

4 Upvotes

Hi there,

I needed to put together a list of Twitter, Reddit and Telegram URLs for my trading bot. It includes top 1000+ cryptos. You can get it here for free should you need it for some of your stuff: www.cryptowasabi.com

enjoy! Cryptowasabi


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 • • Dec 28 '17

Help Request Help with getSheetByName.

4 Upvotes

First off. just wanted to say how much I appreciate the work that's been put into showing people how to do this!

The problem I'm running into is that my getSheetByName is returning null? I've bound the script to a sheet called "Rates", is this what you're supposed to do?

Cheers.

Edit: Never mind, entire spreadsheet file was named "Rates" and not the individual sheet within. Fixed now.


r/cryptosheets • • May 10 '24

Which Is The Best Free Crypto Portfolio Tracker?

3 Upvotes

Hi all,

I need a Crypto Portfolio Tracker to enable me compare my bought price vs current price to help determine when to sell please.

Which spreadsheet is available for free and which I can find guides to add live updates? Is there such a thing or I have to pay?

To start with, is there a way to add my trades from Binance and Kraken to a spreadsheet easily? ie not manually?

Then add, live cyrpto price tracker and see fees etc for tax purposes please?


r/cryptosheets • • Jul 03 '23

The Excel plugin has just stopped working. CS.Price("BTC", "USD") now returns an error.

3 Upvotes

Error is "Object doesn't support propert or method 'getItem'".

Any ideas?


r/cryptosheets • • Jun 10 '22

My login has been disabled and now I can't get a response from 'support" - any suggestions?

3 Upvotes

As the title says, my login is currently disabled. I emailed support 3 days ago and followed up again today - still no response and it is very frustrating.

I am new to Cryptosheets and so downloaded a few templates and tried to get my head around the functions and then I was locked out and I can't find a way to get in touch with them other than the email - to which they don't respond.


r/cryptosheets • • Jan 17 '22

Why does Cryptosheets need to access ALL of my google spreadsheets?

3 Upvotes

I have lots of Google spreadsheets, with all sorts of personal information. I'd like to use Cryptosheets, but installing it requires me to grant permission to "See, edit, create, and delete all your Google Sheets spreadsheets". I'm not comfortable doing this. Can Cryptosheets be used with a reduced scope of access?


r/cryptosheets • • Oct 15 '21

CS.EXRATE XRP (Ripple) showing wrong price

3 Upvotes

Using =CS.EXRATE("XRP";"USDT";"60") on Excel, I'm getting wrong values for XRP. Does anyone know what I am doing wrong? Thank you.

PS. Using =CS.PRICE("XRP";"USDT") shows the right value. But I need the EXRATE function.


r/cryptosheets • • Sep 16 '21

Help Request Need Help: Coinmarketcap Will not fully populate spread sheet on Excel

3 Upvotes

In Excel after loading in the link much of the list will not load only has the value: null

Even after I tried to refresh excel/refreshing the website it will not fully populate the values.

This happens in both views web and table.

What could the issue be?