Login Page - Create Account

Support Board


Date/Time: Thu, 18 Jan 2018 22:05:55 +0000



New Non-CLR Spreadsheet Study Study Reference Method

Support Request:
[2013-08-28 03:03:34]
Sierra Chart Engineering - Posts: 56270
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2013-08-28 03:05:07
[2013-09-06 13:21:31]
Outlander - Posts: 88
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]
Sierra Chart Engineering - Posts: 56270
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2013-09-12 14:13:18]
tomgilb - Posts: 1753
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]
Sierra Chart Engineering - Posts: 56270
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2013-10-02 01:28:55
[2013-10-02 01:29:55]
Sierra Chart Engineering - Posts: 56270
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2013-11-11 03:27:44]
C. Notes - Posts: 96
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]
Sierra Chart Engineering - Posts: 56270
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2013-11-11 10:06:59]
C. Notes - Posts: 96
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: 96
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]
Sierra Chart Engineering - Posts: 56270
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2013-11-24 04:32:01]
enemyspy - Posts: 244
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: 244
Also, is it in the development plans to build any macro functionality into the spreadsheets?
[2013-11-25 07:11:19]
Sierra Chart Engineering - Posts: 56270
No.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2014-08-11 05:43:48]
Outlander - Posts: 88
Is this supported now Sheet5!ID1.SG2.3
I can not get it to work. Regards Outlander
[2014-08-12 11:06:20]
Sierra Chart Engineering - Posts: 56270
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2014-08-12 11:06:36
[2014-08-13 22:26:15]
Sierra Chart Engineering - Posts: 56270
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2014-10-27 16:39:34
[2014-08-14 08:09:04]
Outlander - Posts: 88
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.
@Sierra, Will you provide any documentation where to find it and how to use it?
Or you did it in a way that it does convertion automatically?

[2014-08-14 16:55:13]
Sierra Chart Engineering - Posts: 56270
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2014-08-14 16:57:11
[2014-08-14 17:02:44]
user58907 - Posts: 76
Done.
[2014-08-14 18:53:45]
Sierra Chart Engineering - Posts: 56270
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2014-08-15 04:01:18]
Sierra Chart Engineering - Posts: 56270
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2014-08-15 11:05:25]
Outlander - Posts: 88
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
[2014-08-15 11:31:15]
Sierra Chart Engineering - Posts: 56270
It should work fine no matter what the Study Subgraph is.

We need more information about the problem. What specifically is the issue?
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2014-08-15 11:38:25]
Outlander - Posts: 88
I get the same error "#NAME?" Referring to SG2 works but not SG3 and SG4
Regards Outlander
[2014-08-15 17:00:35]
Sierra Chart Engineering - Posts: 56270
In the case of the Volume by Price study the following Study Subgraphs are set to be excluded from Spreadsheets:
Value Area High Value
Value Area Low Value

We cannot change this because it will affect Study subgraph references when the formulas are using the standard spreadsheet reference method.

We recommend using the Volume Value Area Lines study to get this data.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2014-08-16 11:39:09]
Outlander - Posts: 88
I use numbers of bars for fixed bar count. The volume area lines dos not have that option. Regards Outlander
[2014-08-19 06:52:38]
Sierra Chart Engineering - Posts: 56270
This is not something we can solve without causing problems with cell references in formulas for existing users.

Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2014-08-19 06:53:29
[2014-08-19 13:29:38]
tomgilb - Posts: 1753
SC, you could do what you do in the Zigzag study: create an option for Additional Outputs for Spreadsheets.

To post a message in this thread, you need to login with your Sierra Chart account:

Login


Login Page - Create Account