NexusFi: Find Your Edge


Home Menu

 





SC Spreadsheet trading help


Discussion in Sierra Chart

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




 
Search this Thread
  #1 (permalink)
 addchild 
Bay Area California
 
Experience: None
Platform: TT T4
Broker: Phillip Capital
Trading: Futures
Posts: 809 since Nov 2011
Thanks Given: 927
Thanks Received: 896

I'm trying to program a strategy to pull some data, but I'm having trouble getting the system to exit positions.

Strategy: Sell every new High, buy every new low

GOAL:
I'm trying to flatten ALL positions when one of two things occurs.
1. Price crosses the midpoint ((H+L)/2)
2. RTH close.

PROBLEM:
Long and short positions accumulate, but only PARTIALLY close on any given signal. This results in some positions being open for days while all trades should be less than 24hrs.

Any advice is appreciated.


.
Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
No book, only a stair: journaling fills where price move …
Cryptocurrency
EA
Platforms and Indicators
My Rant with AMP Futures
Trading Reviews and Vendors
Datafeed for Atas
Platforms and Indicators
requesting .nrd replay files from 2026 spy and qqq
The Elite Circle
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Mes vs MNQ
6 thanks
NexusFi site changelog and issues/problem reporting
5 thanks
BERN ALGOS algo trading journal
3 thanks
TopStep Trader disappointment
2 thanks
Johnnys Journal
2 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


addchild View Post
I'm trying to program a strategy to pull some data, but I'm having trouble getting the system to exit positions.

Strategy: Sell every new High, buy every new low

GOAL:
I'm trying to flatten ALL positions when one of two things occurs.
1. Price crosses the midpoint ((H+L)/2)
2. RTH close.

PROBLEM:
Long and short positions accumulate, but only PARTIALLY close on any given signal. This results in some positions being open for days while all trades should be less than 24hrs.

Any advice is appreciated.

One way to flatten all positions is to use cell J29, with something like this:

=OR(J41-INT(J41)>TIMEVALUE("15:59:00"),AND(J8<>0,YourMidpointConditions))

The first half exits at the time between the quotes (edit as needed, leave the quotes), and the second half exits when you have a position and your midpoint conditions are TRUE.

The problem with your partial exits is probably due to the value/formula in J26. This cell controls both entry and exit quantities, and it overrides the Trade Window quantity.


Reply With Quote
Thanked by:




Last Updated on December 10, 2013


© 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