Cymatic Trader Community

[henit]

Hi,

I am new to using excel in trading. Is it easy to create "BACK" & "LAY" buttons in excel or needed lots of programming knowledge? Any example how to create "back" or "lay" button?

Thanks,
Henit.

[Gavin]

Hi Henit,

It isn't very difficult. You create the buttons using the Developer tab in Excel, then program them so that each button's Click event puts your desired command into the cells in the command columns which Cymatic responds to.

There is plenty of information on the internet about how to create buttons in Excel. After you've learnt that, you could try googling how to use Visual Basic to put a value into a cell.

Kind regards,

Gavin

[svilen13]

I am also new to VB. But I understood the easiest command for a button:

Code: Select all

Private Sub CommandButton1_Click()
   Range("BA8") = "Back"
   Range("BD8").ClearContents
End Sub[

Cell BB8 - your odds
Cell BC8 - your stake
These cells can be filled by taking values from other cells or calculated wishes.

[Gavin]

Hi svilen13,

Thank you for helping, it looks good.

Kind regards,

Gavin