Login Page - Create Account

Support Board


Date/Time: Mon, 17 Feb 2020 11:43:18 +0000



Spreadsheet Study - Use Excel

[2019-12-23 15:15:16]
User75949 - Posts: 48 | Ending Date: 2020-03-05
On the latest version on spreadsheet Study there is not any more the chance to export directly in Excell
There is not anymore the line: USE EXCEL yes / no
Is it possible to put it back? or is there any other possibility to easily export in excel that I didn't see?
Regards
[2019-12-23 17:50:01]
Sierra Chart Engineering - Posts: 81153 | Ending Date: 2020-06-09
Did you need an automatic process to export to Excel? We could add an automatic method to save the Sierra Chart Spreadsheet Sheet data to a text file. That could run periodically.
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.
Date Time Of Last Edit: 2019-12-23 17:50:11
[2019-12-23 18:01:25]
User75949 - Posts: 48 | Ending Date: 2020-03-05
on the previous version of Sierra charts on the Spreadsheet Study, "Settings and Inputs" there was a line named:
"Use Excell" and you could set yes / no
If you put yes as soon as the apply button was clicked, automatically an excell spreadsheet was open with already all the content of the default spreadsheet study.
Could it be possible to leave it at it was in the past?
Actually I only need to have directly all the spreadsheet study content on excell, yes an automatic process to export to Excel as it was before.
Most of our students where using this function and definitely miss it.
Tks
regards
[2019-12-26 22:56:46]
Sierra Chart Engineering - Posts: 81153 | Ending Date: 2020-06-09
This feature was removed as part of the process of organizing the code in Sierra Chart better and allowing it to be ported to other operating systems.

We have mentioned, that this feature is eventually going to get removed. We can add the capability to automatically write a spreadsheet to a text file periodically. Let us know if that would be helpful and we will implement that .
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.
Date Time Of Last Edit: 2019-12-26 22:57:40
[2019-12-27 09:04:39]
User75949 - Posts: 48 | Ending Date: 2020-03-05
well actually we don't need the excel spreadsheet to be connected realtime as it was before, it could be ok just a snapshot, like having an option or a button to export a snapshot of the spreadsheet study to excell.
This could be a solution
tks
regards
[2019-12-28 04:12:05]
Sierra Chart Engineering - Posts: 81153 | Ending Date: 2020-06-09
We can definitely add the capability to write a particular Sheet in a Sierra Chart spreadsheet to a text file periodically. We will do that.

And Excel does have the capability to automatically refresh after a specified number of minutes, from the data source which in this case would be a text file. Consult with the Microsoft Excel documentation about this.
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.
[2019-12-28 08:29:22]
User75949 - Posts: 48 | Ending Date: 2020-03-05
Ok thank you we will be waiting for a new realise with this possibility.
regards
[2019-12-28 17:15:31]
tobi - Posts: 326 | Ending Date: 2020-02-28
We can definitely add the capability to write a particular Sheet in a Sierra Chart spreadsheet to a text file periodically. We will do that.
Will that also work when there are more than one sheet in the Sierra Chart spreadsheet (as this is usually the case)?
[2019-12-29 00:07:30]
Sierra Chart Engineering - Posts: 81153 | Ending Date: 2020-06-09
Yes. The setting will be on the Spreadsheet study itself. So you can set this on each instance of the Spreadsheet Study to give you the capability to save more than one sheet.
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.
[2020-01-05 14:38:50]
User664240 - Posts: 32 | Ending Date: 2020-03-18
Is it possible to implement the excel RTD protocols allowing for the exportation of real time data to the spreadsheet.
[2020-01-05 15:10:47]
Sierra Chart Engineering - Posts: 81153 | Ending Date: 2020-06-09
No chance we will waste our valuable time with Microsoft trash interfaces.
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.
Date Time Of Last Edit: 2020-01-05 15:10:58
[2020-01-06 01:29:13]
User664240 - Posts: 32 | Ending Date: 2020-03-18
I'm at a lost to understand that comment with respect to the current SC capabilities. Your choosing an inferior spreadsheet with a better interface over a superior spreadsheet with a "trash" interface while simultaneously limiting the end user's ability to optimize their data feed Why? If your not motivated to write your own interface why not partner with rythmic they have coded their own excel interface??
[2020-01-06 17:11:12]
Sierra Chart Engineering - Posts: 81153 | Ending Date: 2020-06-09
We are no longer supporting Rithmic and that is all we can say. Also, you can develop your own interface between Sierra Chart and Excel by using ACSIL or the DTC protocol server:
https://www.sierrachart.com/index.php?page=doc/AdvancedCustomStudyInterfaceAndLanguage.php
https://www.sierrachart.com/index.php?page=doc/DTCServer.php

