Sample Formulas with Historical Variables

ChartSmart Professional is an upgrade to our current version of Chartsmart. The cost is an additional $20 per month Cdn.

To learn more on our standard version of ChartSmart you should see our videos. Please note that if you go to HELP and ABOUT CHARTSMART and upgrade to version 3.1, then all users will be able to use ChartSmart Professional feature free until June 1, 2005.

ChartSmart Professional allows you to download Backtest Files and do screens on variables, not only in the present, but also in the past. This enables a user to actually specify the direction of a trend indicator. For example, one could not only specify that the RSI 14 is over 70 but also that 4 days ago it was under 50 and 8 days ago it was under 40 and so on. When you go to the YOU SPECIFY tab and enter a formula for any of the custom calculated lists, you can paste one of the formulas below to see how it works. These are only a few examples and the possibilities are limitless. Note that you can use any of the Basic Variables in your formulas but if you want to put a number in front they must come from the list of Historical Variables. Also you can only backtest as far back as you have backtest files for. If you for example download all backtest files in the last 50 days you will be able to set variables with numbers in front of them up to 50 days back.

1) Increasing RSI - This simple formula shows how you can set the current RSI to over 60 for example then specifying that on both 5 and 10 days before it did not exceed 50. This way it will be showing an increasing trend.

#rsi14#>60.and.#5rsi14#<50.and.#10rsi14#<50

2) Closing price today exceeds the highest closing price in the previous 7 trading days - This formula shows how you can use the basic variables open, high, low, close, volume, trades and so on to place some vary specific filter criteria.

#close#>max(#1high#,#2high#,#3high#,#4high#,#5high#,#6high#,#7high#)

3) MACD crossover after a long period where there was no crossover - This shows not only a MACD crossover it specifies that 5 days, 10 days, and 15 days ago that the signal line is above the macd line. Though they may have crossed, in most cases this means there will have been no crossover. This usually occurs when a security is on a constant trend downward, possibly making the crossover when it occurs more significant.

(#sig1225#<#exp12#-#exp25#.and.#1sig1225#>#1exp12#-#1exp25#).and.#5sig1225#>(#5exp12#-#5exp25#).and.#10sig1225#>(#10exp12#-#10exp25#).and.#15sig1225#>(#15exp12#-#15exp25#)

4) Low stochastic and RSI Plus RSI up 2 days in a row - Using the regular tech tab you can set the stochastics and rsi ranges below then use a custom calculated list for the custom formula. The custom formula counters the weakness trend in the other 2 criteria (low rsi and stoch) by also specifying the RSI has risen in the last 2 days.

Custom Formula #rsi14#>#1rsi14#.and.#1rsi14#>#2rsi14#
Set stoch (slow D line) = k%=15 the d%=5 line is <=15
Set RSI - Most Recent 14 day RSI value <=30

5) Chalkins 21 day Money flow Crossover - This formula specifies that the current day ch21 is over 0 but on 1, 3, 5, and 7 days before it was always under. This means there was a crossover in the last day plus it likely did not crossover since 7 days ago.

#chaik21#>0.and.#1chaik21#<0.and.#3chaik21#<0.and.#5chaik21#<0.and.#7chaik21#<0

6) Formula just below for the CUP and Handle- This formula looks back about 142 trading days (92+50 days) and then looks for a decrease in value over a period starting 60 trading days ago to 110 trading days ago. The decrease in value must be at least 15% of the highest value in a 50 day period from 110 trading days ago to 50 trading days ago. then the current close is compared to the same period and then the following weeks to determine if the stock has continued to increase in value but has still not reached the handle.

(#92h50#>(1.15*#60H50#)).and.(#92h50#>#CLOSE#).AND.(#CLOSE#>(1.1*#60H50#)).AND.(#8WKC0#>#22WKC0#).AND.(#102WKC0#<#92H50#).AND.(#CLOSE#>#15WKC0#)

7) Asymptopic Price Decline over 150 trading days - This formula looks back about 150 trading days then specifies that the price then was at least within 30% of the high of the range, then it specifies that over 75 days ago that it had declined to at least 40% of the range then currently it trades within 30% of the low of the range. Usually this screens out a lot of OTCBB charts. It is a good example though of how you can create your own price patterns.

#150last#/(#150last#-#last#)>.7.and.#75last#/(#150last#-#last#)<.4.and.#last#/(#150last#-#last#)<.3.and.#close#>0

8) Declining PE ratio - ChartSmart pro will let you specify screens for the direction of the PE ratio. For example, the following formula would mean the pe is currently less than 10, 100 days ago it is more than 20 and 200 days ago it is more than 30. Of course relationships can be drawn between the pe ratios and the duration of the trend can be expanded. In ChartSmart, you can check the results by running the screen then clicking on the current day, determine the close and eps off the menu in the upper left, then do the same clicking on the daily chart 100 and 200 trading days prevous to today and if you calculate the pe's you will see the trend.

(#last#/#eps#)<10.and.(#100last#/#100eps#)>20.and.(#200last#/#200eps#)>30.and.#eps#>0

9) Constricting 20 day Bollinger Bands - This formula basically says the bollinger band dif is less than 5 days about by 30% and the same with 10 days ago plus the current top of the bollinger is very close to the top of the range for the day. If you put the daily bollinger band on for 20 days it shows a tightening band close to the volatility on the day. Limited here only by your imagination. Unfortunately because it has to do with calculating the CHANGE in and indicator the pro verison is rqrd. You just need to learn the variables and you can draw any relationships to them. http://www.chartsmart.com/variablespro.html

(#bolup20#-#boldn20#)*1.3<(#5bolup20#-#5boldn20#).and.(#5bolup20#-#5boldn20#)*1.3<(#10bolup20#-#10boldn20#).and.#bolup20#<#low#+(#high#-#low#)*1.2