Home >> Support Board

Support Board

Date/Time: Thu, 02 May 2024 17:00:35 +0000

How to Post a Message for Support

[User Discussion] - TROUBLE WITH SPREADSHEET TRADING

View Count: 855

[2016-08-16 15:16:19] #1 [Go To First Post]
User14682 - Posts: 83
THIS IS A BASIC MOVING AVERAGE CROSS BUT I WOULD ALSO LIKE TO INDICATE THAT 1D5.SGE@3 IS < ID6.SG1@3 THIS WORKS =CROSSFROMABOVE( ID1.SG1@3:ID1.SG1@4, ID3.SG1@3:ID3.SG1@4) BUT WHEN I ADD ID5.SG1@3<1D6.SG1@3 IS FAILS TO WORK DOWS ANYONE KNOW HOW TO COMBINE THE TWO? THANKS

[2016-08-16 15:29:35] #2 [Go To First Post]
Sawtooth - Posts: 3990
Try this: =AND(CROSSFROMABOVE(ID1.SG1@3:ID1.SG1@4,ID3.SG1@3:ID3.SG1@4),ID5.SG1@3<ID6.SG1@3)

[2016-08-16 15:34:03] #3 [Go To First Post]
User14682 - Posts: 83
THE USED TO SAY TRUE AND FALSE. NOW IS IT 0 AND TRUE?

[2016-08-16 15:38:19] #4 [Go To First Post]
User14682 - Posts: 83
I LOST MY ARROW? =AND(CROSSFROMABOVE(ID1.SG1@3:ID1.SG1@4,ID3.SG1@3:ID3.SG1@4),ID5.SG1@3<ID6.SG1@3) - I DONT THINK IT WORKED MY CODES USED TO LOOK LIKE THIS.... i BOUGHT A NEW COMPUTER AND REINSTALLED. EVERYTHING CHANGED.. =OR(AND(AA3>AG3,AA4<AG4,AG3>AC3,AG3>AE3,AG3>AI3),AND(AA3>AE3,AA4<AE4,AE3>AC3,AE3>AG3,AE3>AI3),AND(AA3>AI3,AA4<AI4,AI3>AC3,AI3>AE3,AI3>AG3),AND(AA3>AC3,AA4<AC4,AC3>AE3,AC3>AG3,AC3>AI3))

[2016-08-16 16:11:42] #5 [Go To First Post]
Sawtooth - Posts: 3990
What SC version were you using on your old computer? Were you using Old Spreadsheets on your old computer? They have a .scwbf extension. New Spreadsheets have a .scss extension. Old Spreadsheets are not supported in versions later than 1310. The auto-conversion from Old to New spreadsheets works in most cases, but not all. Your original formula should work in the New Spreadsheets, if you didn't change any studies in the Studies to Graph list. New Spreadsheets output 1/0 instead of TRUE/FALSE You can use both the ID#.SG#@# format or the original alpha-column format. There are two advantages to using the ID#.SG#@# format: 1) You can rearrange studies in the Studies to Graph list without messing up your formulas. 2) You can insert/delete columns without messing up your formulas (if you have enough spare Formula Columns before you insert). Suggestion: Use the ID#.SG#@# format when referencing study outputs, and use the alpha column format when referencing columns A-G and Formula Columns.

To post a message in this thread, you need to log in with your Sierra Chart account: