Support Board
Date/Time: Sun, 25 May 2025 22:32:38 +0000
Spreadsheet Functions
View Count: 9529
[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
|
[2013-04-11 20:54:22] |
Sawtooth - Posts: 4220 |
Could you add these please?: ROUNDUP ROUNDDOWN ISBLANK ISEVEN ISODD LEFT RIGHT MID VALUE And MROUND, but maybe ROUNDTOMULTIPLE is the same (?) Also, it would be very handy to have a MROUNDUP and MROUNDDOWN. Although I have not used every function in your list, I wouldn't want to be the one to say any should be removed. |
[2013-04-11 21:30:53] |
|
Yes. Yes. 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 21:31:06
|
[2013-04-11 22:55:25] |
AndyL - Posts: 119 |
Will it be possible to add user-defined Ascil functions?
|
[2013-04-12 07:27:10] |
Marmany - Posts: 311 |
I use right click / sort many times every day on a quote spreadsheet. It would be great if you could have the sort criteria held in memory after a sort is made - as happens with Excel.
|
[2013-04-12 09:09:18] |
AB604E - Posts: 32 |
Please make the following fields as "Read/Write" ability instead of "Read-Only" as of now. Maximum Position Allowed (read-only) Support Reversals (read-only) Allow Opposite Entry with Opposing Position or Orders (read-only) This will add flexibility to control the Auto-Trade function not only disable Auto-Trade and Flatten on certain time of day) May be can Max Position to ZERO but Auto trade still function. Max Position can be increase or decease base on Closed Profit / Loss , base on number of consecutive WINNER/LOSER. This way Amount of Max Position can be scalable using function in Spreadsheet to control. |
[2013-04-12 18:10:24] |
Trader_RT - Posts: 35 |
Thanks for being proactive! I would like to see more Information Functions added to your Spreadsheet Function List, such as: CELL - Returns information about the formatting, location, or contents of a cell. ERROR.TYPE - Returns a number corresponding to an error type. ISBLANK - Returns TRUE if the value is blank ISERR - Returns TRUE if the value is any error value except #N/A ISEVEN - Returns TRUE if the number is even. ISNA - Returns TRUE if the value is the #N/A error value. ISNONTEXT - Returns TRUE if the value is not text. ISNUMBER - Returns TRUE if the value is a number. ISODD - Returns TRUE if the number is odd. ISREF - Returns TRUE if the value is a reference. ISTEXT - Returns TRUE if value is text. NA - Returns the error value #N/A TYPE - Returns a number indicating the data type of a value. Thanks for your Excellent Support and Service!!! |
[2013-04-12 18:45:04] |
CarlRostron - Posts: 80 |
Absolutely!!! Countifs (countif plural) Sumif Sunifs (sumif plural) Index Randbetween (good conditional formatting functionality also please) You guys are amazing developers!! |
[2013-04-17 20:30:41] |
C. Notes - Posts: 130 |
How about macros.. buttons, sliders, etc, would be super helpful.... Also, if there was some way to get the line drawing tool to show on the spreadsheet... would be nice if there was say tool 1-8 and values for each bar... Could even be as simple as drawing tool alert to spreadsheet as in tool 1-8 return boolean value... Date Time Of Last Edit: 2013-04-17 20:34:08
|
[2013-04-17 20:32:43] |
|
Thank you for all of the feedback in this thread. We will not be responding to individual posts, however we are monitoring this and seeing what functions need to be supported.
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 |
[2013-04-17 20:44:08] |
C. Notes - Posts: 130 |
Here is another thought... Perhaps spreadsheet groups and a live show hide window would be awesome... Navigation is a bear currently. Also, a quick click menu item to lock a cell from accidental input... |
[2013-04-17 20:45:31] |
C. Notes - Posts: 130 |
Oh... and detachable sheets would be great..
Date Time Of Last Edit: 2013-04-17 20:46:46
|
[2013-04-21 16:29:28] |
vegasfoster - Posts: 444 |
FYI, a quick way to count or sum using multiple conditions is with sumproduct, this page explains it pretty good http://www.accountingweb.com/topic/excel/some-unlikely-uses-sumproduct
|
[2013-04-22 13:58:23] |
namlem - Posts: 94 |
Hi, this related to alerts, but since they trigger when certain conditions are met in excel cell I will put it here. Would be nice to have kind of alert message format/template for emails. Currently it hard coded to something like "Alert - Chart:<ChartName><TimeFrame>Study:<StudyName>|Formula... date..." |
[2013-05-12 02:40:05] |
C. Notes - Posts: 130 |
a MINZ() (or something like that) would be handy for minimum value greater than zero.... Date Time Of Last Edit: 2013-05-12 02:41:09
|
[2013-05-12 02:43:49] |
C. Notes - Posts: 130 |
Also, Here's another idea MING(Value,Range) For minimum value from range greater than value MAXL(Value,Range) For maximum value from range less than value I know there's ways to do this, but everything I've come up with is a royal pain. This would be real easy and efficient. Date Time Of Last Edit: 2013-05-12 02:58:58
|
[2013-05-12 06:51:44] |
CarlRostron - Posts: 80 |
Looking at this again you have not got =Left, =Right & =Mid. These should be included and are standard Excel functions.
|
[2013-05-14 17:45:54] |
|
These additional function requests should be no problem.
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 |
[2013-07-25 13:18:51] |
TheOddsAreYouDontKnowTheOdds - Posts: 29 |
It would be nice to have a function that can trap the lowest/highest value printed after a trade is made. This would be useful in constructing trailing stops for exit logic inside the spreadsheet. If that already exists, please point me to it! Thanks. EDIT -- Discovered there is a way to do this through a self-referencing formula. It can be cumbersome, but one can get by. See "Locking the state of a one-time condition". http://www.sierrachart.com/index.php?l=doc/doc_WS_AddInfo.html Date Time Of Last Edit: 2013-07-31 00:23:21
|
[2013-07-25 21:26:58] |
gabby alindogan - Posts: 49 |
Can the spreadsheet study native to SC be used referencing COM objects by other brokers who are not in the SC supported trade services but have Excel and VB interfaces for auto trading? If not, is there a way for SC to dynamically update study values from SC to an existing Excel sheet where the VB /Excel autotrading interface is coded? Thanks. |
[2013-07-27 02:45:46] |
|
Sierra Chart does not support COM in this way. COM is a messy and outdated software technology from Microsoft. Sierra Chart does support an interface to Excel with the Spreadsheet study. Refer to: http://www.sierrachart.com/index.php?l=doc/doc_WorksheetStudy.html 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-07-27 02:48:57
|
[2013-07-28 20:02:21] |
gabby alindogan - Posts: 49 |
I would like to rephrase my earlier question. If I use the SC spreadsheet , is there a way to access its cell values using VB6. Something like set qp = getobject(c:mystudy.scwbf) qp.worksheets(Sheet1).activate qp.activesheet.cells(1,1)="test" lastprice=qp.activesheet.cells(2,2) Thanks. |
[2013-07-29 22:21:55] |
|
Not using the built-in Sierra Chart Spreadsheets. You need to set the Use Excel input to Yes and actually output the data to Excel.
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 |
[2013-07-30 11:59:41] |
gabby alindogan - Posts: 49 |
Hi. I am trying to import data to Excel using SC's spreadsheet study. I need to get 4 studies (ie mov avg,adx,custom1,custom2) for 20 tickers-aapl,ibm,etc.... Is there a way to layout the tickers in quotepage format from cells A1 to cell A20, and then get dynamic from the 4 studies for all the 20 tickers onto columns b,c,d,e? If not, is there a way to output it to a text file where I can parse it out using VB? Can the "bar data to file" study write the above example of studies? |
[2013-07-30 18:07:28] |
|
You are not posting in the correct place. You need to start a new thread about this.
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 |
To post a message in this thread, you need to log in with your Sierra Chart account: