Support Board
Date/Time: Mon, 21 Apr 2025 04:58:47 +0000
this will be a tricky one John
View Count: 272
| [2025-03-07 12:09:29] |
| User849502 - Posts: 367 |
|
Hi John, A client and I are stumped. He has SC obvs and he sent me a formula for an NQ - ES spread he trades so that I can have a chart on my pc. Unlike me, he codes, programs and is everything I am not. He Team-viewed into my PC to check everything was exactly as he had, and we still cannot get the chart to generate. We have used both NQH25-CME, and NQH25_FUT_CME in the formula. The former works perfectly on his PC. When we go to generate the chart, trying both formulas, we get the red error message as seen in attachment. We tried the 'translate to current symbol', and that too generates the same red error message. Mike, again, has jumped on my PC to confirm there wasn't an error on my part. Please can you help us to solve this issue? I appreciate your time looking at this, and hope you can give us a fix. thank you so much, John, for your time. Karen ps there wasn't room for symbol sett 2, but it's just showing the same thing as symbol set 1, but with the different symbol. |
 Screenshot 2025-03-07 113827.png / V - Attached On 2025-03-07 11:55:28 UTC - Size: 83.78 KB - 55 views symbol sett1.png / V - Attached On 2025-03-07 12:05:38 UTC - Size: 227.66 KB - 56 views avail symbols.png / V - Attached On 2025-03-07 12:06:01 UTC - Size: 155.47 KB - 38 views |
| [2025-03-07 16:04:44] |
| John - SC Support - Posts: 39362 |
|
The first thing is that when you are setting up a Custom Calculated Symbol, you need to use the symbol names as they exist for that instance of Sierra Chart. So if you are connected to the "Teton CME Routing" then you would use "NQH25_FUT_CME". If you are connected to "SC Data" then it would be "NQH25_CME". But if you are connected to a different service, you would need to use the symbols as they are for that service. What is your "Global Settings >> Data/Trade Service Settings >> Main Settings >> Current Selected Service" set to in the instance where you are setting up these symbols? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-03-10 14:00:09] |
| User849502 - Posts: 367 |
|
John, I wrote a reply back but as I am checking it is not here. So I am going to write the reply again. If you did receive the first I apologise. Weird Anyway, we are both on SC data all service', see attached. What is very odd is that you state 'If you are connects to SC DATA then the symbol would be NQH_CME. Mike uses a HYPHEN NOT an underscore as you state for his SC Data service! Either way we have tried using both hyphens and underscores and neither works. Please look at how each is set up exactly as Mike has it in his SC and running spreads perfectly, but neither hyphens nor underscores work. Thank you for taking time and helping us solve this. |
| underscore.png / V - Attached On 2025-03-10 13:57:09 UTC - Size: 157.15 KB - 29 views symbol sett2.png / V - Attached On 2025-03-10 13:58:02 UTC - Size: 243.52 KB - 22 views sc data.png / V - Attached On 2025-03-10 13:58:19 UTC - Size: 69.17 KB - 25 views |
| [2025-03-10 16:49:04] |
| John - SC Support - Posts: 39362 |
|
Sorry - it would be a hyphen, so it would be "NQH25-CME". The other thing is to ensure you have everything setup properly for that symbol. Follow the instructions at the following link: Custom Calculated Symbols: Instructions If the above does not solve, it then start with a simpler formula, avoid the very long decimal numbers and see if it works. If so, then expand the formula out further. If it does not work with a simpler formula, then most likely it is related to the setup we referenced above. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-03-10 18:49:24] |
| User849502 - Posts: 367 |
|
but John, the thing is the formula works for Mike, your client as well obvs, so why doesn't the formula work for me? We both have SC data, so something is stopping it from working for me when it works for him.
|
| [2025-03-11 09:29:36] |
| User849502 - Posts: 367 |
|
John, For further info for you, here is a screenshot of the spread chart working happily away on Mike's SC data. So what could be going wrong on my end? 1- we both have SC data feed 2- formula works perfectly on his SC 3- we copy the formula exactly into mine 4- he has teamviewered into my acct to make sure every setting is as his is. my chart comes up with large red failure box as shown in the first message to you. Please, can you help us solve this? I so appreciate your time. Karen |
| mikesspread.png / V - Attached On 2025-03-11 09:28:26 UTC - Size: 153.03 KB - 25 views |
| [2025-03-11 14:57:56] |
| John - SC Support - Posts: 39362 |
|
For one thing, your Symbol Settings do not have the option for "Uses Formula Operators" set to "Yes". This needs to be set to "Yes". Also, other items that are changed should not be. Only change the following items, and even then, only if you need/want to. The only important item is "Uses Formula Operators": - Price Format - Tick Size - Currency Value Per Tick - Category - Uses Formula Operators - Download Historical Data for Formula Symbols For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-03-11 15:09:44] |
| User849502 - Posts: 367 |
|
love you! thanks we will try this.
|
To post a message in this thread, you need to log in with your Sierra Chart account: