Support Board
Date/Time: Thu, 16 Jan 2025 22:01:57 +0000
[User Discussion] - Creating a watchlist of custom calculations and scanning it for alert conditions
View Count: 1504
| [2017-11-18 08:54:22] |
| User37537 - Posts: 78 |
|
Hi fellow SC users, I'm trying to use Sierra Chart to automate something I am able to do manually on another platform. What I would like to be able to do is to define a number of custom calculations, consisting of various symbols, have them plotted on a chart and create alert conditions just like for any other chart. But I want to do this for many dozens of formulas. The new calculated symbol study which was recently added provides this in a limited fashion, the problem is you need to have a chart for each symbol which is part of the calculation, and the chart numbers are hard coded. So this does not scale well. Lets say I have the following calculations I want to scan (A+B+C)/D (A+B+E)/D (A+C+F)/D (D+E+F)/G E/(A+B+C) F/(A+B+C) etc... So I want to effectively get these charts loaded graphically, make some alert-enabled drawings on them like I would for a normal symbol, and add them to a watchlist so I can scan them on a regular basis. If anyone has any ideas how to do this in a scalable way (say for 100 formulas), without having to create hundreds of charts, I would be grateful to hear about it. Thanks! |
| [2017-11-18 09:51:33] |
| Neo - Posts: 198 |
|
If anyone has any ideas how to do this in a scalable way (say for 100 formulas), without having to create hundreds of charts, I would be grateful to hear about it.
You can't do this without creating "hundred of charts". However, this does not necessarily create a scalability problem. Although SC is not designed to handle that many charts, it can. I run 100s of charts with quite resource intensive studies/ alert conditions. -When you say "custom calculation" & "many dozens of formulas" are you just referring to creating a basic spread chart, eg "(A+B+C)/D" -Approximately how many different spread charts, eg "(A+B+C)/D" do you need to create? -What "alert conditions" do you want to create? -When you say "alert-enabled drawings " do you want to hand draw lines on a chart? Please provide more details. -Forget the idea of using the SC Scan feature, that is not going to work, and is not how you would do this. |
| [2017-11-18 09:55:57] |
| @sstfrederik - Posts: 405 |
|
Hi, What do your letters represent? In order to perform any calculations the symbol needs to be loaded on a chart in that particular SC instance. Depending on what you really want you can choose for built in SC studies/alerts, spreadsheets or ACSIL coded studies. Kind regards, Frederik |
| [2017-11-18 10:28:50] |
| User37537 - Posts: 78 |
|
Hi guys, thanks for the replies :D I'll do my best to clarify: When you say "custom calculation" & "many dozens of formulas" are you just referring to creating a basic spread chart, eg "(A+B+C)/D"
For the purpose of this discussion when I say 'custom calculation' or 'formula' it means the same thing. So if I have "(FB+AAPL+GOOG)/SPY", that is one custom calculation or one formula.-Approximately how many different spread charts, eg "(A+B+C)/D" do you need to create?
Between 100 and 200.-What "alert conditions" do you want to create?
Chart Drawings in sierrachart support alerts. I use this for my watchlists. So for example I can draw an extending rectangle on the chart for a particular symbol, and when the last candle touches the chart, an alert fires. I simply want to be able to do this for calculated symbols instead of simple ones. So in the example above I would plot "(FB+AAPL+GOOG)/SPY" as the main price graph. Then I would draw an extending rectangle at a level of interest, and when the value of the graph reaches that level and touches the drawing I would want an alert to fire. But I want to do this for 100 formulas, and be able to scan it daily for alerts.-When you say "alert-enabled drawings " do you want to hand draw lines on a chart? Please provide more details. What do your letters represent?
The letters represent symbols in sierrachart for which there is price data available. For example, a stock or a futures contract.I believe you're right Neo, Sierra Chart is pretty fantastic performance-wise and can no doubt handle large numbers of charts. The issue is in the manual overhead of doing this manually. For example, lets say I have 100 formulas I want to scan, and they each have 4 symbols, and the numerators / denominators are different for each formula. That is 400 new charts I need to make every time my watchlist changes, plus 100 charts I need to manually construct to make sure they reference the correct other charts. And when my watchlist changes (which it does often) I would need to do this again. It would take several hours or days to do this process. This is what I mean by not scalable. :( However, maybe there is a less manually-intensive way of doing this? |
| [2017-11-18 10:59:54] |
| @sstfrederik - Posts: 405 |
|
With the current SC possibilities I see the following approach. You will need a chart loaded for every symbol with specific chartsettings that are involved with the calculations you require. I believe your custom symbol can be created with an ACSIL study which will be based on inputs referring to those open charts. For simplicity I assume the same chart (time) settings are used. You will load such a study on a separate chart and the OHLC subgraphs of your custom symbol will be available. Its a matter of defining the type of calculations to see how many studies need to be created. (A=B+C)/D is basically the same as (D+E+F)/G. You will need to load this custom study manually on all those calculations you envision. With your custom charts set up you can start to look into alerts and or other custom study interaction with these charts. This will be quite an experiment. If you are not familiar with ACSIL, you might need to find a programmer. Good luck, Frederik |
| [2017-11-18 11:58:47] |
| User37537 - Posts: 78 |
|
Thank you Frederik, that sounds like a reasonable approach and I think it makes sense. I do not have any experience with ACSIL but I do have a software background so it should not be too difficult to pick up the basics. If I do end up taking the ACSIL approach I will be sure to post updates with my progress in case it helps others. It probably won't be for a while though. I am still hoping there is a less involved way to accomplish this. |
To post a message in this thread, you need to log in with your Sierra Chart account: