A brokerage house gives rebate to our clients on a trade to trade basis. So the rebate is a very flexible number that business team always needs to change. Normally they are already customized in the front office stream, and flow into the settlement system automatically. However, frequently, settlement team is asked to change the rebate after a trade is booked.
Changing of rebate for one or two trades can be done from the front-end web screen, where user locate the trade by reference, browse to the rebate tab, amend the value and save it. But to change a few tens or hundreds trades in this way is frustrating.
We provide a Excel solution for users to read the current rebate, change it to new, generate an upload-able rebate file, and upload it into the settlement system to change rebate in bulk.