Sir, I have sold some Index options on Friday. My "positions" box, when I view on kite, correctly shows these positions that I am currently holding. But when I use Excel "GetPositions" procedure, the dashboard sheet doesn't show these positions. Therefore, I am unable to make queries in my algo about these position that I am holding. I have to manually check if I am still holding these positions because these positions do not exist for my algorithm. Please help. -DCK
The 'GetPositions' function accepts a parameter named 'mode' where you can specify whether you want to return 'Day' or 'Net' positions, default is 'Day'.
In your GetPositions UDF, change the line 'Str = Kite.GetPositions' to 'Str = Kite.GetPositions("Net")'
The 'GetPositions' function accepts a parameter named 'mode' where you can specify whether you want to return 'Day' or 'Net' positions, default is 'Day'.
In your GetPositions UDF, change the line 'Str = Kite.GetPositions' to 'Str = Kite.GetPositions("Net")'