Reply To: Script – Price Change

Optuma Forums Optuma Scripting Script – Price Change Reply To: Script – Price Change

#54221
Darren
Darren
  • Topics: 43
  • Replies: 299
  • Posts: 342

OK thanks. That would be a bit more difficult so if you’re interested in a scripting consultation let us know and we’ll look in to it, or maybe someone else would be willing to reply with a solution. Are you only interested in closing prices and not high / low prices?

There are a couple of other easier ways to measure and compare volatility:

1: Average True Range expressed as a percentage of the close – ATR(BARS=5) / CLOSE()

2: Bollinger BandwidthBBW(Bars=5)

Here’s the ASX200 sorted by lowest ATR as a % ie least volatile over the last 5 days, along with the BBW% (save and open the workbook attached):

Capture

Attachments:
  1. Volatility.owb

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