NexusFi: Find Your Edge


Home Menu

 





High/Low horizontal line of n bars


Discussion in Sierra Chart

Updated
      Top Posters
    1. looks_one EdgeOfChaos with 4 posts (0 thanks)
    2. looks_two mkata with 2 posts (1 thanks)
    3. looks_3 Sawtooth with 1 posts (3 thanks)
    4. looks_4 jdrower with 1 posts (0 thanks)
    1. trending_up 1,962 views
    2. thumb_up 4 thanks given
    3. group 4 followers
    1. forum 8 posts
    2. attach_file 2 attachments




 
Search this Thread

High/Low horizontal line of n bars

  #1 (permalink)
EdgeOfChaos
Paris/France
 
Posts: 14 since Feb 2017
Thanks Given: 4
Thanks Received: 0

Hello all,
Is it possible, with one of the standard studies, to draw an horizontal line to the high and one to the low of n bars and once those n bars are reach, the level created remain through the day.
I've tried doing it with the "Highest High/Lowest Low Over N Bars" study but, as expected, the lines keep moving throughout the day as the line are redrawn after each 5 new bars...
Cheers.

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Trade idea based off three indicators.
Traders Hideout
Better Renko Gaps
The Elite Circle
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
About a successful futures trader who didn´t know anyth …
Psychology and Money Management
Quant vue
Trading Reviews and Vendors
 
  #2 (permalink)
 mkata 
Columbus, OH
 
Experience: Intermediate
Platform: SierraChart
Trading: CL
Posts: 35 since May 2013
Thanks Given: 153
Thanks Received: 24

This request is unclear to me, could you annotate a pic of what you're trying to do. It might clear up my confusion.

Reply With Quote
  #3 (permalink)
 jdrower 
Alameda, CA
 
Experience: Intermediate
Platform: Sierracharts
Trading: NQ
Posts: 45 since Oct 2011
Thanks Given: 177
Thanks Received: 30


Have you used Highest-Lowest over a specific time frame?

Reply With Quote
  #4 (permalink)
EdgeOfChaos
Paris/France
 
Posts: 14 since Feb 2017
Thanks Given: 4
Thanks Received: 0

Ok, sorry for the lack of clarity, i'm trying to keep track of the highs and lows of, for instance, the first 10 (range bars) starting at the European open 8h00.
I've joined pictures showing what i'm trying to explain.

The first one is what i'm looking for, At 8h00 the first candle starts (drawing a low in this instance) and ten candles later no more high/low are taken into consideration, keeping the highest high of the ten candles (drawn at the 6th candles) throughout the day.
I can't really use a time specific high/low as i'm using range bars and am trying to get the the high /low of those 10 first range candles starting at a specific time (8h00 in the morning kin this example.)

The second picture is a chart using the "Highest High/Lowest Low Over N Bars" study and is not what i want.

I hope this rather laborious wall of text is making any sense
Cheers

Attached Thumbnails
Click image for larger version

Name:	2017-06-22_09h56_39.png
Views:	280
Size:	9.0 KB
ID:	236354   Click image for larger version

Name:	2017-06-22_09h58_36.png
Views:	231
Size:	10.1 KB
ID:	236355  
Reply With Quote
  #5 (permalink)
 
CenFlo's Avatar
 CenFlo 
Tampa FL
 
Experience: None
Platform: TOS/TradingView
Broker: TDA
Trading: Equities/Cryptos
Posts: 642 since Apr 2016
Thanks Given: 830
Thanks Received: 960

You could try using the High / Low for time period and specify in the study the time to plot the lines based on what time frame of chart you are using.

Edit, just reread the above post and see that using a time frame isn't going to work.

You miss 100% of the shots you don't take. - Wayne Gretsky
Follow me on Twitter Reply With Quote
  #6 (permalink)
 mkata 
Columbus, OH
 
Experience: Intermediate
Platform: SierraChart
Trading: CL
Posts: 35 since May 2013
Thanks Given: 153
Thanks Received: 24

lol, yes that laborious wall of text made it much more clear, thanks

The only automated way to do what you want is to write an ACSIL program or build the criteria in the SC spreadsheet.

Short of that, you would have to identify the time of bar 10 and manually enter the approximate end time in the High/Low for Time Period - Extended study. This will work perfectly well with range bars too.

Reply With Quote
Thanked by:
  #7 (permalink)
EdgeOfChaos
Paris/France
 
Posts: 14 since Feb 2017
Thanks Given: 4
Thanks Received: 0

All right then, looks like i'm going to learn how to properly use the SC spreadsheet function then !! or go the goold old manual way.
Thanks for the reply guys, and thanks to you too mkata for listing me the alternative options.

Reply With Quote
  #8 (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


EdgeOfChaos View Post
All right then, looks like i'm going to learn how to properly use the SC spreadsheet function then !! or go the goold old manual way.
Thanks for the reply guys, and thanks to you too mkata for listing me the alternative options.

Here is how to do what you want using the Spreadsheet Study study:

Add the Spreadsheet Study study
1) On the Settings and Inputs tab:
-Set the Chart Region to 1
-Give it a name in the Spreadsheet Name field

2) On the Subgraphs tab:
-Set the subgraph Draw Styles like this:
K (SG1): Ignore
L (SG2): Stair Step
M (SG3): Stair Step
N (SG4): Stair Step
O (SG5): Stair Step
-Set SG2 and SG3 colors the same
-Set SG4 and SG5 colors the same

3)On the spreadsheet, use these formulas:
Cell K3:
 
Code
=IF(A3-INT(A3)>TIMEVALUE("08:00:00")+8/24,0,IF(MROUND(A3-INT(A3),1/86400)=TIMEVALUE("08:00:00"),1,K4+1))
Cell L3:
 
Code
=IF(AND(K3>0,K3<=10),MAX(C3,L4),0)
Cell M3:
 
Code
=IF(L3>0,0,IF(K4=10,L4,M4))
Cell N3:
 
Code
=IF(AND(K3>0,K3<=10),MINZ(D3,N4),0)
Cell O3:
 
Code
=IF(N3>0,0,IF(K4=10,N4,O4))

Reply With Quote
  #9 (permalink)
EdgeOfChaos
Paris/France
 
Posts: 14 since Feb 2017
Thanks Given: 4
Thanks Received: 0

Wow that's very nice of you tomgilb !! Thanks you very much!! I'm going to test it this afternoon

Reply With Quote




Last Updated on June 26, 2017


© 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