NexusFi: Find Your Edge


Home Menu

 





Spread Sheet noob question


Discussion in Sierra Chart

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




 
Search this Thread

Spread Sheet noob question

  #1 (permalink)
Willstar44
Australia
 
Posts: 10 since Feb 2018
Thanks Given: 1
Thanks Received: 2

I am sorry if these questions have been asked before, I couldn't find the answers I need.

1. How do you stop the "order and position" pop from showing up when using backtesting. (I rather use just the chart "order history shown on chart" . and whenever I close it re-open after a trade has been open.

2.I am starting out with spreadsheet trading, I have run through a few youtube but getting suck on a few ideas.
has anyone seen any written guide, where we could go step by step, ( the youtube are hard to see the text)? EG setting up Bband system or MA system ( I understand they won't make money, just want to learn)

3.

##I am trying an MA spreadsheet trading bot, that it doesn't buy the cross, rather wait for the spread IE 10 MA is 20 points below 50 MA ( using "Moving average difference" ```=if(AA3-AB3)>20``` ##

how do you make it so it only triggers 1 order ( Enter filed and closed filed )>> then wait for "Moving average difference" = 0 before making another trade.

at the moment - it triggers a long .... take profit .... spreadsheet check that the position balance = 0 + "Moving average difference" = +20 and place another long.

I want to trade like this
1.First trade (eg long )
2. Close trade > ( take profit or stop out )
3.then wait for the "Moving average difference" to cross (0)
4. Spreadsheet wait for "Moving average difference" = (-20) to enter short or (+20) to enter long

4. Is there a way to cancel pending limit order either with time after 5 min , or better with an indicator ( ie i want to use the "Moving average difference" if it fall below +20 cancel limit buy )

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Exit Strategy
NinjaTrader
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
MC PL editor upgrade
MultiCharts
REcommedations for programming help
Sierra Chart
Better Renko Gaps
The Elite Circle
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Just another trading journal: PA, Wyckoff & Trends
34 thanks
Tao te Trade: way of the WLD
24 thanks
GFIs1 1 DAX trade per day journal
15 thanks
Bigger Wins or Fewer Losses?
15 thanks
Vinny E-Mini & Algobox Review TRADE ROOM
13 thanks
  #2 (permalink)
bradhouser
Northern California where the girls are warm
 
Posts: 122 since Nov 2010
Thanks Given: 15
Thanks Received: 72

If you add a counter formula for each candle that could result in a trade, and reset it at your moving average cross. Then only take the one where the count is equal to one.

There is a cell that cancels limit orders, J$27.


Sent from my iPad using futures.io

Reply With Quote
Thanked by:
  #3 (permalink)
Willstar44
Australia
 
Posts: 10 since Feb 2018
Thanks Given: 1
Thanks Received: 2


thanks for the reply

on the Sierra chart forms, got this reply that also works
I cant post links yet

Reply With Quote




Last Updated on April 3, 2018


© 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