Cymatic Trader Community

[Jamesuesername]

Is it possible for Cymatic/Excel to work with two command boxes for triggers, one command cell for lay bets and one for Back bets?
I'm trying to fire in both a back and a lay bet at the same time. Sort of a scalp without having to use the offset feature.

Is it something that could be added?

Thanks in advance.

[Gavin]

Hi. If using only one spreadsheet then only one order at a time can be sent for each selection.

You could consider using two spreadsheets, one to send the back and the other to send the lay bets. You'd need to open the market twice (in two grids). To open additional grids, right click the market name in the navigator and choose 'New Grid'. Connect both grid to separate instances of Excel, not the same spreadsheet file.

Alternatively it might be possible to do it using just one spreadsheet by writing some programming code in Excel's Visual Basic Editor, to automatically send the two orders one after the other, but obviously still not at the same time. You'd need to ensure that the second order is not sent until the first order has finished being submitted.

Kind regards,

Gavin

[Jamesuesername]

thanks for the reply.

I've been messing with VBA but cant develop a code which will clear the status without milking the account, (I have only picked up VBA recently, so I'm not great with it).

Code: Select all

     Private Sub Worksheet_Change(ByVal Target As Range)

     Dim P As String, L As String, B As String
     
     L = "LAY"
     P = "PLACED"
If Range("BD9") = P And Range("BA9") = L Then
          Range("BD9").ClearContents
     End If

           End Sub


That's what I have in VBE, along with formulae in the command cell for the back trigger.

Do you or anyone have a code for clearing the status, with out it milking the account?

Is the two grid method possible with autopilot?

[Gavin]

You need to use the INTERSECT command in your Excel Visual Basic code.

Please see here:

Clearing the status cells

and here is an example of using the INTERSECT command to determine which cells have changed:

Using the intersect command

Yes, you can have a separate autopilot in each instance of Cymatic.

Kind regards,

Gavin

[Jamesuesername]

Thanks but the application will no longer start, I've tried re-installing but i'm still getting the same error message.

Code: Select all

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.ArgumentOutOfRangeException: Value of '100028914.99' is not valid for 'Value'. 'Value' should be between 'Minimum' and 'Maximum'.
Parameter name: Value
   at System.Windows.Forms.NumericUpDown.set_Value(Decimal value)
   at CyTraderBF.FormLoginOptions..ctor(BF_FormMain p_BF_FormMain, Decimal p_demoAccountFundsAvailable, Boolean p_loginStandardMethod)
   at CyTraderBF.BF_FormMain.()
   at CyTraderBF.BF_FormMain.(Object , EventArgs )
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3163.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3151.0 built by: NET472REL1LAST_B
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
CyTraderBF
    Assembly Version: 6.4.4.0
    Win32 Version: 6.4.4.0
    CodeBase: file:///C:/Users/Jquee/AppData/Local/Apps/2.0/ZR6LLDO7.RA5/VYYYLO76.KX8/cytr..tion_e95a99aca2c10e1b_0001.0000_95a43d831a51b044/CyTraderBF.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3056.0 built by: NET472REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
CymaticTraderBetfair
    Assembly Version: 6.4.4.0
    Win32 Version: 6.4.4.0
    CodeBase: file:///C:/Users/Jquee/AppData/Local/Apps/2.0/ZR6LLDO7.RA5/VYYYLO76.KX8/cytr..tion_e95a99aca2c10e1b_0001.0000_95a43d831a51b044/CyTraderBF.exe
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3056.0 built by: NET472REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
BetfairApiWrapperClassLibrary_NG
    Assembly Version: 1.0.3.0
    Win32 Version: 6.4.4.0
    CodeBase: file:///C:/Users/Jquee/AppData/Local/Apps/2.0/ZR6LLDO7.RA5/VYYYLO76.KX8/cytr..tion_e95a99aca2c10e1b_0001.0000_95a43d831a51b044/CyTraderBF.exe
----------------------------------------
System.Data
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3160.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3160.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
CymaticClassLibrary
    Assembly Version: 1.3.0.0
    Win32 Version: 6.4.4.0
    CodeBase: file:///C:/Users/Jquee/AppData/Local/Apps/2.0/ZR6LLDO7.RA5/VYYYLO76.KX8/cytr..tion_e95a99aca2c10e1b_0001.0000_95a43d831a51b044/CyTraderBF.exe
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3056.0 built by: NET472REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3056.0 built by: NET472REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3056.0 built by: NET472REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Transactions
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3056.0 built by: NET472REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Microsoft.GeneratedCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.7.3056.0 built by: NET472REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Security
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3101.0 built by: NET472REL1LAST_B
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Security/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Security.dll
----------------------------------------
System.Web.Services
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3056.0 built by: NET472REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Web.Services/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
----------------------------------------
Newtonsoft.Json
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.3.19514
    CodeBase: file:///C:/Users/Jquee/AppData/Local/Apps/2.0/ZR6LLDO7.RA5/VYYYLO76.KX8/cytr..tion_e95a99aca2c10e1b_0001.0000_95a43d831a51b044/Newtonsoft.Json.DLL
----------------------------------------
System.ServiceModel
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3160.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll
----------------------------------------
System.Runtime.Serialization
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3160.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll
----------------------------------------
System.Management
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3056.0 built by: NET472REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Management/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Management.dll
----------------------------------------
System.ServiceModel.Internals
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3160.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Internals/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Internals.dll
----------------------------------------
SMDiagnostics
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3160.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll
----------------------------------------
System.IdentityModel
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3160.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.IdentityModel/v4.0_4.0.0.0__b77a5c561934e089/System.IdentityModel.dll
----------------------------------------
System.ServiceModel.Web
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3056.0 built by: NET472REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Web/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Web.dll
----------------------------------------
System.Net.Http
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3056.0 built by: NET472REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Net.Http/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Net.Http.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

[Gavin]

Hi and thanks for letting me know.

It sounds like you've accidentally got a very large demo balance in the Login Options windows (where you can normally edit the demo balance when you open the software). I apologise if this is stopping you opening the software.

The simplest way to solve it is to uninstall the software and then delete the contents of the following directory (unfortunately this will also delete any settings that you saved as default, such as custom stakes, colours, API refresh settings, etc):

(replace USERNAME with your actual username on your PC)
C:\Users\USERNAME\AppData\Local\Apps\2.0

for example if your username on your PC is James, then delete all the content of this folder
C:\users\James\AppData\Local\Apps\2.0

Doing that won't delete any custom ladder layout or chart layout files. They will still exist, but the software won't point to any of them. So if you have a default ladder or chart file that you want to start using as default again, you can just load it in the ladder or chart and save it as default again.

Please do not hesitate to ask if you need any further assistance.

Kind regards,

Gavin

[Jamesuesername]

Thanks.