I dont quite understand the problem, but have a look at the ValueWhen() function?



Plotting the end of the month value before the end of the month is using foresight, and although it can be done programatically, it often gives the trader a false sense of security that cannot be traded in real life.


Hope this helps.

wabbit [:D]

One of the limitations of the MS formula language is it doesn't allow you to work through the data from right to left, only from left to right. There might be some MS formula tricks using the ValueWhen(), LastValue() and/or PREV (and maybe some of the forum.dll functions) that might allow you to make this function, but it doesn't immediately spring to mind.

When dealing with time/date issues, you also have to be cognisant that charts deal in "bars" not calendar days, so attempting to shift indicators x-bars where x is based on the number of calendar days in the month is going to run into trouble from the start. You cannot even be assured there will exist a bar for every trading day in the month as some equities are not traded on every trading day. The only thing you know is, if a bar exists the equity traded on that day.

Generally speaking, if I have to spend more than a short period of time thinking about how to work around the limitations of the MS formula language, I will generally stop wasting any further time and simply program an external indicator in a much more powerful programming language that has access to the entire data range and can access it in any order desired. Of course, you have to have the MDK to be able to do this.

Maybe someone else might like the challenge, but I'd either get the MDK or get someone to build this one for you as a library function.


wabbit [:D]

Where to download Forum.dll?

Have two indicators that each plot 1 once a month. When the two are add together, there are some month which both indicator plotted 1 (total 2 in a month). Indicator B is after Indicator A. Is possible to code in a way that ignore indicator A (return 0 rather than 1) and plot just indicator B in month which both indicator return 1?

Indicator A and B are both for optionexp on wednesday (index option).

if(optionexp()=3 and dayofweek()=3,indicatorA,0);
if(optionexp()>32 and dayofweek()=3,indicatorB,0);

The problem is on month which has more than 32 bars, indicator A and B would both plot 1 for the same month even indicator B is after indicator A.

Wanted to code in a way that return indicator B (plot 1) and ignore indicator A (plot 0) on month which has bars more than 32. There is only one option exp per month

huh?


???


wabbit [:D]

Wabbit does the code below works only for optionexp() when plotting backward? When tried using other indicator instead of of optionexp() the close plots forward rather than backward.

oe:=optionexp();
start:=oe>Ref(oe,-1);
data:=ValueWhen(1,start,Ref(C,-1));

If(Cum(start)<LastValue(Cum(start)),
ExtFml("forum.ref",data,-oe),
LastValue(C));

------------------

oe:=Indicator1 { Plot 1 or 0 };
start:=oe<Ref(oe,-1);
data:=ValueWhen(1,start,Ref(C,-1));

If(Cum(start)<LastValue(Cum(start)),
ExtFml("forum.ref",data,-oe),
LastValue(C));

------------------