Home >> Support Board

Support Board

Date/Time: Thu, 25 Apr 2024 00:24:58 +0000

How to Post a Message for Support

Spreadsheet Study - Use Excel

View Count: 4201

[2020-02-10 10:39:56] #25 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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] #26 [Go To First Post]
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] #27 [Go To First Post]
User75949 - Posts: 108
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] #28 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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] #29 [Go To First Post]
User75949 - Posts: 108
ok tks, I just saw it just make "copy values" and paste to the Excel spreadsheet, fine!

[2020-03-30 05:37:30] #30 [Go To First Post]
Sierra_Chart Engineering - Posts: 14076
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] #31 [Go To First Post]
Chris32 - Posts: 50
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] #32 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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] #33 [Go To First Post]
AlinGA - Posts: 14
Hi, "Periodically Save Sheet as Text in Minutes" Is this working now ? Thanks

[2020-12-28 05:02:27] #34 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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] #35 [Go To First Post]
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] #36 [Go To First Post]
Chris32 - Posts: 50
They are tsv files, not txt

[2021-01-18 01:45:31] #37 [Go To First Post]
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] #38 [Go To First Post]
bradh - Posts: 854
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] #39 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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] #40 [Go To First Post]
User136839 - Posts: 20
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] #41 [Go To First Post]
onnb - Posts: 660
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 - 334 views

To post a message in this thread, you need to log in with your Sierra Chart account: