Hello
Can anyone explain to me how this trigger works? I tried using it, but nothing happened...
Update trigger
Moderator: 2020vision
3 posts
• Page 1 of 1
Update trigger
by clinton » Mon Dec 13, 2010 1:08 pm
- clinton
- Posts: 111
- Joined: Mon Oct 22, 2007 12:25 pm
by GaryRussell » Mon Dec 13, 2010 2:30 pm
It does work.
Put UPDATE in the trigger column and the new odds in column R. Providing the bet is not matched or partially matched then it will be updated.
You should also be aware when you set up the Excel link you have the option of ticking UPDATE trigger appends "N" to new bet ref
If this option is ticked then N will be appended to the new bet ref to prevent further updates triggering unless you remove the N using VBA. If it's not ticked then it will continue to update the bet every time the odds change in column R.
Put UPDATE in the trigger column and the new odds in column R. Providing the bet is not matched or partially matched then it will be updated.
You should also be aware when you set up the Excel link you have the option of ticking UPDATE trigger appends "N" to new bet ref
If this option is ticked then N will be appended to the new bet ref to prevent further updates triggering unless you remove the N using VBA. If it's not ticked then it will continue to update the bet every time the odds change in column R.
-
GaryRussell - Site Admin
- Posts: 9872
- Joined: Fri Nov 18, 2005 8:09 pm
- Location: Birmingham, UK
- clinton
- Posts: 111
- Joined: Mon Oct 22, 2007 12:25 pm
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 58 guests