 |
| English | French |
| Bollinger Bands formula | formule Bandes de Bollinger (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 | formule de calcul (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 | formule CCI (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 | formule de somme conditionnelle (A formula that will sum a set of values that meet specified conditions) |
| detrended price oscillator formula | formule Oscillateur de prix redressé (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 | formule Enveloppes (" 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 | Saisie semi-automatique des formules (An AutoComplete feature for Excel formulas) |
| formula bar | barre de formule (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 | Concepteur de formule (A tool that helps you create or edit a formula and also provides information about functions and their arguments) |
| formula item | élément de formule (An output of a batch process controlled by a formula) |
| Formula Palette | palette de formules (A tool that helps you create or edit a formula and also provides information about functions and their arguments) |
| local formula | formule locale (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 | formule mathématique (A mathematical statement in a formal language that can be given a semantic meaning) |
| MDX formula | formule MDX (The online analytical processing (OLAP) equivalent of an SQL query) |
| median price formula | formule de calcul du prix moyen (A formula that calculates the average of the high and low prices) |
| time formula | formule de temps (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 | formule de validation (Checks the data in a field as it is entered. It sets limits or conditions on what can be entered) |
| weighted close formula | formule de clôture pondérée (A formula that calculates the average of the high, low, and close prices, while giving extra weight to the close price) |