watchlist custom columns for SD or TOS

The formula for the column is .....

(((MovingAverage[MA,Close,10,0,D] < MovingAverage[MA,Close,20,0,D] AND MovingAverage[MA,Close,10,0,D,1] > MovingAverage[MA,Close,20,0,D,1] AND MovingAverage[MA,Close,5,0,D] < MovingAverage[MA,Close,20,0,D] )
OR
(MovingAverage[MA,Close,5,0,D] < MovingAverage[MA,Close,20,0,D] AND MovingAverage[MA,Close,5,0,D,1] > MovingAverage[MA,Close,20,0,D,1] AND MovingAverage[MA,Close,10,0,D] < MovingAverage[MA,Close,20,0,D]))) * 1

OR

((MovingAverage[MA,Close,10,0,D] > MovingAverage[MA,Close,20,0,D] AND MovingAverage[MA,Close,10,0,D,1] < MovingAverage[MA,Close,20,0,D,1] AND MovingAverage[MA,Close,5,0,D] > MovingAverage[MA,Close,20,0,D] )
OR
(MovingAverage[MA,Close,5,0,D] > MovingAverage[MA,Close,20,0,D] AND MovingAverage[MA,Close,5,0,D,1] < MovingAverage[MA,Close,20,0,D,1] AND MovingAverage[MA,Close,10,0,D] > MovingAverage[MA,Close,20,0,D]))* 2

Highlight and copy this formula.
Along the top of the SD screen, click columns then custom field wizard (this will open a new window)
Click NEW (this opens the Custom Field Settings window) Enter 'e Signal' in the Field Name. Then past the copied code into the white area under Formula. Click 'Save to Library' and then OK

Then click on the level 1 that contains your watchlist and click the columns tab at the top. Click CUSTOM FIELDS and scroll down and click 'e Signal'

Once the e signal is added as a column in your watchlist, right click on the e signal tab (top of the column). Select Column Properties then Color Rules.

Set When Value Is to = and 0 in the box next to it and then choose Display Text In and Background In and change to White then click ADD RULE. Repeat these steps twice more changing the = to 1 and choose red for both colors and click ADD RULE then =to 2 and choose green for both colors and click ADD RULE
----------------------------------------------------------------------------------------------------

For the chart you must create a custom study. Along the top of the screen, choose Studies - Custom study Wizard - New. Name it, past the following code and then save to library then ok. Repeat these steps for each set of code. Then click Studies - Add Custom Study and scroll down and choose the name you just created. Pick a color and thickness and click ok. Repeat to add the second study.

Code for custom study - e Signal Long

(MovingAverage[MA,Close,10,0,55] < MovingAverage[MA,Close,5,0,55] AND MovingAverage[MA,Close,10,0,55,1] > MovingAverage[MA,Close,5,0,55,1] )


Code for custom study - e Signal Short

(MovingAverage[MA,Close,10,0,55] > MovingAverage[MA,Close,5,0,55] AND MovingAverage[MA,Close,10,0,55,1] < MovingAverage[MA,Close,5,0,55,1] )

If anyone would like, I can email a copy of the workspace of the above picture and you would just simply place the folder in the workspace area of SD (no programming necessary) and change the watchlist too what ever you like

MTUT,

Would you mind sharing your FP column formulas that you use in SD?

Many thanks!

Does anyone have a 5 crossing 10 crossing 20 scan for TOS available that they would be willing to share? I use TOS and would love to try it !
Thank you.

Quote
NMR
Does anyone have a 5 crossing 10 crossing 20 scan for TOS available that they would be willing to share? I use TOS and would love to try it !
Thank you.

Here's the one I wrote for myself. I tried to filter out some of the false positives, but you still have to use this in conjunction with all the other indicators as not every signal is a trade.

EDIT: Oops. I just re-read your post and realized that you wanted a scan indicator. The code I posted below is a charting indicator which draws a vertical line on the chart when the 3 moving averages cross over. At any rate, give it a go if you wish.

# 3 moving averages crossover signals

input SMA_short = 5;
input SMA_medium = 10;
input SMA_long = 20;

def AvgS = Average(close, SMA_short);
def AvgM = Average(close, SMA_medium);
def AvgL = Average(close, SMA_long);
def Candle_White = close > open;
def Candle_Red = close < open;

def Eup = (AvgS > AvgM and AvgM > AvgL);
def Edn = (AvgS < AvgM and AvgM < AvgL);
def CrossUp = Eup and !Eup[1] and close > AvgM;
def CrossDn = Edn and !Edn[1] and close < AvgM;

def BuySignalUp = if (Eup and Candle_White and CrossUp[0] and close > (if Candle_White[1] then close[1] else open[1])) then 1
        else 
            if (Eup and Candle_White and CrossUp[1] and close[1] < (if Candle_White[2] then close[2] else open[2]) and close > (if Candle_White[2] then close[2] else open[2])) then 1
        else
            Double.NaN;

def BuySignalDn = if (Edn and Candle_Red and CrossDn[0] and close < (if Candle_Red[1] then close[1] else open[1])) then 1
        else 
            if (Edn and Candle_Red and CrossDn[1] and close[1] > (if Candle_Red[2] then close[2] else open[2]) and close < (if Candle_Red[2] then close[2] else open[2])) then 1
        else
            Double.NaN;


AddVerticalLine((BuySignalUp), "Calls", Color.UPTICK);
AddVerticalLine((BuySignalDn), "Puts", Color.LIGHT_RED);

def strongEup = Eup and close > AvgS;
def strongEdn = Edn and close < AvgS;
AddLabel(strongEup, "E-UP", Color.GREEN);
AddLabel(strongEdn, "E-DN", Color.RED);

Edited 1 time(s). Last edit at 12/10/2013 10:24AM by robert.

outstanding- thank you !!!

Raleigh Trader asked for a FP signal in the collumns of SD. Here is one for a 55 min timeframe. Simply change all the 55 to whatever you want D, 34,8 etc.

This formula will return a value of 0, 1 or 2. 0 = no signal 1 = Long 2 = short

(MovingAverage[MA,Close,3,3,55] < MovingAverage[MA,Close,2,0,55] AND MovingAverage[MA,Close,3,3,55,1] >= MovingAverage[MA,Close,2,0,55,1] AND

StochasticRSI[StocK,13,21,5,3,55] > StochasticRSI[StocD,13,21,5,3,55] AND StochasticRSI[StocK,13,21,5,3,55,1] < StochasticRSI[StocD,13,21,5,3,55,1] AND

MACD[Diff,Close,8,13,5,55] > 0 AND MACD[Diff,Close,8,13,5,55,1] <= 0) * 1

OR

(MovingAverage[MA,Close,3,3,55] > MovingAverage[MA,Close,2,0,55] AND MovingAverage[MA,Close,3,3,55,1] <= MovingAverage[MA,Close,2,0,55,1] AND

StochasticRSI[StocK,13,21,5,3,55] < StochasticRSI[StocD,13,21,5,3,55] AND StochasticRSI[StocK,13,21,5,3,55,1] > StochasticRSI[StocD,13,21,5,3,55,1] AND

MACD[Diff,Close,8,13,5,55] < 0 AND MACD[Diff,Close,8,13,5,55,1] >= 0)* 2

Perfect, many thanks, MTUT!

I wrote a scan that will scan through whatever symbols you load in the screener and will return all up or down on the E chart timeframes of 55,34,21,10,5,and 3. This screenshot is from a scan I ran this afternoon.


Select File, New, Screener and paste this formula in under the formula section, and also select or import some symbols in your symbol list:

(MovingAverage[MA,Close,10,0,55] > MovingAverage[MA,Close,20,0,55] AND MovingAverage[MA,Close,5,0,55] > MovingAverage[MA,Close,10,0,55]) AND

(MovingAverage[MA,Close,10,0,34] > MovingAverage[MA,Close,20,0,34] AND MovingAverage[MA,Close,5,0,34] > MovingAverage[MA,Close,10,0,34]) AND

(MovingAverage[MA,Close,10,0,21] > MovingAverage[MA,Close,20,0,21] AND MovingAverage[MA,Close,5,0,21] > MovingAverage[MA,Close,10,0,21]) AND

(MovingAverage[MA,Close,10,0,10] > MovingAverage[MA,Close,20,0,10] AND MovingAverage[MA,Close,5,0,10] > MovingAverage[MA,Close,10,0,10]) AND

(MovingAverage[MA,Close,10,0,5] > MovingAverage[MA,Close,20,0,5] AND MovingAverage[MA,Close,5,0,5] > MovingAverage[MA,Close,10,0,5]) AND

(MovingAverage[MA,Close,10,0,3] > MovingAverage[MA,Close,20,0,3] AND MovingAverage[MA,Close,5,0,3] > MovingAverage[MA,Close,10,0,3])(MovingAverage[MA,Close,10,0,55] > MovingAverage[MA,Close,20,0,55] AND MovingAverage[MA,Close,5,0,55] > MovingAverage[MA,Close,10,0,55]) AND

(MovingAverage[MA,Close,10,0,34] > MovingAverage[MA,Close,20,0,34] AND MovingAverage[MA,Close,5,0,34] > MovingAverage[MA,Close,10,0,34]) AND

(MovingAverage[MA,Close,10,0,21] > MovingAverage[MA,Close,20,0,21] AND MovingAverage[MA,Close,5,0,21] > MovingAverage[MA,Close,10,0,21]) AND

(MovingAverage[MA,Close,10,0,10] > MovingAverage[MA,Close,20,0,10] AND MovingAverage[MA,Close,5,0,10] > MovingAverage[MA,Close,10,0,10]) AND

(MovingAverage[MA,Close,10,0,5] > MovingAverage[MA,Close,20,0,5] AND MovingAverage[MA,Close,5,0,5] > MovingAverage[MA,Close,10,0,5]) AND

(MovingAverage[MA,Close,10,0,3] > MovingAverage[MA,Close,20,0,3] AND MovingAverage[MA,Close,5,0,3] > MovingAverage[MA,Close,10,0,3])

OR

((MovingAverage[MA,Close,10,0,55] < MovingAverage[MA,Close,20,0,55] AND MovingAverage[MA,Close,5,0,55] < MovingAverage[MA,Close,10,0,55]) AND

(MovingAverage[MA,Close,10,0,34] < MovingAverage[MA,Close,20,0,34] AND MovingAverage[MA,Close,5,0,34] < MovingAverage[MA,Close,10,0,34])AND

(MovingAverage[MA,Close,10,0,21] < MovingAverage[MA,Close,20,0,21] AND MovingAverage[MA,Close,5,0,21] < MovingAverage[MA,Close,10,0,21]) AND

(MovingAverage[MA,Close,10,0,10] < MovingAverage[MA,Close,20,0,10] AND MovingAverage[MA,Close,5,0,10] < MovingAverage[MA,Close,10,0,10]) AND

(MovingAverage[MA,Close,10,0,5] < MovingAverage[MA,Close,20,0,5] AND MovingAverage[MA,Close,5,0,5] < MovingAverage[MA,Close,10,0,5]) AND

(MovingAverage[MA,Close,10,0,3] < MovingAverage[MA,Close,20,0,3] AND MovingAverage[MA,Close,5,0,3] < MovingAverage[MA,Close,10,0,3]))

To get the columns to display the color, right click on a current column heading and select custom field wizard, then new and paste this formula: (MovingAverage[MA,Close,10,0,55] > MovingAverage[MA,Close,20,0,55] AND MovingAverage[MA,Close,5,0,55] > MovingAverage[MA,Close,10,0,55])*1 OR (MovingAverage[MA,Close,10,0,55] < MovingAverage[MA,Close,20,0,55] AND MovingAverage[MA,Close,5,0,55] < MovingAverage[MA,Close,10,0,55])*2



Repeat the process for making the other columns for the other time frames but replace 55 with the respective time in the formula (example replace all instances of 55 with 34 for the E34 column and do this for each column that you make)
To make the block green or red make the rule when value=1 display color in green and then add rule, when value=2 display color in red and then add rule.



Edited 1 time(s). Last edit at 04/09/2014 04:44PM by TCB.

Just downloaded StrategyDesk last week and LOVE it because it's so similar to Qcharts, BUT you can do so much more with it.

The only thing I really wish it had was something similar to the Autowave (fibonacci pattern finder), or "ZigZag" feature. I know Robert gave us a code for ThinkOrSwim which works great! Is there ANY way to recreate the wording for this code so that it's recognizable in StrategyDesk?

Another great benefit of the Autowave is being able to scroll through each symbol and quickly see the price swing amounts. I still have Qcharts, if any of y'all code experts need a reference.

Thanks in advance y'all

p.s. Happy Easter/Resurrection Day everyone

is there a way to on the tos platform to send an alert to phone or email for when the CC is crossing going up or down or does a script have to be made ? Thank you

@Chris M. Check out the tutorial @ [www.youtube.com]

Lots of capabilities in this platform (supports both text/email). Start by setting up your notification preferences Setup->Application Settings->Notifications.