NexusFi: Find Your Edge


Home Menu

 





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


Discussion in Sierra Chart

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




 
Search this Thread
  #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?
$12M Ceasefire Contract Goes Disputed as Bandar Abbas St …
Prediction Markets & Event Contracts
Kharg Island at 6%, Regime Fall at 1.5% -- The Black Swa …
Prediction Markets & Event Contracts
CME Raises Energy Futures Margins After Iran-War Volatil …
Commodities
Iran Airspace Contract Surges to 33.5% as Project Freedo …
Prediction Markets & Event Contracts
NinjaTrader Parent Payward Acquires Bitnomial for $550M …
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Sober Journey With S&P
20 thanks
2026 Jlab journal
10 thanks
Trying to learn Volume and price action correlation
8 thanks
Algo automated / semi-automated trading anyone?
6 thanks
Lady Vols Primer: Trading Volatility Journal
5 thanks
  #2 (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

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: EdgeClear, FCM:Phillip, Data:Denali, Routing:Teton
Trading: YM RTY ES NQ
Posts: 480 since Nov 2009
Thanks Given: 222
Thanks Received: 608


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:	284
Size:	71.8 KB
ID:	246604  
Reply With Quote
  #7 (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


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


© 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