|
|
To advertise on these forums, e-mail us. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
Excell Help Please
Can one of you expert excell gurus please help me with the following.
I am trying to put the retirement staking plan on excell. I have as a primary target $600 (divsor 6 thus min bet $100) I have this in col C. In colD I have my losses. This is from col M which is the profit and loss col. Thus my formula in col D is =-M4. ColE is the total of colC +ColD formula =C5+C5. At present this offsets all profit and losses in colM into my total target instead of the desired stop when previous losses are recouped. My formula for col D should in fact be =-M4 if <0 use 0. How I can I effect this I've played with it for hours and I concede defeat The computor has been saved two inches from the floor several times. I thank you in advance Regards Beton |
#2
|
|||
|
|||
OOps just had another look at this. It is col E that this should occur thus it should have the formula =C4+D4 if <600 use 600 Again how can I achieve this?
Thanks again Beton |
#3
|
|||
|
|||
Beton, I don't know if it will help but in an old post there is a copy of this staking plan, which is on an Excel spreadsheet.
I shall go back thru for you and see if I can find it if you like.
__________________
Jose'. |
#4
|
|||
|
|||
Quote:
If your system produces the odd long run of outs then maybe another type of staking plan is better. As I said drop me a line and I will send a few different ones for you to peruse. Regards Zlotti Last edited by Zlotti : 24th June 2005 at 07:49 PM. Reason: Update |
#5
|
|||
|
|||
Hi Beton,
Put this formula in cell E4 =IF(C4+D4<600,600,C4+D4) Regards, Wun |
#6
|
|||
|
|||
Thanks that seems to do the trick I'll start loading my data tommorrow
regards Beton |
Thread Tools | Search this Thread |
Display Modes | |
|
|