NexusFi: Find Your Edge


Home Menu

 





Spread Sheet noob question


Discussion in Sierra Chart

Updated
    1. trending_up 1,083 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?
MC PL editor upgrade
MultiCharts
Cheap historycal L1 data for stocks
Stocks and ETFs
Better Renko Gaps
The Elite Circle
What broker to use for trading palladium futures
Commodities
ZombieSqueeze
Platforms and Indicators
 
  #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