NexusFi: Find Your Edge


Home Menu

 





Help with spreadsheet study for trading strategy


Discussion in Sierra Chart

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




 
Search this Thread
  #1 (permalink)
 thafuz 
Greensboro NC/USA
 
Experience: Beginner
Platform: ninjatrader
Trading: Mini NQ and MNQ
Posts: 4 since Jan 2016
Thanks Given: 5
Thanks Received: 0

Hello, I have developed a strategy in sierra spreadsheet for system for trading, I am trying to figure out how away to make it take only the first entry long and ignore the following entries until an entry in the opposite direction is triggered. Could some one point me in the direction of a solution. I am not a programmer but I was able to get the strategy working the way i would like except this part.

Thank you for you time.


Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
White House Drops First Alien Files Today -- Market Says …
Prediction Markets & Event Contracts
Irans Answer Due Today: Peace Surges to 33.5%, Invasion …
Prediction Markets & Event Contracts
Ceasefire Collapse: Iran Fires 24 Missiles, Israel Hits …
Traders Hideout
Trump Lands in Beijing on CPI Day: Iran Peace Expires To …
Prediction Markets & Event Contracts
I Have a Thing Called Iran -- Trump Stays in DC as Airsp …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
NexusFi site changelog and issues/problem reporting
10 thanks
Darmok and Jalad at Tanagra
3 thanks
Big Mike in Ecuador
1 thanks
30 Sessions
1 thanks
  #2 (permalink)
ondafringe
Albuquerque, NM, USA
 
Posts: 124 since Jul 2012
Thanks Given: 87
Thanks Received: 118

I don't really do SC SS stuff, but couldn't you modify your Buy Entry criteria to check if J5 > 0, which, if true, would indicate you are already in a Long position?


Reply With Quote
  #3 (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



Quoting 
I am trying to figure out how away to make it take only the first entry long and ignore the following entries until an entry in the opposite direction is triggered.

One way to do it is to create a persistent variable in a Formula Column. Here is an example:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetExampleFormulasAndUsage.php


Reply With Quote




Last Updated on July 31, 2020


© 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