Login Page - Create Account

Support Board


Date/Time: Sat, 02 Jul 2022 08:20:09 +0000



Spreadsheet

View Count: 2572

[2013-05-11 19:49:16]
User39772 - Posts: 300
I inserted a study: Spreadshetd System/Alert.

I configured the K3 and M3 columns with formulas like =E3>AA3.
The columns show FALSE/TRUE.

Problem 1:
I do not see any arrows in the chart.

Problem 2:
I I insert a formula like =crossfrombelow(E3:E4,AA3:AA4) i see #NAME in the cell instead of a result.

Problem 3:
How can I have access to the spreadsheet without using Excel.
The Spreadsheet only opens if I press apply button but I want to be able to always have access to the Spreadsheet.

Problem 4:
I have several moving averages in the chart, how do i know which column in the spreadsheet refers to which moving average.
The column only says "simple moving average".

Looking forward to your reply.

Hint: I use Excel in another than English version but I assume this has nothing to do with the problems above.








[2013-05-11 22:08:59]
tomgilb - Posts: 3327
1) To see the arrows, you might need to Reload and Recalculate. Focus the chart and press the Insert key.

2) You might need to use a semicolon instead of a comma in your case.
=crossfrombelow(E3:E4;AA3:AA4)

3) Once you press OK, the study is added and you will always have access to it.

4) Study outputs appear on the spreadsheet in columns AA and above in the same order they appear in the Studies to Graph list. If that is not enough to identify them, put a name in the Short Name field of the MAs and it will precede the study name in row 1. You could also color the font in row 1 and 2 to match the MA color


Date Time Of Last Edit: 2013-05-11 22:55:32
[2013-05-12 16:30:19]
User39772 - Posts: 300
1) Unfortunately this did not help. I do nor see any arrows.
2) if I use a semikolon I get an error message and the formula is not accepted.
Question "crossfrombelow" is not an Excel function, maybe this is the reason why the name will not be accetpted. I f I use standard excel function
there is no problem.
3) Yes vie Excel but how can I have access without Excel and how can I make the spreadsheet visible.
4) Ok done, this worked.
[2013-05-12 18:09:29]
tomgilb - Posts: 3327
If 'Use Excel' is set to Yes, set it to No. You may have to close Excel before you will have control of SC to set it to No.
The Yes option is available, but not recommended as it can be unreliable:
http://www.sierrachart.com/index.php?l=doc/doc_WorksheetStudyInputs.html#UseExcel

If setting 'Use Excel' to No and pressing OK and OK doesn't produce the SC spreadsheet, try this:
1) Go to Window >> Tile Horizontally
or
2) Remove the spreadsheet study, press OK and choose No to not save it. Then add it to the chart again, give it a name in the Spreadsheet Name field, and leave 'Use Excel' set to No.

CROSSFROMBELOW is only a SC spreadsheet function, and only works on SC spreadsheets.

Here's some tips:
http://www.sawtoothtrade.com/tip-2.html
Date Time Of Last Edit: 2015-08-14 01:35:27
[2013-05-13 18:43:56]
User39772 - Posts: 300
Hello, I updated to 971 and the arrows became visible. Without any changes they suddenly disappeared today.
[2013-05-17 08:57:57]
Sierra Chart Engineering - Posts: 103551
Are you running the non-CLR version of Sierra Chart? Please update by selecting Help >> Download Prerelease to make sure you have the CLR version.

Also, we do not provide any support for Excel. We cannot help with that.

You need to use the built-in Sierra Chart spreadsheets.

Let us know what questions you still have.
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-05-17 11:50:33]
User39772 - Posts: 300
Hello I do not use Excel, I use the SC Spreadsheet, so my experiences mentioned above are in relation to SC SS.
I do used "Download Current" to update to 971. Now I have 976 as u mentioned above. but still no trading arrows.
What is the difference between CLR and non-CLR.
[2013-05-18 00:02:05]
Sierra Chart Engineering - Posts: 103551
You are only going to see arrows at the bars where a formula returns TRUE. Are you using the Spreadsheet System/Alert study?

In what columns are the formulas?
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-05-19 18:49:23]
User39772 - Posts: 300
I found the mistake. I added further indicators into the chart and that caused some columns to change, that have been addressed in the
formulas.

If I want to move my "Spreadsheet System" to another instance of SC, i.e. different root folder, and to load it into charts over there, how can I manage this so that I have system and spreadsheet available in the other instance and maybe on several charts simultaneously for automatic trading.
[2013-05-28 06:08:07]
Sierra Chart Engineering - Posts: 103551
Please refer to this section here:
http://www.sierrachart.com/index.php?l=doc/doc_Sharing_Spreadsheet_Study.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-05-28 06:23:22
[2013-05-28 06:23:13]
Sierra Chart Engineering - Posts: 103551
Prior post has been updated. We provided you an incorrect link. This is the proper link:
http://www.sierrachart.com/index.php?l=doc/doc_Sharing_Spreadsheet_Study.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

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

Login

Login Page - Create Account