Non Price Study

[erickguz]

Hello Forum,

I am trying to create a NON PRICE STUDY. I would like to plot a graph of my own indicator on an advanced chart.

This is what I would like to do:

-Get the 10 day sum of the following:

if Close > Close(-1), return Close - Close(-1)
if Close > Close(-1), && Close(-1) > Close(-2), return Close - Close(-2)

I would then like to get the sum of the above for 10 bars.

In EXCEL, I have the following formula (I don't want to use EXCEL anymore...)

IF(and(a5>a4,a4>a3),a5-a3,IF(and(a5>a4,a4<a3),a5-a4,0))

then, on a different column, I have: SUM(a5:a14)
which I graph.

Also, is it possible to plot the graph with parameters of -5 to +5? I don't care to see when the result goes beyond +/-5.

I have seen all of the Javascript videos, and read the forums, but have encountered some difficulty; thus, I graciously thank you for your assistance.

I don't know if it can be done on the FORMULA WIZARD, but I am trying to avoid it for now, so that I can actually see the code, how it works, and play with it.

Thanks in advance,
EG

[erickguz]

#2...

Ok, I didn't do too well with my first question ... So,

Is there an existing formula that I can manipulate or can anyone offer input into creating this and plotting it on the indicator pane?

A 10 day sum of:
(If today's close is greater than yesterday's close, return close() - close(-1))

Thanks.