Support Board
Date/Time: Sun, 24 Nov 2024 05:26:57 +0000
Built In Spreadsheet Study..#Name?... and other issues
View Count: 1449
| [2013-09-09 11:22:35] |
| User37170 - Posts: 29 |
|
I get #Name? when using function "CrossFrombelow" ............... should I not be using this formula? Also cannot define a range - greyed out on the menu. Why is this ? #INVAL! error sometimes as well ..... what does this mean ? Trying to use Spreadsheet Trading Alert Study and I have read all the supplied info ... From this it appears I should be able to use the above formulae and create range names as per standard Excel...... Please help. Thanx a bunch. |
| [2013-09-09 18:07:17] |
| |
|
We will look into the problem with the CrossFromBelow function. If you are referring to Spreadsheet >> Define Name, then this is not currently supported with the new spreadsheets. 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 |
| [2013-09-09 19:14:37] |
| |
|
The error you are getting with the crossover functions will be solved this week. They were not implemented in the new spreadsheets yet. We apologize for that.
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 |
| [2013-09-09 20:13:26] |
| Sawtooth - Posts: 4118 |
|
You can use this formula for a cross from below: =AND(AC4>AA4,AA3>AC3) A cross from above would then only require the opposite operator: =AND(AC4<AA4,AA3<AC3) where AA is a faster MA and AC is a slower MA. |
To post a message in this thread, you need to log in with your Sierra Chart account: