Twitter Charts 2

[Darren]

Following on from this thread here are details for charts posted on our Twitter account. Comment in the Tweet and we’ll post the details here.

For example, to calculate the average drawdown for the members of an index, as per this Tweet: https://twitter.com/Optuma/status/1471137257969135621?s=20

This was calculated using the Drawdown Percent function DDP() in the custom Market Breadth module, with the Breadth Action set to Average.

By default, the DDP() function will calculate distance from the 1 year high.

Once calculated, the data can be viewed in the Breadth Data tool below the price chart:

2 users thanked author for this post.

Donald Chu, Thomas

[Deepak]

Hii Sir,

It seems ismember is not working on this any reason.

Regards,
Deepak

[Darren]

Hi Deepak,

The ISMEMBER() function only works with true/false conditions, not when calculating averages.

3 users thanked author for this post.

Julius, Deepak Gharpure, Thomas

[Darren]

Breakout scan: https://twitter.com/Optuma/status/1482727843171868672?t=JzBy3BTgpMf_3_i2Z3lAzw&s=19

//Define pivots; #$Bars=10; H1=PIVOT(MIN=$Bars, TYPE=High, IGNOREUNCONFIRMED=True); L1=PIVOT(MIN=$Bars, TYPE=Low, IGNOREUNCONFIRMED=True); //Get pivot values; H2=VALUEWHEN(HIGH(), H1); L2=VALUEWHEN(LOW(),L1); //When did the pivots occur?; $TH1=TIMESINCESIGNAL(H1, UNIT=Bars); $TL1=TIMESINCESIGNAL(L1, UNIT=Bars); //Close crosses previous pivot level with a new high/low since the pivot; (CLOSE() CrossesAbove H2 and CLOSE() > HIGHESTHIGH(BARS=$TL1)) or (CLOSE() CrossesBelow L2 and CLOSE() < LOWESTLOW(BARS=$TL1))

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

//Define pivots; #$Bars=10; H1=PIVOT(MIN=$Bars, TYPE=High, IGNOREUNCONFIRMED=True); L1=PIVOT(MIN=$Bars, TYPE=Low, IGNOREUNCONFIRMED=True); //Get pivot values; H2=VALUEWHEN(HIGH(), H1); L2=VALUEWHEN(LOW(),L1); //When did the pivots occur?; $TH1=TIMESINCESIGNAL(H1, UNIT=Bars); $TL1=TIMESINCESIGNAL(L1, UNIT=Bars); //Close crosses previous pivot level with a new high/low since the pivot; (CLOSE() CrossesAbove H2 and CLOSE() > HIGHESTHIGH(BARS=$TL1)) or (CLOSE() CrossesBelow L2 and CLOSE() < LOWESTLOW(BARS=$TL1))

1 user thanked author for this post.

Julius

[Tim]

Can you post the script for the slope of the linear regression.

https://twitter.com/Optuma/status/1491725380251750405

[Darren]

If you type ‘linear’ in the script editor window then all suggestions will pop up, including LRSLOPE():

[Darren]

VIX curve chart: https://twitter.com/Optuma/status/1503686929652408322?s=20&t=1bCnrW9A03LrLGX9BhgMig

Save workbook attached (requires access to the CBOE Indices data).

[Darren]

Day of the Week formulas: https://twitter.com/Optuma/status/1520384472356560896

The DAYOFWEEK() function assigns a value to each week day, with Sundays assigned a 1, Mondays = 2, etc. As such, to mark all Fridays on a chart use DAYOFWEEK()==6 in a Show Bar. This will show all Fridays with a fall greater than 3%:

DAYOFWEEK()==6 and CHANGE()<-3

1 2 3 4

DAYOFWEEK()==6 and CHANGE()<-3

1 user thanked author for this post.

Thomas

[Darren]

5 Consecutive Down Weeks: https://twitter.com/Optuma/status/1523622055534419968

The Days Down DD() function counts the consecutive bars a value (the close by default) has been lower (Days Up DU() does the opposite).

On a weekly timeframe DD()==5 will signal when there have been 5 consecutive weekly lower closes, which was used in the signal test.

For 5 consecutive lower highs use DD(HIGH())==5

The Days Down tool can be used on a chart (currently 6 weeks for the SPX):

 

[Darren]

To calculate how long ago the close was at the latest low (or high) – and the dates they occured: https://twitter.com/Optuma/status/1537704403205079040

Worst Change Since:

//Display as Date in Watchlist; //Get the last 1D ROC change %; D1=LAST(ROC(BARS=1)); //Get the BarDate when the 1D ROC was less than D1; BARDATE(ROC(BARS=1)<D1, UNIT=Days)

1 2 3 4 5 6 7

//Display as Date in Watchlist; //Get the last 1D ROC change %; D1=LAST(ROC(BARS=1)); //Get the BarDate when the 1D ROC was less than D1; BARDATE(ROC(BARS=1)<D1, UNIT=Days)

Lowest Close Since:

//Display as Date in Watchlist; //Get the last close price; D1=LAST(CLOSE()); //Get the BarDate when the Close was less than D1; BARDATE(CLOSE()<D1)

1 2 3 4 5 6 7

//Display as Date in Watchlist; //Get the last close price; D1=LAST(CLOSE()); //Get the BarDate when the Close was less than D1; BARDATE(CLOSE()<D1)

Weeks Since Low

//Get the last close price; D1=LAST(CLOSE()); //Get the time since the Close was less than D1; TIMESINCESIGNAL(CLOSE()<D1, Unit=Weeks)

1 2 3 4 5 6

//Get the last close price; D1=LAST(CLOSE()); //Get the time since the Close was less than D1; TIMESINCESIGNAL(CLOSE()<D1, Unit=Weeks)

To find the high dates instead, change the < to >. Sample weekly watchlist attached that can be saved as a layout and applied to any other lists.

2 users thanked author for this post.

Louis Spector, Thomas

[Thomas]

Hi Optuma team,

can you publish the script for the Twitter chart “ATH Drawdown” (https://twitter.com/Optuma/status/1539727679586443265)?

As always many thanks for your excellent support.

Best wishes,
Thomas

[Darren]

Hi Thomas – use the Drawdown tool set to 100 year lookback (the all-time high calculation is wrong and is being fixed).

https://help.optuma.com/kb/faq.php?id=1237

1 user thanked author for this post.

Thomas

[Author]

Posts