Login Page - Create Account

Support Board


Date/Time: Thu, 02 May 2024 01:12:34 +0000



Post From: Spreadsheet for TPO Chart Values

[2014-04-14 01:47:57]
Sierra Chart Engineering - Posts: 104368
We need to understand what it is you are looking for. Spreadsheets will currently output the TPO profile values for the most recent profile. Are you looking for data for the most recent profile?

Here is an example of the data outputted:

TPO Chart Values
Period Start:2014-04-11 00:00:00
Open:1320.2
Last:1318.4
IB Range High:1322.0
IB Range Low:1319.8
IB Range Width:11
TPO VA %:70%
Total TPO Count:396
TPO Midpoint:1319.2
TPO POC:1318.8
TPO VA High:1320.8
TPO VA Low:1315.8
TPOs Above/Below POC:200 / 176
Total Volume:73546
Volume POC:1318.6
Volume VA High:1320.8
Volume VA Low:1316.4
Volume Above/Below POC:37575 / 31387

This is additional information you are looking for:

Univariate Summary:
Maximum Value:1324.2
Upper 90%:1323.2
Upper Quartile 75%:1321.7
Mean:1319.2
Median:1319.2
Mode:1318.8
Lower 25%:1316.6
Lower 10%:1315.0
Minimum Value:1314.0
Range:10.2
Standard Deviation:2.2
Variance Coefficient:0.001682
Error of the Mean:0.111500

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