NexusFi: Find Your Edge


Home Menu

 





Can this be Done ?


Discussion in Sierra Chart

Updated
    1. trending_up 1,739 views
    2. thumb_up 1 thanks given
    3. group 3 followers
    1. forum 3 posts
    2. attach_file 1 attachments




 
Search this Thread
  #1 (permalink)
 Babool 
Detroit, MI
 
Experience: Master
Platform: Sierra Chart
Trading: NQ, CL, ES, GC
Posts: 95 since Jul 2011
Thanks Given: 17
Thanks Received: 125

This is what I want to do. I want to take a donchian channel and have the channel change based on a 3 and 12 bar simple moving average.

For example if the 3 bar moving average is > than the 12 bar moving average I want the top channel of the donchian channel to be hidden so that only the lower channel is showing on the chart. If the 3 bar moving average is < 12 bar moving average then I want the bottom channel hidden. It will kind of look like a parabolic when finished.

Any help on this would be appreciated incredibly. Thanks.

Regards


Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Zytrade: Devin Brady, CEO - Ask Me Anything (AMA)
Brokers
White House Drops First Alien Files Today -- Market Says …
Prediction Markets & Event Contracts
ATFX Suspends Prop Trading Unit ATFunded -- Full Review …
Funded Trading Evaluation Firms
Powell in 48 Hours: Word Markets Give 78% on Inflation, …
Prediction Markets & Event Contracts
Peace Deal Forward Curve: May 22%, June 51%, December 81 …
Prediction Markets & Event Contracts
 
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)
 pludloe 
Greenville, SC
 
Experience: Beginner
Platform: Sierra Chart
Trading: NQ
Posts: 39 since Jul 2015
Thanks Given: 170
Thanks Received: 65


Babool View Post
This is what I want to do. I want to take a donchian channel and have the channel change based on a 3 and 12 bar simple moving average.

For example if the 3 bar moving average is > than the 12 bar moving average I want the top channel of the donchian channel to be hidden so that only the lower channel is showing on the chart. If the 3 bar moving average is < 12 bar moving average then I want the bottom channel hidden. It will kind of look like a parabolic when finished.

Any help on this would be appreciated incredibly. Thanks.

Regards

Here is one way to do it. The Donchian is a 20 period, if you want to change it. I made the alerts >= and <= just because it looked better to me. Delete the equal signs if that's not what you want.


Attached Files
Elite Membership required to download: Donchianparabolic.StdyCollct
Reply With Quote
  #3 (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



Babool View Post
This is what I want to do. I want to take a donchian channel and have the channel change based on a 3 and 12 bar simple moving average.

For example if the 3 bar moving average is > than the 12 bar moving average I want the top channel of the donchian channel to be hidden so that only the lower channel is showing on the chart. If the 3 bar moving average is < 12 bar moving average then I want the bottom channel hidden. It will kind of look like a parabolic when finished.

Any help on this would be appreciated incredibly. Thanks.

Regards

It can be done using the Spreadsheet Study study.
Try this:
-Hide the Donchian Channel study
-Add the Spreadsheet Study study
-Set the Chart Region to 1
-Give the spreadsheet study a name in the Spreadsheet Name field
-Set the Draw Styles of SG1 and SG2 to Line-SkipZeros
-On the spreadsheet, use these formulas:
Cell K3:
=IF(ID2.SG1@3>ID3.SG1@3,ID1.SG2@3,0)
Cell L3:
=IF(ID2.SG1@3<ID3.SG1@3,ID1.SG1@3,0)
where ID2 and ID3 are the MAs, and ID1 is the Donchian Channel. Edit as needed.


Reply With Quote
Thanked by:
  #4 (permalink)
 Babool 
Detroit, MI
 
Experience: Master
Platform: Sierra Chart
Trading: NQ, CL, ES, GC
Posts: 95 since Jul 2011
Thanks Given: 17
Thanks Received: 125


tomgilb View Post
It can be done using the Spreadsheet Study study.
Try this:
-Hide the Donchian Channel study
-Add the Spreadsheet Study study
-Set the Chart Region to 1
-Give the spreadsheet study a name in the Spreadsheet Name field
-Set the Draw Styles of SG1 and SG2 to Line-SkipZeros
-On the spreadsheet, use these formulas:
Cell K3:
=IF(ID2.SG1@3>ID3.SG1@3,ID1.SG2@3,0)
Cell L3:
=IF(ID2.SG1@3<ID3.SG1@3,ID1.SG1@3,0)
where ID2 and ID3 are the MAs, and ID1 is the Donchian Channel. Edit as needed.

Wow, I can't thank you enough for taking the time to put this together for me. It works like a charm.


Started this thread Reply With Quote




Last Updated on February 2, 2017


© 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