EOD Toolkit Help

The EOD Toolkit is an assortment of utilities and formulas for MetaStock 7.0+. The toolkit contains DLL functions, custom formulas, and explorations.

DLL FUNCTIONS

These will show up in MetaStock at the Paste Functions dialog.

GetTextFile - Retrieves data out of a comma-separated text file. The first parameter is the file name (if this is blank, it uses the data folder + symbol + ".CSV"). The second parameter is the column heading. For example, the statement:

will pull the values in the column named "Rate" from the file named "MyTest.csv".

TwoMAsOfPriceCrossoverPrice - Calculates the closing price necessary to make two exponential moving averages cross. The indicator value today is what tomorrow's price must be to cause a crossover tomorrow. The user specifies the length of the moving averages.

MAOfMACrossoverPrice - Calculates the closing price necessary to make a moving average of a moving average cross a moving average. The indicator value today is what tomorrow's price must be to cause a crossover tomorrow. The user specifies the length of the moving averages.

MACDCrossoverPrice - Calculates the closing price necessary to make a 9-period trigger line and a traditional 15%/7.5% MACD cross. The indicator value today is what tomorrow's price must be to cause a crossover tomorrow.

GetCurrentDayOfMonth, GetCurrentMonth, and GetCurrentYear - Returns the current day of the month, the current month, and the current year. Most useful to filter out securities from explorations that are not up to date.

DataIsUpToToday - Checks if the last day of data is equal to today. Used to filter securities in the explorer.

Median Volume - Calculates the median volume over the specified time periods. That is, half of the volume occurred above the median, and half occurred below.

Line - Calculates a line, based on the starting date and percent increase given. Date must be given in YYMMDD format. The increase that you specify is for each bar (i.e., trading day).

LLVSinceHHV - Returns the lowest low value since the security hit a new high. The user specifies the time periods in the HHV function.

Overhead Resistance Indicator - Our own indicator that measures the % of trading in the past n-periods that occurred above the current price.

GetTickerLength - Returns the length of the security's ticker symbol. Useful to separate NASDAQ (four character) from NYSE and AMEX (3 and fewer character) stocks.

CUSTOM FORMULAS

These will show up in MetaStock starting with "DeBry.com ET"

Swing Percent - A swing percent system.

Date functions - Date-related functions, including Year-to-date performance ($ and %), Quarter-to-date performance ($ and %), Month-to-date performance($ and %). Also has functions to "mark" the last day of the month, quarter, and year.

4% Rule - Gives 4% rule buy and sell signals.

Day of Week - Returns the average performance for the specified day of the week. Running this on the Dow back to 1900 shows that, on average, Monday has been the worst day of the week, and Friday the best.

EXPLORATIONS

Window Dressing - An exploration to find stocks that show unusual price behavior on the last day of quarters.