Field files may be suffixed with a colon followed by a lag value, as in field0=tim.v:5 .
Field functions usually require a certain number of comma-separated arguments prefixed by a colon, as in field0=tr:10,253 . However, some user interfaces may allow or require use of parentheses isntead of a colon, as in field0=tr(10,253) .
Take note of default values, which are assigned to investments without meaningful values in the source data; N/A indicates that a default value is not required because a meaningful field value is always available.
Follow each field's link to the glossary for more details.
| Name | Type | Description | Default Value | Start | End |
|---|---|---|---|---|---|
| abs | field functioin | absolute value | N/A | 19740107 | 20071231 |
| aprc | field functioin | daily actual price | N/A | 19740107 | 20071231 |
| av10.a | field file | average daily volume over 10 market days | 0 | 19821112 | 20071231 |
| av21.a | field file | average daily volume over 21 market days | 0 | 19821130 | 20071231 |
| av63.a | field file | average daily volume over 63 market days | 0 | 19830128 | 20071231 |
| avg | field functioin | average by group | N/A | 19740107 | 20071231 |
| beta | field functioin | Beta vs S&P500 | N/A | 19740107 | 20071231 |
| bncut | field functioin | bottom n cut-off value by group | N/A | 19740107 | 20071231 |
| bpcut | field functioin | bottom % cut-off value by group | -HUGE_VAL | 19740107 | 20071231 |
| cdv.a | field file | Actual Current Dividend | 0 | 19740107 | 20071231 |
| day | field functioin | day of month | N/A | 19740107 | 20071231 |
| dfh | field functioin | days from high | N/A | 19740107 | 20071231 |
| dfl | field functioin | days from low | N/A | 19740107 | 20071231 |
| dsio | field functioin | days since investment opened for purchase | N/A | 19740107 | 20071231 |
| dsp | field functioin | days since purchase | N/A | 19740107 | 20071231 |
| dspo | field functioin | days since pricing opened | N/A | 19740107 | 20071231 |
| dv253.a | field file | Actual Dividend 253d | 0 | 19740107 | 20071231 |
| exp | field functioin | base e exponentiation | N/A | 19740107 | 20071231 |
| gprc | field functioin | daily g-price | N/A | 19740107 | 20071231 |
| gtoa.a | field file | daily g-price to actual price conversion factor | N/A | 19740107 | 20071231 |
| hgprc | field functioin | high g-price | N/A | 19740107 | 20071231 |
| if | field functioin | conditional value | N/A | 19740107 | 20071231 |
| int | field functioin | truncation to integer | N/A | 19740107 | 20071231 |
| lgprc | field functioin | low g-price | N/A | 19740107 | 20071231 |
| linear | field functioin | linear combination/weighted sum | N/A | 19740107 | 20071231 |
| ln | field functioin | natural logarithm | 0 | 19740107 | 20071231 |
| max | field functioin | maximum | N/A | 19740107 | 20071231 |
| mcpp.a | field file | market capitalization as full-market percentile rank | 0 | 19740107 | 20071231 |
| min | field functioin | minimum | N/A | 19740107 | 20071231 |
| mod | field functioin | remainder | N/A | 19740107 | 20071231 |
| month | field functioin | month | N/A | 19740107 | 20071231 |
| ord | field functioin | market date ordinal | N/A | 19740107 | 20071231 |
| pav63p.a | field file | price times av63.a as full-market percentile rank | 0 | 19830128 | 20071231 |
| pcntl | field functioin | percentile rank (within group) | N/A | 19740107 | 20071231 |
| pgprc | field functioin | projected g-price | N/A | 19740107 | 20071231 |
| ph253.g | field file | g-price divided by high g-price over 253 market days | N/A | 19740107 | 20071231 |
| pow | field functioin | exponentiation | N/A | 19740107 | 20071231 |
| pref | field function | preferred fields, when available | N/A | 19740107 | 20071231 |
| product | field functioin | product | N/A | 19740107 | 20071231 |
| rank | field functioin | rank (within group) | 0 | 19740107 | 20071231 |
| ratio | field functioin | ratio | N/A | 19740107 | 20071231 |
| rrs | field functioin | regression relative strength | N/A | 19740107 | 20071231 |
| rsi | field functioin | Relative Strength Index | N/A | 19740107 | 20071231 |
| sbdates.txt | signal file | Screen Builder dates | N/A | 19740107 | 20071231 |
| sho.a | field file | actual shares outstanding | 0 | 19740107 | 20071231 |
| sma | field functioin | simple moving average | N/A | 19740107 | 20071231 |
| sprc | field functioin | daily SI-adjusted price | 0 | 19960513 | 20071231 |
| styp.a | field file | security type | N/A | 19740107 | 20071231 |
| sum | field functioin | sum by group | N/A | 19740107 | 20071231 |
| tncut | field functioin | top n cut-off value by group | N/A | 19740107 | 20071231 |
| tpcut | field functioin | top % cut-off value by group | HUGE_VAL | 19740107 | 20071231 |
| trm | field functioin | total return (multiplier) | N/A | 19740107 | 20071231 |
| trp | field functioin | total return (percentage) | N/A | 19740107 | 20071231 |
| *.u | field file | User-Defined: *.u | 255 | - | - |
| vol | field functioin | volatility | N/A | 19740107 | 20071231 |
| vprc | field functioin | daily VL-adjusted price | 0 | 19860106 | 20071231 |
| year | field functioin | year | N/A | 19740107 | 20071231 |