Matched and Requested Odds in Results Tab

[excelhasey]

I am using a modified Gruss "sample spreadsheet" but I can't remember which one now but I know I haven't amended the data to be shown on the Results tab and I notice that columns G & I in the Results tab are stating the same values - G is Requested Odds and I is Matched Odds

I am using BACK-SP but even if my bet isn't matched and the bet is placed at SP, I would expect these columns to vary, i.e. one example today is saying the Matched and Requested Odds as 4.39090685040515 in both columns G & I

No way do I request Odds of 14 decimal places !!!!! - So obviously it is an SP price which is fine but the Requested Odds column should really read something like 5.0

Any thoughts anyone ??

[osknows]

BA only writes up to column F in the results sheet so it's likely columns G and I are being written via code.

Have a look in the worksheet_change event of the results sheet and see what the calculation is.

[excelhasey]

Thats all I can see :-

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

[alrodopial]

I am using a modified Gruss "sample spreadsheet" but I can't remember which one now but I know I haven't amended the data to be shown on the Results tab and I notice that columns G & I in the Results tab are stating the same values - G is Requested Odds and I is Matched Odds

I am using BACK-SP but even if my bet isn't matched and the bet is placed at SP, I would expect these columns to vary, i.e. one example today is saying the Matched and Requested Odds as 4.39090685040515 in both columns G & I

No way do I request Odds of 14 decimal places !!!!! - So obviously it is an SP price which is fine but the Requested Odds column should really read something like 5.0

Any thoughts anyone ??

I'm guessing that this info is retrieved from bf account and bf at the "betting history" page shows always requested odds same as matched odds. Nothing you can do or maybe you can log the requested odds by yourself with some kind of code.