SCRIPTING: OFFSET FROM SIGNAL

Optuma Scripting
1

 

Hi Guys,

I have a script that identifies a Gann Swing Top (the "2nd Top") that is preceded and succeeded by lower swing tops:

// Gann Swing 1 Week
GS1 = SWINGEND(GANNSWING(METHOD=Use Next Bar, DAY(PERIODAMOUNT=1),SWINGCOUNT=1));

// Succeeding Lower Top
GS2SucLoTop = GS1[-2] < GS1[0];

// Preceding Lower Top
GS2PreLoTop = GS1[0] > GS1[2];

// Identify Swing Top
GS2ndTop = GS1[0] > GS1[1];

// 2nd Top Signal
GS2ndTopSignal = GS2ndTop and GS2PreLoTop and GS2SucLoTop AND (TIMESINCESIGNAL(GS2ndTop) < 1);

SetupSignal = GS2ndTopSignal;

SetupSignal

This script results in the relevant Tops bing highlighted by the Orange SHOWBAR Arrows:

20180306 Double Top Script
20180306 Double Top Script1885×1066 124 KB

I then wish to identify the previous Gann Swing Top (the "1st Top") that meets the same criteria and thought the following script should do this:

// 2nd Top Signal
GS2ndTopSignal = SCRIPT(SCRIPTNAME=Identify 2nd Top);

GS1stTopSignal = Offset(GS2ndTopSignal, OFFSET=1);

GS1stTopSignal

However this produces the Magenta SHOWBAR Arrows shown in the above screen shot. Obviously not what I was expecting.

It is my understanding that the OFFSET function looks back to the previous instance of the signal, in this case "GS2ndTopSignal".

Is my understanding of the OFFSET function confused, or is it not working as expected?

I've attached a copy of my workbook for your review.

Cheers

Trevor

20180305-Test-Double-Top-Show-Bars.owb (33.1 KB)

2

Hi Trevor,

Offset() only returns value according to the Bar position instead of the Signal position.

It is a good idea to have a different Offset() that could easily point to the previous / next signal. I will pass it on to the team.

In the meantime, here is the script to look for the signal that is lower than the next signal (using -1 as offset value)

 

GS2ndTopSignal = SCRIPT(SCRIPTNAME=Test);

// use IF() to give the High at the Signal and fill the other positions with zero

Value1 = If(GS2ndTopSignal > 0, PriceAtSignal(GS2ndTopSignal, PRICE=High), 0);

// Use NonZero() to shrink the Value1 list by removing the zeros so it can use Offset() to find the next / previous signal

Signal1 = NONZERO(Value1);

Signal1 < OFFSET(Signal1, OFFSET=-1)

3

Hi All,

Thanks for the suggestion Henry, that's a neat trick I must remember. It looks to be identifying the "1st Tops" correctly for me.

Now I have new conundrumScratching Head

My objective is to identify double tops, ignoring intermediate "swing steps", but having the 2nd Top between 0 and 0.5% higher than the 1st Top of the pair.

My script essentially comprises four parts:

#1 +++++ Gann Swing Parameters

#2 +++++ Identify 2nd Top of Double Top

#3 +++++ Identify 1st Top of Double Top, ie the Top preceding 2nd Top Signal

#4 +++++ Compare 1st and 2nd Top, 2nd Top to be between 0 and 0.5% higher than 1st Top

The first 3 parts appear to be working correctly, as the 2nd Top and 1st Tops are identified using SHOW BARS for those portions of the script. You can see this in the attached Workbook, 2nd Tops have an Orange arrow, 1st Tops Magenta arrow (and "criteria meeting" double Tops a Blue arrow).

Part #4 is driving me nutsPull Hair, and I haven't got much more hair to pull out!

While it appears to identify some of the Double Tops being sought, it misses some and it also identifies others that do not meet the limiting 0 to 0.5% criteriabummer

20180307 Erroneous Double Tops
20180307 Erroneous Double Tops1622×1009 107 KB

I've been attempting to identify the cause of my problem using the //PLOTS in a SHOW VIEW, but therein rests another problemScratching Head

When I remove the // comment delimiters Script Manager tells me "Please enter a valid script to add this criteria" and I'm darned if I can work out why notPull Hair

20180307 Enter valid script...
20180307 Enter valid script...786×349 26.5 KB

So here is my script:

 

// Double Top: 2nd 0 to 0.5% greater than the 1st

// Setup Signal:

// 1 Day Gann Swing

// Double Top with

// 2nd Top between 0% and +0.5% of the 1st Top

// Lower Tops each side of 1st and 2nd Tops

 

// #1 +++++ Gann Swing Parameters

// Gann Swing 1 Day

GS1 = SWINGEND(GANNSWING(METHOD=Use Next Bar, DAY(PERIODAMOUNT=1),SWINGCOUNT=1));

 

