I came home the other day and found my bot had stopped due to an overflow error.

After each market is traded the “My Bets” page data is added to a log sheet along with bet attempt data. Every week or so I save this sheet and clear it in the bot.

When running, the code finds the next empty row to paste to but that row number value is an integer data type. This has a limit of 32767. As can be seen, I’d left it too long and it reached it’s limit.




One thought on “Overflow”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s