Support Board
Date/Time: Sun, 19 Jan 2025 19:41:55 +0000
Is Excel Still Available as a Spreadsheet Option?
View Count: 1507
| [2018-05-07 07:59:13] |
| QTrader08 - Posts: 5 |
|
Hi, I've gone through the documentation and it states to use the "Use Excel" input to enable Excel spreadsheets. However, I don't see that input available. Has this functionality been discontinued? If so, are there any other studies available that would return the intercept of a regression. I'm aware of the slope method but I also need the intercept. I started manually writing the ADF test in a spreadsheet(i.e. quicker prototyping than C++) but noticed that the LINEST function which is available in Excel isn't available in the spreadsheet. Can you inform me of any alternatives? Thanks |
| [2018-05-07 09:15:06] |
| |
|
So you need to get the y-intercept of a linear regression using two input arrays? Yes Excel is still supported but it is easiest if we just help you with this function. 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: 2018-05-07 09:16:13
|
| [2018-05-07 23:17:18] |
| |
|
Would the Excel INTERCEPT function work for you? We can add that.
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: 2018-05-07 23:17:29
|
| [2018-05-08 13:04:08] |
| QTrader08 - Posts: 5 |
|
Hi, In Excel, I've used the LINEST function which returns the slope and intercept. If you can add the INTERCEPT function I believe that would work. |
| [2018-05-08 19:14:58] |
| |
|
Okay we will add INTERCEPT.
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: