SUMMER 2023
NO ACTIVE DEVELOPMENT
Not sure if BotMon still works. Not used it in years and Google made a lot of changes
April 17, 2021 - Binance API tickers fix
Fixed the tickers (if we get a connection) - tickers are cached for 2 minutes
April 15, 2021 - Bittrex API V3 upgrade
Upgraded to support API v3 - Bittrex end of life API v1
April 14, 2021 - Binance API trying to fix
Binance REST API is a pain and is always overloaded. Nothing I can do ;-(
Dec 20, 2020 - Collector improvement
Binance - mainly for Ctrxl but also some changes for BotMon to hopefully improve on the Binance bans.
Dec 16, 2020 - Collector improvement
Kraken - removed dependencies
Nov 1, 2020 - Bittrex Collector
Migrated to API v3
Sept 10, 2020 - Kraken Ticker fix
Was broken on sept 6
Sept 6, 2020 - Kraken Collector fix _& Tools fix
Kraken Collector - Issue decrypting some keys
Cannot read property 'replace' of undefined - change in tools that should hopefully fix an BFX issue (reported by Fernando Gabriel)
March 28, 2020 - Tiny fix in tools.gs
Ticker gave an error (probably due to some Google changes)
February 16, 2020 - CoinMarketCap issues due to Google BUG !!!!
You can now (optional) activate DriveApp to overcome the CoinMarketCap issue.
Add the following line to the main script: (requirements).
var e = DriveApp.getFileById();
February 10, 2020 - BotMon 3.5d - Removed driveapp dependency
Create a creative Fetch loop to avoid DriveApp dependency
February 6, 2020 - BotMon 3.5c - 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
January 17, 2020 - BotMon 3.5b
Error handling - can not find .gs library
Fix to random horizontal line issue in CONFIG (looks like a bug in sheets)
November 17, 2019 - BotMon 3.5a
Migration Wizard / Reset broke in 3.5 - fixed
November 11, 2019 - BotMon 3.5 (You do not have permission to access the requested document)
Fixed Error: during evaluation
Complete new and updated license / evaluation scheme
September 21, 2019 - Backend updates / No sheet update required
version 3.4d = [CMC_Mapping] table is updated in the template. You can manually copy these entries to your sheet.
[tools] Encrypted API keys are now supported. The create/remove Trigger button will encrypt the API fields
[core] Coins with *** in CMC_Mapping are now skipped from balance
[tools] Most fiat currencies are now recognized and do not show as '?'
September 17, 2019 - Fixed the Num error
Num Err fix that was caused by old Coinmarketcap API call and non USD/EUR
Added some fiat currency symbol names
Added CMC_Mapping definitions to master template
February 19, 2019 - Removed Kucoin support
Kucoin changed their API and I don't think anyone was using it
January 27, 2019 - Binance Trades fix
Added PAX, USD, USDC markets
No sheet update required. Remove some rows in Trades and clear the Balance to force an update
November 17, 2018 - Sheet update, did not change version (3.4c)
Added some symbols to CMC_Mapping
October 31, 2018 - Documentation Improvements
Added Balance chapter and screenshots (balance and unmatched)
Installation instructions
Version 3.4c - October 22, 2018 - Formatting
Withdrawals and Deposits - changed conditional formatting in template
October, 2018 - Documentation
Privacy and Security - most questions are still around this topic
Version 3.4b - September, 2018 - Error handling
POL: Improved error handling to central script - no update required !
Version 3.4b - June 20, 2018 - Sheet changes
CMC_Mapping : added BFX coin mappings - thanks Shawn
CONFIG : Bug Fix: USD fiat mapping = 1 (formula change in sheet) - thanks Shawn
SHEET : Bug Fix: Several hardcodes EUR symbols are now dynamic to selected currency - thanks Shawn
Version 3.4a - June 18, 2018 - Error handling
Improved overall error handling
June 2 - shared cache for Coinmarketcap api v2 and ignore Binance errors on no response (temp ban)
June 17 - stats!G19 formula changed
June 18 - Bitfinex API improvements
Version 3.4 - May 13, 2018 - Foundation
Core Enhancement
Lots of internal changes (settings object, route all functions through main etc.)
Performance and Reduced API calls (address 'Exceeded maximum execution time') - Reduce fetches on Binance !
Detect changes to the balances and only fetch what and if required (important for Binance & Bitfinex users)
Option to force specific symbols to always be fetched (new in config) symbol, symbol, symbol
Modular - Profiles Profiles determine what functions will run
Matching Windows - specifies a window to reduce matching process and increase performance
Removed the tweaks (they are now obsolete) - BotPrimCurrency, Binance, Bitfinex tweaks
Trades - new buttons
All functions have a button and can be activate manually
New buttons, including a clear button to restart order matching (useful for learning/testing)
CONFIG
Improved consistency for settings in config
Removed obsolete settings and switches
Balance
BTC values added
Triggers
Trigger Profiles can be manually activated with hotkeys (Ctrl-Alt-Shft 1 or 2) - leveraging the new Macro feature in sheet
Detect first time run and ask to initiate the recommended Trigger profile
Remove Triggers when expired eva
Remove Triggers when we force an update
We now have 2 Profiles that can be scheduled with a Trigger
Trigger pop-up when created/removed
Migrate
Rewrote migration assistant with to improve version validation and error handling
Ticker sheet - removed (was a bit of noise)
CSV example sheets consolidated to a single sheet
May 6, 2018 - cloud library updated, effective immediately
Documentation updates - Order Matching and Errors
Bittrex - improved error handling and withdrawals bugfix
Binance - improved error handling
Poloniex - deposits & withdrawals
May 5, 2018 - sheet
Updated the About page in the sheet (no new version number)
May 4, 2018 - cloud library updated, effective immediately
Migrate will now do withdrawls
Bitfinex - deposits -withdraws + sheet row bug (download the latest sheet - bug in row 43)
Kraken - added deposits & withdrawls
Cryptopia - added deposits & withdrawls and fixed a date/time issue
Sheet updates in 3.3a
BFX config must be row 43
Tickers errorlevels since we only collect current exchange tickers in the saas version
May 3, 2018 - cloud library updated, effective immediately
Kucoin and Cryptopia bug fixes - Thanks Mike for let me use your keys
Version 3.3a - May 1, 2018 - Bug fix - Copy the sheet
Fix: When Deposits was set to OFF, orders where not pulled
All order matching and api function are now turned on by default
Doc and Video on removing rows and restart the order matching (useful for testing) [link]
April 30, 2018 - cloud library updated, effective immediately
One to one Deviation - do the one to one match if there is a small difference (fee) - (request Carlo)
Suppress Negatives - don't show the fiat calculations if there is a loss (negative value) - (request by cirkator for GunBot)
Version 3.3 - April 28, 2018 - Tons of Enhancements - Copy the sheet
Sheet - CMC_Mapping - added a bunch of exceptions in the default table.
Migrate - CMC_Mapping table - we ask you to migrate your custom table
Migrate - added 2 more fields so we don't migrate settings below D29 in the release
Migrate - Migrate custom query formula from Unmatched!A6, see the Doc Unmatched
Trades - fix, remove percentage in Col T when 100% filled
Exchanges
Cryptopia (not tested, requires user feedback)
Kucoin (not tested, requires user feedback)
Poloniex (requires user feedback if orders are correctly pulled)
Binance - extended the Bot Primary Currency filter so it understands pairs
if your bot is only trading BTC-USDT pairs you only want to fetch these orders. This makes it really fast ! - cirkator
Unmatched - fix, the new (S-J)/J formula in col Z was not cleared
Unmatched - added Michael's code for recalc
Withdrawls - new tab, limited to Binance and Bittrex at this point
Code - massive code cleanup, extended debugging capabilities and improved error handling.
Code - moved approx. 95% of the script code to a central url to simply roll-out of new functionality.
Version 3.2 - April 22, 2018 - General Enhancements
Binance - enhanced the grouping of orders to a single BotMon trade when Binance did split off your order in multiple orders (Michael)
Bitfinex - Balance, sum trading, deposits and exchange balances (Marco)
Bitfinex - Deposits added (limited to one currency)
Trades - Improved calculations (Cirkator)
Unmatched - added a percentage column - (Col S - Col J)/Col J (Michael)
Config - Reset button will now reset setting in CONFIG to factory default as well
Config - Added a Binance API parameter field (Mark)
Doc - Described the new features in the documentation
Version 3.1c - April 20, 2018 - DEBUG option
Added a DEBUG switch to the script. This will provide more details on what data is returned from the API. See the script for more details (tools, script editor)
Removed the warning message about Deposits and Triggers
Version 3.1b - April 16, 2018 - Enhancements
Migrate data and settings
License settings
Deposits
CSV import
Convert date column to text
API import
Binance communication improvement - recvWindow=6000000
Version 3.1a - April 8, 2018 - Bug fixes and Enhancement
CONFIG - option to disable fetching orders - request by jbo
Binance specific bug fixes:
CSV import bug fix for USDT pairs
Calculation fix when sell order is split over multi orders - order price was summed - reported by cirkator
Binance specific notes in the doc
Version 3.1 - April 5, 2018 - Binance Tweak (error 429)
"Sometimes a small change can make a big difference"
Added a 'Bot Primary Currency Filter' to reduce API calls and increase performance for Binance Bot users. See the doc for more details.
Thanks cirkator for reporting this issue
Version 3.0 - March 10, 2018 - NEXT GEN
We have completely rewritten BotMon with support for multiple exchanges
Exchanges: Binance, Bittrex, Bitfinex, Kraken and Poloniex
BotMon 2.x users:
Since BotMon 3.x has a different datamodel we don't support migration from BotMon 2.x
BotMon 2.91 for Bittrex is still available in the PUBLIC folder but will no longer be maintained
Version 2.91 - January 13, 2018 - BUG FIX!!! This version is available here
Major bug sneaked in yesterday in the matching. Hope this solved it.
Version 2.9 - January 12, 2018 - Fiat price moved to coinmarketcap
Script: Fiat prices are now pulled from coinmarketcap to increase reliability. (dropped cryptocompare)
Script: Added a startup Trigger so BotMon will now update the sheet on startup
Sheet: improved calculations CONFIG M39, M40, G46
Fiat: AUD, BRL, CAD, CHF, CLP, CNY, CZK, DKK, EUR, GBP, HKD, HUF, IDR, ILS, INR, JPY, KRW, MXN, MYR, NOK, NZD, PHP, PKR, PLN, RUB, SEK, SGD, THB, TRY, TWD, USD, ZAR
Version 2.8 - January 1, 2018 - Because I'm a nice guy (most of the times)
Deposits and Withdrawals enhancements
data is added to sheet and not overwritten
options to add a note on transaction level (thanks Vic, useful for other as well I assume )
Research: Double entries are due to timezone issue after an import ;-( - Let's figure out how to solve this.
Version 2.7 - December 23, 2017 - Bittrex Open orders
There was confusion about the term 'Open' in BotMon and I received an enhancement request for Bittrex Open Orders,
The term 'Open' is now changed to 'Unmatched' and a real Open Orders tab is added
Version 2.6 - December 14, 2017 - Role-up release
Includes 2.5a - 2.5f changes
new:
cache the local currencies prices from cryptocompare
trades total was not updated when sheet was not changed - this is fixed
update button will force recalc of the total (update config!d40)
Version 2.5f - December 12, 2017 - Error handling
Improved error handling when no data is received from API (Browser.msg error)
Version 2.5e - December 12, 2017 - Blue lines in Trades fix
Make sure all 'old' blue lines are removed by clearing col B during update
Added local currencies THB, ZAR, TRY
Version 2.5d - December 10, 2017 - Bug fix
Update timestamp before doing compliance verification
Version 2.5c - December 6, 2017 - Bug fix in blue lines
Blue lines in trades where not correct updated. Forgot to remove a comment yesterday ;-(
Version 2.5 - December 5, 2017 - More local currencies and a Recalculate button in Trades
Added a couple of more local currencies to the list: EUR,USD,GBP,RUB,CHF,CAD,SEK,IDR
Error handling if we don't get a price from cryptocompare
cache the cryptocompare prices now for 10 minutes to reduce issues with slow responding c.c. servers.
New recalculate button in trades
Version 2.4 - December 3, 2017 - Like your feedback on Multi Currency Support
Import
full row, including your previous calculations
hide help after import
Multi Currencies
Pull prices from Cryptocompare to support many local currencies. We can easily add new currencies.
ETH- BTC- & USDT- currency pairs
Started a BotMon documentation page
Version 2.32- November 30, 2017 - We are stable now
Fixed an issue with the broken Ticker
Version 2.31 - November 29, 2017 - Error handling is more complex than you think
What if there is a coin in your wallet without a Ticker. Some more error handling
Version 2.3 - November 28, 2017 - Thanks for the feedback
Error handling - hopefully this solves all "Can not read property" error message that some experienced.
Improved matching - when a buy order is matched, it's now marked and will be skipped during the next match.
Config - improved calculations/statistics and a area for me to put some simple help notes.
Import - small adjustments
Version 2.2 - November 26, 2017 - More Love into the Robot
Open - More checks to verify orphaned orders. What's left you have to mark with 'X' manually in the Trades tab.
Trades - changes the marker for a matched order.
Version 2.1 - November 25, 2017 - Performance and Fun stuff
Performance - option to disable Withdrawals and Deposits when you press Update. You still can retrieve the data from the tab.
Manual Sheet as requested by one of our users (example)
Error handling on tickers
More quick sync buttons to only update what you are looking at
Version 2.0 - November 23, 2017 - Introducing Mr. Robot (I love this guy)
Bug fixes
Balance sheet will do calculations on all coins
New sheet for Unmatched / Open trades for the bot
Mr. Robot can look at orphaned trades
You can manually mark a Trade orphaned with 'X' in column K in the Trades sheet
Some additional buttons
Version 1.91 - November 18, 2017 - General improvements
Easier initial setup
more info in the help screen
additional button
Optimized the today tab
Colors - Conditional formatting is back without to much performance impact
Some other small adjustments
Performance
Version 1.9 - November 12, 2017 - General improvements
New Today's Total in Trades
New Quick sync button in balance sheet to only refresh the balance sheet and it's calculations
Hide/Unhide column adjustment
Bittrex fee in balance sheet will automatically adjust if Bittrex will make changes to the fee (currently 0.0025%)
Fixed BTC calculation bug in Balance
Version 1.8 - November 10, 2017 - USDT fix in the Balance sheet
Fixed bug in the balance sheet with USDT (thanks Rubens) - TypeError: Cannot read property "Bid" from null.
A few other minor enhancements
Version 1.7 - November 7, 2017 - Performance, Performance, Performance !
Dynamic sheet size (amount of lines) to increase performance
Conditional formatting (text colors) makes the sheet slow. Conditional formatting is removed on several sheets.
Trigger automatically created when you migrate
Version 1.6a - November 4, 2017 - Setting changed to Increase Performance
Range of Conditional formatting is changed to only change colors to the first 35 lines. The conditional formatting makes the sheet extremely slow.
Version 1.6 - November 1, 2017 - Balance Sheet
Order Matching in the Balance Sheet
A few cell formula optimizations in the Trades Sheet
Config has a few new formulas
New user, Help sheet will auto hide when sheet has value
Help text: Changes 30 days to 200 lines
Version 1.5 - October 27, 2017 - Released BotMon
Created the tool because many Cointrexer users are using Bots with Bittrex
Before 1.5 it was knows as TX View
Version 1.0 - August 2017 - started TXView to view transactions on Bittrex