NexusFi: Find Your Edge


Home Menu

 





Sierra Chart Worksheet System For Trading/Alert Discussions


Discussion in Sierra Chart

Updated
      Top Posters
    1. looks_one Sawtooth with 73 posts (125 thanks)
    2. looks_two luckcity with 43 posts (2 thanks)
    3. looks_3 RT912 with 12 posts (0 thanks)
    4. looks_4 bxman with 10 posts (0 thanks)
      Best Posters
    1. looks_one Sawtooth with 1.7 thanks per post
    2. looks_two aBuzz54 with 1 thanks per post
    3. looks_3 tradermark2009 with 0.5 thanks per post
    4. looks_4 MWG86 with 0.3 thanks per post
    1. trending_up 64,420 views
    2. thumb_up 139 thanks given
    3. group 44 followers
    1. forum 182 posts
    2. attach_file 9 attachments




 
 

Sierra Chart Worksheet System For Trading/Alert Discussions

 
luckcity
sydney australia
 
Posts: 44 since Jul 2012
Thanks Given: 26
Thanks Received: 2

Hi Tom,

And Happy New Year!
Thanks so much for the Study Angle suggestion, and I should have known determining ranges can be done from columns B-G.

Today I'm trying to create a counter that will only enable after getting to 2.
I don't think an If statement can send a value to a different cell, was hoping to do something like
=IF(CROSSFROMABOVE(AS3:AS4,AA3:AA4),H6=1,0)
having H6 be the counter, but I'm guessing the all the counting will have to be done in one formula.

It won't be as easy as seen in other "counters", where e.g the previous bar is FALSE, and the current bar is TRUE, either.

This counter counts entry signals, and a separate formula (that happens to be the exit signal) zeroes the counter.

Ive seen the double-if, suggested in the past, that will persist the 1st if until the 2nd resets.
Could my counter be done similarly, perhaps using a triple if?
Or is there another way to do it where the enabling value is set in a simpler fashion?


Can you help answer these questions
from other members on NexusFi?
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
Better Renko Gaps
The Elite Circle
NexusFi Journal Challenge - April 2024
Feedback and Announcements
Futures True Range Report
The Elite Circle
Deepmoney LLM
Elite Quantitative GenAI/LLM
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
The Program
18 thanks
GFIs1 1 DAX trade per day journal
18 thanks
 
 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: 216
Thanks Received: 603


luckcity View Post
Hi Tom,

And Happy New Year!
Thanks so much for the Study Angle suggestion, and I should have known determining ranges can be done from columns B-G.

Today I'm trying to create a counter that will only enable after getting to 2.
I don't think an If statement can send a value to a different cell, was hoping to do something like
=IF(CROSSFROMABOVE(AS3:AS4,AA3:AA4),H6=1,0)
having H6 be the counter, but I'm guessing the all the counting will have to be done in one formula.

It won't be as easy as seen in other "counters", where e.g the previous bar is FALSE, and the current bar is TRUE, either.

This counter counts entry signals, and a separate formula (that happens to be the exit signal) zeroes the counter.

Ive seen the double-if, suggested in the past, that will persist the 1st if until the 2nd resets.
Could my counter be done similarly, perhaps using a triple if?
Or is there another way to do it where the enabling value is set in a simpler fashion?

Counting formulas, like persistent variable formulas, must be in a Formula Column.

You could just count from 1, and then require it be n-1 in the cell that references it.
If that doesn't work, you could use another Formula Column that simply subtracts 1 from the counting formula column.

Use a formula like this, e.g. in O3:
=IF(L3,0,IF(K3,O4+1,O4))

Started this thread
Thanked by:
 
luckcity
sydney australia
 
Posts: 44 since Jul 2012
Thanks Given: 26
Thanks Received: 2


Hi Tom,
Increment the same cell's count and reference the last bar,
=IF(L3,0,IF(K3,O4+1,O4))
worked as suggested, thanks, had been looking at how to do counting for quite a while.
I am very close to going LIVE trading, now.

Not thinking next question is about formulas, but rather the spreadsheet setup.
Trying to create a stop order that is 30 ticks from the signal, and then cancel it after X bars.

The Working Orders cancel is working in J27.

Its the offset I'm having issues with.
J22 the Price cell, is
=IF(K3=1,E3+30,0)
and the target price appears there when Buy entry is true, expected.
And J71 (order type) is S for Stop.

But order seen is Market, after end of signal candle, not expected Stop, thirty ticks away.

Thanked by:
 
 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: 216
Thanks Received: 603


luckcity View Post
Hi Tom,
Increment the same cell's count and reference the last bar,
=IF(L3,0,IF(K3,O4+1,O4))
worked as suggested, thanks, had been looking at how to do counting for quite a while.
I am very close to going LIVE trading, now.

Not thinking next question is about formulas, but rather the spreadsheet setup.
Trying to create a stop order that is 30 ticks from the signal, and then cancel it after X bars.

The Working Orders cancel is working in J27.

Its the offset I'm having issues with.
J22 the Price cell, is
=IF(K3=1,E3+30,0)
and the target price appears there when Buy entry is true, expected.
And J71 (order type) is S for Stop.

But order seen is Market, after end of signal candle, not expected Stop, thirty ticks away.

You must reference the ticksize:
=IF(K3=1,E3+30*J21,0)
If your entries are at close of bar, you must also reference row 4:
=IF(K4=1,E4+30*J21,0)

Started this thread
Thanked by:
 
luckcity
sydney australia
 
Posts: 44 since Jul 2012
Thanks Given: 26
Thanks Received: 2

Thanks for the offset info Tom,

Sounds like it was a formula issue after all.
Sorry, I saw the doc saying it required the tick size cell, but assumed since was working with tick size of 1, it wouldn't be needed.
I'm not sure it works, as I haven't had time this week yet, but thanks in advance.

Wanted to ask one more before the weekend, when I'll be able to do more

I'm guessing this question is the one that is answered "only with ASCIL, not in a spreadsheet."
1.
Is there anyway, by using Management by Study, or the Exit cells, to single out a contract, say the first of two, to exit differently than the 2nd contract?

Attached order management is great, but was hoping for just a little more control.
I think this was answered with the expected answer on the support board, here.

Too bad that two charts, with accompanying ss's isn't possible.
2.
I'd like to sneak in a 2nd question.
Is there "shorthand" for ranges, such as
=OR(P3=1,P4=1,P5=1,P6=1,P7=1,P8=1,P9=1,P10=1,P11=1,P12=1,K4<>1,K5<>1,K6<>1,K7<>1,K8<>1,K9<>1,K10<>1,K11<>1,K12<>1,K13<>1,K14<>1)
Think I saw a solution in the docs by using "...", but can't find it now.
Perhaps counters are the best for these situations

 
 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: 216
Thanks Received: 603


luckcity View Post
Thanks for the offset info Tom,

Sounds like it was a formula issue after all.
Sorry, I saw the doc saying it required the tick size cell, but assumed since was working with tick size of 1, it wouldn't be needed.
I'm not sure it works, as I haven't had time this week yet, but thanks in advance.

Wanted to ask one more before the weekend, when I'll be able to do more

I'm guessing this question is the one that is answered "only with ASCIL, not in a spreadsheet."

Is there anyway, by using Management by Study, or the Exit cells, to single out a contract, say the first of two, to exit differently than the 2nd contract?

Attached order management is great, but was hoping for just a little more control.
I think this was answered with the expected answer on the support board, here.

Too bad that two charts, with accompanying ss's isn't possible

The Trade Management by Study study can only move one stop, it is always the one closest to the current price.
It's not possible to assign a specific stop to a separate instance of the TMS study, so using multiple instances would not provide any benefit.

It is possible to scale out using the Spreadsheet System for Trading study, using different conditions for each exit, albeit complex. You can even combine formula exits and Attached Orders' stops.

It is also possible to use 2 charts in the same chartbook, using the same-named spreadsheet, to do some fancy things, again complex. But the need for this would be rare, given other potentialities.

Started this thread
Thanked by:
 
bradhouser
Northern California where the girls are warm
 
Posts: 122 since Nov 2010
Thanks Given: 15
Thanks Received: 72


luckcity View Post
Is there "shorthand" for ranges, such as
=OR(P3=1,P4=1,P5=1,P6=1,P7=1,P8=1,P9=1,P10=1,P11=1,P12=1,K4<>1,K5<>1,K6<>1,K7<>1,K8<>1,K9<>1,K10<>1,K11<>1,K12<>1,K13<>1,K14<>1)
Think I saw a solution in the docs by using "...", but can't find it now.
Perhaps counters are the best for these situations

If P3, K4, etc. are either a 1 or a 0, then =OR(P3=1,P4=1, etc.) is the same as =OR(P3,P4,etc.)

For K4, K5, etc, you can use the Not operator ("!"), so =OR(K5<>1,K6<>1,etc.) is the same as =OR(!K5,!K6, etc).

 
 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: 216
Thanks Received: 603


Quoting 
2.
I'd like to sneak in a 2nd question.
Is there "shorthand" for ranges, such as
=OR(P3=1,P4=1,P5=1,P6=1,P7=1,P8=1,P9=1,P10=1,P11=1,P12=1,K4<>1,K5<>1,K6<>1,K7<>1,K8<>1,K9<>1,K10<>1,K11<>1,K12<>1,K13<>1,K14<>1)
Think I saw a solution in the docs by using "...", but can't find it now.
Perhaps counters are the best for these situations

Try this:
Use a Formula Column to find all of the <>1 in K, e.g. column Q:
=K3<>1
In column R:
OR(SUM(P3:P12)>0,SUM(Q4:Q14)>0)

Started this thread
Thanked by:
 
luckcity
sydney australia
 
Posts: 44 since Jul 2012
Thanks Given: 26
Thanks Received: 2

Hi Tom,

Back again for your help...

I wish to see a formula column cell show true when one of the SG columns have shown the highest value of the day's session (time set in J75)
e.g
[ID1.SG1] Volume is in column AA

AA3 270 true
AA4 120
AA5 80
AA6 230 true
AA7 130
AA8 200 true (session open)

I could do it, with a lot of OR's, but not quite sure how to clear the data from before session start

 
 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: 216
Thanks Received: 603


You'll need to create an incrementing variable that resets at the session start, then find each time it increments.
The following example uses volume in column F:

Put this in cell O3:
=IF(OR(INT(A3)>INT(A4),AND(FRACTIME(A4)<$J$75,FRACTIME(A3)>=$J$75)),0,IF(F3>O4,F3,O4))
This resets at a new day or at the time in J75, and increments each time volume is greater.

Put this in P3:
=O3>O4
This finds each time it increments.

Started this thread
Thanked by:

 



Last Updated on January 3, 2022


© 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