Support Board
Date/Time: Mon, 26 May 2025 00:13:58 +0000
Post From: Spreadsheet Functions
[2013-04-11 03:23:44] |
|
Hello, We have said that we are developing our own new spreadsheet functionality. We are finally well underway to getting this complete. We need to determine the spreadsheet functions that are needed. Below is the current list. If there is a function you would like to see, let us know. If there is a function you see here, that you think is unnecessary for us to be adding, then let us know as well. ABS(number) ACOS(number) ACOSH(number) ADDRESS(row, column, ref type [, A1 format - logical value] [, sheet name]) AND(comma separated list of logical condition expressions) ASIN(number) ASINH(number) ATAN(number) ATANH(number) AVEDEV() AVERAGE(number list.) AVERAGEIF CEILING(number, multiple) CHOOSE CHOOSE(index, item list) COLUMN(reference) COLUMNS(reference) CONCATENATE(text1, text2, ....) CORREL() COS(number) COSH(number) COUNT(value list) COUNTA(expression list) COUNTBLANK() COUNTIF(range, criteria) CROSSFROMABOVE(range1, range2) CROSSFROMBELOW(range1, range2) CROSSOVER(range1, range2) DATE(year, month, day) DATEVALUE(text) DAVERAGE() DAY(Serial DateTime Value) DAYS360() DEGREES() DEVSQ() DGET() DMAX() DMIN() DSUM() EDATE EOMONTH EVEN(number) EXACT(expression1, expression2) EXP(number) FINV() FISHER() FISHERINV() FLOOR(number, significance) FORECAST FORECAST() FREQUENCY GROWTH HLOOKUP(search item, search range, row index) HOUR(Serial DateTime Value) IF(Condition, TrueValue, FalseValue) INDEX(reference [, row] [, column] [, range number]) INT(number) ISERROR ISLOGICAL LARGE LINEST() LN(number) LOG(number [, base]) LOG10(number) LOOKUP(lookup value, lookup range, result range) MATCH MAX(number list) MAXIF MEDIAN() MIN(number list) MINIF MINUTE(Serial DateTime Value) MOD(number, divisor) MONTH(Serial DateTime Value) NETWORKDAYS NOT(logical) NOW() ODD(number) OFFSET(starting cell reference, rows, columns [, height] [, width]) OR(logical condition expression list separated by commas) PEARSON() PERCENTILE PERCENTRANK PI() POWER() PROB RAND() ROUND(number, digits) ROUNDTOMULTIPLE(number, multiple) SECOND(Serial DateTime Value) SIN(number) SINH(number) SLOPE(Y Values Range, X Values Range) SMALL SQRT(number) STDEV() SUM(number list) TAN(number) TANH(number) TEXT TIME(hour, minute, second) TIMEVALUE(text) TODAY() TREND() TRUNC(number [, precision]) VLOOKUP(search item, search range, column index) WEEKDAY(Serial DateTime Value) WEEKNUM WORKDAY YEAR(Serial DateTime Value) ZTEST Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2013-04-11 18:59:54
|