Login Page - Create Account

Support Board


Date/Time: Sat, 07 Dec 2019 21:35:52 +0000



Export TPO/MP data

[2014-05-27 20:02:01]
jbutta - Posts: 84
I would like to export various TPO/MP to text files for further processing. Specifically, I would like to export the following data and would like to know if there is a way to export this to a text file at the end of the day...thanks



TPO and VOL Profile Information:  
Period Start Date  
First Price of Period
Last Price Date and Tine
Last Price of Period  
Price Increment in Ticks  
Total Number of TPO's  
Price of TPO Midpoint  
TPO Point of Control  
TPO VA Upper Bound  
TPO VA Lower Bound  
TPO's above POC  
PO's below POC  
Total Volume  
Price of Vol Midpoint  
Vol Point of Control  
Vol VA Upper Bound  
Vol VA Lower Bound  
Vol above POC  
Vol below POC  
IBR Upper Bound  
IBR Lower Bound  
TPO Mean  
TPO Mode  
TPO Median  
[2014-05-27 20:48:41]
Sierra Chart Engineering - Posts: 78989
Some or all of this is outputted in a text format to a Spreadsheet when using the Spreadsheet study:
http://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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2014-05-28 01:16:48]
jbutta - Posts: 84
Yes I understand that those values are available but only for the current day in the spread sheet. Is there a way to get them historically for past days? If not Is there a way to specify that the spreadsheet files saves in the data folder as a csv? This would allow someone to read the file at end of day and record them externally?

[2014-05-28 04:01:03]
Sierra Chart Engineering - Posts: 78989
No there is not a way to get them historically.

When you use File >> Save As you can change the file type on the Save File window and choose a text format.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.

To post a message in this thread, you need to login with your Sierra Chart account:

Login

Login Page - Create Account