Support Board
Date/Time: Sun, 24 Nov 2024 09:20:44 +0000
Keeping spreadsheets light
View Count: 2246
| [2013-08-23 15:40:08] |
| TheOddsAreYouDontKnowTheOdds - Posts: 29 |
|
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: 179 |
|
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 |
|
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 |
|
It's a needed feature, maybe they are adding it with the new spreadsheet?
|
| [2013-08-26 10:12:56] |
| |
|
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. 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-08-26 11:24:42] |
| namlem - Posts: 94 |
|
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] |
| |
|
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. 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-09-03 17:14:59
|
| [2013-08-28 05:54:39] |
| vegasfoster - Posts: 444 |
|
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] |
| |
|
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. 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-04 12:38:09] |
| Bedhog - Posts: 179 |
|
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 |
|
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] |
| |
|
This all sounds fine. You should also be aware of the new study referencing method for Spreadsheets that we are working on: New Non-CLR Spreadsheet Study Study Reference Method 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. 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: