Profit & Loss excel

[dixiedean]

Hi

Can anyone help me with a formula for profit & loss in excel? If i sum all the results in the results sheet column D generated from BA it never adds up to what betfair balance is? I thought the results would show exactly what i had won or lost less commission taken is that not the case?

Any help greatly appreciated.

Regards

H

[osknows]

Hello,

Unless things have changed recently, I don't think BA adjusts the results for commission in the results sheet; you would need to calculate this yourself. It's not as straight forward as applying commission to every winner. You have to apply commission to the net profit for individual markets.

Other complications may include commission changes and premium/data charges.

Regards
Os