Formula conversion - Aussie Stock Forums

1. ## Formula conversion

I have some Boolean Formula (not written by me I have no idea how to) that I wish to convert to use in Metastock. Does anyone have any suggestions or ideas? Thanks a million!

2. ## Re: Formula conversion

Post it up and will have a go if its not too complicated. Actually post just a portion of it to get me started.

3. ## Re: Formula conversion

RSI3<RSI3.20-2*SQR(ABS(RSI3.1.^2 + RSI3.1.1 ^ 2 + RSI3.12 ^ 2

is the first line

4. ## Re: Formula conversion

Looks like my ability to read Boolean is on par with my French...

Do you know what it is in English?

from the beginning
What is RSI3 ... is that a 3 period rsi ?
What is RSI3.20 ... is that some other period rsi?

in fact, are all the RSI point something just different length rsis?

SQR is square root right?
ABS is absolute value?
^2 is divided by 2?

This looks pretty easy to put into Metastock code if my assumptions above are
right.

I will show you what this line will look like, using letters instead of numbers
for the length of the RSI, you just put in the rsi lengths instead of the letters.
I am not in front of Metastock at the moment, I cant remember the square root
function but I reckon everything else is ok

OK here goes...

rsi(a)<(rsi(b) - 2*(sqr(abs(rsi(c)/2 + rsi(d)/2 + rsi(e)/2)))

Have you got Metastock? It will help you correct if there are extra brackets
in there or things missing.

5. ## Re: Formula conversion

will do that thanks a million, it finishes with

AND C > XAVGC20 ANDC > XAVGC50

6. ## Re: Formula conversion

Back in front of Metastock

square root is sprt, not sqr - so replace that in the post from me above

The final line:

AND C > XAVGC20 ANDC > XAVGC

c is close right?
XAVGC20 would be the average close over the last 20 periods?
XAVGC50 would be the average close over the last 50 periods?

That would give:

and c > Mov(c, 20,S) and c > Mov(c, 50,S)

and thats it

Good luck with that.

7. ## Re: Formula conversion

thanks a million Timmy i owe you one!

8. ## Re: Formula conversion

Originally Posted by ticnau
RSI3<RSI3.20-2*SQR(ABS(RSI3.1.^2 + RSI3.1.1 ^ 2 + RSI3.12 ^ 2

is the first line
Is it returning the same result? Because if it isn't I'm pretty certain ^2 means to the power of 2.... ^2 is squared in every other program and handheld I've used.

9. ## Re: Formula conversion

Originally Posted by shinobi346
Is it returning the same result? Because if it isn't I'm pretty certain ^2 means to the power of 2.... ^2 is squared in every other program and handheld I've used.
That sounds fair enough shinobi, looks like I may have some brushing up to do on my Boolean...has anyone ever been to Boolea?

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
Aussie Stock Forums