Upside tool idea

Optuma General Discussion
1

The drawdown tool is great to measure the downside, is it possible to write a tool that does the reverse and gives the same information but for the upside?
Thanks Peter

2

Hi Peter,

We have a Range from Extremes tool that shows the current percentage from a high and low (1 year by default).

You can use the associated RFE() function in a watchlist or Show View using the low price:

RFE(DEFAULT=Low)

Click on the text to change the lookback period from the 1 year default (eg 6 months):

image

Here’s the upside % from the 1 year low for the ASX Sectors, showing IT is the best at +59%. Click the link to save the workbook.

Upside.owb (29.1 KB)

image
image2080×1017 171 KB

3

Thanks Darren, I like the show view. Is it possible to add an average line to the RFE tool?
Thanks

4

Hi Peter,

The RFE tool is a dynamic label only, so the only way to see a moving average is to add the standard MA tool to the Show View.