Embedded Files
2024 Binance
Unfortunately, due to regulations, Binance.com restricts access from certain areas, including the United States.
This prevents a connection from Google Sheets (Cloud) to the Binance API, which is a requirement for Cointrexer to collect data.
We understand this may be frustrating, and some users suggested using a proxy service to bypass this restriction. However, prioritizing user security is paramount. Proxy services can potentially expose sensitive data, and we strongly advise against them.
For now, Binance.com can be managed manually by setting the exchange source to manual.
April 25, 2022 - Version CtrXL 1.6
New location for the connectors
We used Google Pages to host some of our files. This Google service is end of life so we are now hosting connectors on GitHub
Connector changes
Added MEXC Global
Updated OKX /OKEX for API v5
May 6, 2021 - Etherscan Collector improved
Now can do decimal adjustment
Mar 7, 2021 - Version CtrXL 1.5g - (script update only)
Another improvement to overcome the Binance API connectivity issue
We now have an option that always tries to connect to Binance but will fallback to the cache if connection fails.
Set Log Frequency to < 6h, ttl to any value other than 0 or 666 and caching off for Binance
Here is a short video New video howto Binance
Feb 21, 2021 - Version CtrXL 1.5f - (script update only)
Configure caching tobe used only if real-time update fails. Howto: set ttl to 21600 and turn off caching for exchange
Feb 23, 2021 - Collector added
Mercadobitcoin exchange Brazil
Feb 21, 2021 - Version CtrXL 1.5d and 1.5e - keys error - (script update only)
Should solve "Can not read properties 'keys' from null" that some users reported.
Feb 19, 2021 - Version CtrXL 1.5c - tiny cache improvement in script
Cache is now cleared when turned off (disabled) or ttl is 0 or 666.
A section is added to the ctrxl docs that explains caching
Feb 16, 2021 - Version CtrXL 1.5b - script update and CONFIG Log Skip Zero
In version 1.5 we introduced a new feature that prevents writing to Log when we have received an empty balance.
Sheet: I added a switch in CONFIG, called "Log Skip Zero" where you can turn this feature off. There might be cases where you have a zero balance and want to log zero balances.
Script: added 'Log Skip Zero' but skipzero is also still working.
Script: changed notification to -> write to Log is cancelled because an empty balance is detected and 'Log Skip Zero' is 'ON' in CONFIG.
Feb 15, 2021 - Version CtrXL 1.5a - script update only
This version is focused on connectivity (zero balances) issues on Binance. We can not solve the Binance bans but have the following enhanced as work around.
don't log a zero balance - we don't write LOG if the balance is zero. This can be changed with skipzero=OFF in CONFIG if you want to log the failures as well.
turn caching on for Binance and run from (startup) Trigger as shown in my video
the default cache time to live (ttl) is now set to 10 minutes. (600). If you don't trade a lot, you can set it to max. value 21600. (6 hours)
clear cache - you can manually delete the cache by setting ttl to 0 or 666 and run update
only cache valid content. Double check that we never cache an empty balance
Migration Assistant now supports more than 20 exchanges
see that an exchange failed to update:
I added a simple formulas to the Dashboards on feb 13 that show if all balances are updated:
This formula checks all exchanges that are not Manual for zero totals. If we have zero, it displays a cross.
=if(COUNTIFS(Totals!D6:D,"<>MAN",Totals!E6:E,0)>0,"❌","✔️")
Howto update: see the docs or just copy the script since this is a script update only. Change the version number in cell CONFIG!E25 to 1.5.
Feb 13, 2021 - Dashboards
Added / Fixed the validation formula in Dashboard 2 and 7
Feb 4, 2021 - Version CtrXL 1.4j
Dashboard 7 added to the template
Namebase connector added
Jan 27, 2021 - Collector improved
New Etherscan collector to administer and collect tokens
Jan 20, 2021 - Collector improved
Bitvavo
Jan 17, 2021 - Collector added/improved
ZeroHash
OkCoin
Jan 16, 2021 - Collector added
ZeroHash
Jan 10, 2021 - Collector improvement
FTX subaccount fix
Jan 4, 2021 - Collector improvement
Kraken Futures fix
Jan 1, 2021 - Version CtrXL 1.4i
Added the TTL switch in CONFIG
Added CoinEx for Kol
Dec 26, 2020 - Dashboards
Script - changed version number 1.4h (no change)
Dashboard5 - Tiny pimp
Dec 25, 2020 - Dashboards
Dashboard3 - Added a cool query to LOG
Dashboard5 - Updated the query to one entry per month
Dec 23, 2020 - Version CtrXL 1.4h
Refreshed Dashboard3 - video
Dec 20, 2020 - Collector improvement
Binance Futures improvements
Dec 18, 2020 - Improving Binance Exchange Specific Documentation
Clearly we receive most questions about Binance ;-)
Dec 16, 2020 - Collector improvement
Kraken - removed dependencies
Nov 21, 2020 - Version CtrXL 1.4g | Pimping Dashboards
New Dashboard6 - added a Pivot Table
Update Dashboard2 - added 2 percentage formulas G8 &C12
Nov 19, 2020 - Collector added
SimlpeFX
Nov 18, 2020 - Collector improvement
Binance Futures USDT and COIN - new parameters
Nov 17, 2020 - Added example to My Sheets
Get the High Log Date from Log
Nov 15, 2020 - Collector improvement
Bybit improvements and added 'debug' switch
Bittrex improved error handling
Bit2C and GoPax improved performance and added 'debug' switch
Nov 14, 2020 - Collector improvement
Coinbase Pro (GDX) performance improvements and added 'debug' switch
BitMEX - added 'debug' switch
Nov 13, 2020 - Collector improvement and Dashboard3
Etherscan collector [+]
Dashboard3 tiny pimp + p/l formula
Nov 12, 2020 - Collector improvement
Binance Margin Isolated
Nov 12, 2020 - Version CtrXL 1.4f | Customer data in label
Added a few formulas to the Dashboard3 E1 / G12 / C5 customer@exchange$invest
Turn Text wrap on in Log titlebar if you have long labels
Nov 10, 2020 - Collector added
Delta Exchange added
Nov 9, 2020 - Collector bug fix
Coinbase (CNB) added limit=100 switch to support large balances
Nov 8, 2020 - Version CtrXL 1.4e | Fix
Negative balance is now displayed (Margin Wallet)
Collector Bitvavo added
Nov 6, 2020 - Collector added
Yobit
Phemex
Nominex
Vinex Network
Nov 4, 2020 - Collector added
Probit
Oct 29, 2020 - Collector enhancements
Binance - improved margin balance - thanks Dmitry
Binance - future is now using /fapi/v2
Oct 28, 2020 - Collector enhancements
Binance - fixed margin balance bug
Binance - fixed "SyntaxError: Empty JSON string
Oct 27, 2020 - Collector enhancements
Binance - added debug switch and more -> see Binance notes
Oct 26, 2020 - Collector added
Upbit
Bitso
Oct 23, 2020 - Version CtrXL 1.4d | New Exchanges
Added Collectors for :
CoinDCX
BtcTurk
IDEX 2.0
Crex24
Cleaned two man tabs
Oct 13, 2020 - Version CtrXL 1.4c | Lic and key issue | get latest version
Cell G28 messed up the API keys - make sure it is empty . Remove 'exchange specific notes' and just clear the cell
Google changes again. The sheet now prompts for your license key - thanks Kevin
Aug 24, 2020 - Added url in CONFIG to exchange specific notes
Changed TIP lines
Changed the lic url
Aug 23, 2020 - Version CtrXL 1.4b | Optinal - Scope of the script
@OnlyCurrentDoc allows the script only access current doc
Aug 18, 2020 - Bybit Collector bugfix
Fix Non BTC balances - thanks to Michele for his help
July 17, 2020 - Version CtrXL 1.4a | Optional update !
Config K17 = =iferror(if($E$17="FULL_BTC",max(Log!$E$6:$E),max(Log!$D$6:$D)),0)
Config K18 = =iferror(if($E$17="FULL_BTC",min(Log!$E$6:$E),MIN(Log!$D$6:$D)),0)
June 2, 2020 - BitMart Collector
Added Collector
May 18, 2020 - Dashboard improvements
Log high and Low low point to CONFIG
May 10, 2020 - Dashboard 3 update
Pimped Dashboard 3
Improvements to My_Sheet, percentage
May 1, 2020 - Dashboard 1 update
Percentage change in E10 and updated formula in E8 to show 'real time'
April 27, 2020 - Dashboard 5 added
Thanks to Aden for the inspiration
April 20, 2020 - Coinbase Collector fix
Thanks Dave Yellowstone
April 17, 2020 - Deribit Collector fix
Thanks Johannes for reporting the issue
March 31, 2020 - Kraken Collector => Futures
Kraken Futures added to the collector
March 19, 2020 - BKEX, BitForex and MXC Collectors Added
Corona time
March 15, 2020 - bitFlyer Collector Added
Had some free cycles so created this (not fully tested)
February 23, 2020 - Version CtrXL 1.4 | Optional update !
Role up release since the original release of 1.3 in September 2019
Migration wizard changes
migrate both 1.3 and 1.4 sheets (1.2 depreciated)
custom formulas CONFIG!E14 and CONFIG!E15 are set to default and not migrated
CoinMarketCap cache fallback to an alternative update mechanism if fetch fails
February 20, 2020 - Bytbit Collector Added
Added a Bybit Collected - requested by Guido
February 18, 2020 - FTX Collector Added
Added a FTX Collected - requested by Tom
February 16, 2020 - Binance Collector Improved
margin and future balance are now supported - see doc (requested by Guido)
February 13, 2020 - Binance Collector Improved
'us' as third attribute in CtrXL will change the url to Binance us - couple of requests about this
February 12, 2020 - BitMex Collector Improved
'testnet' as third attribute in CtrXL will change the url to bitmex testnet
Dashboard1:C41 | iferror(query(Balance!$C$6:T,"select J, F,G,H,I,N,O,P,T,S where D='"& D39 &"' order by H desc limit 10", false),"empty")
February 10, 2020 - CtrXL 1.3g Removed Drive dependency
Created a loop in the UrlFetch to avoid using drive app
February 7, 2020 - CtrXL 1.3f Fix tiny issue in 1.3e
Duration timer showed Finished in NA seconds
February 6, 2020 - CtrXL 1.3e Bug in Google V8 JS Engine
Google RunTime V8 Update on feb 5 broke a key feature in the script.
The FetchApp feature is not working anymore to get CMC_Cache and I had to use DriveApp
This requires more authorizations !!!! Hope this is temporary !!!!
Link to this issue
Additional error handling on initializing tools library
Demo mode will only generate unique symbols
Migration now only supports from version 1.3 (custom formulas are not migrated)
January 27, 2020 - CtrXL 1.3d Dashboard enhancements
Optimized all query formulas in Dashboards to include QUERY .... FALSE
January 14, 2020 - Tiny fix in Dashboard1 - no version change
Queries, changed limit 10 to limit 9
All time high added to I9 in Dashboard1
January 10, 2020 - Currency_com Collector Added
Requested by Andrey
December 18, 2019 - BitMEX Collector Improved
Improved authentication
November 15, 2019 - CtrXL 1.3c Dashboard enhancements
Pimped Dashboard3
Added Dashboard4
Added Label tab to address dynamic list of exchanges issue
November 11, 2019 - CtrXL 1.3b (You do not have permission to access the requested document)
Fixed Error: during evaluation
Complete new and updated license / evaluation scheme
October 28, 2019 - Updated Dashboard1
All time High and Low in Dashboard Col M
October 3, 2019 - Updated Dashboard1
More crypto logos and http links in Dashboard1
September 28, 2019 - Small update to version 1.3a
DEBUG - 'DEMO_MODE' will generate random demo content on every update
Customer Log formula: Log output 1 will not be recalculated when you Reduce the Log size. Log output 2 will be recalculated
September 27, 2019 | Version CtrXL 1.3 - get it here | video | howto update doc
Extend Fiat currencies : Non USD or EUR currencies can now be configured.
Support for 30+ different exchanges
Custom Formulas in the Balance tab allow you to extend the functionality
Custom Logging is extended to two fields.
Dashboard 1 : now displays currency icons and hyperlinks
Bug fix: Migration wizard lost formula in CONFIG!E8
Error handling: Maximum 5000 lines in Log or stop and disable Triggers - main.gs
Error handling: Suppress error messages when libraries failed to load - main.gs
Advanced Users: Cache Time To Live can be set in config (default value is 21600 = 6 hour)
Roll-up all other new features since we released 1.2 back in June (see below)
September 22, 2019 - Formula update
CONFIG!E8 - if (E7<>"USD",GoogleFinance(CONCAT("CURRENCY:USD",E7)),1)
September 21, 2019 - Some updates
[CMC_Mapping] table is updated.
[tools] Most fiat currencies are now recognized and do not show as '?' Let me know if something is missing,
September 8, 2019 | IDEX collector
IDEX collector for Bernd
September 5, 2019 | GOPAX collector
GOPAX collector for Elis
September 3, 2019 | Luno (BitX) and Liquid collector
A Ludo and a Liquid collector for Elis
September 2, 2019 | Indodax collector
An Indodax collector for Elis ( best effort because CtrXL will not do IND )
August 21, 2019 | Binance collector fix
Added &recvWindow=6000 again to see if this fixes issue for some users
August 16, 2019 | Binance collector fix
A Binance System Upgrade impacted the API - &recvWindow=6000000 removed
August 8, 2019 | Bitpanda Global Exchange support for Bernd
PGE Collector added
July 5, 2019 | Template update
Small change to Dashboard2 select C, D, G,H, K,L,.........
June 21, 2019 | Release CtrXL 1.2 - get it here | howto update in the CtrXL Doc
Roll-up release since the original release of CtrXL 1.1 back in december 2018
Extended the list of support exchanges - see doc
CtrXL API, allows you to add your own exchange collector (more)
Clean Log feature to reduce the log to one line per day ( important )
Update wizard validates v1.1
All time High/Low
Execution time counter
June 7, 2019 | Bitpanda support for Bernd
Bitpanda collector added - see doc
May 12, 2019 | Etherscan.io support for Jon
Etherscan collector added - cold storage users can use this for their ETH
April 23, 2019 | Binance Jersey (Binance.je)
Binance Jersey is added - limited support / no GBP
March 23, 2019 | Avg. Weather
Added average weather on your balances to CONFIG and Dashboard 1 and 2
March 20, 2019 | Gate.IO Collector
Added a Balance Collector for Gate.IO
February 26, 2019 | Dashboard 3
Label specific Dashboard - useful if you manage cryptos for others
Existing users, you can just copy Dashboard3 to their existing sheet by right click on Dashboad3 and select "Copy To" and select your sheetfile.
Screenshot: click to enlarge
February 21, 2019 | Fixed KuCoin
KuCoin API collector updated to v2
February 19, 2019 | Disabled KuCoin
KuCoin changed their API to v2.0 and this requires some coding. Action Moosy !
February 13, 2019 | Cache View File Problem
New link: https://docs.google.com/spreadsheets/d/1bUfO38qLXHr4jjzqHdl4OXM7ZIpBD5gZ5Ttt9QBQdWE/edit?hl=en&rm=minimal#gid=1649765657
February 2, 2019 | Deribit
Deribit Collector for Fer
December 26, 2018 | MY_SHEET
Easier for newbies to get started with MY_SHEET
Removed Customization Examples (Complex for newbies)
December 22, 2018 | Bit2C
Added Israeli Crypto Exchange Bit2C
December 21, 2018 | Bitsane
Added Bitsane exchange
December 20, 2018 | Fixed Coinbase Pro URL // GDAX
Small change in GDAX collector -> Coinbase Pro
December 18, 2018 | Added Bibox
Bibox API in Google Apps Script was a pain in the ass and took quite some cycles to figure it out.
December 15, 2018 | Added Huobi and OKEx and some sheet adjustments
Huobi | Check the doc if you have issues. Timezone settings are important
OKEx exchange
CMC_Mapping update
CMC Cache View Link added in CONFIG
December 13, 2018 | Added Gemini and BitMEX
Added a collector for Gemini & BitMEX (BitMEX api is crap)
Tiny fix in CONFIG F formula copied down
Version 1.1 - December 10, 2018 | Copy ctrxl 1.1 to your Google Drive
Exchanges
Added collectors for HitBTC and CEX.IO
Supported Exchanges are now in [Sources] tab
Migration Assistant
Imports CONFIG and LOG
Set Log date column to date format
Triggers Button Bug Fix
Dashboard improvements
Version 1.0b - November 18, 2018 - In development | Copy ctrxl 1.0b to your Google Drive
Usability
Balance Sheet - Clear button will now reset/recreate the filter
Balance Sheet - You can now add columns with your own formulas
Config Sheet - Improved settings for Trigger (frequency)
Log Sheet - Added Custom Logging field in Config
Coinmarketcap timestamp - this is pulled out of the blob we receive from CMC
Customization Sheet - Improved examples
Buy Sheet - Profit Loss example sheet | Balance Sheet
Quality
Improved update notification
Check if API key is empty
Under the hood
Parser validates [exchange] section before updating the config sheet
Cache Marketdata
Version 1.0a - November 15, 2018 - New Puppy
Initial release
See Cointrexer Classic
https://sites.google.com/site/moosyresearch/projects/cryptos/cointrexer
Google Apps Script Private Authentication API APIs Request GAS script balance balances. Google Sheet
Binance Bitfinex Bitstamp Bittrex CEX.IO Coinbase Cryptopia Gemini GDAX HitBTC Huobi Kraken Kucoin Poloniex APIs
Huobi Google Sheets - Huobi Google Script - Huobi Google Apps Script
Bitstamp Google Sheets - Bitstamp Google Script - Bitstamp Google Apps Script
HitBTC Google Sheets - HitBTC Google Script - HitBTC Google Apps Script
Gemini Google Sheets - Gemini Google Script - Gemini Google Apps Script
CEX.IO Google Sheets - CEX.IO Google Script - CEX.IO Google Apps Script
Google Sites
Report abuse