A commonly asked question is: “How can I move the items in my report so they appear in a different order?”
||If you have questions or an idea you'd like to see demonstrated here, please send your comments to: RWmailbag@zacks.com
Did you know there are up to 12 years of historical data within the Research Wizard?
As a convenience, every time you create a screen within the main screening database and then backtest it, it’ll automatically toggle into the historical backtesting databases.
But you can access these and other databases on your own for a variety of screening and reporting purposes whenever you wish.
First, let’s take a look at all of the different Zacks Databases that comes loaded with the Research Wizard.
Available Zacks Databases
The following is a list of available Zacks databases.
- DBCM: This is the default screening database and is updated daily.
- DBCMHIST: This is the main backtesting database. For screening purposes, it contains five years (260 weeks) of historical data for screening. For backtesting, it can contain as many as 10 years (in weekly data points) of backtesting data based on the user’s subscription level.
- DBZHE: Monthly Historical database containing data for fundamental estimate and ratio items for entire universe.
- DBDA: Fundamental Historical Annual Data database containing annual income statements, balance sheet and cash flow items; 10K data going back 12 years.
- DBDQ: Fundamental Historical Quarterly Data database containing quarterly income statement and balance sheet items; 10Q data going back six years (24 quarters).
- DBDP: Daily Historical Prices database containing 560 days of daily price information.
- DBWP: Weekly Historical Prices database containing 625 weeks of weekly price data.
- DBQUOTE: Intraday (15-20 minutes delayed) prices database.
- AGGIND: Aggregate Industry database containing current fundamental data aggregated by Zacks Expanded Industry Groups.
- AGGSEC: Aggregate Sector database containing current fundamental data aggregated by Zacks Expanded Sector Groups.
How to Access the Different Databases
Accessing the different databases is easy.
- On your Menu Bar, go to File and then Select Open Database.
Once you do, the Zacks Database window pops up. (See below.)
- To open any one of the different databases, just select the one you want and then Click Ok.
For this example, let’s select the DBZHE – Monthly Historical database, then click OK.
Once you do, the main Research Wizard page will reappear with the new database loaded.
Tip: To be sure which database you’re in, the database’s acronym will appear above the Items window and to the right of the word Database:.(See below.)
As you explore the different items available in the different databases, you’ll often see numbers inside of parentheses to the right of an item’s description.
This shows you the numbers of number of available data points this item has available to access and in what periodicity it’s in, i.e.:
- D for Daily
- W or Wk for Weekly
- M or Mth for Monthly
- Q or Qtr for Quarterly
- Y or Yr for Yearly
- For example, while still in the DBZHE database, select Price and Returns in your Categories window and then Month-end Price under Price in the Items window.
To the right of the item, you’ll see (144 Mth).
That simply means there’s 144 month worth of monthly data points available to access to screen or report on.
Beneath there for example, you’ll see the item Beta (60 months) (48 Qtr).
The ‘48 Qtr’ means there’s 48 Quarterly data points that you can access for this item from this database.
(The ‘60 months’ is simply describing what period of time was used to calculate the Beta measure.)
To learn how to use these different periods (as a date specific function or as ‘lag’ function), please see the Tips and Tricks article called: How to Use the Historical Search Box from the ‘Main’ Screening Window, Issue # 10. http://zacksrw.com/Tips_Tricks10.asp
For further information on how you can combine different data items form different databases with the same Calculation Expression, go to the Tips and Tricks article called: Accessing Multiple Databases in the Same Calculation Expression, Issue # 8. http://zacksrw.com/Tips_Tricks8.asp
To switch to another database, repeat the steps from above.
As a shortcut, to switch back to the main default DBCM screening database, just go to File on your Menu Bar and select Reset Database.
This will take you back to the main DBCM database as shown below.
A screening and backtesting tool is only as powerful the database(s) that it runs on.
With the Research Wizard, there’s over 650 different data items to pick and choose from and a virtual infinite number of custom calculations one can create on their own. And this is all made possible due to the various databases available in the Research Wizard as well as the depth of historical data you have access too.
Start exploring the different databases and please browse the other Tips and Tricks articles to help you master the program and to help
you become a better stock picker today. http://zacksrw.com/Tips_Tricks.asp