Login Page - Create Account

Support Board


Date/Time: Tue, 24 May 2022 00:53:32 +0000



Post From: --AUTO-TRADING-- How do I incorporate a second spreadsheet signa

[2013-06-04 03:34:23]
User268601 - Posts: 28
Ok, I have the 5 minute chart with the spreadsheet for trading indicator on it and the 30 minute indicator overlayed, with the blanks filled in. So far so good.

Before this what I was doing was I had a 30 minute chart with the spreadsheet for trading indicator on it and trades were generated by crossing over an indicator. The formulas I was using were: =AND(crossfrombelow(E3:E5,AG3:AG5)) in K3 and =AND(crossfromabove(E3:E5,AI3:AI5)) in M3. Simple enough.

What I am now trying to accomplish is to have two signals. The first one has to be what I just explained above with the signal/alert condition that's generated on the 30 minute, and somewhere within that 30 minute bar I want the second signal from the 5 minute to execute the trade. This second signal is also generated from a similar crossover but on the 5 minute chart crossing through a 5 minute indicator. So the 30 minute one has to occur first, and the 5 minute one is what will execute the trade within that 30 minute bar.

If you could help me to get in the ballpark of how to do this I would be greatly appreciative.