I am a day trader doing trading system research.

I can't get a formula to work out on both sides for a positive result

=IF(OR(D2,1),(H2-E2),IF(OR(D2,2),(E2-H2)))

I would also like 'D' to calculate based on it's letter entry, B/S
=IF(OR(D2,B),(H2-E2),IF(OR(D2,S),(E2-H2)))

D E F G H
I
B/S Entry Drawdown Ticks Hi/Lo Ticks
S 1357 1357.75 0.75 1355 -2.00
B 1354 1357 3.00 1358 4.00

Is this what you want:

=IF(OR(D2="B"),(H2-E2),IF(OR(D2="S"),(E2-H2)))


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45752

Yes, thanks! that did the trick. I may have more...
--
DTrader


"JBeaucaire" wrote:


Is this what you want:

=IF(OR(D2="B"),(H2-E2),IF(OR(D2="S"),(E2-H2)))


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45752

A little more help please?


=IF(OR(I2=6,"BE"),IF(OR(I26,6),IF(OR(I2<6,0)
--
DTrader


"JBeaucaire" wrote:


Is this what you want:

=IF(OR(D2="B"),(H2-E2),IF(OR(D2="S"),(E2-H2)))


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45752

=IF(OR(I2=6,"BE"),IF(OR(I26,6),IF(OR(I2<6,0)

Try it as: =IF(I2<6,0,IF(I2=6,"BE",6))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:65
xdemechanik
---

What to give this a shot?

=IF(I2<6,-8)*IF(I2=6,-4,)*IF(I2=7,-4)*IF(I2=8,"BE")
--
DTrader


"Max" wrote:

=IF(OR(I2=6,"BE"),IF(OR(I26,6),IF(OR(I2<6,0)

Try it as: =IF(I2<6,0,IF(I2=6,"BE",6))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:65
xdemechanik
---

"DTrader" wrote:
=IF(I2<6,-8)*IF(I2=6,-4,)*IF(I2=7,-4)*IF(I2=8,"BE")

Try: =VLOOKUP(I2,{0,-8;6,-4;8,"BE"},2)

Suggest that you post formula queries in .worksheet.functions,
which is a more appropriate group
Keep it to one specific query per new post
Put in as many (new) posts as you may have specific queries (don't continue
asking new queries in the same thread after your original query has been
answered)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---