Twitter Charts 2

Optuma Forums Optuma General Discussion Twitter Charts 2

Viewing 15 posts - 16 through 30 (of 31 total)
  • Author
    Posts
  • #68789
    Thomas
    • Topics: 130
    • Replies: 176
    • Posts: 306

    Hi Darren,

    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.

    Best wishes,
    Thomas

    • This reply was modified 2 months ago by Thomas.
    #68795
    Darren
    • Topics: 70
    • Replies: 871
    • Posts: 941

    Hi Thomas,

    It has been created using a Show View below a yearly price chart, and the price chart ‘view’ hidden in the Structure Panel.
    Capture

    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:

    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.

    1 user thanked author for this post.
    #68977
    Thomas
    • Topics: 130
    • Replies: 176
    • Posts: 306

    Hi Darren,

    The story goes on and on. You have again published on Twitter a great chart about the % SPX stocks 20EMA > 50EMA.

    Link: https://twitter.com/Optuma/status/1557641938576330752?cxt=HHwWgMC-weTF7Z0rAAAA

    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,
    Thomas

    #68981
    Darren
    • Topics: 70
    • Replies: 871
    • Posts: 941

    Hi Thomas,

    This is the breadth calculation, set to Percent:

    The Signal Test formula for when the breadth crosses above 33 after crossing 20:

    1 user thanked author for this post.
    #69057
    Thomas
    • Topics: 130
    • Replies: 176
    • Posts: 306

    Hi Darren,

    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”?

    Twitter link:

    As always really many thanks for your exceptional good support and ideas.

    Best wishes,
    Thomas

    #69059
    Darren
    • Topics: 70
    • Replies: 871
    • Posts: 941

    Hi Thomas,

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

    #69113
    Thomas
    • Topics: 130
    • Replies: 176
    • Posts: 306

    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

    • This reply was modified 3 weeks ago by Thomas.
    #69117
    Darren
    • Topics: 70
    • Replies: 871
    • Posts: 941

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

    Change to IsDown for the red arrows.

    1 user thanked author for this post.
    #69119
    Thomas
    • Topics: 130
    • Replies: 176
    • Posts: 306

    Thanks Darren,

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

    Many thanks,
    Thomas

    #69121
    Darren
    • Topics: 70
    • Replies: 871
    • Posts: 941

    Hi Thomas,

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

    1 user thanked author for this post.
    #69123
    Thomas
    • Topics: 130
    • Replies: 176
    • Posts: 306

    Hi,

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

    S-P 500 August Performance

    Best wishes
    Thomas

    1 user thanked author for this post.
    #69135
    Darren
    • Topics: 70
    • Replies: 871
    • Posts: 941

    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:

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

    The retracement value is calculated using this formula:

    #69189
    Jason
    • 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!

    #69195
    Darren
    • Topics: 70
    • Replies: 871
    • Posts: 941

    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:

    For negative values:

    Workbook attached.

    • This reply was modified 2 weeks ago by Darren.
    1 user thanked author for this post.
    #69255
    Deepak
    • Topics: 85
    • Replies: 71
    • Posts: 156

    Hi,

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

    S-P 500 August Performance

    Best wishes
    Thomas

    How u managed to show only aug histogram.

Viewing 15 posts - 16 through 30 (of 31 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest