Stop Button

[chopper]

Hello,

I'm new to Gruss and plan to start using it for automated trading from excel in the new year.

If I'm in a situation where I need to stop everything suddenly (eg if my position looks wrong or something strange happens in the market) is there a way to do this in one-click?

If not I was thinking I could have a button that if pressed populates the adjacent cell with 'Stop' and then I could have an IF statement which ensures I trade no further. Or maybe someone has a better idea for achieving this?

Would someone mind telling me how I can write a macro that populates a cell with text when a button is pressed and removes this text when the button is pressed again.

Thanks for any help.

[jokerjoe]

To stop everything manually, you'd have to unlink the sheets (Excel menu > Log current prices). You can then green up in one click.

For the button solution you create a button on the sheet, link the button press event to a macro. Said macro changes cell value or formula as desired. Not difficult if you already know VBA.

Actually it's prob easier to just create a checkbox, link that to a cell and that then automatically changes the cell value TRUE/FALSE, no VBA required.

[osknows]

There are many ways to do this depending on how your excel formulas are set up but perhaps the easiest option is to set your bank or stake to zero

You can then record 2 macros, one to set your stake to zero and another to reset. Assign the macros to either a control button or a keyboard short cut such as Ctr+Q

[alrodopial]

automated trading from excel

The easiest way to start/stop this is to fire a macro that disables / enables the events in your sheet.

Code: Select all

Sub ENABLE()
    Application.EnableEvents = True
End Sub

Sub DISABLE()
    Application.EnableEvents = False
End Su