Using the "Update" Function

[vanbuuts]

I have tried using the "UPDATE" function in the trigger column, odds of 1.01 in the odds column but the bet doesn't fire. It just shows "Cancelled" in the Bet Ref column. What else needs to happen for a bet to update successfully?

[Captain Sensible]

Not sure what you mean by the bet doesn't fire? UPDATE needs an unmatched bet reference in column T, it'll then check the odds against the one in column R and if different it should submit the change. Check the bet reference column to see if it holds the valid reference if it's a new bet with N appended to it it won't update it.

[vanbuuts]

I just get the message "Cancelled" in the bet ref column and the odds are not adjusted

[Captain Sensible]

Has the bet already been cancelled or is the update trigger now cancelling that bet? If you have the odds column empty it will cancel the bet, how are you entering all your bet data, by VBA or excel. I'd check the order of how you new odds etc are being entered see if there's a problem there.

[vanbuuts]

The bets are entered by formula. Basically if my bet is not matched after 5 seconds I submit "UPDATE" in the trigger column, and odds 1.01 in the odds column (to take best available).

I now get the bet ref with Bet taken or lapsed message?

[Captain Sensible]

Is the bet being cancelled though? The bet ref column would only show as cancelled if the bet's been cancelled, do you have fill/kill options on the initial bet?

[vanbuuts]

Hi, no the bet is not fill or kill or being canceled by formula.

It's not really clear how to use the Update function.

Does the stake column need populating, does the bet time / ref cells need clearing?

[Captain Sensible]

Hi, no the bet is not fill or kill or being canceled by formula.

Why is the bet showing as cancelled in the bet ref column if it's not been cancelled? Have you checked the bet ref to see if it's valid before sending UPDATE. The program uses the bet ref in column T so I've no idea why it's reporting it as cancelled if it isn't.

[vanbuuts]

HI CS, equally confused - hence my opening question.

Possibly fixed this - just need to check an example when it occurs and report back

[vanbuuts]

Hi CS, thanks for your help. It worked by leaving the stake cell blank - I was populating with the original stake