NexusFi: Find Your Edge


Home Menu

 





Sierra chart spreadsheet BBand system


Discussion in Sierra Chart

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




 
Search this Thread

Sierra chart spreadsheet BBand system

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

Could someone please help guide me how to create a simple bollinger band system

I just want it to the following
1. at startup please buy bid at the bottom bollinger band price and Sell ask at the top bollinger band price
2. once fill the spreadsheet won't allow it to open another position until close
3. take profit, stop lost from trade window


it looks like the spreadsheet cant place buys and sell at the same time.

Currently have this ( it work but not great)
k3= if (last E3 > middle bollinger band AB3, 1, 0)
j22 = roundup(AA3)
J71 and J72 = L - for Limit order

so this work, but it only updates the price once it crosses the middle
I've tried to place k3 =1 ., so every new candle it would replace the last order. but doesn't work

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Trade idea based off three indicators.
Traders Hideout
MC PL editor upgrade
MultiCharts
Better Renko Gaps
The Elite Circle
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
How to apply profiles
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Spoo-nalysis ES e-mini futures S&P 500
29 thanks
Just another trading journal: PA, Wyckoff & Trends
25 thanks
Tao te Trade: way of the WLD
24 thanks
Bigger Wins or Fewer Losses?
23 thanks
GFIs1 1 DAX trade per day journal
18 thanks
  #2 (permalink)
bradhouser
Northern California where the girls are warm
 
Posts: 122 since Nov 2010
Thanks Given: 15
Thanks Received: 72

Willstar44:

Congratulations on taking the steps to learn spreadsheet trading in Sierra. What you describe is very doable.

1. Buying at bid and selling at ask are examples of limit orders. There is a cell for each of the four buy/sell signals that controls whether a Market or Limit order should be entered. It appears you know how to do that. Make sure you automatically or manually cancel any orders that don’t get filled.l
2. The Spreadsheet System for Trading can prevent entering a new position if already in a trade.
3. You can use attached trades and do chart trading while auto trading. Manual trading is not disabled when auto trading.

You cannot place buy and sell on the same symbol, unless you trade from two different accounts. It is illegal in the US anyway. Besides, your system should determine a direction, that is what it is designed to do.

Replacing K3 with one only makes sense if you want to make sure the system is working, but it essentially buys every candle, so not much of a strategy.

If you are interested, I develop trading systems for sale, using spreadsheets. PM me for info.

Brad Houser
ForgivingComputers.com


Sent from my iPad using futures.io

Reply With Quote




Last Updated on April 27, 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