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 Trembling Hand with 1 posts (0 thanks)
    4. looks_4 AllSeeker with 1 posts (0 thanks)
    1. trending_up 2,917 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?
Kharg Island at 6%, Regime Fall at 1.5% -- The Black Swa …
Prediction Markets & Event Contracts
Trump Truth Social Fires Hormuz From 10% to 59% -- Arsen …
Prediction Markets & Event Contracts
One Wallet Made $200K in Hours: AP Probes Polymarket Cea …
Prediction Markets & Event Contracts
Iran Lebanon Problem Kills Switzerland Talks, Brent at $ …
Prediction Markets & Event Contracts
CFTC Opens First COT Report Review in 20 Years -- Asks W …
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Big Mike in Ecuador
205 thanks
Sober Journey With S&P
21 thanks
30 Sessions
20 thanks
Volume Indicators
8 thanks
Thanks Mike. Godspeed.
7 thanks
  #2 (permalink)
 
AllSeeker's Avatar
 AllSeeker 
Mumbai, India
 
Experience: Beginner
Platform: TradingView & ZerodhaKite
Trading: NIFTY, BANKNIFTY
Frequency: Daily
Duration: Minutes
Posts: 1,533 since Jan 2019
Thanks Given: 5,601
Thanks Received: 5,315

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,241 since Dec 2013
Thanks Given: 4,586
Thanks Received: 10,531

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