Support Board
Date/Time: Thu, 28 Nov 2024 13:53:42 +0000
Quick question - Custom symbol formula: is (1/{SYMBOL}) or {SYMBOL}^-1 better?
View Count: 322
| [2023-04-28 11:50:37] |
| User34124 - Posts: 276 |
|
Just wondering what the best method is for inverting a symbol in a long string, for example 1/US30 * 1/SPX500 * XAUUSD * 1/NAS100 I have checked the documentation especially point 6 which leads to Working with Spreadsheets: Arithmetic Operators But just require some more clarification as my outputs seem to differ, causing me to believe the " ^-1 " being negative could be problematic. Date Time Of Last Edit: 2023-04-29 01:52:09
|
| [2023-04-28 15:11:14] |
| John - SC Support - Posts: 36350 |
|
It should work. The Custom Calculated Symbols use the same calculations as the Spreadsheets do, and the Spreadsheets can handle a negative exponent. What is the difference you see? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-04-29 01:51:48] |
| User34124 - Posts: 276 |
|
Ah, I think I had disk issues which caused the errors. Negative exponents tested and works fine. Just to clarify, brackets are used just fine also right? 1/{US30}*{XAUUSD}/(1/{NAS100}) would work like 1/{US30}*{XAUUSD}*/{NAS100}^-1 |
| [2023-05-01 15:13:55] |
| John - SC Support - Posts: 36350 |
|
Parentheses can be used with the custom symbols.
For the most reliable, advanced, and zero cost futures order routing, use 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: