Twitter Charts 3

[Darren]

This thread is for charts posted on twitter.com/Optuma

Previous Twitter threads can be found here and here.

[Darren]

To calculate the returns for the first 3 days of each month: https://twitter.com/Optuma/status/1577984492488343552

//Calculate required period rate of change; V1=ROC(BARS=3); //Month change trigger; M1=MONTHNUM() <> MONTHNUM()[1]; //Set M1 offset to the end of the previous month, ie [2] for 3 days, [3] for 4, etc; IF(M1[2],V1,HIDDEN())

1 2 3 4 5 6 7 8

//Calculate required period rate of change; V1=ROC(BARS=3); //Month change trigger; M1=MONTHNUM() <> MONTHNUM()[1]; //Set M1 offset to the end of the previous month, ie [2] for 3 days, [3] for 4, etc; IF(M1[2],V1,HIDDEN())

So to calculate for the first 5 days of each month V1 should be changed to ROC(Bars=5) and the M1 offset in the last line to [4].

2 users thanked author for this post.

Louis Spector, Thomas

[Thomas]

Hi Darren,

In your Twitter tweet https://twitter.com/Optuma/status/1583433417974243328?cxt=HHwWgICzvbyTvvkrAAAA you wrote: “9.6% of US listings made a new 52 week intraday low yesterday (12.4% of NYSE & 7.7% of Nasdaq).”

How did you get the value 9.6% when 12.4% of NYSE and 7.7% of Nasdaq stocks made new 52-week lows?

Thank you and best wishes,
Thomas

[Darren]

Hi Thomas,

This was calculated using breadth data from DTN IQFeed.

//Sum NYSE & Nasdaq 52 week lows; N52L = (FINL.Z:IQInd + FIQL.Z:IQInd); //Sum NYSE & Nasdaq total listings; TOT = (IINT.Z:IQInd + IIQT.Z:IQInd); //Calc %; (N52L/TOT)*100

1 2 3 4 5 6 7 8

//Sum NYSE & Nasdaq 52 week lows; N52L = (FINL.Z:IQInd + FIQL.Z:IQInd); //Sum NYSE & Nasdaq total listings; TOT = (IINT.Z:IQInd + IIQT.Z:IQInd); //Calc %; (N52L/TOT)*100

For Thursday there were 4,843 listings on Nasdaq, and 3,310 on NYSE, for a total of 8,153. With 784 new 52 week lows (374 on Nasdaq and 410 on NYSE) we get 784 / 8153 = 9.6%.

For the individual exchanges you could use our breadth data (NYSE52WL and NASDAQ52WL), but we don’t have the total number of listings to calculate the combined percentage.

1 user thanked author for this post.

Thomas

[Thomas]

Hi Darren,

