Support Board
Date/Time: Sun, 24 Nov 2024 05:08:52 +0000
New Non-CLR Spreadsheet Study Study Reference Method
View Count: 15372
| [2013-08-28 03:03:34] |
| |
|
1. We are working on a new method to reference studies outputted by the Spreadsheet Study in the non-CLR version of Sierra Chart. The reference method will be by using the studies unique ID, the subgraph and the row number. It has long been a problem when studies are added, removed or the number of subgraphs in a study changes and references to existing studies are thrown off. This makes formula maintenance difficult. We now have a comprehensive solid solution for this. With the changes planned, any time a study is added or removed, existing references will be fine as long as they are not referring to a removed study. If the number of subgraphs in a study increases this will not be a problem either. This image shows an example of the new format: http://www.sierrachart.com/images/NewSpreadsheetStudyReferenceFormat.png 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-08-28 03:05:07
|
| [2013-09-06 13:21:31] |
| Outlander - Posts: 91 |
|
If using the same spreadsheet for more then one chart and all charts have the same study's it seems to me that the new method do not work as the reference number is the same for all charts on the same study.The reference number is the same on all sheets in the spreadsheet. Regards Outlander
|
| [2013-09-07 02:26:16] |
| |
|
These new Study Subgraphs references are specific to individual Sheets they are displayed and used in. Unless they are prefixed with the sheet name. For example you will be able to do something like this: Sheet5!ID1.SG2.3 This is not quite supported yet. 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-09-12 14:13:18] |
| Sawtooth - Posts: 4118 |
|
I frequently use row 1 of Formula Columns for input values. Will row 1 still be available?
|
| [2013-10-01 12:13:23] |
| namlem - Posts: 94 |
|
What is the new address for A3 date time cell? ID0.SG0.3? ok, understood, A3 works well. I'm just wondering why cell B3 can be referenced in both ways - using new style ID0.SG1.3 and old B3... at the same time A3 doesn't have new style address. Date Time Of Last Edit: 2013-10-01 12:20:02
|
| [2013-10-02 01:28:06] |
| |
|
There is not a new reference method for column A and there does not need to be one because that is always constant and present. Date-Time data is not normally part of studies.
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-10-02 01:28:55
|
| [2013-10-02 01:29:55] |
| |
|
The new reference method will not affect this: I frequently use row 1 of Formula Columns for input values. Will row 1 still be available?
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-11-11 03:27:44] |
| C. Notes - Posts: 129 |
|
Hi, Just installed the latest version and wow! it's a whole new system it looks like!... Problem is I need my chartbook and sheets like I had them... How can I do this or do I need to revert back to an older version? |
| [2013-11-11 08:55:53] |
| |
|
Are you referring to the non-CLR version? The non-CLR version does use new spreadsheet functionality which cannot read the old spreadsheet files. At least at this time.
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-11-11 10:06:59] |
| C. Notes - Posts: 129 |
|
Hi, Yes the non CLR version... I am running quite a bit of stuff and fell into a lot of Microsoft errors so I switched.. It seemed to clear things up a bunch... The latest version does not load my spreadsheets properly, so I reverted back to 1043 But wow those new sheets look nice... What worries me is being able to port my work over... I have quite a bit of labor logged into my system here...Sheet names are important... I use a free standing "GUI" sheet to control everything....this is elaborate from color coding, conditional formatting, etc... That sheet didn't load at all on the new version (It is an added sheet with no chart assign...) I'm really excited about these updates, just need a reasonable way to port over... A simple copy paste could be feasible, but sheet references are gone Just brainstorming here... Cheers |
| [2013-11-11 10:09:13] |
| C. Notes - Posts: 129 |
|
Also, I would like to find a way to make the switch as soon as possible so as to maintain my work on the best possible platform for the future..... |
| [2013-11-12 17:17:05] |
| |
|
The new spreadsheets are still under development. They are still considered a beta. We do plan to add a program to convert the previous CLR spreadsheet files to the new format. 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-11-24 04:32:01] |
| enemyspy - Posts: 306 |
|
I am looking to migrate over to non-clr as the cpu load is causing too much latency on my charts. However I am not too stoked to copy and paste all the formulas from all my spreadsheets and modify the referencing formulas due to laziness. When do you expect the program to convert to non-clr to be available? Would it be worth waiting for it if I have like 15 spreadsheet files I need to re-code? |
| [2013-11-24 04:37:06] |
| enemyspy - Posts: 306 |
|
Also, is it in the development plans to build any macro functionality into the spreadsheets?
|
| [2013-11-25 07:11:19] |
| |
|
No.
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 |
| [2014-08-11 05:43:48] |
| Outlander - Posts: 91 |
|
Is this supported now Sheet5!ID1.SG2.3 I can not get it to work. Regards Outlander |
| [2014-08-12 11:06:20] |
| |
|
When do you expect the program to convert to non-clr to be available? This is available in the latest Sierra Chart release.Is this supported now Sheet5!ID1.SG2.3 We will check on 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 Date Time Of Last Edit: 2014-08-12 11:06:36
|
| [2014-08-13 22:26:15] |
| |
|
To reference a cell from a study column using the new alternative reference method, use this new format: [OptionalSheetName!]ID[StudyIDNumber].SG[SubgraphNumber]@[RowNumber] Example: Sheet5!ID1.SG2@3 The old format which uses a dot before the row number is no longer 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 Date Time Of Last Edit: 2014-10-27 16:39:34
|
| [2014-08-14 08:09:04] |
| Outlander - Posts: 91 |
|
It did not work get the error "#NAME?" This is the code I used =Sheet3!ID1.SG1@3 Regards Outlander |
| [2014-08-14 08:53:53] |
| namlem - Posts: 94 |
|
When do you expect the program to convert to non-clr to be available?
This is available in the latest Sierra Chart release.Or you did it in a way that it does convertion automatically? |
| [2014-08-14 16:55:13] |
| |
|
We are going to be making a video today demonstrating how to use the alternate Study Subgraph column reference method
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: 2014-08-14 16:57:11
|
| [2014-08-14 17:02:44] |
| user58907 - Posts: 83 |
|
Done.
|
| [2014-08-14 18:53:45] |
| |
|
We see a problem with the alternate reference method for Study Subgraph columns on spreadsheets which will cause a NAME error. We are working to resolve this now. 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 |
| [2014-08-15 04:01:18] |
| |
|
The problem with using the alternate referencing method or identifier for Study Subgraph columns on a Spreadsheet, has been resolved in 1174. Update Sierra Chart to the latest version through the Help menu. Here is a new video we put together featuring some of the improvements in the new spreadsheets including the new alternate reference method: https://www.sierrachart.com/Videos/New%20Spreadsheets.wmv 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 |
| [2014-08-15 11:05:25] |
| Outlander - Posts: 91 |
|
I still have problem with volume by price indicator.The alternate reference method only works on SG2. I would like to plot SG3 and SG4. Regards Outlander
|
To post a message in this thread, you need to log in with your Sierra Chart account: