Is there anyway to know that the My_bets sheet has been updated before firing in a new bet?
If there is an entry in MyBets with status F you must also check there isn't also an entry with status U.
Double backing
Moderator: 2020vision
21 posts
• Page 2 of 2 • 1, 2
by GaryRussell » Tue May 29, 2012 2:25 pm
To answer your original question.
If there is an entry in MyBets with status F you must also check there isn't also an entry with status U.
If there is an entry in MyBets with status F you must also check there isn't also an entry with status U.
-
GaryRussell - Site Admin
- Posts: 9872
- Joined: Fri Nov 18, 2005 8:09 pm
- Location: Birmingham, UK
by eclipse » Wed May 30, 2012 8:36 am
Yeah, it is checking to see if the unmatched amount is zero (ie no unmatched bets outstanding) before it will fire a new bet.
-
eclipse - Posts: 226
- Joined: Mon Apr 16, 2007 10:54 am
- Location: S. E. England
by GaryRussell » Thu May 31, 2012 2:55 pm
eclipse wrote:Yeah, it is checking to see if the unmatched amount is zero (ie no unmatched bets outstanding) before it will fire a new bet.
It's checking this on the trigger sheet from what you've said. At this point MyBets can be behind so if you are getting the remaining stake from MyBets I also recommend checking that there no status U bets at the same time.
-
GaryRussell - Site Admin
- Posts: 9872
- Joined: Fri Nov 18, 2005 8:09 pm
- Location: Birmingham, UK
by eclipse » Thu May 31, 2012 4:49 pm
Yeah it checks My_Bets sheet to see there are no U bets, ie unmatched bets = 0.
-
eclipse - Posts: 226
- Joined: Mon Apr 16, 2007 10:54 am
- Location: S. E. England
by GaryRussell » Thu May 31, 2012 5:51 pm
eclipse wrote:Yeah it checks My_Bets sheet to see there are no U bets, ie unmatched bets = 0.
It's impossible for the matched amount to change if there are no more unmatched bets. This would mean it's actually wrong in the bets manager in the BA application itself.
Would it be possible to send us a spreadsheet containing the formulas/VBA that does this check?
-
GaryRussell - Site Admin
- Posts: 9872
- Joined: Fri Nov 18, 2005 8:09 pm
- Location: Birmingham, UK
by eclipse » Fri Jun 01, 2012 9:39 am
No worries Gary, think I've sorted it now, have put a delay in to allow My_bets to fully update itself, seems to be ok now, thanks for the help.
-
eclipse - Posts: 226
- Joined: Mon Apr 16, 2007 10:54 am
- Location: S. E. England
21 posts
• Page 2 of 2 • 1, 2
Who is online
Users browsing this forum: Bing [Bot] and 52 guests