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?
El Clasico Draws $9.2M in Prediction Market Action -- Bi …
Prediction Markets & Event Contracts
Trump Truth Social Fires Hormuz From 10% to 59% -- Arsen …
Prediction Markets & Event Contracts
Prop Firm Tracked Payouts Hit $115M in Q1 but Growth Fla …
Funded Trading Evaluation Firms
Kalshi Sets $4.13B All-Time Weekly Record as Polymarket …
Prediction Markets & Event Contracts
OneChronos Launches First Combinatorial Auction FX Venue …
Currencies
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Sober Journey With S&P
23 thanks
2026 Jlab journal
10 thanks
Algo automated / semi-automated trading anyone?
6 thanks
Lady Vols Primer: Trading Volatility Journal
6 thanks
2026 Fire Horse
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