Year-to-Date performance values

Optuma Forums Optuma Scripting Year-to-Date performance values

This topic contains 1 reply, has 1 voice, and was last updated by Darren Darren 2 weeks, 4 days ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #49223
    Darren
    Darren
    • Topics: 29
    • Replies: 157
    • Posts: 186

    To create a watchlist column with YTD values use the ROC() function set to Yearly timeframe (so the change will be calculated from the close of the last yearly bar). Note: if you want to display as a percentage in a watchlist column divide the result by 100:

    Capture1

    If you have divided by 100, right-click on the watchlist column header and change the Column Type to Percentage. It’s also possible to colour code the cells under Custom Labels, eg green > 0 and red < 0 values (note: delete the Label text so just the value shows, as per the example).

    Capture1

    You can also show summary information for the column, such as the count (number of items in the list), Average, or Sum. In the Watchlist properties enable Show Summary Row, and to show the average YTD% right-click in the grey bar of the YTD column and under Summary Type select Average:

    Capture1

     

    #49583
    Darren
    Darren
    • Topics: 29
    • Replies: 157
    • Posts: 186

    To calculate annual performance for a calendar year change the watchlist timeframe to 1 Year and use the ROC() offset for each year in the square brackets, so last year would be:

    ROC(BARS=1)[1] / 100

    and the year before last:

    ROC(BARS=1)[2] / 100

    etc.

    NOTE: by default watchlists only load 1 year of data so be sure to change the Date Range property to something like 5 or 10 Years:

    Capture

    In the example above the ASX200 Materials (XMJ) sector is down 5% this year, but was up 18.5% in 2017, 39.1% in 2016, and -19.5% in 2015. The final column uses the Annual Rate of Return function ARR() set to 3 years, so Materials has averaged 16.1% a year since the end of 2015.

    ARR(PERIODAMT=3)/100

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

Pin It on Pinterest

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close