Login Page - Create Account

Support Board


Date/Time: Sat, 15 Mar 2025 23:50:00 +0000



Study - Spreadsheet Formula

View Count: 577

[2022-07-09 03:45:18]
nicktrader - Posts: 744
To see the POC volume of each bar, I use the Study "Spreadsheet Formula" and refer to the Study "VPOC for Bars" with this formula "=VAP(ID3.SG1,0)". I have greatly reduced the number of bars to calculate <100.
I noticed now that this study causes the chartbook to load twice after opening.

Is there another way to see the POC volume without loading a second time?

Many thanks
[2022-07-09 08:47:10]
Sierra Chart Engineering - Posts: 104368
We do not see a saved chart which is part of a Chartbook reload twice upon opening when using this study:
Volume Point of Control for Bars

There must be some other reason for this. Refer to:
High CPU Usage | Inactive User Interface | Poor Performance | Long Time to Load Chart Data | Charts Reloading Often: 30.3 - Charts Reloading Often
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
[2022-07-09 09:57:53]
nicktrader - Posts: 744
Thank you for the quick reply. But the source of the problem is the study "Spreadsheet Formula". Please see pic.

I have opened a new chartbook with only one M3 chart and there are only two studies in use.

I use "Spreadsheet Study" to be able to see the values in the Chart Value window.
imageStudy Spreadsheet.png / V - Attached On 2022-07-09 09:56:13 UTC - Size: 15.5 KB - 148 views
[2022-07-09 21:25:12]
Sierra Chart Engineering - Posts: 104368
We see the problem. This will be resolved in the next release.
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