Hi,
After reading this full thread, i tried playing with Nest (Zerodha), Excel Macros and placing orders.
I logged in to Zerodha, launched Nest Plus.
Then i opened excel, created a macro as below and ran this macro from excel sheet.
Sub TestIE()
Set plusObject = CreateObject("nest.plusapi")
plusObject.SetObjectName ("DryRun")
plusObject.PlaceOrder("BUY", "OrderNo_1", "NSE", "HINDALCO-EQ", "DAY", "LIMIT", 1, 100.15, 0, 1, "NRML", "RGxxx-13906") = 1
End Sub
When i run the above macro, in my Zerodha Nest Trader software i get message saying ObjectName not set SetObjectName is not called.
However, the macro code above sets objectName.
Any help?