Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 18 May 2024 21:05:35 +0000
Migrating to New Spreadsheet
View Count: 1025
| [2016-07-17 16:56:38] |
| Crazy_Bull - Posts: 17 |
|
I have developed a trading system based on the Old Spreadsheets. It has hundreds of Defined Names and several hundred formulas. Unfortunately, for real-time quotes I need to upgrade to 1392 or later. It appears that support for the Old Spreadsheets was dropped sometime prior to 1392. If that is true, then I need to migrate to the New Spreadsheets. Unfortunately, when I installed the current version of Sierra Charts, 1445, the installation attempted to convert my old spreadsheet, but failed. I didn't capture the failure message. However, I have attached my Old Spreadsheets spreadsheet if that helps. I don't see an "Import Old Spreadsheet" command in the 1445. That surprises me since that would appear to be a convenient way to try the conversion again and at least capture the error message. Short of that, I do see any way to force the conversion again except a re-install of Sierra Chart on top of the old version that still supported the Old Spreadsheets. Your suggestions regarding how to best resolve this issue would be most welcomed! John Clark |
Private File |
| [2016-07-18 16:40:28] |
| |
|
We will convert this for you. We started to do this, and then ran into an exception. Therefore, we will need to resolve that, if possible. Could have something to do with the large file size. I don't see an "Import Old Spreadsheet" command in the 1445. To do the conversion again, you just need to select File >> Open Spreadsheet. Set the File Type to Sierra Chart Old Spreadsheets. Select the file. Press Open. 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: 2016-07-18 16:41:41
|
| [2016-07-18 18:59:21] |
| |
|
We are not going to be able to convert this. This is from one of our developers regarding this: This spreadsheet, for whatever reason, takes a lot of memory. I was able to convert the file by setting the /LARGEADDRESSAWARE linker option on the SpreadsheetFileConverter, but Sierra Chart runs out of memory before it can fully load the file.
You will need to redesign what you are doing to use less memory. 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: 2016-07-18 18:59:42
|
| [2016-07-18 19:25:10] |
| Crazy_Bull - Posts: 17 |
|
Ouch! That's terrible news! I've spent six man-years developing this system. It's really too bad you've chosen to deprecate the Old Spreadsheets! There are over 1500 formulas and over 800 Defined Names in my spreadsheet. It will take several man-months to port to the New Spreadsheet system if I have to start over! Are there no engineering tools that can help me with the port such as the ability to export Define Names from the Old Spreadsheets and import those into the New Spreadsheets? That way I wouldn't have to start from scratch and could copy/paste the formulas from Old Spreadsheets to New. |
| [2016-07-18 19:28:44] |
| Crazy_Bull - Posts: 17 |
|
What's the max size the spreadsheet converter can accommodate?
|
| [2016-07-18 20:59:16] |
| Crazy_Bull - Posts: 17 |
|
WHOA! In investigating how I could possibly port to the New Spreasheets, I just learned that User Defined Names are NOT SUPPORTED! IMHO, that is a MAJOR, MAJOR shortcoming. Reading formulas that contain only cell addresses is a NIGHTMARE for all but simplistic formulas. As mentioned before I have over 1500 complex formulas and over 800 User Defined Names. So by virtue of User Defined Names not being supported in the New Spreadsheets, that rules them out entirely. The next best option would be to use v1392 or later that supports the Old Spreadsheets. I'll give that a try. My concern with that approach is that if there is another mandatory update for real-time quotes, that will be against your current software tree with supports ONLY the New Speadsheets, and I will be out of luck completely. Having support for Excel-feature spreadsheets is the MAIN reason I went with Sierra Chart in the first place, and it has been great until now. If I end up having to do a port, I will need to review my options and select the path the minimizes the man-hours required to do the port. |
| [2016-07-18 21:51:00] |
| Crazy_Bull - Posts: 17 |
|
GEEZ!!! It's worse than I thought. 1307 is the last version to support the Old Spreadsheets! But I'm required to update to at least 1392 for real-time quotes. Why? Is this a government mandated requirement? 1392 won't work for me because the Old Spreadsheets aren't supported. It appears it's time to move on! :-( |
| [2016-07-18 22:10:01] |
| |
|
There are a lot of messages here. Let us get back to about if we can add User Defined Name support without much difficulty. What's the max size the spreadsheet converter can accommodate?
This is not the problem. The spreadsheet was converted but the problem is Sierra Chart is running out of the available 4 gigabytes of memory for it. So even if User Defined Name support is added, there is still this problem as well. Why do you say this: But I'm required to update to at least 1392 for real-time quotes.
Are you referring to the Sierra Chart Exchange Data Feed? We would have to check but this may still work with 1307. At least this gives you some time for now. There is also the ability to share data between instances of Sierra Chart. So you could share data from a newer version in an older version. 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: 2016-07-18 22:11:02
|
| [2016-07-18 22:33:45] |
| Crazy_Bull - Posts: 17 |
|
The reason I thought I was required to update to 1392 is that get the following message each time I launch Sierra Chart: If your trading account is authorized for ICE exchange real-time data, it is necessary to update to version 1392 or higher to be able to receive historical price data. Now that I re-read the message, I see that's it's not for real-time data, but for historic data. My bad! Can you explain why this limitation occurred? So it appears that I can stay on my current version of Sierra Chart, at least for the time being. I certainly can't upgrade to the New Spreadsheets since User Defined Names were deprecated. |
| [2016-07-18 22:41:06] |
| |
|
Are you using ICE symbols? This has to do with exchange fees being imposed by ICE for all users now. So you can put the blame on them for these kinds of problems. 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 |
| [2016-09-14 21:12:00] |
| namlem - Posts: 94 |
|
Hi SC team, do you have plans to add support of custom names defined by the user or it's a final decision with no perspectives? |
| [2016-09-14 22:56:21] |
| User553714 - Posts: 184 |
|
Yes, it would be good to see support for named ranges for spreadsheets, thanks.
|
| [2016-09-15 05:42:38] |
| |
|
We need to check on 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: