NexusFi: Find Your Edge


Home Menu

 





Spread Sheet noob question


Discussion in Sierra Chart

Updated
    1. trending_up 1,084 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?
Option : Call and Put increase at same time ?
The Elite Circle
Trade idea based off three indicators.
Traders Hideout
Quantum physics & Trading dynamics
The Elite Circle
REcommedations for programming help
Sierra Chart
What broker to use for trading palladium futures
Commodities
 
  #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