Login Page - Create Account

Support Board


Date/Time: Mon, 28 Oct 2024 11:16:58 +0000



Exporting data from chart to .txt

View Count: 2314

[2015-07-17 12:02:57]
wat - Posts: 67
Hi,

I would like to ask about ways to export data from SC(SC data feed) into .txt.

Lets say I have a 5 minute timeframe chart where I have volume indicator and CCI.
Is there a way to export those data into txt file, which would be then shown as:

Instrument Open High Low Close Time Volume CCI


Thank you for help.
[2015-07-17 17:49:04]
Sierra Chart Engineering - Posts: 104368
To export both the price data and study data, you need to use the Spreadsheet Study and then save the data on the Sheet as a text file with File >> Save As.

Refer to this page:
https://www.sierrachart.com/index.php?page=doc/doc_StudiesSystemsAlerts.php
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
[2015-07-20 12:07:21]
wat - Posts: 67
It works well except for TPO: Volume profile study.

Is it possible to get TPO values into spreadsheet?

Also I have tried to add Volume By Price into spreadsheet but value of "Point of Control" is always zero on chart hence its also zero in spreadsheet making this value useless. Is it a bug or can I fix it?

Thank you.
Date Time Of Last Edit: 2015-07-20 12:19:01
imagesierra_poc.png / V - Attached On 2015-07-20 12:18:45 UTC - Size: 7.46 KB - 306 views
[2015-07-21 09:10:22]
Sierra Chart Engineering - Posts: 104368

Is it possible to get TPO values into spreadsheet?
Specifically what TPO values are you looking for? In general the answer is no.


Also I have tried to add Volume By Price into spreadsheet but value of "Point of Control" is always zero on chart hence its also zero in spreadsheet making this value useless. Is it a bug or can I fix it?


The only solution to this is to remove the TPO Profile Chart study. We did not realize that is the study you are using.
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
[2015-07-21 14:36:29]
wat - Posts: 67
The only solution to this is to remove the TPO Profile Chart study. We did not realize that is the study you are using.

Thank you, that fixed it a bit. Without TPO the Volume By Price provides only last value, all previous are 0 in spreadsheet. I suppose that I will need to make a study just to store and provide those data, is that correct?
[2015-07-21 18:22:50]
Sierra Chart Engineering - Posts: 104368
We do see this problem and we will solve this. It should be solved today.
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
[2015-07-21 19:58:40]
Sierra Chart Engineering - Posts: 104368
We have looked into this:
Volume By Price provides only last value, all previous are 0 in spreadsheet.

This is the result of using a Volume Graph Period Type of "Visible Bars" with the Volume by Price study. So do not use that type when using the Spreadsheet study if you want to see the Point of Control on the spreadsheet.
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