Login Page - Create Account

Support Board


Date/Time: Wed, 08 Jul 2020 09:51:41 +0000



Keeping spreadsheets light

[2013-08-23 15:40:08]
TheOddsAreYouDontKnowTheOdds - Posts: 29 | Ending Date: 2013-11-01 [Expired]
To all you Super-Users out there:

Does anyone know if I can do this? (Y/N) is all I'm looking for.

I have several studies on a chart. I also have a Spreadsheet Study for Trading (my last study in the study stack) for that chart. I don't need every one of my OTHER studies (e.g. MACD) to output to the spreadsheet because many don't play into any trading logic... I use them ONLY on the chart and ONLY for visual analysis and monitoring.

Is there a setting to prevent OUTPUT of any unnecessary studies (values) to the spreadsheet (i.e. in columns AA and beyond)?

I'm trying to reduce pointless computational load on the spreadsheet.

Thanks in advance.
[2013-08-23 16:21:55]
Bedhog - Posts: 151 | Ending Date: 2020-09-27
If you only need the most recent numbers, try changing the default "Number of Rows" from 1000 to 10.
[2013-08-23 18:34:55]
TheOddsAreYouDontKnowTheOdds - Posts: 29 | Ending Date: 2013-11-01 [Expired]
Yes, thanks. Good idea. At one point I had taken it down to 150 but I can see how I might take it down a whole lot more.

[2013-08-24 21:41:09]
vegasfoster - Posts: 444 | Ending Date: 2014-11-03 [Expired]
It's a needed feature, maybe they are adding it with the new spreadsheet?
[2013-08-26 10:12:56]
Sierra Chart Engineering - Posts: 87393 | Ending Date: 2021-04-05
After reducing the number of rows outputted to the spreadsheet, be sure to delete the data in those unused rows on the spreadsheet. It will still remain until manually deleted.
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-08-26 11:24:42]
namlem - Posts: 94 | Ending Date: 2019-09-13 [Expired]
Agree that this functionality is necessary.
Together with "Hide" study option, would be nice to have "Do not calculate" or "Do not output to Spreadsheet" option, which differs from Remove study that it doesn't shift all other studies in the Spreadsheet.
[2013-08-28 01:14:25]
Sierra Chart Engineering - Posts: 87393 | Ending Date: 2021-04-05
With the new spreadsheets, we are going to think about how to solve the problem of studies being added and removed and affecting the cell references. This obviously has been an ongoing issue that causes significant problems.

Maybe cell references in formulas can refer to the unique study IDs rather than the standard spreadsheet column letters. We will work on this.

We will also add an option for a study to not output itself to the spreadsheet.
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-09-03 17:14:59
[2013-08-28 05:54:39]
vegasfoster - Posts: 444 | Ending Date: 2014-11-03 [Expired]
I'm not making a suggestion, but one thing I've contemplated is dynamically adjusting the rows based upon the number of bars in the chart using a row buffer. For example, you set to your spreadsheet to "Dynamic Update" and then specify a buffer, e.g. 100 rows. If you loaded a renko chart and it had 5625 rows, then the sheet would load 5725 rows and 100 rows would be added if the number of bars increased to 5726 rows or 100 rows would be deleted if the number of bars decreased to 5524. That way the number of rows is kept at a minimum for the loaded chart, but it's not constantly re-sizing on every bar.
[2013-09-03 17:16:29]
Sierra Chart Engineering - Posts: 87393 | Ending Date: 2021-04-05
We will see. We do plan to do some improvements with the management of the number of rows of chart data outputted to a Spreadsheet.
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-04 12:38:09]
Bedhog - Posts: 151 | Ending Date: 2020-09-27
This is my workaround for the cell references.

When adding new studies to a chart, move them down to the bottom of the "Studies to Graph" list. This has allowed my spreadsheets and defined cell references to remain intact because the new study outputs will appear in the unused cells far to the right in the spreadsheet. If you find that you don't want that study, but suddenly find out it will jazz your references, just hide the study so it no longer shows up on the chart. If you are using a low number of rows, the impact should be minimal on a capable computer.
[2013-09-26 11:46:12]
TheOddsAreYouDontKnowTheOdds - Posts: 29 | Ending Date: 2013-11-01 [Expired]
Thanks to everyone who replied.

This is what I have learned from others and by trial-and-error.

1. Use as few rows as possible. Don't worry if your signal relies on long/slow moving averages or far-back data. There's a solution for that (see #3 and * below). Remember to delete the data from rows you don't want.

2. Make the logic simple. Complexity introduces execution risk.

3. Let the chart do the work, not the spreadsheet.*

4. Reserve spreadsheet power for position-dependent logic and risk-management (e.g. once I have x contracts at an average price of y, shift my exit criteria/price by z).

There's other stuff but this will address many of the common causes of computational speed problems.
* If you are using spreadsheets with more than a handful "if-then" statements, consider using studies like "Color Bar on Alert" etc. That way you can generate signals based on multiple criteria from the main price graph AND adjacent studies. You write the alert to say that if X, Y and Z conditions occur in such and such studies and price graphs, then DO SOMETHING. In this case, color the relevant bar in say, Yellow. This paints the bar Yellow, but more importantly, also outputs a signal to the spreadsheet. You have the result but the logic is OFF the spreadsheet.

SC Engineering, please correct if anything sounds wrong.
Cheers.
[2013-10-13 22:16:39]
Sierra Chart Engineering - Posts: 87393 | Ending Date: 2021-04-05
This all sounds fine.

You should also be aware of the new study referencing method for Spreadsheets that we are working on:
https://www.sierrachart.com/SupportBoard.php?ThreadID=2789

At this point, it should be mostly complete in the latest prerelease.

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.

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

Login

Login Page - Create Account