Support Board
Date/Time: Tue, 26 Nov 2024 09:45:16 +0000
[User Discussion] - Automated trading spreadsheet
View Count: 1068
| [2014-04-19 18:52:52] |
| Jaap - Posts: 3 |
|
Hello, I know the SC guys don't give support with the spreadsheet formulas but I hope some other user is willing to help me with this one. I am really hopeless with Exel and spreadsheets and I am having great difficulties in writng the correct formulas for my setups. I am workin with two simple Moving Averages and I would like to automate my buy and sell orders. Setup Buy entry: a setup occurs at the close of a 5 min. bar when SMA1 closes above SMA2 and the price closes above SMA1. Setup Sell entry:a setup occurs at the close of a 5 min. bar when SMA2 closes below SMA1 and the price closes below SMA2. this means I only want to look for setups at the close a every 5 min. bar. Targets and stops are 8 ticks in both cases. As long as there is 1 working order no new orders are allowed. Could anyone supply me with a correct formula for the SC spreadsheet. It would save me a lot of time and trouble. Thanks and regards Jaap |
| [2014-04-19 20:59:30] |
| Sawtooth - Posts: 4120 |
|
Try this: K3: =AND(AC4>AA4,AA3>AC3,E3>AA3) M3: =AND(AA4<AC4,AC3<AA3,E3<AC3) where AA is SMA1 and AC is SMA2. In the study settings, set 'Signal Only On Bar Close (K,M)' to Yes. Assure 'Allow Entry With Working Orders' is No. For a stop and a target, use the Attached Orders functionality. |
| [2014-04-19 22:05:53] |
| Jaap - Posts: 3 |
|
Thanks for your speedy reply tomgilb; I'll give it a try and let you know if it works Regards Jaap |
To post a message in this thread, you need to log in with your Sierra Chart account: