Target.Columns.Count Guidance

[osknows]

Sorry for so many questions today but really getting into this now

Is anyone able to let me know how the refresh works in relation to the Target.Columns.Count?

I understand the 16 column count price refresh but I also see Target.Columns.Count with values 5 and 10 - what columns are these refreshing?

Also, what if I select additional columns in the Excel/log current prices; does this incrementally add to the 16 each refresh or is each selection handled differently on a seperate refesh?

Thank you,
Os

[GaryRussell]

The 5 column refresh is where it updates the bet ref, bet time, average matched odds, average matched stake and P&L.

I'm not sure why you are getting a 10 column count. Can you let me know what the values of Target.Row and Target.Column are for these and I will tell you what they are updating.

If you add additional columns they are updated in the same update as the 5 columns so for each additional column it will increase.

I recommend that you use the 16 column update event to make changes to the trigger column.

[osknows]

Doh! The column 10 is me passing value "U" into J2

Thank you
Os