Twitter Charts 2

Optuma General Discussion
21

Hi Thomas,

Mondays have a value of 2 using the DAYOFWEEK() function so the formula is as follows, with the previous close being Friday:

DAYOFWEEK() == 2 and CHANGE()<-2 and CHANGE()[1]<-1
1 Like
22

Hi Darren,

I hope I do not bother your with my many questions but I have to ask you again how you created your latest chart on Twitter about the August seasonality.

Here is the Twitter link: https://twitter.com/Optuma/status/1564988160341319681

Of special interest for me are the scripts for the the chart with the arrows that show the August of each year.

Really many thanks for your great work and for the Optuma software. Using Optuma was one of the best investment decisions I have made in three decades.
Thomas

23

Thanks Thomas - appreciate your comments. On a monthly chart, the green arrows are when August closes higher:

MONTHNUM()==8 and CLOSE() IsUp

Change to IsDown for the red arrows.

24

Thanks Darren,

one last question to this topic: What is the script for the “August Return %”?

Many thanks,
Thomas

25

Hi Thomas,

For the August % return change the Show View to a histogram:

M1 = MONTHNUM() == 8; 
M2 = CHANGE(); 
IF(M1 == 1,M2,0)
1 Like
26

Hi,

Here is an example what beautiful and especially informative charts can be created with Optuma.

S-P 500 August Performance

Best wishes
Thomas

27

The attached workbook loads a watchlist of the S&P500 stocks and calculates the current retracement level of the 52 week high / low range, as per this Tweet:

https://twitter.com/Optuma/status/1565647281055039488?s=20&amp;t=RwpmsMwkJ32RfC8aBVs2kA

The list gets grouped if they are above / below 50% retracement level

The retracement value is calculated using this formula:

Hi52 = HIGHESTHIGH(RANGE=Look Back Period, INCBAR=True, BACKTYPE=Weeks, BARS=52); 
Lo52 = LOWESTLOW(RANGE=Look Back Period, INCBAR=True, BACKTYPE=Weeks, BARS=52);
R1=(Hi52-Lo52);
R2 = CLOSE()-Lo52;
R2/R1

Percent-Retrace.owb (238 KB)

28

I’m wondering how you got the labels on the histogram? Using Show Bar never seems to work for me when putting it on a Show View script. Thanks!

29

Hi Jason,

You need to set the Show Bar to Number using a formula of just Close() to show the closing value of the Show View. In the case of histograms you can have one Show Bar set to use green labels with a high position showing for positive values, and another Show Bar with red / low labels for negative values.

For positive values use this IF formula and the HIDDEN() function:

IF(CLOSE()>0, CLOSE(),HIDDEN())

For negative values:

IF(CLOSE()<0, CLOSE(),HIDDEN())

Workbook attached.

Show-Bar-Histogram-Values.owb (14.4 KB)

30

[postquote quote=69123]
How u managed to show only aug histogram.

31

Hi Deepak and Jason,

The script for the month is:

Line1 = MONTHNUM() == 8 ; 
Line2 = CHANGE() ; 
Line3 = IF(Line1 == 1, Line2, HIDDEN()) ; 
Line3

The script for the percentages are:

IF(CLOSE() > 0, CLOSE(), HIDDEN())

and:

IF(CLOSE() < 0, CLOSE(), HIDDEN())

The script for the “Up-Months” is:

MONTHNUM()==8 and CLOSE() IsUp

The script for the “Up-Months” is:

MONTHNUM()==8 and CLOSE() IsDown

For the up and down months use the Show Bar tool and set it to “Arrow”.

I have attached my workbook for August.

Best wishes
Thomas

August-Performance.owb (22.3 KB)

32

Highest/Lowest Relative close count and date

https://twitter.com/Optuma/status/1574702539798622208?s=20&t=_s_iw75rRqLwBxLH53QmQQ

Similar to this formula, but using the RIC() function instead:

//Days since high;
D1=RIC();
D2=LAST(D1);
TIMESINCESIGNAL(D1>D2, Unit=Bars)

For the date that the relative was this low (change the watchlist Column Type to date).

//Date since this low;
D1=RIC();
D2=LAST(D1);
BARDATE(D1<D2)
1 Like