can you post the formula you are using ?



KennyG wrote:
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

--
Matt Lynn

Message posted via http://www.officekb.com