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
Automated back bet based on price movements
Forum rules
Developers: Please contact Gavin to request permission before you begin posting here.
Users: For each new project, please simply post an outline of your requirements in a new topic. Thereafter you can of course liaise directly with any developer to discuss any confidential aspects of the project if you feel that is necessary (for example via email or private message). By posting publicly initially, you will be helping to create interest in Find A Developer. It will also help to show that jobs are being completed successfully and thus encourage other users. The busier it becomes the better it will be for everyone.
Cymatic is unable to do bespoke programming work for individual users, but if you post your requirements here, then other professional programmers might offer to do the work for a fee. Cymatic accepts no liability and we do not check the credentials of respondents. So please ask appropriate questions or seek references before accepting a quotation.
Please also keep in mind that after your Cymatic free trial expires, you would need a paid Cymatic subscription in order to continue using Cymatic with spreadsheets. So please don't pay for customizations to spreadsheets without realizing this possibility. Thank you.
Developers: Please contact Gavin to request permission before you begin posting here.
Users: For each new project, please simply post an outline of your requirements in a new topic. Thereafter you can of course liaise directly with any developer to discuss any confidential aspects of the project if you feel that is necessary (for example via email or private message). By posting publicly initially, you will be helping to create interest in Find A Developer. It will also help to show that jobs are being completed successfully and thus encourage other users. The busier it becomes the better it will be for everyone.
Cymatic is unable to do bespoke programming work for individual users, but if you post your requirements here, then other professional programmers might offer to do the work for a fee. Cymatic accepts no liability and we do not check the credentials of respondents. So please ask appropriate questions or seek references before accepting a quotation.
Please also keep in mind that after your Cymatic free trial expires, you would need a paid Cymatic subscription in order to continue using Cymatic with spreadsheets. So please don't pay for customizations to spreadsheets without realizing this possibility. Thank you.
4 posts
• Page 1 of 1
Automated back bet based on price movements
by leeming23 » Wed Jan 05, 2022 12:59 pm
You do not have the required permissions to view the files attached to this post.
- leeming23
- Posts: 6
- Joined: Wed Dec 22, 2021 5:18 am
Re: Automated back bet based on price movements
by leeming23 » Mon Jan 10, 2022 4:29 pm
I have added a tick offset function which I took from another excel file. Still hoping to neaten things up.
You do not have the required permissions to view the files attached to this post.
- leeming23
- Posts: 6
- Joined: Wed Dec 22, 2021 5:18 am
Re: Automated back bet based on price movements
by Gavin » Fri Feb 04, 2022 11:56 am
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
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
-
Gavin - Site Admin
- Posts: 3876
- Joined: Wed Jan 23, 2013 9:11 pm
- Location: United Kingdom
Re: Automated back bet based on price movements
by leeming23 » Fri Feb 04, 2022 8:42 pm
I see what you mean about the unmatched bets. I'll have a look at that.
Thanks for the response Gavin
Thanks for the response Gavin
- leeming23
- Posts: 6
- Joined: Wed Dec 22, 2021 5:18 am
4 posts
• Page 1 of 1
Return to Excel - Find A Developer
Who is online
Users browsing this forum: No registered users and 0 guests
