Support Board

Date/Time: Mon, 06 May 2024 23:22:38 +0000

Post From: Automated trading spreadsheet

[2014-04-19 18:52:52] Link To Thread - Link To Post [Go To First Post]
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