I have a formula problem that I can't figure out

[KennyG]

I have a trading journal that I'm trying to design and use a money management
setup in it. It is supposed to look to see how many trades that the money
management part says could be put on, open at a given time, then if that test
is met then it calculates the available number of stocks / option contracts
that could be placed with a set amount of money. The problem that I'm having
is when the test comes out negative, all of the cells in the calculation
column all return "no trade", Is there a formula that I'm missing that will
just give the results on that row insteat of the full 3700 rows in that
column?
Here is a screen shot of a test page:

$256.75 stock Open
option Closed
4



Stock / Calc $ Formula counting total
Option # Amount cell cells trades
a option 2 $1.25 2 Closed 0 1
b option 1 $1.95 1 Closed 0 1
c stock 3 $95.00 3 Closed 0 1
d stock 3 $75.00 3 Open 1 1
e option 4 $0.65 4 Closed 0 1
f stock 4 $65.00 4 Open 1 1
g option 3 $0.95 3 Closed 0 1
h stock 3 $78.00 3 Open 1 1
no trade $0.35 no trade Open
3 8


Any help would be greatly appreciated

 

[Mattlynn via OfficeKB.com]

can you post the formula you are using ?

I have a trading journal that I'm trying to design and use a money management
setup in it. It is supposed to look to see how many trades that the money
management part says could be put on, open at a given time, then if that test
is met then it calculates the available number of stocks / option contracts
that could be placed with a set amount of money. The problem that I'm having
is when the test comes out negative, all of the cells in the calculation
column all return "no trade", Is there a formula that I'm missing that will
just give the results on that row insteat of the full 3700 rows in that
column?
Here is a screen shot of a test page:

$256.75 stock Open
option Closed
4



Stock / Calc $ Formula counting total
Option # Amount cell cells trades
a option 2 $1.25 2 Closed 0 1
b option 1 $1.95 1 Closed 0 1
c stock 3 $95.00 3 Closed 0 1
d stock 3 $75.00 3 Open 1 1
e option 4 $0.65 4 Closed 0 1
f stock 4 $65.00 4 Open 1 1
g option 3 $0.95 3 Closed 0 1
h stock 3 $78.00 3 Open 1 1
no trade $0.35 no trade Open
3 8

Any help would be greatly appreciated

 

[KennyG]

can you post the formula you are using ?

I have a trading journal that I'm trying to design and use a money management
setup in it. It is supposed to look to see how many trades that the money

[quoted text clipped - 27 lines]

Any help would be greatly appreciated

These are the two main ones that I've tried lately, the if(not one checks to
see if a trade is available to take or not
IF(NOT($I$18>L9),G9,"No Trade")

This one is the one that decides what the calculation will be, If I try to
use this one alone I either get FALSE or a column of zeros
IF($I$18<=L9,IF(D9="stock",$A$1/F9,IF(D9="option",$A$1/(F9*100),IF($I$18>L9,
"0","no trade"))))

I've tried about every formula that I could find to try and get this to work.
What I need is if it dosen't meet the criteria of the money management part
to show No Trade.