Hi there,
Apologise if I've posted this in the wrong section but I'm currently developing a spreadsheet that links into MFPro using TimeMachine and need it to be able to place bets through an Excel sheet as this mimics my live trading environment.
After reading through the manual the following code is recommended for Excel to communicate with MFPro:
Sub Back(marketID As Long, selectionID As Long, price As Double, amount
As Double, handicapID as Long)
Dim feed As Integer
Dim data As String
feed = Application.DDEInitiate("FEEDER7", "betting")
If feed > 0 Then
data = "back/" & marketID & "/" & selectionID & "/" & price & "/" &
amount & "/" & handicapID
Range("AB1000") = data
Application.DDEPoke feed, "bet", Range("AB1000")
End If
End Sub
However when testing the "feed = Application.DDEInitiate("FEEDER7", "betting")" causes both excel and MFPro to hang and I have to restart both applications and cannot get any further. I've checked on the help forum and cannot see any conclusive posts on how to fix this issue other than another user has had the same thing happen.
Can anyone advise on how I can fix this as I desperately need to get this working in order to fully implement my test trading environment. Alternatively is there another way of sending basic Back, Lay, Cancel and GreenUp commands to MFP through a button click in excel (possibly having MFP monitoring a hidden cells in excel and executing a command based on this)?
Any suggestions more than welcome
Many thanks
Matt