Login Page - Create Account

Support Board


Date/Time: Thu, 25 Apr 2024 23:23:56 +0000



[Programming Help] - Request: Color Based on Alert Condition, output result of formula?

View Count: 471

[2021-10-18 03:14:27]
j4ytr4der_ - Posts: 918
Hello SCE, I have a request. I was trying to do something I thought would be very simple, but it appears to not be possible currently and I think many would find it helpful.

I have an alert condition that returns a price level inside the current bar. I would like to place a visualization (a line in my case) at this level. Unfortunately the only choices for output from the Alert Condition studies, are 1.0, the Input Data, or a fixed Custom value. The formula I'm using for my alert already returns the price level I need if true, I just need an option for output, something like "Value of Formula".

Would it be possible to add this feature to the various Color _____ Based on Alert Condition studies?

Or if there is a way to do this that I am missing, I would really appreciate being pointed in the right direction.

Thank you for your time either way.
[2021-10-18 12:16:18]
Sawtooth - Posts: 3976
Use the Spreadsheet Formula study, and put your formula in its Formula field.
[2021-10-18 12:26:12]
j4ytr4der_ - Posts: 918
Yeah that was my first thought, but unfortunately I can't as the formula is quite complex, and Spreadsheet Formula only accepts a formula that is on a single line, not one that has multi-line formatting, indentation, etc. But thanks anyway.
[2021-10-18 15:44:17]
John - SC Support - Posts: 31131
What you are requesting is really what an ACSIL study is for. What you want to do is fairly straightforward in terms of setting up the code, as you would just the subgraph to the result of your condition, since a negative result should already give a 0, that is just what you want (zeros are not displayed by default). Refer to the information starting here:
Advanced Custom Study Interface and Language (ACSIL): Introduction
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-10-18 16:03:47]
j4ytr4der_ - Posts: 918
Yeah that was actually the very first thing I looked into. Unfortunately I'm dealing with VAP data and that is way way WAYYY over my head. C++ in general is already way over my head and then adding VAP to it... no chance at least not for me.
[2021-10-18 17:40:19]
John - SC Support - Posts: 31131
I would check with Ackin to see if he might have something that does what you are looking for. He has a lot of free studies that he has created/provided.

Do a search for his name and you should be able to find him and request a direct message.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-10-18 20:29:17]
j4ytr4der_ - Posts: 918
Oh sure I know him and we have spoken many times. I just always prefer to have full control over what I'm using, wherever possible. I also prefer to do things using stock/built-in features wherever possible so as to reduce reliance on 3rd parties. But yes I use a number of his utility studies currently as they are the only way to get VAP data into a spreadsheet. Good stuff.

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

Login

Login Page - Create Account