Support Board
Date/Time: Thu, 20 Feb 2025 20:48:41 +0000
Spreadsheet Study - Use Excel
View Count: 4468
| [2020-02-10 10:39:56] |
| |
|
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. 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 |
| [2020-02-21 07:08:50] |
| tobi - Posts: 351 |
|
No, this is not yet implemented. We apologize for this.
Any news or outlook on this?
|
| [2020-03-11 19:27:46] |
| User75949 - Posts: 125 |
|
it is not even possible to select some cell on the spreadsheet study and copy manually them on excell... or there is a way to do it (manually I mean) that I don't know? tks regards |
| [2020-03-12 09:20:28] |
| |
|
Yes. You need to use the Spreadsheet Copy functionality. Refer to: Spreadsheet Menu: Spreadsheet >> Copy Value 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 |
| [2020-03-12 10:31:19] |
| User75949 - Posts: 125 |
|
ok tks, I just saw it just make "copy values" and paste to the Excel spreadsheet, fine!
|
| [2020-03-30 05:37:30] |
| Sierra_Chart Engineering - Posts: 18502 |
|
The spreadsheet study input Periodically Save Sheet as Text in Minutes has now been implemented in the latest release.
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, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-08-19 14:39:07] |
| Chris32 - Posts: 60 |
|
I have been trying to use this functionality but I do not understand how to save multiple sheets from the same spreadsheet. It seems that the same file Data\spreadsheetname.tsv is overwritten every time a sheet is being saved. Is there any way to save sheets to separate files? |
| [2020-08-19 20:04:19] |
| |
|
There is not support for saving multiple Sheets as text. You would need to use a separate named Spreadsheet file for each sheet you want to save.
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 |
| [2020-12-28 04:15:32] |
| AlinGA - Posts: 14 |
|
Hi, "Periodically Save Sheet as Text in Minutes" Is this working now ? Thanks |
| [2020-12-28 05:02:27] |
| |
|
Yes this has been implemented for some time now.
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 |
| [2020-12-28 05:04:54] |
| AlinGA - Posts: 14 |
|
Hi, where we can find the txt documents? They are not in the DATA folder ? Thanks
|
| [2020-12-28 11:48:17] |
| Chris32 - Posts: 60 |
|
They are tsv files, not txt
|
| [2021-01-18 01:45:31] |
| User123235 - Posts: 46 |
|
Hi SC, I set the "periodically save sheet as text" to 1 minute and it opens in excel. However, it does not save every minute. I get this error: Error saving spreadsheet. Failed to create the file. Error: Windows error code 32: The process cannot access the file because it is being used by another process. | 2021-01-17 17:34:27.966 * Requested new login tokens. | 2021-01-17 17:35:15.777 Received 8 login tokens. | 2021-01-17 17:35:16.487 Error saving spreadsheet. Failed to create the file. Error: Windows error code 32: The process cannot access the file because it is being used by another process. | 2021-01-17 17:35:28.648 * Error saving spreadsheet. Failed to create the file. Error: Windows error code 32: The process cannot access the file because it is being used by another process. | 2021-01-17 17:36:29.339 * Error saving spreadsheet. Failed to create the file. Error: Windows error code 32: The process cannot access the file because it is being used by another process. | 2021-01-17 17:37:30.049 * |
| [2021-01-18 02:09:17] |
| ForgivingComputers.com - Posts: 1012 |
|
When you open the file in Excel, it is being locked by Excel. The fix is to either close Excel or do File Save As and use the XLSX file type. Another option is to open it with Notepad++, as it will not create a write lock on the file. |
| [2021-01-18 03:31:51] |
| |
|
In regards to post #37, the file is being locked by Excel preventing Sierra Chart from writing it and we do not have a solution for that
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 Date Time Of Last Edit: 2021-01-18 03:32:25
|
| [2021-01-18 14:12:00] |
| User136839 - Posts: 21 |
|
Here is how I have done it without problems: Open a blank file in Excel. Go to the "Data" tab and there click "Get Data" in the Ribbon. Select "From File > From CSV/Text". Now a file manager will open. Navigate to the location of the tsv file. You will not be able to see it, so in the bottom right corner, instead of "Text Files" select "All Files". Now select the tsv file and it will import. From there it gets more complex. You'll have to adjust for the column headings and formatting but I have no problems with the file being locked. It updates regularly. Date Time Of Last Edit: 2021-01-18 14:26:07
|
| [2021-01-18 21:05:06] |
| onnb - Posts: 662 |
|
fyi, I have a sc-excel integration in progress. It currently supports basic level 1 realtime data via RTD. More specifically you can send Ask, Bid Last and SG live data to excel. See image with notes. It's a work in progress but if anyone is interested in beta-testing it please send an email to support@trade29.com |
 sc-excel-rtd.png / V - Attached On 2021-01-18 21:00:59 UTC - Size: 364.36 KB - 367 views |
To post a message in this thread, you need to log in with your Sierra Chart account: