Login Page - Create Account

Support Board


Date/Time: Fri, 26 Apr 2024 11:04:18 +0000



Export TPO/MP data

View Count: 1716

[2014-05-27 20:02:01]
vectorTrader - Posts: 86
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: 104368
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. 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-05-28 01:16:48]
vectorTrader - Posts: 86
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: 104368
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. 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