And it is up to Rithmic to create proper compatibility between Rithmic and Sierra Chart by using the DTC Protocol. The problems with the existing interface is because they provided a problematic API in the past and we are certainly not going to be burdened with the new solution they have. They need to solve this. Not us.
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.
Date Time Of Last Edit: 2020-01-06 17:13:50
[2020-01-06 18:34:07]
User664240 - Posts: 32 | Ending Date: 2020-03-18
Thx that clarifies several of my questions. Perhaps you could save me the time of exploring both of your solutions and choose the simpler one for exporting real time data to excel. It appears to be the DTC protocol?
[2020-01-07 17:16:33]
User664240 - Posts: 32 | Ending Date: 2020-03-18
Does the fact that TT has RTD functionality and I'll be using their SC supported data feed save me the effort of developing my own interface?
[2020-01-08 14:52:21]
tobi - Posts: 326 | Ending Date: 2020-02-28
Yes. The setting will be on the Spreadsheet study itself. So you can set this on each instance of the Spreadsheet Study to give you the capability to save more than one sheet.
Is that implemented already?
[2020-01-08 14:58:15]
Sierra Chart Engineering - Posts: 81153 | Ending Date: 2020-06-09
We will get back to you on all of this.
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.
[2020-01-16 10:14:56]
tobi - Posts: 326 | Ending Date: 2020-02-28
We will get back to you on all of this.
Any news on that?
[2020-01-16 17:01:55]
Sierra Chart Engineering - Posts: 81153 | Ending Date: 2020-06-09
We apologize for the delay.

Thx that clarifies several of my questions. Perhaps you could save me the time of exploring both of your solutions and choose the simpler one for exporting real time data to excel. It appears to be the DTC protocol?
Well if we were to do something like this ourselves, it would probably be easiest to use ACSIL and feed Excel the data by accessing the data through this function:
https://www.sierrachart.com/index.php?page=doc/ACSIL_Members_Functions.html#scGetTimeAndSales

Here is the full documentation for ACSIL:
https://www.sierrachart.com/index.php?page=doc/AdvancedCustomStudyInterfaceAndLanguage.php


Does the fact that TT has RTD functionality and I'll be using their SC supported data feed save me the effort of developing my own interface?
No, this does not save you the effort because that is completely separate functionality from what Sierra Chart uses from TT.

If you need your Sierra Chart account activated during this development just let us know.
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.
Date Time Of Last Edit: 2020-01-16 17:04:42
[2020-01-17 22:09:28]
User664240 - Posts: 32 | Ending Date: 2020-03-18
Yes please activate my account.
[2020-01-18 08:44:07]
Sierra Chart Engineering - Posts: 81153 | Ending Date: 2020-06-09
This is done.
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.
[2020-01-26 23:08:55]
User316362 - Posts: 133 | Ending Date: 2020-05-17
will there be an option to periodically save sheet as a txt file or a csv file? Or perhaps a "delimited" text file?
Date Time Of Last Edit: 2020-01-26 23:11:55
[2020-01-27 06:20:41]
Sierra_Chart_Engineering - Posts: 528 | Ending Date: 2020-11-26
Yes, this is coming.
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
[2020-02-08 08:57:16]
tobi - Posts: 326 | Ending Date: 2020-02-28
You have added "Periodically Save Sheet as Text in Minutes" to the SpreadsheetStudy
Is this working already? If yes, where is the txt-file stored at? If not, when is it coming?

Please also add, that the txt-file is saved right away when the chart is opend and data has updated. That way one doesn't have to wait for at least 1 minute.
Date Time Of Last Edit: 2020-02-08 08:59:54
[2020-02-10 10:39:56]
Sierra Chart Engineering - Posts: 81153 | Ending Date: 2020-06-09
No, this is not yet implemented. We apologize for this.
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