July 20, 2022 at 6:19 am #68789
I have figured out how you have calculated the maximum intra-year drawdowns. You calculate the percentage difference between the closing price of the previous year and the lowest low of the next year.
OK so far so good, but this is not the “real” maximum intra-year drawdown. A better naming would be helpful e.g. maximum drawdown between the closing price of the previous year and the lowest low of the next year.
July 20, 2022 at 7:05 pm #68795
- This reply was modified 2 months ago by Thomas.
It has been created using a Show View below a yearly price chart, and the price chart ‘view’ hidden in the Structure Panel.
The Show View formula set to display as a histogram is simply CHANGE() for the columns (as the chart is a yearly timeframe it will calculate yearly change).
Max intra-year low is a Show Plot for the blue line:12345678//Current low;V1 = LOW();//Prev close;V2 = CLOSE();//Percent calc;DIFFPCT(V1,V2)
This is different from the DDP() function which uses the 52 week high whereas this calculates from the close of the previous year.
A workbook for the SPX attached, which includes Show Bar formulas for the labels.August 12, 2022 at 6:10 pm #68977
The story goes on and on. You have again published on Twitter a great chart about the % SPX stocks 20EMA > 50EMA.
Would it be possible to publish here the scripts using this analysis?
I know of course I need the Optuma Breadth Module to calculate the % SPX stocks, but I have it.
Many thanks and best wishes,
ThomasAugust 12, 2022 at 6:26 pm #68981
This is the breadth calculation, set to Percent:123MA(BARS=20, CALC=Close, STYLE=Exponential) > MA(BARS=50, CALC=Close, STYLE=Exponential)
The Signal Test formula for when the breadth crosses above 33 after crossing 20:123456V1=GETDATA(CODE=[BREADTHSYMBOL]:Market Breadth);R1=V1 CrossesAbove 33;R2=V1 CrossesAbove 20;SIGNALAFTER(R2,R1)August 24, 2022 at 4:38 pm #69057
This time making it short: “Can you publish here in the forum the scripts for the chart and backtest of your Twitter analysis about “$SPX losing 2% on a Monday following a 1% loss on a Friday”?
— Optuma (@Optuma) August 23, 2022
As always really many thanks for your exceptional good support and ideas.
ThomasAugust 24, 2022 at 6:13 pm #69059
Mondays have a value of 2 using the DAYOFWEEK() function so the formula is as follows, with the previous close being Friday:123DAYOFWEEK() == 2 and CHANGE()<-2 and CHANGE()<-1September 1, 2022 at 5:09 pm #69113
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.
September 1, 2022 at 6:56 pm #69117
- This reply was modified 3 weeks ago by Thomas.
Thanks Thomas – appreciate your comments. On a monthly chart, the green arrows are when August closes higher:123MONTHNUM()==8 and CLOSE() IsUp
Change to IsDown for the red arrows.September 1, 2022 at 7:17 pm #69119
one last question to this topic: What is the script for the “August Return %”?
ThomasSeptember 1, 2022 at 7:37 pm #69121
For the August % return change the Show View to a histogram:12345M1 = MONTHNUM() == 8;M2 = CHANGE();IF(M1 == 1,M2,0)September 1, 2022 at 8:31 pm #69123
Here is an example what beautiful and especially informative charts can be created with Optuma.
1 user thanked author for this post.September 3, 2022 at 1:13 am #69135
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:
130 stocks of the $SPX members are trading above the 50% level of their 52 week high / low range (SPX at 28%). On avg, they have retraced 71%, are +38% above their 52 week low, & +11% YTD: pic.twitter.com/eZCXArLrBY
— Optuma (@Optuma) September 2, 2022
The list gets grouped if they are above / below 50% retracement level
The retracement value is calculated using this formula:1234567Hi52 = 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/R1September 6, 2022 at 10:59 pm #69189Jason
- Topics: 4
- Replies: 3
- Posts: 7
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!September 7, 2022 at 12:41 am #69195
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:123IF(CLOSE()>0, CLOSE(),HIDDEN())
For negative values:123IF(CLOSE()<0, CLOSE(),HIDDEN())
- This reply was modified 2 weeks ago by Darren.
1 user thanked author for this post.September 11, 2022 at 1:53 pm #69255
- You must be logged in to reply to this topic.