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,442 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?
Zytrade: Devin Brady, CEO - Ask Me Anything (AMA)
Brokers
White House Drops First Alien Files Today -- Market Says …
Prediction Markets & Event Contracts
ATFX Suspends Prop Trading Unit ATFunded -- Full Review …
Funded Trading Evaluation Firms
Powell in 48 Hours: Word Markets Give 78% on Inflation, …
Prediction Markets & Event Contracts
Peace Deal Forward Curve: May 22%, June 51%, December 81 …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Big Mike in Ecuador
205 thanks
Sober Journey With S&P
21 thanks
30 Sessions
20 thanks
Volume Indicators
8 thanks
Thanks Mike. Godspeed.
7 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