NexusFi: Find Your Edge


Home Menu

 





How To: Spreadsheet auto trade.. lmt buy -2 ticks


Discussion in Sierra Chart

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




 
Search this Thread

How To: Spreadsheet auto trade.. lmt buy -2 ticks

  #1 (permalink)
 scottemp 
Chicago, IL
 
Experience: Intermediate
Platform: SC
Trading: ES
Posts: 17 since Jan 2013
Thanks Given: 21
Thanks Received: 3

Hi,

When using the Spreadsheet System for Trading, is there a way when the K col (Buy Entry) or M col (Sell Entry) is set True to enter a limit of -/+2 ticks of Col E (Last Price) instead of a Buy Market at the Current Price?

Thank You!!!

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Exit Strategy
NinjaTrader
Better Renko Gaps
The Elite Circle
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
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
18 thanks
The Program
18 thanks
  #2 (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: 216
Thanks Received: 603

To place a Limit entry 2 ticks from the Close of the signal in K3 or M3, do this:
-Put this in J22:
=E4-2*J21
Put this in J24:
=E4+2*J21
-Set J71 and J73 to L

Reply With Quote
  #3 (permalink)
 scottemp 
Chicago, IL
 
Experience: Intermediate
Platform: SC
Trading: ES
Posts: 17 since Jan 2013
Thanks Given: 21
Thanks Received: 3


THANKS SO VERY MUCH!!!!!!!!

Started this thread Reply With Quote
Thanked by:
  #4 (permalink)
inverter633
canada
 
Posts: 39 since Jan 2016
Thanks Given: 5
Thanks Received: 15


tomgilb View Post
To place a Limit entry 2 ticks from the Close of the signal in K3 or M3, do this:
-Put this in J22:
=E4-2*J21
Put this in J24:
=E4+2*J21
-Set J71 and J73 to L

hy tom, i have a problem save after putting the formula in scss, when i quit the sierra.
when I turn it on again every time I lose the formulas ,,, what am I doing wrong?
I tried saving scss especially..cht save specially and analisis especially save..and still lose all formulas when I restart my computer

Reply With Quote
  #5 (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: 216
Thanks Received: 603


inverter633 View Post
hy tom, i have a problem save after putting the formula in scss, when i quit the sierra.
when I turn it on again every time I lose the formulas ,,, what am I doing wrong?
I tried saving scss especially..cht save specially and analisis especially save..and still lose all formulas when I restart my computer

Make sure you are working on the Sheet# that matches the the 'Formula Source Sheet Number' in the spreadsheet study settings.

Reply With Quote
Thanked by:
  #6 (permalink)
inverter633
canada
 
Posts: 39 since Jan 2016
Thanks Given: 5
Thanks Received: 15

is that all ok?

Attached Thumbnails
Click image for larger version

Name:	shet.png
Views:	192
Size:	71.8 KB
ID:	246604  
Reply With Quote
  #7 (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: 216
Thanks Received: 603


inverter633 View Post
is that all ok?

You should have started a new thread for this question, because it is unrelated to the original title and subject.

If the spreadsheet study is only on one chart, keep it simple:
-Set the 'Chart Data Output Sheet Number' to 0
-Set the 'Formula Source Sheet Number' to match its Chart#
-Set the 'Always Set Formula Source Sheet Number To Output Sheet Number' to No
-Only work on the Sheet# that matches its Chart#

Reply With Quote
Thanked by:
  #8 (permalink)
inverter633
canada
 
Posts: 39 since Jan 2016
Thanks Given: 5
Thanks Received: 15


tomgilb View Post
You should have started a new thread for this question, because it is unrelated to the original title and subject.

If the spreadsheet study is only on one chart, keep it simple:
-Set the 'Chart Data Output Sheet Number' to 0
-Set the 'Formula Source Sheet Number' to match its Chart#
-Set the 'Always Set Formula Source Sheet Number To Output Sheet Number' to No
-Only work on the Sheet# that matches its Chart#

excuse for the wrong topic, but thank you very much for it

Reply With Quote




Last Updated on February 4, 2018


© 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