Login Page - Create Account

Support Board


Date/Time: Sun, 22 Dec 2024 23:13:52 +0000



Post From: Referencing multiple charts in spreadsheet for auto-trading

[2015-05-11 14:50:26]
User81805 - Posts: 9
I did this, but the formula does not seem to be working as it should. Maybe it is not a correct formula for what I am trying to do?

The long-trade formula goes as follows: =AND(Sheet3!E3>Sheet3!B3,Sheet2!E3>Sheet2!B3,Sheet1!E3>Sheet1!B3,Sheet1!E4>Sheet1!B4,Sheet1!E5>Sheet1!B5)

Chart #3 is a weekly chart, Chart #2 is a daily chart, and Chart #1 is a 1 hour chart. All the charts have the Spreadsheet for Trading study added, with the same name in the Name Field.