Support Board
Date/Time: Tue, 26 Nov 2024 08:33:12 +0000
Spreadsheet for TPO Chart Values
View Count: 2232
| [2014-04-11 02:50:11] |
| Profile123 - Posts: 43 |
|
Hi, How do I get TPO Chart Values into a spreadsheet? |
| [2014-04-11 04:22:51] |
| |
|
It depends what you are specifically looking for. The documentation in this section here completely explains the subject: https://www.sierrachart.com/index.php?l=doc/doc_TPOVolProfileCharts.html#TextInformation 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 |
| [2014-04-11 15:28:00] |
| Profile123 - Posts: 43 |
|
Thank you for your response. I read the documentation. I'm not clear if I can have all the values in the Chart Value Window. I am looking for all the values but specifically the: TPO Midpoint Total TPO Count TPO POC Mean Mode Medium I really would appreciate if I could get these values. How can I do that? And, if not how can someone help me to be able to extract these values into a spreadsheet. Thank you for your help. |
| [2014-04-14 01:47:57] |
| |
|
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 |
| [2014-04-14 15:06:41] |
| Al SC Developer - Posts: 434 |
|
In ver 1121, we have added the TPO Mean, Median, and Mode to the spreadsheet output.
|
| [2014-04-14 17:53:02] |
| Profile123 - Posts: 43 |
|
Yes I'm looking for data for the most recent profile. The values above are the values that I'm looking for. However, I'm not getting them on my spreadsheet. Can you guide me on how to get them on my spreadsheet please? I don't know why they are not coming up. Thank you. I appreciate it. |
| [2014-04-15 23:52:59] |
| Profile123 - Posts: 43 |
|
Hi, can someone help me with the above comment please. Thank you. |
| [2014-04-16 00:39:11] |
| |
|
We have updated the documentation in this section here to explain how to use the Spreadsheet study to see this data: http://www.sierrachart.com/index.php?l=doc/doc_TPOVolProfileCharts.html#TextInformation However, you still need to wait until version 1121 for this. It is not out yet. 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 |
| [2014-04-16 06:51:07] |
| Profile123 - Posts: 43 |
|
Ok. Thank you. Why would I need to wait for a newer version when this information was available in prior version? When will the new version be out? |
| [2014-04-16 09:17:39] |
| |
|
Not all of the data you are looking for was available in the prior versions. We have now released 1121. Update 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 |
| [2014-04-16 19:15:12] |
| Profile123 - Posts: 43 |
|
Ok. Thank you for the Prelease. I have downloaded it and I'm not getting the Chart Window Values in column I and J as indicated. Is there something that is missing or that I'm not doing? Thank you |
| [2014-04-16 19:36:41] |
| Profile123 - Posts: 43 |
|
Actually, I was able to get it to work as a Default Spreadsheet. I have one question. Can the Chart Values been outputted to Excel? Once I set it to output to Excel those values do not come up. Thank you |
| [2014-04-16 20:35:00] |
| Profile123 - Posts: 43 |
|
I also want to bring to your attention a programming error on the Default Spreadsheet that needs to be fixed. Here is the issue. The Default Spreadsheet rows of Column I and J are not properly aligned. I have uploaded a screen shot so it can be viewed. The File's name is listed below. Please let me know if there is any questions. Uploaded Files: Rows on Default Spreadsheet not aligned.png - Size: 329152 bytes - Delete - (Private) Make Public |
Private File |
| [2014-04-16 22:24:07] |
| |
|
Thank you for pointing this out. This will be corrected. Might have been a bug introduced in the latest 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 |
| [2014-04-17 04:15:58] |
| Profile123 - Posts: 43 |
|
Your welcome. I have a question. Can the chart values be outputted to Excel? What I have been able to output to Excel is limited information. Also, how do I save the default spreadsheet so it is not lost upon shutting down? Thank you |
| [2014-04-17 05:24:41] |
| |
|
No, these particular values cannot be outputted to Excel. You can save a spreadsheet by going to the Spreadsheet window and selecting File >> Save. 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: