Excel bet placement error

[ians1711]

This was reported once before on the Correct Score market. The resolution doesn't apply to me. Trying to place a LAY on the Any Unquoted market. Diagnostic.txt shows:

17:35:25:415: Error logging bet ref(s) after bet placement. System.InvalidCastException: Conversion from string "Any Unquoted " to type 'Date' is not valid.
at Microsoft.VisualBasic.CompilerServices.Conversions.ToDate(String Value)
at Microsoft.VisualBasic.CompilerServices.Operators.CompareObject2(Object Left, Object Right, Boolean TextCompare)
at Microsoft.VisualBasic.CompilerServices.Operators.ConditionalCompareObjectEqual(Object Left, Object Right, Boolean TextCompare)
at Betting_Assistant.Excel.logLatestRefsImmediate()

[ians1711]

OK think I have found the reason but not the cause. Cell A21 among others was expecting a date format - when I changed the format to text it was OK.

So how does BA specify the cell format of the stuff it copies over - in this case the Selection Name column???

[MarkRussell]

Hi,

It doesn't specify a format.

Excel sometimes assumes a format and gets it wrong.

Formatting the column to text is the way to correct the problem.

Regards,
Mark

[ians1711]

Thanks Mark