I want my VBA to:
- Login into Zerodha kite account.
- Integrate API.
- Then download the live data from there and after analysing the data, it should upload data for buy or sell option.
I tried to log on to Zerodha account, but it is just refusing my request, so I can't do anything.
Sub Test()
Set ie = CreateObject("InternetExplorer.application")
ie.Visible = True
ie.Navigate ("https://https://kite.zerodha.com/" & ActiveCell)
Do
If ie.ReadyState = 4 Then
ie.Visible = False
Exit Do
Else
DoEvents
End If
Loop
ie.Document.Forms(0).all("User").Value = "aaa"
ie.Document.Forms(0).all("Password").Value = "bbbb"
ie.Document.Forms(0).submit
End Sub
I want that I should be able to integrate zerodha API then download the live data from there in I2 and after certain calculation I want the price of J2 to be uploaded for buy or sell signal.