Search for an answer or browse help topics to create a ticket
View all categories

When I downloaded my order book from Kite, instead of showing quanity, it is showing a date. Why is it so?

When you download your order book from Kite, the orderbook gets downloaded in excel format.


For example, if you have placed a single order and the same gets filled, ideally, the entry should show 1/1 (order quantity filled/ order quantity given). But, the excel reads 1/1 in date format, due to which you see 01-Jan in your order book. Similarly, if the maximum number of orders you have placed and the orders filled are within 12, then you will see the same as dates. 


Alternatively, you can open the orderbook file in Notepad/Notepad++, where you wouldn’t have this issue.