NexusFi: Find Your Edge


Home Menu

 





what should I put in the buy exit or sell exit cell in spreadsheet if I want to clos


Discussion in Sierra Chart

Updated
    1. trending_up 3,410 views
    2. thumb_up 1 thanks given
    3. group 2 followers
    1. forum 5 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
hmgl
Shanghai,China
 
Posts: 3 since Aug 2016
Thanks Given: 1
Thanks Received: 0

what should I put in the buy exit or sell exit cell in spreadsheet if I want to close position on current bar close ?


Reply With Quote

Can you help answer these questions
from other members on NexusFi?
After $87M Settles NO: Irans Nuclear Redline Sets Up the …
Prediction Markets & Event Contracts
CFTC Workforce Shrinks 24% to 15-Year Low While Predicti …
Traders Hideout
Bookmap Global Plus Lifetime + Lifetime Addons For Sale
Platforms and Indicators
The May 31 Binary: 60% Trump Declares Iran Ops Over, Onl …
Prediction Markets & Event Contracts
CPI Eve: Fed Hike Odds Hold at 52% for the First Time, I …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Sober Journey With S&P
24 thanks
2026 Jlab journal
10 thanks
Algo automated / semi-automated trading anyone?
6 thanks
Lady Vols Primer: Trading Volatility Journal
6 thanks
Trying to learn Volume and price action correlation
5 thanks
  #3 (permalink)
bradhouser
Northern California where the girls are warm
 
Posts: 125 since Nov 2010
Thanks Given: 16
Thanks Received: 72


To close a trade, put a formula that evaluates to True or 1 based on what ever condition you want. For example if the 50 ema is study ID 1, subgraph 1, and you want to exit when the last price of the bar is greater than the 50 ema, you would put =E3>ID1.SG1@3


Sent from my iPad using NexusFi


Reply With Quote
  #4 (permalink)
bradhouser
Northern California where the girls are warm
 
Posts: 125 since Nov 2010
Thanks Given: 16
Thanks Received: 72

To only exit when you are in a trade, you should check cell J8 to be > 0 for a Buy Exit. So the above formula would be =AND(E3>ID1.SG1@3,J$8>0)



Sent from my iPad using NexusFi


Reply With Quote
Thanked by:
  #5 (permalink)
hmgl
Shanghai,China
 
Posts: 3 since Aug 2016
Thanks Given: 1
Thanks Received: 0

J8 in my version is not the one you mentioned. And I just want to exit without any ema stuff. How can I do that ?


Reply With Quote
  #6 (permalink)
bradhouser
Northern California where the girls are warm
 
Posts: 125 since Nov 2010
Thanks Given: 16
Thanks Received: 72

Perhaps I misunderstood the question. To exit a long trade cell L3 should be set to 1. To exit a short trade cell N3 should be set to one. Does that help?


Sent from my iPad using NexusFi


Reply With Quote




Last Updated on February 15, 2017


© 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