NexusFi: Find Your Edge


Home Menu

 





SC Spreadsheet trading help


Discussion in Sierra Chart

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




 
Search this Thread

SC Spreadsheet trading help

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

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?
Cheap historycal L1 data for stocks
Stocks and ETFs
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
ZombieSqueeze
Platforms and Indicators
MC PL editor upgrade
MultiCharts
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
 
  #2 (permalink)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 219
Thanks Received: 603


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


© 2024 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 - Privacy Policy - Downloads - Top
no new posts