// #2 +++++ Identify 2nd Top of Double Top

// Succeeding Lower

TopGS2SucLoTop = GS1[-2] < GS1[0];

// Preceding Lower

TopGS2PreLoTop = GS1[0] > GS1[2];

// Identify 2nd Swing Top

GS2ndTop = GS1[0] > GS1[1];

// 2nd Top Signal

GS2ndTopSignal = GS2ndTop and GS2PreLoTop and GS2SucLoTop AND (TIMESINCESIGNAL(GS2ndTop) < 1);

// +++++ 2nd Top identified

 

// #3 +++++ Identify 1st Top of Double Top, ie the Top preceding 2nd Top Signal

// use IF() to give the High at the Signal (GS2ndTopSignal) and fill the other positions with zero

GS2ndTopValue = If(GS2ndTopSignal > 0, PriceAtSignal(GS2ndTopSignal, PRICE=High), 0);

// Use NonZero() to shrink the GS2ndTopValue list by removing the zeros so it can use Offset() to find the next / previous signal

GS2ndTopNonZero = NONZERO(GS2ndTopValue);

// Determine 1st Top Signal

GS1stTopSignal = (TIMESINCESIGNAL(GS2ndTopNonZero) < 1 AND TIMESINCESIGNAL(GS2ndTopNonZero) > -1) AND (GS2ndTopNonZero <= OFFSET(GS2ndTopNonZero, OFFSET=-1) or GS2ndTopNonZero > OFFSET(GS2ndTopNonZero, OFFSET=-1) );

// +++++ 1st Top identified

 

// #4 +++++ Compare 1st and 2nd Top, 2nd Top to be between 0 and 0.5% higher than 1st Top

// Get Double Top High Prices

GS1stTopValue = PRICEATSIGNAL(GS1stTopSignal, PRICE=High);

GS2ndDTopValue = PRICEATSIGNAL(GS2ndTopSignal, PRICE=High);

// % range between 1st Top and 2nd Top

DoubleTopRatio = (GS2ndDTopValue - GS1stTopValue) / ((GS2ndDTopValue + GS1stTopValue) / 2) * 100;

// Test if Top Ratio in range 0 to +0.5

DoubleTopSignal = If(GS2ndTopSignal AND DoubleTopRatio >= 0 AND DoubleTopRatio < 0.5 , 1, 0);

 

// PLOTS

Plot1=GS1stTopValue;

Plot1.Colour = Red;

Plot1.Plotstyle = Step; // Step, Line, Histogram, Shaded, Shaded Step,

Plot1.LineWidth = 5;

Plot1.LineStyle = Dash;

//

//Plot2=GS2ndDTopValue;

Plot2.Colour = Lime;

Plot2.Plotstyle = Line; // Step, Line, Histogram, Shaded, Shaded Step,

Plot2.LineWidth = 3;

Plot2.LineStyle = Dots;

//

// Plot3=TopRatio;

Plot3.Colour = blue;

Plot3.Plotstyle = Line; // Step, Line, Histogram, Shaded, Shaded Step,

Plot3.LineWidth = 3;

Plot3.LineStyle = Dots;

DoubleTopSignal

 

Any and all bright ideas on what's causing my problems will be very much appreciated.

Cheers

Trevor

20180307-Test-Double-Top-Show-Bars.owb (236 KB)

4

Hi Trevor,

I found some minor changes in #4 section to achieve your goal.

After looking at the plots of GS1stTopValue and GS2ndDTopValue in Show View, the 1st Top value you are looking for is actually GS1stTopValue[1] or Offset(GS1stTopValue, OFFSET=1) which is the previous Bar value of the GS1stTopValue. Because they become equal when swings turn at the 2nd Top.

So here is the script for #4

// #4 +++++ Compare 1st and 2nd Top, 2nd Top to be between 0 and 0.5% higher than 1st Top

// Get Double Top High Prices

GS1stTopValue = PRICEATSIGNAL(GS1stTopSignal, PRICE=High);

GS2ndDTopValue = PRICEATSIGNAL(GS2ndTopSignal, PRICE=High);

// % range between 1st Top and 2nd Top

DoubleTopRatio = 100 * (GS2ndDTopValue - GS1stTopValue[1]) / GS1stTopValue[1];

// Test if Top Ratio in range -0.25 to +0.25

DoubleTopSignal = If(GS2ndTopSignal AND DoubleTopRatio >= 0 AND DoubleTopRatio < 0.5 , 1, 0);

DoubleTopSignal

 

Cheers

Henry

20180307-Test-Double-Top-Show-Bars1.owb (238 KB)

5

Many thanks Henry, that's resolved my issue. Now my script is working as desired.

Cheers

Trevor