NexusFi: Find Your Edge


Home Menu

 





SC Spreadsheet trading help


Discussion in Sierra Chart

Updated
    1. trending_up 1,829 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: 899

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?
Strike Pause Holds, Oil Erases Monday Spike -- May CPI W …
Traders Hideout
Election Sunday Resolves: Peru Heads to Runoff at 42pct, …
Prediction Markets & Event Contracts
CME Cuts Precious Metals Margins Up to 21% Starting Toda …
Commodities
Post-Summit Market Verdict: ES -1%, NQ -1.5%, 10-Year Yi …
Traders Hideout
Rubios Good News Within Hours and the 30-Day Math: Why H …
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
  #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