DIFFERING_MARKETS

[excelhasey]

I am trying to trigger bets on more than one selection in a field, but it managed to place one bet and the others had a message "DIFFERING_MARKETS" - Any idea what this is referring to ??

[GaryRussell]

Are you sure the stake and odds columns are filled in correctly before the trigger column? If the first selection has 0 in the stake then you will get this error.

[excelhasey]

Good morning Gary,

The stake and odds boxes should be filled in, but it all happens so fast !!!

The odds are taken from F5:F50 cell range i.e. R5 is populated with F5, R6 with F6 etc as you would expect and the stake taken from sheet 3 of my worksheet which has some criteria on.

Now the stake could change depending on the odds fluctuating, as they do, but I assumed Excel would take a snapshot of the figure and populate it in the correct cell (column "S") and that it wouldn't matter if it isn't fixed on sheet 3. It obviously populates the odds column and manages to fire in a request for what ever odds you ask for when it is met in the market - So shouldn't the same apply to the stake column - No ??

If the stake has to be a rigid number then why does it manage to fire off one bet request which gets matched but not the others ??

I have no limiter to say when bets placed equals "x", then no more bets etc, so in theory all selections could be triggered.

Is it possible in Excel to take something like my fluctuating stake at some point (maybe time based or maybe when the odds become low or high enough to meet your criteria) to then place that data into another cell (say 'AZ5'), but fix it i.e. if its 4.3 in the 'F5' cell then the new cell ('AZ5') says 4.3 and stays fixed whilst the original odds cell still bounces about as it does ??

I am new to Gruss but I have to say the programme and support is fantastic, I am sure others will have already told you that, but fair play to you, you are doing a great job and deserve a respectful pat on the back mate.

That said I have always convinced myself that all I needed was something like this and I could make a regular few bob, now I have it I am reducing my testing bank regularly - hmmm I am obviously missing something - Anyway keep up the good work

Cheers

[GaryRussell]

Now the stake could change depending on the odds fluctuating, as they do, but I assumed Excel would take a snapshot of the figure and populate it in the correct cell (column "S") and that it wouldn't matter if it isn't fixed on sheet 3. It obviously populates the odds column and manages to fire in a request for what ever odds you ask for when it is met in the market - So shouldn't the same apply to the stake column - No ??

The same does apply. The stake doesn't have to be fixed. Are you sure the stake calculated is always £0.01 or more?

If the stake has to be a rigid number then why does it manage to fire off one bet request which gets matched but not the others ??

It places the bets in batches of 15 if any of the stakes are below minimum. One batch could still work if there was a problem with the other. Did 15 selections have the error message?

Is it possible in Excel to take something like my fluctuating stake at some point (maybe time based or maybe when the odds become low or high enough to meet your criteria) to then place that data into another cell (say 'AZ5'), but fix it i.e. if its 4.3 in the 'F5' cell then the new cell ('AZ5') says 4.3 and stays fixed whilst the original odds cell still bounces about as it does ??

There shouldn't be a need to do this as fixing the stake is not the solution to your problem.

Check how you are calculating the stake. Could it ever be calculated as zero? The only way I can replicate the DIFFERING_MARKETS error is if one of the selections has a zero stake.

[excelhasey]

I suppose it could be zero or "", now you have me thinking about it if the odds change dramatically very quickly. This is not what I had intended but if the odds change for a particular selection which takes it outside the set criteria then the stake would be withdrawn, so yes I suppose with the speed of In Play this might occur - I will try and tweak to ensure it is always above zero, if I can, and give it a whirl.

But in the meantime as per my previous post "Is it possible in Excel to take something like my fluctuating stake at some point (maybe time based or maybe when the odds become low or high enough to meet your criteria) to then place that data into another cell (say 'AZ5'), but fix it i.e. if its 4.3 in the 'F5' cell then the new cell ('AZ5') says 4.3 and stays fixed whilst the original odds cell still bounces about as it does ??" - do you think ??

Thanks

[GaryRussell]

But in the meantime as per my previous post "Is it possible in Excel to take something like my fluctuating stake at some point (maybe time based or maybe when the odds become low or high enough to meet your criteria) to then place that data into another cell (say 'AZ5'), but fix it i.e. if its 4.3 in the 'F5' cell then the new cell ('AZ5') says 4.3 and stays fixed whilst the original odds cell still bounces about as it does ??" - do you think ??

Only by using VBA code, it can't be done with a formula.