Average Price Matched

[spreadform]

There is an option to display this column in the grid interface, and the ladder interface always includes it in the upper right. The Help file says: "Displays the average price matched based on volume matched at each price" (Home > Betting Assistant Features > Ladder Interface). That sounds like volume-weighted average price, which is what I'm looking for.

I'm trying to display this column in Excel from the grid interface but cannot find the corresponding checkbox in Additional columns (Excel > Log Current Prices). There is an "Average last matched price", but this is something completely different.

Is there a way to log this column in Excel?

[GaryRussell]

It's the exact same figure. Are you definitely seeing different values in the spreadsheet to the grid?

[spreadform]

They are similar but not the same, Gary.

[spreadform]

See Excel log file and BA screenshot attached. The prices in question are highlighted in red in the log file (last column was added manually). The prices are definitely not the same.

[GaryRussell]

Am I missing something? I cannot see the average last price matched as output in additional columns in the screenshot. Is it the two highlighted columns you are comparing? One is just the last price matched, not average. Additional columns are output starting at column Y.

[spreadform]

I have "SP" and "Average last matched price" checked in the "Additional columns" list of the "Excel - log current prices" dialog box (Excel > Log Current Prices). Column X is all zeros, and each cell in column Y and Z contain a single space character (" "). Everything else is blank.

[GaryRussell]

I have "SP" and "Average last matched price" checked in the "Additional columns" list of the "Excel - log current prices" dialog box (Excel > Log Current Prices). Column X is all zeros, and each cell in column Y and Z contain a single space character (" "). Everything else is blank.

Due to the way additional columns were implemented they are only available if triggered betting is enabled. Is enabled triggered betting ticked when you select log current prices?

[spreadform]

Not currently, Gary, as I'm only trying to get prices now. But you are right, as soon as I enable triggered betting, the columns start populating. Everything looks good now, the captured "Average last matched price" data in Excel matches "Average Price Matched" shown in the software. Thanks for your help!