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 SMCJB with 1 posts (0 thanks)
    4. looks_4 Trembling Hand with 1 posts (0 thanks)
    1. trending_up 2,160 views
    2. thumb_up 4 thanks given
    3. group 6 followers
    1. forum 7 posts
    2. attach_file 2 attachments




 
Search this Thread

Average Price Change indicator

  #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?
Better Renko Gaps
The Elite Circle
Deepmoney LLM
Elite Quantitative GenAI/LLM
Ninja Mobile Trader VPS (ninjamobiletrader.com)
Trading Reviews and Vendors
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
59 thanks
Funded Trader platforms
37 thanks
NexusFi site changelog and issues/problem reporting
24 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
19 thanks
  #2 (permalink)
 
AllSeeker's Avatar
 AllSeeker 
Mumbai, India
Legendary Pratik_4Clover
 
Experience: Beginner
Platform: TradingView & ZerodhaKite
Trading: NIFTY, BANKNIFTY
Frequency: Daily
Duration: Minutes
Posts: 1,423 since Jan 2019
Thanks Given: 5,245
Thanks Received: 5,006

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: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 219
Thanks Received: 603


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: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 219
Thanks Received: 603


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 and Stellar
Broker: Advantage Futures
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,041 since Dec 2013
Thanks Given: 4,375
Thanks Received: 10,192

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: 246 since Jun 2011
Thanks Given: 28
Thanks Received: 358

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 Twitter Reply With Quote




Last Updated on June 13, 2021


© 2024 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 - Privacy Policy - Downloads - Top
no new posts