Login Page - Create Account

Support Board


Date/Time: Thu, 02 May 2024 09:30:11 +0000



cpu usage

View Count: 1260

[2015-12-10 23:45:52]
User53474 - Posts: 19
I noticed that when I am doing nothing with Sierra charts it shows up as using 12% to 14% of my cpu in the Task Manager display of Windows. I have a chart book open and it is displayed on my screen but I am disconnected from the data feed and not doing anything. Is this normal?
Date Time Of Last Edit: 2015-12-10 23:46:19
[2015-12-11 00:22:24]
Sierra Chart Engineering - Posts: 104368
No, that is not normal. There are a couple of reasons why this occurring. One of them could be the Countdown Timer study.

Refer to help topic 30:
http://www.sierrachart.com/index.php?page=doc/helpdetails30.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
[2015-12-12 22:14:04]
User53474 - Posts: 19
I don't use the countdown timer study. I did notice that if I minimize the Sierra Charts window the usage drops to zero, but if I restore it the usage goes right back up.
[2015-12-12 22:18:02]
Sierra Chart Engineering - Posts: 104368
Therefore, it is an indication a chart window or windows is being continuously redrawn.

Once again, refer to help topic 30:
http://www.sierrachart.com/index.php?page=doc/helpdetails30.html

Are there any messages displayed in the Sierra Chart Message Log continuously?
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
[2015-12-13 17:52:36]
User53474 - Posts: 19
I see a message that a chart has tagged another chart for recalculation appear periodically; these are 2 charts where a study is overlaid from one to the other. That message does not appear when I am doing nothing and am disconnected from the data feed and the cpu usage by Sierra Charts shows 8 to 10 %. I checked all the charts in this chartbook and none have more than 30 days of data loaded. There is one daily chart which I use the continuous futures symbol on. I have been reading through topic 30 but so far I don't see what would be causing this. Any other ideas?
[2015-12-14 02:36:45]
User53474 - Posts: 19
So I removed the study overlay and no longer get the "tagged for recalculation" message. But SierraChart.exe still is using 10% or more of my cpu when it is just displayed on the screen, not connected to a data feed and I am not doing anything with it besides looking at the display.
[2015-12-14 07:22:38]
Sierra Chart Engineering - Posts: 104368
Select File >> Close All Chartbooks. Does the CPU usage of Sierra Chart drop to 0%?

If so, provide us the Chartbook that causes CPU usage when Sierra Chart is not connected to the data feed. Here are instructions:
https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile

It can be privately attached.
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
[2015-12-14 13:41:47]
User53474 - Posts: 19
The cpu usage does drop to 0% when I close this chartbook. I have attached the chartbook and spreadsheet files.
Private File
Private File
[2015-12-14 22:25:28]
Sierra Chart Engineering - Posts: 104368
We notice about 0 to 1% when disconnected from the data feed when testing this Chartbook. We would expect it would always be at 0% and we do not know where the majority of that CPU usage is coming from.

It certainly is not any charts being calculated and that we can say with certainty. That is the main thing that we check for.

What do you have the Global Settings >> General Settings>> Chart Update Interval set to. Make sure it is not less than 200.
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: 2015-12-14 22:26:02
[2015-12-15 00:15:45]
User53474 - Posts: 19
I had it set at 100. I changed it to 200 and after the charts reloaded my cpu usage is between 7% and 10%. Before this change it was 10% to 14%. Still when I minimize the Sierra window it goes to 0% but jumps right back to 7% to 10% when I restore the window.
[2015-12-15 04:12:55]
Sierra Chart Engineering - Posts: 104368
We have discovered the problem. It is from Chart Drawings been copied from one chart to another chart. There was a recent change with this involving the comparison of additional flags and one flag should not have been compared.

This will be resolved in the next release coming out later this evening.
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
[2015-12-15 05:33:18]
Sierra Chart Engineering - Posts: 104368
This is now solved. Update Sierra Chart with Help >> Download 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
[2015-12-15 18:37:56]
User53474 - Posts: 19
Thanks for working on this problem. When I go to download menu, there is only a prelease new spreadsheets option. I use old spreadsheets in the chartbook with the problem. Will you have an oldsheet release with the fix?
[2015-12-15 18:43:26]
Sierra Chart Engineering - Posts: 104368
No. Support for Old Spreadsheets has been discontinued:
Differences Between New Spreadsheets and Old Spreadsheets

You need to move over to New Spreadsheets when you can.

What we recommend you do is to install another copy of Sierra Chart on your System and transfer your files over:
http://www.sierrachart.com/index.php?page=doc/helpdetails15.html

In your own time, you can work with New Spreadsheets until you get everything working properly.

However, if you are using Sierra Chart through TransAct you can only use one copy on your system. So you will need to use your own direct account:
https://www.sierrachart.com/index.php?page=doc/doc_DirectAccount.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: 2015-12-15 18:47:04
[2015-12-15 21:00:45]
User53474 - Posts: 19
So does that mean you won't be fixing this problem in the old spreadsheet version?

Is there a date when you won't support old spreadsheets at all?

Do you have a conversion program that converts old spreadsheets to new, or any other type of aids? It would be a monumental task to manually recreate and test every spreadsheet I have over to the new format. Is there at least some type of checklist that defines everything that needs to be changed? I have tried copying an old spreadsheet into a chartbook using the new spreadsheet software and it was barely recognizable with many formula cells lost or not working as they did before.
[2015-12-15 21:15:47]
Sierra Chart Engineering - Posts: 104368
Support for Old Spreadsheets is discontinued, so the answer is yes to this question:
So does that mean you won't be fixing this problem in the old spreadsheet version?


Is there a date when you won't support old spreadsheets at all?
No specific date. You can expect you will be able to use them for at least 3 years.

When you are using the version of Sierra Chart which supports New Spreadsheets and you open an Old Spreadsheet using the file extension scwbf it will be automatically converted.

with many formula cells lost or not working as they did before.
Give us an example of one of the formulas that was lost or did not work as expected.
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: 2015-12-15 21:16:39
[2015-12-15 21:16:56]
Sierra Chart Engineering - Posts: 104368
Some corrections were made to the prior post.
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
[2015-12-15 23:56:25]
User53474 - Posts: 19
OK. So I thought I give this a fresh start so I downloaded the new spreadsheet version of Sierra Charts. When I opened the chartbook which I sent to you, the charts all looked ok but the new .scss spreadsheet was missing all my formulas in several of the sheets. The studies are in the sheets, but for chart #'s 5, 7, 9 and 12 all of my formulas are gone. I am attaching a copy of this new converted version of the spreadsheet I sent to you earlier this week.
Private File
[2015-12-16 02:30:57]
Sierra Chart Engineering - Posts: 104368
We will not be spending any further development time or time analyzing the program that converts an Old Spreadsheet to a New Spreadsheet. Unless it is a simple problem where only a certain number of Sheets are copied. So we will make sure that all of the Sheets are copied.

What we can possibly help with is if there is a particular formula you are using which is not supported in New Spreadsheets, we will see how we can help with that. So if some formulas did not copy over to the New Spreadsheet, you will need to manually enter them.

If you have a complex Spreadsheet set up this is not necessarily an easy process for you and we are not claiming that it is. So it is not something which should be rushed. You need to take your time and work on the conversion.
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: 2015-12-16 02:32:49
[2015-12-16 04:41:46]
User53474 - Posts: 19
The problem with the converted spreadsheet I sent you isn't that just some of the formulas didn't copy over, it's that on several of the sheets NONE of the formulas copied over. Seems like a problem that should be addressed imo.

Regarding problems with specific formulas, here is one I tried reentering from old to new and it gives me a syntax error on the new spreadsheet:

=IF($BV$4<>0,INDEX($BV$5:$BV$100,SUMPRODUCT(MATCH(1,--($BV$5:$BV$100<>$BV$4),0))),$CM$30)
[2015-12-16 05:03:05]
Sierra Chart Engineering - Posts: 104368
We will not be spending further time on the conversion program, other than verifying that all Sheets in the Spreadsheet are converted/copied to the New Spreadsheet.

We will add support for SUMPRODUCT assuming there are no complications with that.

However, what is the underlined part in this formula:

=IF($BV$4<>0,INDEX($BV$5:$BV$100,SUMPRODUCT(MATCH(1,--($BV$5:$BV$100<>$BV$4),0))),$CM$30)
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: 2015-12-16 05:05:56
[2015-12-16 06:10:30]
bekitz3 - Posts: 83
It is my understanding that the INDEX/MATCH combo in the New Spreadsheets is highly inefficient relative to the Old Spreadsheets. Are there any plans to address this?

SPREADSHEET - Tracking a Cell | Post: 71585
The INDEX/MATCH combination is very inefficient in the New Spreadsheets, when used in a row 3 cell. However, if you use it in a non-repeating cell, the inefficiency is negligible.


SPREADSHEET - Tracking a Cell | Post: 76214
The INDEX/MATCH combination is very inefficient in the New Spreadsheets
SC Support is aware of this.

[2015-12-16 07:05:40]
Sierra Chart Engineering - Posts: 104368
We will improve the performance when using INDEX and MATCH.
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
[2015-12-16 09:49:58]
Sierra Chart Engineering - Posts: 104368
As a temporary solution to the original problem involving Chart Drawings, go to each of the charts in the Chartbook and select Tools >> Manage Chart Drawings Window. Remove any unnecessary drawings.

And only copy Chart Drawings from other charts, when necessary.
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
[2016-01-07 02:07:12]
Sierra Chart Engineering - Posts: 104368
We want to update you on New Spreadsheet performance improvements. Here is the latest information:
Basic Examples of How You Use INDEX, MATCH / Spreadsheet Performance Improvements Now Available | Post: 77938
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