Quote:
|
Originally Posted by FXCM Help
The Time has now been added into the Order2GoDDE application and source files. Please re-download the file in the original post.
The format is included in the excel file provided, but will be in the form of:
"=O2GDDE|Time!EURUSD"
|
If the DDE server function of Time! is not working for you - as is often the case, unfortunately, it is useful to know that your computer clock can do the job instead.
>the worksheet formula is =NOW()
the computer clock can thereby raise an Event in a Calculate Event macro, and the included procedure run as required e.g.to update a cell or indicator that will ultimately generate a trading order
to avoid raising the Event on every tick of the clock, you can insert a "trigger sheet" that will be selective of the Calculate Event; I also found it necessary to turn off the higher than worksheet event chain as follows:
Private Sub Worksheet_Calculate()
Application.EnableEvents = False
'run your required procedure here
Application.EnableEvents = True
End Sub
NB Event macros must reside within the relevant sheet module itself (VBA Editor) or they won't function.
