Support Board
Date/Time: Thu, 16 Jan 2025 21:52:24 +0000
Post From: Creating a watchlist of custom calculations and scanning it for alert conditions
| [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? |