Select Page

Optuma Forums Optuma General Discussion Twitter Charts 3

Tagged: , ,

Viewing 12 posts - 1 through 12 (of 12 total)
• Author
Posts
• #69485
Darren
• Topics: 74
• Replies: 967
• Posts: 1,041

#69487
Darren
• Topics: 74
• Replies: 967
• Posts: 1,041

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

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.
#69615
Thomas
• Topics: 140
• Replies: 189
• Posts: 329

Hi Darren,

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

#69623
Darren
• Topics: 74
• Replies: 967
• Posts: 1,041

Hi Thomas,

This was calculated using breadth data from DTN IQFeed.

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.
#69885
Thomas
• Topics: 140
• Replies: 189
• Posts: 329

Hi Darren,

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

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.

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

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

#69887
Darren
• Topics: 74
• Replies: 967
• Posts: 1,041

Hi Thomas,

Try this on a monthly chart:

###### 1 user thanked author for this post.
#70353
Darren
• Topics: 74
• Replies: 967
• Posts: 1,041

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:

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

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

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

###### 1 user thanked author for this post.
#70389
Pentti
• Topics: 3
• Replies: 4
• Posts: 7

Hi,

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

Regards, Pentti Rahko

#70393
Darren
• Topics: 74
• Replies: 967
• Posts: 1,041

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.
#71001
Thomas
• Topics: 140
• Replies: 189
• Posts: 329

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:

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

Best wishes,
Thomas

#71003
Darren
• Topics: 74
• Replies: 967
• Posts: 1,041

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.
#71013
Thomas
• Topics: 140
• Replies: 189
• Posts: 329

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

Viewing 12 posts - 1 through 12 (of 12 total)
• You must be logged in to reply to this topic.