COM Refresh rate

[ganna76]

3 questions from an extremely long term user:

(1) How often do the prices in Excel get refreshed? If I have the grid set to full steam during a horse race, I can see refreshes happening at intervals as low as 50 millliseconds. Does this mean Excel is updated at the same rate?

(2) Regarding cross matching / synthetic prices (i believe these are bdatl and bdatb)... are these prices shown in the grid interface and / or the ladder interface during horse racing in-play?

(3) Lastly, by default the grid seems to show minimum £2 stakes, so an available stake of, say £1.50 won't be shown on the grid. Is that right? Is there any way to change that so it shows any amount, no matter how small?

[GaryRussell]

(1) How often do the prices in Excel get refreshed? If I have the grid set to full steam during a horse race, I can see refreshes happening at intervals as low as 50 millliseconds. Does this mean Excel is updated at the same rate?

It updates Excel as frequently as it can. Updating Excel through it's COM interface carries an overhead so it depends on your PC's speed and how many markets and selections are being updated. It may skip Excel refreshes to prevent them backing up in a queue. I can not make any guarantees on how many refreshes you will get.

(2) Regarding cross matching / synthetic prices (i believe these are bdatl and bdatb)... are these prices shown in the grid interface and / or the ladder interface during horse racing in-play?

Make sure you have ticked Show Cross Matched Prices and unticked Apply cross matching formula in recognised markets in general preferences and it will display these prices.

(3) Lastly, by default the grid seems to show minimum £2 stakes, so an available stake of, say £1.50 won't be shown on the grid. Is that right? Is there any way to change that so it shows any amount, no matter how small?

If price streaming is enabled it displays as low as £1 and this is not configurable. You can set the number of decimal places to display in grid preferences. If it's set to zero places then it's rounded down to nearest £1 eg. £1.50 and £1.90 are rounded down to £1.

If you disable price streaming and tick Do not roll up stakes when streaming disabled in general preferences then it will display any amount down to £0.01 on the grid. If the decimal places on the grid is zero anything below £1 is rounded up to £1 so it's recommended to set the decimal places to 2. The ladder does not display decimal places and anything below £0.50 will not display and anything above £0.51 is displayed as £1.

[Drunkenight]

'Make sure you have ticked Show Cross Matched Prices and unticked Apply cross matching formula in recognised markets in general preferences and it will display these prices.' - That is interesting.
I have always had 'Show Cross Matched Prices' and 'Apply Cross Matching Formula in Recognised Markets' both ticked. Please can you let me know what the difference should be? Thanks

[GaryRussell]

'Make sure you have ticked Show Cross Matched Prices and unticked Apply cross matching formula in recognised markets in general preferences and it will display these prices.' - That is interesting.
I have always had 'Show Cross Matched Prices' and 'Apply Cross Matching Formula in Recognised Markets' both ticked. Please can you let me know what the difference should be? Thanks

This fetches the non virtual prices from the API and Betting Assistant does the calculation to create the virtual prices itself. You will still see the same virtual prices.

[Drunkenight]

OK. Thanks Gary. So does that mean that by having both ticked we are effectively doing the same job twice?
Does it mean that I am using resources that I don't need to use and possibly slowing my systems down?

Any help will be gratefully received.