Anyone know how to monitor exactly how prices were matched?

[spindlefish]

My Excel skills are very basic, and what I'm seeking might be a bit of a long shot - but is the following possible, and how?

I'd like to monitor whether the volume matched at a given price was as a result of backers accepting the existing best 'available to back' price, or as a result of layers accepting the best 'available to lay' price?

Ideally I'd like to have an Excel sheet showing something like this:

BACK LAY FACTOR
8.2 £1288 £644 2
8.4 £1125 £1189 0
8.6 £921 £2759 -3

.....so the above would show that at 8.2, twice as much was matched because backers reached out to accept 'available to lay' prices, and at 8.6, three times as much was matched by backers accepting 'available to lay' money. The 8.4 price was pretty evenly matched.

Hope someone gets my drift and can help!

(Apologies, but the formatting of my little table above is a bit messed up and I don't know how to fix it)

[doris_day]

Yes, that's something which quite a lot of people like the idea of and I had developed for me as part of another app some years ago. There are caveats however as the decision to place it in the Back or Lay column is based on the position of the Last Traded Price. So, if the current prices are 8.2/8.4 and you know the Last Traded Price was 8.2 at a Volume of 100, then you'd place 100 in the Back column and so on. The difficulty occurs when there is limited volume and prices move around a lot and so quite often the volumes get put into the wrong column. But the information is somewhat useful.
I suggest you PM user osknows whom I'm sure will be able to throw an excel file together for you.

[spindlefish]

Thanks for the reply doris. I don't actually need a triggered bet - just the information as to whether each price was traded passively or aggressively, and in what ratio.

My last paragraph was written all wrong. It should read "......three times as much was matched by layers accepting 'available to back' money. "

D'oh!

[doris_day]

Sure but os could put an informational excel file together for you without any triggers. You'd need the excel file in order to extract the data you need.