Knowledge Base

Knowledge Base

Research Wizard 4.0 "Error 1004 - Backtest Failed"

Article Number 0003

Issue

When I run a backtest report in Research Wizard 4.0, I am getting the "Error 1004 - Backtest Failed" message.

Solution

If your Screen Definitions contain some specific data period references in the criteria, they cannot be backtested.

Example: Screen Definitions that contain expressions "EVERY" or "ANY" , "RECENT", "RECENT[-N], "TODAY", or "TODAY[-N].

If the Screen Definition contains any of these expressions, the Research Wizard will produce an Error message 1004, Backtest Failed, followed by the Query Error message.

To avoid this error message, try using a calculation expression that combines several of your parameters.

Example, if you want to backtest a screen that has the following two parameters:

i192[Recent] = 1 and
i192 [Recent-1W] = 2,

at the Calculation Expression menu, enter the following:

i192=1 and i192[-1W] =2

and at the Screen by prompt, select TRUE.

Back

Copyright © 2001 Zacks Investment Research, Inc.

	Knowledge Base


	Research Wizard 4.0 "Error 1004 - Backtest Failed"

	Article Number 0003 Issue When I run a backtest report in Research Wizard 4.0, I am getting the "Error 1004 - Backtest Failed" message. Solution If your Screen Definitions contain some specific data period references in the criteria, they cannot be backtested. Example: Screen Definitions that contain expressions "EVERY" or "ANY" , "RECENT", "RECENT[-N], "TODAY", or "TODAY[-N]. If the Screen Definition contains any of these expressions, the Research Wizard will produce an Error message 1004, Backtest Failed, followed by the Query Error message. To avoid this error message, try using a calculation expression that combines several of your parameters. Example, if you want to backtest a screen that has the following two parameters: i192[Recent] = 1 and i192 [Recent-1W] = 2, at the Calculation Expression menu, enter the following: i192=1 and i192[-1W] =2 and at the Screen by prompt, select TRUE.
	Back Copyright © 2001 Zacks Investment Research, Inc.