NexusFi: Find Your Edge


Home Menu

 





Average Price Change indicator


Discussion in Sierra Chart

Updated
      Top Posters
    1. looks_one skellington with 3 posts (1 thanks)
    2. looks_two Sawtooth with 2 posts (3 thanks)
    3. looks_3 job9 with 1 posts (0 thanks)
    4. looks_4 Trembling Hand with 1 posts (0 thanks)
    1. trending_up 2,986 views
    2. thumb_up 4 thanks given
    3. group 6 followers
    1. forum 7 posts
    2. attach_file 2 attachments




 
Search this Thread
  #1 (permalink)
 skellington 
San Jose, CA
 
Experience: Intermediate
Trading: Futures
Posts: 32 since May 2021
Thanks Given: 36
Thanks Received: 37

Hi, I'm looking for an indicator that shows the average price change over the last N bars.

Something like:

SUM_N_BARS(ABS(OPEN - CLOSE)) / N

This is not the same as ATR (average true range) and I can't find this indicator if it already exists.

Thanks!


Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Without Pulisic, USA 61.5% Live vs. Australia -- France …
Prediction Markets & Event Contracts
CME Group CEO Calls CFTC-Approved Crypto Perps Dangerous …
Traders Hideout
June 15 Peace Odds Surge From 3.6% to 12.25% After Trump …
Prediction Markets & Event Contracts
$500M Riding on World Cup 2026: France/Spain Co-Favored …
Prediction Markets & Event Contracts
The June 15 Resolution Trap: Irans Agreed Text Still Pri …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
NexusFi site changelog and issues/problem reporting
10 thanks
Darmok and Jalad at Tanagra
3 thanks
Big Mike in Ecuador
1 thanks
30 Sessions
1 thanks
  #2 (permalink)
 
AllSeeker's Avatar
 AllSeeker 
Mumbai, India
Pratik_4Clover
 
Experience: Beginner
Platform: TradingView & ZerodhaKite
Trading: NIFTY, BANKNIFTY
Frequency: Daily
Duration: Minutes
Posts: 1,535 since Jan 2019
Thanks Given: 5,611
Thanks Received: 5,317

Shot in the dark, but doesn't "ROC" indicator calculate the same, even better since its in % ?


Visit my NexusFi Trade Journal Reply With Quote
  #3 (permalink)
 skellington 
San Jose, CA
 
Experience: Intermediate
Trading: Futures
Posts: 32 since May 2021
Thanks Given: 36
Thanks Received: 37


Nope, ROC is the sum of the differences of the LAST prices over N bars.


Started this thread Reply With Quote
Thanked by:
  #4 (permalink)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: EdgeClear, FCM:Phillip, Data:Denali, Routing:Teton
Trading: YM RTY ES NQ
Posts: 480 since Nov 2009
Thanks Given: 222
Thanks Received: 608


Quoting 
Hi, I'm looking for an indicator that shows the average price change over the last N bars.

Try this:

Add the Spreadsheet Formula study.
- Put this formula in its Formula field: =ABS(O-C)
- Check 'Hide Study' (optional).

Add the Moving Average - Simple study.
- Set the 'Based On'' to the Spreadsheet Formula study.
- Set the 'Chart Region' to the same as the Spreadsheet Formula study.
- Set the 'Input Data' to Result
- Set the 'Length' to your requirements.


Reply With Quote
Thanked by:
  #5 (permalink)
 skellington 
San Jose, CA
 
Experience: Intermediate
Trading: Futures
Posts: 32 since May 2021
Thanks Given: 36
Thanks Received: 37

Thanks that does work, but is it normal for spreadsheet formula indicator to only calculate to N bars back (2000 is the default).

Other build in indicators just seem to calculate as needed and you can scroll back days or weeks and they work fine, but the spreadsheet formula based one stops after 2000 bars back (for example).


Started this thread Reply With Quote
  #6 (permalink)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: EdgeClear, FCM:Phillip, Data:Denali, Routing:Teton
Trading: YM RTY ES NQ
Posts: 480 since Nov 2009
Thanks Given: 222
Thanks Received: 608


Quoting 
is it normal for spreadsheet formula indicator to only calculate to N bars back (2000 is the default).

It is a limitation in other studies that contain user formulas:
-Color Bar Based On Alert Condition
-Color Background Based On Alert Condition
-Trading System Based On Alert Condition
-All 3 spreadsheet studies

If you want to see further back, you can scroll the chart into the past, do a Replay Chart, and hit Pause.


Reply With Quote
Thanked by:
  #7 (permalink)
 
SMCJB's Avatar
 SMCJB 
Houston TX
Legendary Market Wizard
 
Experience: Advanced
Platform: TT Stellar & Tradestation
Broker: Primarily Advantage Futures
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals, U308 and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,242 since Dec 2013
Thanks Given: 4,586
Thanks Received: 10,533

Your over complicating it.
If todays close is C and yesterdays close was C[1] then todays change is C-C[1]
It follows that the "average price change over the last 3 days" is
( (C - C[1]) + (C[1]-C[2]) + (C[2]-C[3]) ) / 3
which is just simply
(C- C[3])/3
Hence the "average price change over the last N days" is just (C-C[N])/N


Reply With Quote
  #8 (permalink)
 Trembling Hand 
Melbourne, Land of Oz
 
Experience: Advanced
Platform: Sierra Chart, CQG
Broker: CQG
Trading: HSI
Posts: 249 since Jun 2011
Thanks Given: 30
Thanks Received: 369

There is a way to do this with SC studies.
  1. Add the "Study Subgraphs Difference" Study
  2. Choose the Open and Close as the two inputs
  3. And a Simple Moving Average study and select the first difference as input


2021-06-14 12_44_20-Window




2021-06-14 12_56_41-Window


Follow me on X Reply With Quote




Last Updated on June 13, 2021


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts