Login Page - Create Account

Support Board


Date/Time: Mon, 26 May 2025 00:13:58 +0000



Post From: Spreadsheet Functions

[2013-04-11 03:23:44]
Sierra Chart Engineering - Posts: 104368
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