Cymatic Trader Community

Hi guys,

Looking for some help with this. I'm new to the excel side of automation. I have used a sample spreadsheet from this forum (Gavin's Lay the Field) and crudely Frankensteined it into a back bet bot. Hoping the bot can place a back bet at the best available price one the price meets a certain point. I've done this by having a trigger point price and backing one tick below that. Happy to just back at the trigger point price but not sure if it will be matched in time should I choose that option. I guess I'm chasing steam so once the price moves, it moves pretty quickly. The liquidity isn't always great on the matches I'm betting on.

Fundamentally it works but there are some wasted steps and that I'd like to bypass and other steps I'd like to fix.

I only want one bet to matched in total so once that has happened, I'd like to the bot to stop placing bets. I've tried to do that by counting cells AT8 & AT9 but not sure if that is working.

By using the above method, I'm hoping the count bet section starting in cell BE1 and the matched bets section in BI1 can be removed? I did try and get rid of them but kept getting error messages with my code. In the end I just typed TRUE into all three boxes as a quick fix.

Any suggestions would be great.

Thanks

John

I have added a tick offset function which I took from another excel file. Still hoping to neaten things up.

Hi John,

Counting the matched back bets in column AT sounds like a reasonable approach. If you haven't already done so, I expect you'll also want to check for unmatched bets, to prevent your robot sending a stream of duplicate bets.

You can't prevent Cymatic from populating columns BE to BI, but you are free to clear the contents if and when you need to do so.

Kind regards,

Gavin

I see what you mean about the unmatched bets. I'll have a look at that.
Thanks for the response Gavin