Support Board
Date/Time: Thu, 28 Nov 2024 05:46:00 +0000
[Programming Help] - Text Tags cannot be a numeric value, only strings
View Count: 298
| [2023-05-31 00:46:21] |
| j4ytr4der_ - Posts: 938 |
|
In a Spreadsheet Trading System, I wanted to include a numeric value for my text tag. Unfortunately it seems pretty clear that only text strings will work. I think it would be extremely useful to have the flexibility of the text tag being a numeric value and not only a string. Could this be implemented? If not, is there any simple way to convert a returned numeric value, to a text value? Like the inverse of VALUE()? |
| [2023-05-31 01:05:21] |
| j4ytr4der_ - Posts: 938 |
|
Strike that! To my total amazement wrapping my formula in TEXT() actually worked! So there's the easy answer.
|
| [2023-05-31 01:11:43] |
| j4ytr4der_ - Posts: 938 |
|
Except, something is very wrong. The value in cell J102 is not the value being recorded in the TAL. J102 contains 20 (as a text string). But the TAL says 24. This is consistent, every time I test this, the value in the TAL doesn't match the value on the spreadsheet. Anyone have any ideas why? |
| [2023-05-31 01:17:32] |
| j4ytr4der_ - Posts: 938 |
|
I believe I see what's happening. I have some simple logic set to be one value if long, another if not. In the microseconds between the working order existing (j4) and the position existing (j8), the logic is failing, and the resulting value on the TAL is the value for not long, instead of long. This happens too fast to see of course, so it looks like the spreadsheet is correct the whole time, but it's definitely winding up with the "not long" value instead (the "false" condition of my logic)
Date Time Of Last Edit: 2023-05-31 12:54:00
|
| [2023-05-31 02:15:21] |
| j4ytr4der_ - Posts: 938 |
|
OK something else is going on. Even if I remove the logic, and just put in a fixed formula, the tag is wrong in the TAL. These are the two formulas I've tried in J102: =TEXT((ID0.SG2@3 - J94) * 4)
=TEXT((J94 - ID0.SG3@3) * 4)
But I don't consistently get the correct value on the TAL (number of ticks from the high/low of the bar, the entry order was located) |
To post a message in this thread, you need to log in with your Sierra Chart account: