Conflation

[RobOrBob]

Hi all,

I'm trying to smooth the prices pushed into an Excel workbook. Sudden spikes can have unfortunate consequences!

I have 'Price Streaming' ticked.

If I have 'Full Stream' unticked (with 'Auto' ticked) and use a 'Refresh' of, say, 0.2 (200ms) does that mean that whatever the prices are (approximately) 200ms since the last these are the ones Excel receives?

If I have 'Full Stream' ticked (with 'Auto' ticked) plus Options>Preferences>Throttling>Conflation ms set to 200 does this mean that whatever the prices have been in the last 200ms since the last are aggregated and this is what Excel receives? Full stream gives me an AR of 25-50ms so I'm hoping that with potentially 4-8 sets of prices this should help smooth the spikes.

Or have I completely misunderstood!

Regards,

Gordon

[GaryRussell]

If I have 'Full Stream' unticked (with 'Auto' ticked) and use a 'Refresh' of, say, 0.2 (200ms) does that mean that whatever the prices are (approximately) 200ms since the last these are the ones Excel receives?

The streamed prices will be updated up to every 20ms in the background into a cache. The prices will be read from this cache every 200ms and excel updated. This is providing the conflation is 0.

If I have 'Full Stream' ticked (with 'Auto' ticked) plus Options>Preferences>Throttling>Conflation ms set to 200 does this mean that whatever the prices have been in the last 200ms since the last are aggregated and this is what Excel receives? Full stream gives me an AR of 25-50ms so I'm hoping that with potentially 4-8 sets of prices this should help smooth the spikes.

This is correct. Betfair will push the prices update every 200ms with all in between updates aggregated. Immediately after this update Excel will be updated.

[RobOrBob]

Thanks Gary!