FYERS API Bridge can be integrated with Excel and to Algo trade from Excel, you can code in VBA to for sending signals in FYERS API Bridge in excel. You need to create a TCP client as given below.
Read this article to understand how FYERS API Bridge works?
Important: Ensure that you change the value of the RemoteHost property to the friendly name of your computer.
Private Sub Form_Load()
' The name of the Winsock control is tcpClient.
' Note: to specify a remote host, you can use
' the IP address (ex: "127.0.0.1")
tcpClient.RemoteHost = "RemoteComputerName"
tcpClient.RemotePort = 30001
End Sub
Private Sub cmdConnect_Click()
' Invoke the Connect method to initiate a
' connection.
tcpClient.Connect
End Sub
Private Sub txtSend_Change()
tcpClient.SendData txtSend.Text
End Sub
Private Sub tcpClient_DataArrival _
(ByVal bytesTotal As Long)
Dim strData As String
tcpClient.GetData strData
txtOutput.Text = strData
End Sub
Example String to send to the port -“9”, “LE”,”SBIN”,”L”,””,”290″,”7″,”EQ”,””