Support Board
Date/Time: Thu, 09 Jan 2025 20:04:25 +0000
Spreadsheet system for trading
View Count: 902
| [2016-08-15 14:55:29] |
| User14682 - Posts: 83 |
|
Currenty I have this formula: =CROSSFROMBELOW( ID1.SG1@3:ID1.SG1@4, ID3.SG1@3:ID3.SG1@4) How do I indicate that ID5.SG1 also needs to be > ID6.SG1 |
| [2016-08-15 18:40:30] |
| |
|
You just need to use the AND function: http://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html 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 |
| [2016-08-15 19:07:11] |
| User14682 - Posts: 83 |
|
WHATS WRONG WITH THIS? =OR(AND(CROSSFROMBELOW(ID1.SG1@3:ID1.SG1@4,ID3.SG1@3:ID3.SG1@4),AND(ID5.SG1@3>1D6.SGQ@3)) MY FORMULAS USED TO LOOK LIKE THIS... CAN I NO LONGER USE THE COLUMN? =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-15 21:02:33] |
| Sawtooth - Posts: 4147 |
|
Yes, you can use either 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 other Formula Columns. Date Time Of Last Edit: 2016-08-15 23:05:13
|
| [2016-08-16 18:06:12] |
| Crudeoilist - Posts: 18 |
|
I don't know what you are trying to do so my reply might not be of any help. But what I do is use the color bar for alerts study and code in what ever i need to color the bar as a buy or sell signal. then in the spreadsheet for trading study i simply refer it to the color bar study as a true/false statement. but then again, my code is not really that long. hope this helps
|
| [2016-08-16 18:13:07] |
| User14682 - Posts: 83 |
|
IS THERE A WAY TO IMPORT MY OLD CHARTS INTO SIERRA CHART?
|
| [2016-08-16 18:47:25] |
| |
|
Corrected formula: =AND(CROSSFROMBELOW(ID1.SG1@3:ID1.SG1@4,ID3.SG1@3:ID3.SG1@4),ID5.SG1@3>1D6.SGQ@3) MY FORMULAS USED TO LOOK LIKE THIS... CAN I NO LONGER USE THE COLUMN? =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)) Yes you can still use direct referencing of the columns. Or you can use this format like you did in the first formula: http://www.sierrachart.com/index.php?page=doc/Spreadsheets.html#ReferencesStudySubgraphColumnsSpreadsheetStudy IS THERE A WAY TO IMPORT MY OLD CHARTS INTO SIERRA CHART?
Yes. Refer to:http://www.sierrachart.com/index.php?page=doc/Chartbooks.html#CopyChartbook 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 Date Time Of Last Edit: 2016-08-16 18:48:11
|
To post a message in this thread, you need to log in with your Sierra Chart account: