VBA to login in zerodha account and then download

2020-05-06 10:14发布

I want my VBA to:

  1. Login into Zerodha kite account.
  2. Integrate API.
  3. 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.

0条回答
登录 后发表回答