NexusFi: Find Your Edge


Home Menu

 





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


Discussion in Sierra Chart

Updated
    1. trending_up 1,603 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?
Trade idea based off three indicators.
Traders Hideout
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
REcommedations for programming help
Sierra Chart
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
Quant vue
Trading Reviews and Vendors
 
  #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: 219
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: 219
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:	197
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: 219
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