Average Price Change indicator - futures io
futures io



Average Price Change indicator


Discussion in Sierra Chart

Updated
      Top Posters
    1. looks_one skellington with 3 posts (1 thanks)
    2. looks_two tomgilb 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 264 views
    2. thumb_up 4 thanks given
    3. group 6 followers
    1. forum 7 posts
    2. attach_file 2 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Search this Thread
 

Average Price Change indicator

(login for full post details)
  #1 (permalink)
 skellington 
San Jose, CA
 
Experience: Beginner
Trading: Futures
 
Posts: 17 since May 2021
Thanks: 14 given, 9 received

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 futures io?
EMA as a trailing stop
Traders Hideout
Looking for VisEMA indicator for NT7
NinjaTrader
looking for developer for pine scripts
Platforms and Indicators
you cant wait for life is not hard anymore before you de …
Psychology and Money Management
Find the largest volumes in the cluster
NinjaTrader
 
 
(login for full post details)
  #2 (permalink)
 AllSeeker 
Legendary Pratik_4Clover
Mumbai, India
 
Experience: Beginner
Platform: TradingView & ZerodhaKite
Trading: Crude, NIFTY, BANKNIFTY
 
AllSeeker's Avatar
 
Posts: 980 since Jan 2019
Thanks: 2,992 given, 3,035 received

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

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #3 (permalink)
 skellington 
San Jose, CA
 
Experience: Beginner
Trading: Futures
 
Posts: 17 since May 2021
Thanks: 14 given, 9 received


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

Started this thread Reply With Quote
The following user says Thank You to skellington for this post:
 
(login for full post details)
  #4 (permalink)
 tomgilb 
Nashville TN USA
 
Experience: Advanced
Platform: SierraChart
Broker: Sierra Futures/SC Denali
Trading: NQ ES YM
 
Posts: 448 since Nov 2009
Thanks: 173 given, 562 received


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
The following 2 users say Thank You to tomgilb for this post:
 
(login for full post details)
  #5 (permalink)
 skellington 
San Jose, CA
 
Experience: Beginner
Trading: Futures
 
Posts: 17 since May 2021
Thanks: 14 given, 9 received

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
 
(login for full post details)
  #6 (permalink)
 tomgilb 
Nashville TN USA
 
Experience: Advanced
Platform: SierraChart
Broker: Sierra Futures/SC Denali
Trading: NQ ES YM
 
Posts: 448 since Nov 2009
Thanks: 173 given, 562 received


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
The following user says Thank You to tomgilb for this post:
 
(login for full post details)
  #7 (permalink)
 SMCJB 
Legendary Market Wizard
Houston, TX
 
Experience: Advanced
Platform: Trading Technologies
Broker: Primary Advantage Futures. Also ED&F and Tradestation
Trading: Primarily Energy but also a little GE, GC, SI & Bitcoin
 
Posts: 4,152 since Dec 2013
Thanks: 3,474 given, 8,226 received

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
 
(login for full post details)
  #8 (permalink)
 Trembling Hand 
Melbourne, Land of Oz
 
Experience: Advanced
Platform: Sierra Chart, CQG
Broker: CQG
Trading: HSI
 
Posts: 187 since Jun 2011
Thanks: 17 given, 269 received

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


futures io Trading Community Platforms and Indicators Sierra Chart > Average Price Change indicator


Last Updated on June 13, 2021


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing

BloodHound Fundamentals 101 w/Jeremy Tang @ SharkIndicators

Elite only
 

Our 12-year anniversary w/ $$,$$$ prizes (check soon)

June
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada), info@futures.io
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.
no new posts