Custom Field Editor
The Custom Field Editor is a tool that was created to help you in the creation of Custom Fields in Stock Investor Pro. This editor will help you create an algebraic formula that is syntactically correct and then apply it to every company in the database. These custom fields can then be used for screening as well as creating custom views and reports.
To open the Custom Field Editor, choose the Custom Field iccon from the toolbar or select Tools from the main menu and then Custom Field Editor (Tools--Custom Field Editor). You can also open the Custom Field Editor by simultaneously pressing the Alt and C keys (Alt + C). Following any of these steps will open the Custom Field Editor window:
The Custom Field Editor has several elements, which we explain here:
This is the area where the actual algebraic formula will appear.
To build a custom field simply start by clicking on the appropriate operator ('(', '+', '*', etc.), selecting the appropriate field from the pickers, or typing a constant value. As you do these things you will notice a formula appear in the Expression Box. Remember that the Expression Box is nothing more than a text box. Once a field or operator is added using the pickers, you can edit the text as if you were working in a text editor. This is helpful for removing mistakes or adding in missing operators or parenthesis but can also be the problem for syntax errors.
This picker will place the selected operator in to the Expression Box. Operators that are valid are:
Throughout the Stock Investor program you will be presented with the need to select a particular financial field (i.e., Company Name, Earnings per Share Y1, PE, etc.) from the database. Whenever this is necessary you will be given a standard tree consisting of data fields Definitions inside the categories like the following:
In order to view the fields inside, click on the + beside the field category (i.e., Company Information, Price & Share Data, Custom Fields, etc.). Once a category is open you can choose the actual field you are want by double clicking on it or by highlighting it and clicking the Select button.
This is a useful function to ensure that the formula is inputted correctly in the Expression Box. Although it cannot account for financial logic errors in a calculation, it can check that all open parentheses have a closing parentheses, that the field names entered are typed correctly and do exist in the database and if there are missing or duplicate operators or fields.
These buttons will invoke the Save command. If the custom field is new you will be presented with a window asking for you to give the field a Name (which is required) and a Description (which is optional). When done select the OK button. Immediately after saving a custom field you will be prompted to calculate the field. Although you have a formula, it still needs to be applied to each company in the database before a value of some kind will be placed in that company's record. You can say 'No 'to the calculation, but you will need to come back and calculate the field before you run a screen or rank utilizing it. By not calculating the field, you will most likely receive zero companies passing a screen that utilizes it.
This action will cause Stock Investor to take the formula for the currently edited custom field and apply it to each company in the database. This is required before you can actually use a custom field in a screen or rank. Until this is done there will be NO VALUE in the actual company records. You will normally be requested to calculate a custom field upon saving it. However, if you said 'No' to the calculation process at that time, this will allow you to come back and calculate the field at a later time.
One feature that many users may not be familiar with is the collection of mathematical expressions that is available to perform more advanced calculations. Here we will discuss how to utilize some of the more useful expressions.
Custom fields are created in Stock Investor with the Custom Field Editor. To open the Custom Field Editor, select Custom Field Editor from the Tools menu (Tools-Custom Field Editor), click on the Custom Field Editor icon from the toolbar, or use the Alt+C key command.
Once you are in the Custom Field Editor, you can access the mathematical functions from the pull-down menu in the lower right side of the Custom Field Editor: