Support Board
Date/Time: Sat, 10 May 2025 20:07:59 +0000
Post From: Automated trading spreadsheet
| [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 |