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

 
 Jesal 
Canada
 
Experience: Intermediate
Platform: SIERRA
Trading: ES
Posts: 26 since Apr 2015
Thanks Given: 93
Thanks Received: 8


tomgilb View Post
Yes, you can scale in using the Spreadsheet System for Trading study.

ln:12 would need to be Yes.
You will need a formula in J26 that returns the correct entry quantity for the initial and subsequent entries.
The K3/M3 formulas will need to be able to trigger the initial entry and subsequent entries.
There might be other settings and formulas to consider, depending on your specific system.


Thanks a lot Tom, appreciate your help.
I think it's clear, but I think I'm missing something as it doesn't enter a second trade.
Here's what I did for order quantity...

K3: =AND(ID5.SG19@4>0, ID5.SG1@3>25)
J26: =IF(J10>10, 2,1) ***if profit/loss >10, enter another order.

It's not adding a scale in. Not sure if it references J26 again once in a trade...
Not quite sure how to modify K3 for 2nd entry...


Can you help answer these questions
from other members on NexusFi?
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
Deepmoney LLM
Elite Quantitative GenAI/LLM
ZombieSqueeze
Platforms and Indicators
NexusFi Journal Challenge - April 2024
Feedback and Announcements
 
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
38 thanks
NexusFi site changelog and issues/problem reporting
27 thanks
GFIs1 1 DAX trade per day journal
19 thanks
The Program
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


Quoting 
Not sure if it references J26 again once in a trade

When K3/M3 goes TRUE, the value in J26 will be used, regardless if you're flat or not.

Quoting 
Not quite sure how to modify K3 for 2nd entry

The K3/M3 formula will have an OR statement because there are two conditions for entries, 1st and 2nd.
Something like this, where the two conditions are exclusive:
K3: =OR(AND(ID5.SG19@4>0, ID5.SG1@3>25),AND($J$10>10,$J$8>0))

Note: this J26 formula: =IF(J10>10, 2,1) will only be true when there is an open profit, not loss.

Started this thread
Thanked by:
 
 Grantx 
Reading UK
Legendary no drama Llama
 
Experience: None
Posts: 1,787 since Oct 2016
Thanks Given: 2,826
Thanks Received: 5,058


Hi @tomgilb
Using the Zig Zag and spreadsheet study, how would I populate a column containing certain basic calculations such as:
Average of the last 10 printed swing sizes
Difference between the last 2 high swings
Difference between the last 2 low swings

etc..

I really just want to populate a single cell with a formula and then place the results as text on the chart. The worksheet formulas seem to copy down the entire column and the problem with the zig zag study is that the numbers are constantly changing until a swing has been firmly established.This means the text indicator constantly changes.

Thanks.

Visit my NexusFi Trade Journal
 
 Jesal 
Canada
 
Experience: Intermediate
Platform: SIERRA
Trading: ES
Posts: 26 since Apr 2015
Thanks Given: 93
Thanks Received: 8


tomgilb View Post
When K3/M3 goes TRUE, the value in J26 will be used, regardless if you're flat or not.

The K3/M3 formula will have an OR statement because there are two conditions for entries, 1st and 2nd.
Something like this, where the two conditions are exclusive:
K3: =OR(AND(ID5.SG19@4>0, ID5.SG1@3>25),AND($J$10>10,$J$8>0))

Note: this J26 formula: =IF(J10>10, 2,1) will only be true when there is an open profit, not loss.

I have everything entered like above.
Once I'm on a trade and profit is more than 10ticks, it still does not scale in. Thinking I screwed up the settings. Is there anything here that sticks out that is completely wrong?


 
 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 
Is there anything here that sticks out that is completely wrong?

Based on your J26 formula, Maximum Position Allowed (ln:20) would need to be 3 or larger.

Also, 30000 rows is huge. You might see some lag with this setting. 1000 rows is recommended, and is usually sufficient.

Started this thread
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


Grantx View Post
Hi @tomgilb
Using the Zig Zag and spreadsheet study, how would I populate a column containing certain basic calculations such as:
Average of the last 10 printed swing sizes
Difference between the last 2 high swings
Difference between the last 2 low swings

etc..

I really just want to populate a single cell with a formula and then place the results as text on the chart. The worksheet formulas seem to copy down the entire column and the problem with the zig zag study is that the numbers are constantly changing until a swing has been firmly established.This means the text indicator constantly changes.

Thanks.

You would need to use this method to bring previous Zigzag values to row 3, each in their own Formula Column:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetExampleFormulasAndUsage.php

Started this thread
 
 Jesal 
Canada
 
Experience: Intermediate
Platform: SIERRA
Trading: ES
Posts: 26 since Apr 2015
Thanks Given: 93
Thanks Received: 8

No wonder my Sierra started to slow down a bit I was testing and forgot to put it back to 1000

Thanks a lot Tom, it's working now...
tomgilb View Post
Based on your J26 formula, Maximum Position Allowed (ln:20) would need to be 3 or larger.

Also, 30000 rows is huge. You might see some lag with this setting. 1000 rows is recommended, and is usually sufficient.

Sent using the NexusFi mobile app

 
 bxman 
Kent / UK
 
Experience: Beginner
Platform: Sierra Chart
Posts: 162 since Nov 2019
Thanks Given: 23
Thanks Received: 24

Hi,
Am trying to figure out how to code around pivot points and want the logic to follow:

If no trade is open and first attempt at pp1
If crossfromabove pp1-- buy
If crossfrombelow pp1 -- sell

If no trade is open and previous trade at pp1 was a winner
If crossfromabove pp1-- buy
If crossfrom below pp1 -- sell

If no trade is open and previous trade at pp1 was a loser
-skip this trade
-reset attempt counter so thrid attempt can be true...i.e. doesnt remember the 1st loser

Hope this makes sense
Thanks in advance

Visit my NexusFi Trade Journal
 
 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


bxman View Post
Hi,
Am trying to figure out how to code around pivot points and want the logic to follow:

If no trade is open and first attempt at pp1
If crossfromabove pp1-- buy
If crossfrombelow pp1 -- sell

If no trade is open and previous trade at pp1 was a winner
If crossfromabove pp1-- buy
If crossfrom below pp1 -- sell

If no trade is open and previous trade at pp1 was a loser
-skip this trade
-reset attempt counter so thrid attempt can be true...i.e. doesnt remember the 1st loser

Hope this makes sense
Thanks in advance

Since there is no restriction to entries after winners, skipping an entry when you've had a loser is the only condition that needs to be limited.

I would approach this by 'Locking the State of a One Time Condition'
https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudiesSpecialTasks.php
Here is another example of its use:
https://www.sawtoothtrade.com/example-9.html

Add the Trading: Losing Trades study and lock a TRUE/1 when it changes value. Then release it one bar after the next entry signal.
Its reference must be FALSE/0 in your K3/M3 entry formulas.

Arriving at the actual formula to do this automatically will probably require some trial and error. And it can be difficult to get it to work the way you want.

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


Hi, see you have moved to Nashville, Tom

Have received help earlier on how to find lowest volumes of a session
=IF(OR(INT(A3)>INT(A4),AND(FRACTIME(A4)<$H$10,FRACTIME(A3)>=$H$10)),10000,IF(F3<S4,F3,S4))
(using start time in $H$10, with formula put in S column)

but not sure on how to calculate a running average of all values
from an opening bell.
Any help appreciated


 



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