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

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 NexusFi