You have again published an interesting chart about the December seasonality on Twitter ( https://twitter.com/Optuma/status/1598343500952649728?cxt=HHwWgICytcO8uq4sAAAA ).

I have figured out the script that does the counting of the number of positive and negative December returns:

Line1 = MONTHNUM() == 12 ; Line2 = CHANGE() ; Line3 = IF(Line1 == 1, Line2, HIDDEN()) ; Line4 = IF(Line3 >= 0, 1, 0) ; Line5 = ACC(Line4) ; Line5

1 2 3 4 5 6 7 8

Line1 = MONTHNUM() == 12 ; Line2 = CHANGE() ; Line3 = IF(Line1 == 1, Line2, HIDDEN()) ; Line4 = IF(Line3 >= 0, 1, 0) ; Line5 = ACC(Line4) ; Line5

So far so fine. But I have a data history of the S&P 500 going back to 1885 so the above script calculates the number of positive Decembers going back to 1885.

Using the chart property setting “Date Range” and select “Selected Date” and setting the start date of the chart to 01/01/1950 the above script calculates of course the number of positive December returns since 01/01/1950.

But is there a way set the start date of the calculation beginning 01/01/1950 in the above script?

I have worked with the “Look Back Period” settings in the “ACC” function, but when I enter a fixed number of years looking back the current year calulation is correct but not the past years.

Line5 = ACC(Line4, RANGE=Look Back Period, BACKTYPE=Years, BARS=73) ;

1 2 3

Line5 = ACC(Line4, RANGE=Look Back Period, BACKTYPE=Years, BARS=73) ;

I have worked with the “BarDate and StringDate Functions” but without success.

Start = BARDATE()==STRDATE(DATE=1949-12-31);

1 2 3

Start = BARDATE()==STRDATE(DATE=1949-12-31);

So I need again your help to figure out how to set the start date of the calculation to 01/01/1950.

Best wishes
Thomas

[Darren]

Hi Thomas,

Try this on a monthly chart:

V1=MONTHNUM()==12 and CLOSE() IsUp; ACC(V1, RANGE=Look Back Period, BACKTYPE=Date, STARTDATE=1950-01-01)

1 2 3 4

V1=MONTHNUM()==12 and CLOSE() IsUp; ACC(V1, RANGE=Look Back Period, BACKTYPE=Date, STARTDATE=1950-01-01)

1 user thanked author for this post.

Thomas

[Darren]

Show Bar labels:  https://twitter.com/Optuma/status/1625454807833284614?s=20&t=9E9H46kkIglnMWXV1VjWmw

To show the monthly range % on each candle:

For the green labels, use the following as a Show Bar set to display as a Number:

R1=(HIGH()/LOW()-1) * 100; IF(CLOSE() IsUp, R1,0)

1 2 3 4

R1=(HIGH()/LOW()-1) * 100; IF(CLOSE() IsUp, R1,0)

For the red labels, add a second Show Bar and change the Position to Low and use the following:

R1=(LOW()/HIGH()-1) * 100; IF(CLOSE() IsDown, R1,0)

1 2 3 4

R1=(LOW()/HIGH()-1) * 100; IF(CLOSE() IsDown, R1,0)

For the histogram below the chart use the following in a Show View:

R1=(HIGH()/LOW()-1) * 100; R2=(LOW()/HIGH()-1) * 100; IF(CLOSE() IsUp, R1,R2)

1 2 3 4 5

R1=(HIGH()/LOW()-1) * 100; R2=(LOW()/HIGH()-1) * 100; IF(CLOSE() IsUp, R1,R2)

Optuma clients can save and open the attached workbook as an example.

1 user thanked author for this post.

Thomas

[Pentti]

Hi,

I am interested how I can make Russell 3000 breadth thrust indicator that was used in today’s Twitter tweet.

Regards, Pentti Rahko

[Darren]

Hi Pentti,

The Breadth Thrust measure will be in our new Breadth Data which will be released to clients in the coming weeks. It will include these 50 measures for major global exchanges, including Russell 3000, FTSE 350, NIFTY 500, and the EuroStoxx 600.

We’ll be announcing when this data will be available soon!

1 user thanked author for this post.

Thomas

[Thomas]

Hi Optuma team,

you posted on Twitter a chart with the sector weights ( https://twitter.com/Optuma/status/1661135632633331712?cxt=HHwWgIDUrdGDxY0uAAAA ).

Here is the chart:

I use Optuma v2.1 Beta Build 97 and so I am able to get the sector weights.

The scripts for the sector weights are easy ( https://help.optuma.com/kb/faq.php?id=1269 ).

What causes me problems to replicate is the issue that you have empty cells when a stock is not a member of the sector. In my script I get for the stocks that are not members of a sector the value “0.00”.

I tried the following script to get empty cells for non-members but failed:

Line1 = ISMEMBER(SYMBOLLIST=NASDAQ 100) ; Line2 = WEIGHT(SYMBOLLIST=QQQ - Invesco QQQ Trust) ; Line3 = IF(Line1 == 1, Line2, HIDDEN()) ; Line3

1 2 3 4 5 6

Line1 = ISMEMBER(SYMBOLLIST=NASDAQ 100) ; Line2 = WEIGHT(SYMBOLLIST=QQQ - Invesco QQQ Trust) ; Line3 = IF(Line1 == 1, Line2, HIDDEN()) ; Line3

Please inform me what script you used to get empty cell values for non-members of a sector.

Best wishes,
Thomas

[Darren]

Hi Thomas – there’s a bit of a trick in the formatting of the columns. The script is simply WEIGHT(SYMBOLLIST=QQQ – Invesco QQQ Trust) and once added right-click on the column header and change the Column Type to Percentage. Under Custom Labels put a blank space for the label and set ==0 to white:

1 user thanked author for this post.

Thomas

[Thomas]

Thank you Darren,

A really nice trick with the blank space for the label. I have worked with the Custom Labels property but the idea of the blank space did not occur to me.

Perhaps a small improvement:
If you choose the colour black instead of white, the default row colour formatting in the watchlist is maintained.

Thanks,
Thomas

[Author]

Posts