Seasonality Charts

Optuma Forums Optuma General Discussion Seasonality Charts

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #54525
    Darren
    • Topics: 73
    • Replies: 900
    • Posts: 973

    For more on Seasonality Charts click here.

    Attached is a workbook containing charts for the ASX200 index, SPX, FTSE, DAX, NIFTY, Shanghai and Nikkei showing average performance each month. The chart on the left shows the change for a specified month each year – in this example September.

    You can change to your own charts, or right-click on the page tab and select Clone Page to make a copy and keep the original.

    Capture

    Note – the blue diamond on the Seasonality Chart on the right is the current value.

    It’s created using a Show View under a monthly chart changed to a histogram, and then the price chart itself is hidden in the Structure Panel so only the histogram is displayed.

    For September, the formula used is as follows:

    Change the MONTHNUM() value in Line 3 for the required month.

    • This topic was modified 3 years ago by Darren.
    2 users thanked author for this post.
    #57001
    Darren
    • Topics: 73
    • Replies: 900
    • Posts: 973

    By changing the Comparison Style property of the Seasonality chart to Compare Years you can enter the years of the US Elections. Here’s the S&P500 index showing annual performance since 1952 (note the workbook can be downloaded from the link below).

    Capture

    3 users thanked author for this post.
    #69785
    Darren
    • Topics: 73
    • Replies: 900
    • Posts: 973

    Attached is an updated workbook with a look at midterm years, and a YTD time series using an Historical Comparison chart:

    Capture3

    #69799
    John
    • Topics: 11
    • Replies: 4
    • Posts: 15

    Thanks for sharing these!

    Is this a way to take the historical chart comparison and blend the years into one line showing the average?

    • This reply was modified 1 week ago by John.
    #69811
    Darren
    • Topics: 73
    • Replies: 900
    • Posts: 973

    Thanks John – it’s not possible to show the average of the Historical Comparison chart at this time, but this has been logged for inclusion in a future update.

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

Pin It on Pinterest