Subject | English | Chinese Taiwan |
comp., MS | array formula | 陣列公式 (A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results) |
comp., MS | Bollinger Bands formula | 布林通道公式 (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) |
comp., MS | calculation formula | 計算公式 (A Multidimensional Expressions (MDX) expression used to supply a value for cells in a calculation subcube, subject to the application of a calculation condition) |
comp., MS | commodity channel index formula | 順勢指標公式 (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) |
comp., MS | detrended price oscillator formula | 區間價格震盪指標公式 (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) |
comp., MS | envelopes formula | 封套公式 (" 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.") |
comp., MS | Evaluate Formula | 評估公式 (An option that enables the user to see the different parts of a nested formula evaluated in the order the formula is calculated) |
comp., MS | formula bar | 資料編輯列 (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) |
comp., MS | local formula | 本機公式 (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) |
comp., MS | MDX formula | MDX 公式 (The online analytical processing (OLAP) equivalent of an SQL query) |
comp., MS | median price formula | 中間價格公式 (A formula that calculates the average of the high and low prices) |
comp., MS | time formula | 時間公式 (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) |
comp., MS | validation formula | 驗證公式 (Checks the data in a field as it is entered. It sets limits or conditions on what can be entered) |
comp., MS | weighted close formula | 加權收盤價公式 (A formula that calculates the average of the high, low, and close prices, while giving extra weight to the close price) |