MyBets worksheet

[danjuma]

Gary or anybody please,

Does the E column in the MyBets worksheet return a letter like P to indicate a partially matched bet, or does it just return U or F.

Many thanks.

[Captain Sensible]

Haven't used it myself but surely part matched bets would just show the relevant amounts as both U and F with the same bet ref

[danjuma]

Haven't used it myself but surely part matched bets would just show the relevant amounts as both U and F with the same bet ref

Not sure myself, as haven't experienced such a situation. Hopefully Gary would confirm.

[danjuma]

Hi Gary,

Any input into this? Basically what i want to establish is say I place a back bet of £10 @ 3.5 on a selection and the bet gets fully matched in say 3 chunks of say £5 @ 3.5, £3 @ 3.6 and £2 @ 3.7. How would this be displayed in the MyBets sheet. I need to get the odds and stake matched for a different calculation and I can't get this from the V and W columns in the logging sheet as these will change to the new odds and stake as they are matched (I think, or would they show the average odds and total stake after fully matched, not sure now, have not paid attention ). Basically, where is the best place to get the odds (average) and stake (fully matched) - the V and W column in the logging sheet or the C and D columns in the MyBets sheets?

Many thanks.

[GaryRussell]

In the case of a partially matched bet there will be two rows on MyBets for the same reference. The partially matched portion will have status F and the unmatched portion will have status U.

When a bet is fully matched column V does show the average matched odds.

[GaryRussell]

Basically what i want to establish is say I place a back bet of £10 @ 3.5 on a selection and the bet gets fully matched in say 3 chunks of say £5 @ 3.5, £3 @ 3.6 and £2 @ 3.7. How would this be displayed in the MyBets sheet

There will be one row on MyBets showing the average matched price. Column V on the main sheet will show the same odds.

[danjuma]

Basically what i want to establish is say I place a back bet of £10 @ 3.5 on a selection and the bet gets fully matched in say 3 chunks of say £5 @ 3.5, £3 @ 3.6 and £2 @ 3.7. How would this be displayed in the MyBets sheet

There will be one row on MyBets showing the average matched price. Column V on the main sheet will show the same odds.

Does that mean column V on the main sheet will now show the same average matched price in the one row in MyBets?

Thanks

[GaryRussell]

Yes. It has always done so in all versions of BA.

[danjuma]

Many thanks Gary.

[Bumble]

Gary - this is interesting and relevant to what I'm trying to do. Am I right in thinking that at any one point in time, for a single Bet Reference then MyBets will contain one of three things:

i) A single row with that bet reference, with "U" in columns 5
ii) A single row with that bet reference, with "F" in column 5
iii) At most, two rows with that bet reference, one with "U" and one with "F" in column 5.

We'll often just have (i) closely followed by (ii). I'm interested in (iii). I'm hoping you'll say that if a single bet is partly matched (say four times) there will still (at any one refresh) be one F row and one U row for that bet reference. Over time, the Stake and Odds in columns 2 and 3 of each of those rows will change.

Or have I misunderstood, so that it is possible to have three or more rows in MyBets with the same bet reference?

Many thanks

[GaryRussell]

You are correct. There are only those three possibilities. A partially matched bet will always have two entries, one "F" for the matched portion and one "U" for the unmatched portion no matter how many chunks it gets matched in.

[Shaun]

Can i confirm with the above if we have matched and Unmatched amounts with the same betref will they both contain P

[GaryRussell]

Can i confirm with the above if we have matched and Unmatched amounts with the same betref will they both contain P

No, on MyBets they never appear with P, this is only in column T on the main sheet. So if it contains P on the main sheet then you will find two entries in MyBets for the same reference.

[Shaun]

ty