Hi everyone,
Can anyone point me in the right direction here, If i lay and then back the same horse (if its winning) on the bet results page on my spreadsheet it only shows the original back side of the bet , is this right?
Bet ref Selection name Bet type Amount Average Odds
8777537368 Deal Or No Deal L -0.61 2.96 RESULT_LOST
Is there any way i can show the actual profit/loss? or record this somehow? I am trying to work the next stake from the previous results
mike...
Bet results
Moderator: 2020vision
5 posts
• Page 1 of 1
Bet results
by mikey » Thu Aug 27, 2009 8:10 pm
- mikey
- Posts: 29
- Joined: Mon Aug 24, 2009 10:01 pm
- Location: Suffolk
by osknows » Thu Aug 27, 2009 10:19 pm
When excel runs the sheet_change event after BA refreshes you can place a "U" in cell J2 which refreshes your balance and exposure
You can then use a simple excel formula
New Total = Balance - Current Exposure
The only problem with this is that until the market is settle the figures won't update but then it's not any slower than waiting for the bet results page to update
You can then use a simple excel formula
New Total = Balance - Current Exposure
The only problem with this is that until the market is settle the figures won't update but then it's not any slower than waiting for the bet results page to update
-
osknows - Posts: 946
- Joined: Wed Jul 29, 2009 12:01 am
by mikey » Fri Aug 28, 2009 7:50 am
Thanks Osknows,
This would be good if i had a level profit/loss on all runners but it can be a bigger loss on the losers and a small loss/profit on the winner.
I was more thinking of some code maybe when the race finished to copy the winner (1.01 odds?) profit/loss figure to a page and keep all of todays results and base my next stake on these figures. unfortunatly i'm not good with creating code but maybe able to adjust something to suit.
Anyone got some example code i could try??
mike
This would be good if i had a level profit/loss on all runners but it can be a bigger loss on the losers and a small loss/profit on the winner.
I was more thinking of some code maybe when the race finished to copy the winner (1.01 odds?) profit/loss figure to a page and keep all of todays results and base my next stake on these figures. unfortunatly i'm not good with creating code but maybe able to adjust something to suit.
Anyone got some example code i could try??
mike- mikey
- Posts: 29
- Joined: Mon Aug 24, 2009 10:01 pm
- Location: Suffolk
by osknows » Fri Aug 28, 2009 5:49 pm
In theory yes but the problem with your suggested method is that it doesn't always work that way. I've seen numerous races where a tight finish results in some very strange suspended market prices. The winner is not always 1.01
It's always possible to code around this but I think it's easier to accept the time delay in the market settlement updates
It's always possible to code around this but I think it's easier to accept the time delay in the market settlement updates
-
osknows - Posts: 946
- Joined: Wed Jul 29, 2009 12:01 am
by osknows » Fri Aug 28, 2009 6:58 pm
"This would be good if i had a level profit/loss on all runners but it can be a bigger loss on the losers and a small loss/profit on the winner."
Hopefully your staking plan means that any change to your new stake based on a previous loss or win is very small. If not I would reconsider your stkaing plan
Hopefully your staking plan means that any change to your new stake based on a previous loss or win is very small. If not I would reconsider your stkaing plan
-
osknows - Posts: 946
- Joined: Wed Jul 29, 2009 12:01 am
5 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 37 guests