Login Page - Create Account

Support Board


Date/Time: Fri, 19 Apr 2024 19:37:13 +0000



spreadsheet for trading - cell formating and validation list

View Count: 1045

[2014-03-12 17:40:17]
User60591 - Posts: 39
Hi,

have a problem with Validation in Cell properties.
I windows i use ";" as list separator and when I use ";" in Input source validation works fine. Problem Is that when sierra restarts it changes ";" to "," and I must replace the comma each time I start Sierra.

Second thing is the cell formating issue with conditional formatting.
I wanna green colour fill ind the cell when the conditnon/ Value is TRUE. Only way I get this if I set:
Type: Cell Value
Operator: Not equal
Value: TRUE

After I close formating and I check it again Value is gone but it keeps on with propper cell formating.

pls check this out.


thank you

[2014-03-12 20:59:36]
Sierra Chart Engineering - Posts: 104368
It sounds like you are referring to features in the older spreadsheet functionality which we are no longer providing support for and will be eventually removed from the software.

Not quite sure where you are finding "validation", but conditional formatting is something that we do not support any longer.

Therefore, we recommend not putting reliance on these features.
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
[2014-03-12 22:00:45]
User60591 - Posts: 39
version 1097
right click on the cell--> cell properties-->validation


Idea is to select auto strategy to trade, i.e. long, short... with nested "if" in K and M
It works as I described in previous post.
Same thing with conditional formating, basically it works.

Does your answer means that this will not work after a certain point in future updates?



Date Time Of Last Edit: 2014-03-12 22:01:22
[2014-03-13 00:15:02]
Sierra Chart Engineering - Posts: 104368
OK, we know what you are referring to. We do not provide support for that feature and we expect it would become unavailable at the end of this year.
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

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account