English | German |
array formula | Matrixformel (A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results) |
Bollinger Bands formula | Bollinger-Bänder-Formel (A formula that calculates the standard deviation above and below a simple moving average of the data. Since standard deviation is a measure of volatility, a large standard deviation indicates a volatile market, and a smaller standard deviation indicates a calmer market) |
calculation formula | Berechnungsformel (A Multidimensional Expressions (MDX) expression used to supply a value for cells in a calculation subcube, subject to the application of a calculation condition) |
commodity channel index formula | Warenkanalindexformel (A formula that calculates the mean deviation of the daily average price of a commodity from the moving average. A value above 100 indicates that the commodity is overbought, and a value below -100 indicates that the commodity is oversold) |
conditional sum formula | Formel für bedingte Summe (A formula that will sum a set of values that meet specified conditions) |
detrended price oscillator formula | trendbereinigte Kursoszillatorformel (A formula that calculates the difference between the daily price and the moving average. This is useful for identifying cycles and overbought and oversold price levels) |
envelopes formula | Umschlagformel (" A financial formula that calculates "envelopes" above and below a moving average using a specified percentage as the shift. The envelopes indicator is used to create signals for buying and selling. You can specify the percentage the formula uses to calculate the envelopes.") |
Formula AutoComplete | AutoVervollständigen für Formeln (An AutoComplete feature for Excel formulas) |
formula bar | Bearbeitungsleiste (A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell) |
Formula Builder | Formel-Generator (A tool that helps you create or edit a formula and also provides information about functions and their arguments) |
formula item | Formelartikel (An output of a batch process controlled by a formula) |
Formula Palette | Formelpalette (A tool that helps you create or edit a formula and also provides information about functions and their arguments) |
local formula | lokale Formel (A formula that is stored in a cell of a shape instead of being inherited from a master or a style. A local formula overrides changes to the corresponding cell in the master of which the shape is an instance) |
mathematical formula | Mathematische Formel (A mathematical statement in a formal language that can be given a semantic meaning) |
MDX formula | MDX-Formel (The online analytical processing (OLAP) equivalent of an SQL query) |
median price formula | Medianpreisformel (A formula that calculates the average of the high and low prices) |
time formula | Zeitformel (An expression that is created following the Simple Time Period Syntax. It takes the form of a time unit plus or minus a whole number, such as Year-1 or Month-6. It is the formula that is applied when you are using time intelligence on a dashboard) |
validation formula | Gültigkeitsprüfung (Checks the data in a field as it is entered. It sets limits or conditions on what can be entered) |
weighted close formula | gewichtete Schlusskursformel (A formula that calculates the average of the high, low, and close prices, while giving extra weight to the close price) |