Support Board
Date/Time: Thu, 28 Nov 2024 00:30:57 +0000
Spreadsheet data export not showing properly
View Count: 322
| [2023-06-06 17:13:40] |
| User358827 - Posts: 21 |
|
Hi, I exported my spreadsheet data as a .txt file and opened it in Excel choosing delimited, tab, general settings however my data in columns m through P where I have formulas are not showing data. Two columns are showing the formulas and the other two columns have "#Value". Is there anything I can do to get this data to show in an excel spreadsheet? The formulas in Sierra are working accurately. Thanks for your help. |
| [2023-06-06 17:16:20] |
| John - SC Support - Posts: 36350 |
|
You would have to look at the text file to first ensure that what you are seeing in Excel matches the text file. If the text file does not have the correct information, then how did you export the information?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-06-06 17:45:42] |
| User358827 - Posts: 21 |
|
Hi John, I checked the text file and it is showing that formulas are being exported from the spreadsheet. In the sierra spreasheet the formulas show as numbers but when exported to a txt file they show as formulas that have no functionality in excel. Is there any way to export the formulas in the sierra spreadsheet as number only? |
| [2023-06-06 18:55:04] |
| John - SC Support - Posts: 36350 |
|
How are you doing the export?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-06-06 23:25:15] |
| User358827 - Posts: 21 |
|
Hi John, I was using the instructions in the support guide. I go to file save as, choose my directory to save, and save as a .txt file. The columns with formulas are exporting as formulas and not numbers. The one solution I thought of is to copy the column of numbers in the Sierra spreadsheet to a new column as values. I would prefer not to do this since it creates more work to analyze data. Also, this is only happening on formula data not data referencing study ids. Any ideas would be appreciated. |
| [2023-06-07 14:06:31] |
| John - SC Support - Posts: 36350 |
|
We will be updating the save of the Spreadsheet so it will allow you to save out the values. It may take a few days for us to get this done and then released (maybe a week). The only option at the moment is to copy and paste the cells from the Sierra Chart spreadsheet to Excel. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-06-07 15:55:37] |
| User358827 - Posts: 21 |
|
Hi John, Thanks a lot for getting back to me - that's great news. Once this feature is updated will I need to get onto the latest version of Sierra? Also, I'll put a note in my calendar to check in at the end of next week to check status. Thanks, Scott |
| [2023-06-07 16:21:45] |
| John - SC Support - Posts: 36350 |
|
Yes, when it is available, you will have to update to the current Pre-Release (as that is where it will be available first). Follow these instructions to update: Software Download: Fast Update For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-06-14 19:16:49] |
| User358827 - Posts: 21 |
|
Hi John, I just wanted to check in to see if this feature was updated. Thanks, Scott |
| [2023-06-14 19:40:14] |
| John - SC Support - Posts: 36350 |
|
It looks like this has not been done yet. We will check with the developers to find out the status.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-06-15 13:01:44] |
| Sierra_Chart Engineering - Posts: 17199 |
|
We cannot make a promise as to the timing of this. It still may be quite some time before we can get to it.
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 |
To post a message in this thread, you need to log in with your Sierra Chart account: