We are facing certain issues in our project for which we require you guideline, our project is as follows:
About our project :
Trade Tracking System of Angel Broking
We are trying to track the trades of client of Angel broking on the situations like Auctions, penalty and so on..
Scenerio:
BSE every evening provides a BO file (Order log file), which is the merged file of all trades (Executed or not executed) done in or by Angel Broking's Client or by Angel Broking traders. So here we are trying to form a system where in if a Manger of any higher Authority wants to fetch a details of particular client as a whole details from particular date wise or trade wise then he should be able to just put in the client code( or UCC code) and get all the details till the date or trades specified.
For which we have generated 4 buckets till now and we are stuck up at what else should be there in regards to buckets.
PFA, the excel sheet APP.xlsx , BO file.txt, and also the explanation sheet of BO file fields (Segregartion of BO file.xlsx)