by osknows » Sun Sep 15, 2013 10:14 am
The simplest way is to monitor each market sheet and as soon as a bet reference appears then log it to another sheet with the market name. This method is also essential if you have a complex trading tool as a single bet ref may be transient.
Profit and loss is applied at the market level so you will need a formula to sum the profit for the whole market. If it's in profit, distribute the commission against the selections in profit.