Stored Value Export

[tommyc333]

Hi - I'm have a question regarding SV exports that hopefully someone else will have encountered.

I've created some stored values which I will use to calculate profitability and other things for my automation.

The problem I've got is that when certain selections don't store values the columns in the export don't maintain their 'order'.

Please see the attached snip. My Rankx-PL SVs are not all in column H. The selection which happened to have a bet matched has a different SV in column H and the Rankx-PL SV is in column L.

I want to process these files and combine with the Market-PL reports using Power Query or Python and it's going to cause me issues if the columns are not consistent.

I hope this makes sense!

Thanks
Tom

[tommyc333]

I've managed to find a workaround for this in case it helps anybody else - the functionality appears to be to arrange the columns in alphabetical order, so in the case of SVs that can have no value, if the SV name comes before others alphabetically, these will populate columns before others.

I've not explained that hugely well, but essentially, I've appended a 'z' to the start of the SV name and it forces it to the right of my other columns, keeping them in order.

I've not tried it with digits, but these would probably also work!