Support Board
Date/Time: Thu, 18 Apr 2024 20:19:25 +0000
Help about spreadsheet strategy
View Count: 1081
[2014-11-20 21:32:25] |
User60897 - Posts: 6 |
Need help for the strategy, I want to use MA crossover and if macd diff >0 how could I write this. (for example, Ma1 = AA, Ma2 = AB and Macd diff = AG) When I write in K column = crossover( AA3:AA4,AB3:AB4), it works; But I add = crossover( AA3:AA4,AB3:AB4) and AG3 >0, it occurs error message.(NAME!) Another question is that K column's alert is an arrow how can I change to a dot or something else? Thanks! |
[2014-11-20 23:26:05] |
Sawtooth - Posts: 3973 |
This is the syntax: =AND(CROSSOVER(AA3:AA4,AB3:AB4),AG3>0) On the Subgraphs tab, change the Draw Style of Buy Entry (SG1) to your choice. |
[2014-11-21 01:29:35] |
User60897 - Posts: 6 |
tried =CROSSOVER(AB3:AB4,AA3:AA4) and (CROSSOVER(AB3:AB4,AA3:AA4), AJ2>0) Still get error #Name? |
[2014-11-21 02:41:57] |
Sierra Chart Engineering - Posts: 104368 |
Do you know if you are using New Spreadsheets or Old Spreadsheets? If you are entering specifically this, it is not valid: =CROSSOVER(AB3:AB4,AA3:AA4) and (CROSSOVER(AB3:AB4,AA3:AA4), AJ2>0) Seems like you might want: = AND(CROSSOVER(AB3:AB4,AA3:AA4), CROSSOVER(AB3:AB4,AA3:AA4), AJ2>0) Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: