Support Board
Date/Time: Sat, 15 Mar 2025 02:42:08 +0000
[User Discussion] - Spreadsheet Study use Excel
View Count: 911
| [2022-02-10 20:01:51] |
| User21223 - Posts: 92 |
|
In current versions it is not possible to use Excel in Spreadsheet Study. Formerly there was such an option Study Settings Use Excel. I want to use Excel how to solve it . |
| [2022-02-10 23:09:46] |
| Sawtooth - Posts: 4183 |
|
It is no longer supported. But there is an option in the study settings to 'Periodically Save Sheet As Text In Seconds', where it is saved as a .CSV file. https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#PeriodicallySaveSheetAsTextInMinutes |
| [2022-02-11 08:25:57] |
| User21223 - Posts: 92 |
|
Thank you for your interest. I need an Excel connection in real time. As it was in the earlier versions of the Sierrachart. Is it possible to move the Studies Spreadsheet Study from the old version to the newest? |
| [2022-02-11 14:40:13] |
| Sawtooth - Posts: 4183 |
|
Is it possible to move the Studies Spreadsheet Study from the old version to the newest?
No, this is not possible.I need an Excel connection in real time.
This no longer exists. The only option is to use the intermittent CSV export.
|
| [2022-07-10 20:54:43] |
| Chad - Posts: 234 |
|
It's confusing that the Study's param name indicates 'Seconds', yet the documentation states its save frequency in terms of minutes instead. @SCE, would it be possible in the near-term for the study to be modified so that the save frequency could indeed be specified in seconds? I.e. I assume we can't use a floating-point int like '0.01667' to make equivalent of a 1-second save freq. Also, could the save operation be modified so that instead of overwriting the previous/existing one, a new file is created, ideally with the HH.MM.SS timestamp in its filename? Date Time Of Last Edit: 2022-07-10 21:00:25
|
To post a message in this thread, you need to log in with your Sierra Chart account: