Login Page - Create Account

Support Board


Date/Time: Sun, 05 May 2024 17:01:01 +0000



Spreadsheet study - outputting Volume by price data issue

View Count: 1255

[2015-09-14 18:49:15]
Pawel_Szpak - Posts: 48
SierraChart 1296 - new spreadsheets.

As per the attached chart - I have a 15m chart with a volume by price study, set to draw a profile daily, and mark the point of control as well as value area with value area high and low drawn.
I've added a spreadsheet study to this chart. Settings in attached pic.
The resulting spreadsheet study is not exporting the Value area High/low price points - only the Point of control price. See spreadsheet pic.

However, there is some more data starting at a much later column, although it has no label and is running horizontally instead of vertically. See spreadsheetpic2.
What is this further data?
How can I have a volume by price study export the value area high/low prices into the spreadsheet study?


Thanks
imageChartPic.PNG / V - Attached On 2015-09-14 18:48:42 UTC - Size: 74.29 KB - 315 views
imageSpreasheetstudysettings.PNG / V - Attached On 2015-09-14 18:48:49 UTC - Size: 34.95 KB - 322 views
imageSpreadsheetPic.PNG / V - Attached On 2015-09-14 18:48:55 UTC - Size: 110.2 KB - 339 views
imageSpreadsheetPic2.PNG / V - Attached On 2015-09-14 18:49:00 UTC - Size: 11.36 KB - 314 views
[2015-09-16 04:32:29]
Sierra Chart Engineering - Posts: 104368
To get the Value Area High and Low on a Spreadsheet you need to use the Volume Value Area Lines study.

Although we will see if we can solve this with the Volume by Price study in the next release.

Refer to this input description here to understand the Volume at Price data which is being outputted to the Spreadsheet:
https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html#OutputVolumeAtPriceData
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