% target for the day

[christine]

Hi all, I'm thinking about introducing a '% target' for the day to one of my systems that uses the Lay_Favourite Excel spreadsheet (like the one that appears in the Place_Bets_liability spreadsheet). However I've tried to copy it across from that spreadsheet, but cannot get the formula to pull through properly. Could anyone advise me how to correctly incorporate this? Many thanks as always, Christine

[osknows]

Hi Christine,

Without seeing the formula it's difficult to help

In general I have used IF statements to test if the target profit has been met, eg

=IF(CURRENT_BANK >= TARGET_PROFIT, 0, NORMAL_STAKE) which

would actually look something like this with real cell references
=IF(N$2>=M$2*(1+O$2),0,5)

(if the bank in cell N2 is greater than or equal the starting bank in M2 plus the targey profit then set stake to 0 otherwise set to 5). The $ means the cell number won't increment when you drag down the formula

You can then nest IF statements inside each other using the same principle

=IF(CURRENT_BANK >= TARGET_PROFIT, 0, IF(CURRENT_BANK <= STOP LOSS, 0, NORMAL_STAKE))

(does the same as above but checks for loss limit)

If your still stuck send me the link to the spreadsheet and I'll have a look

Os