Support Board
Date/Time: Wed, 15 Jan 2025 23:48:33 +0000
VolumebyPrice Spreadsheet Columns output changed from V1482?
View Count: 3105
| [2017-09-25 14:07:11] |
| User931283 - Posts: 55 |
|
I waited a long time to update to newest 1615, from 1482, watching lots of development-- till dev finished major progress. V1615 has a great improvement in memory usage with my large 53-chart, 12 spreadsheet Chartbook. Problem: Spreadsheets shifted columns on VbP Vol by price, number of output columns,dropping from 16 on one, to 4-- but not all (some in my V1482 had and still have (in V1615) 4-column output) 1482 VbP on one chart was putting out 16 columns (not sure why) when others put out 4 columns. 1615 VbP on same chart VbP puts out 4 columns (default?) (no longer 16). I didn't change anything between update version. Note: I tested 1615 on an existing Source Chart VbP by adding a test Spreadsheet. That defaults to 3 columns where it is not This is on overlay of VbP from Chart with no spreadsheet into chart with spreadsheet (overlay Uses Colors,Styles from Source). I don't see option to change columns input to overlay or in source VbP study. This may affect 2 or 3 spreadsheets. Since these charts work together, several charts are now wrong. Other than that, V1615 looks great. Using V1615 I added a test Spreadsheet to the same Source VbP above that had (under 1482) output 16 cols to target spreadsheet but now puts out 4 cols. (SG2 to Vol Wgted Avg SG5) under 1615. In this test source chart-Sprdsheet V1615 puts 3 cols, to SG4 (Val Area Low). Date Time Of Last Edit: 2017-09-25 17:13:13
|
| [2017-09-25 17:41:43] |
| |
|
Normally there would be 3 columns of data outputted to the Spreadsheet by the Volume by Price study. When using the Study/Price Overlay study, we will look into that. There should also be 3 columns. 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 |
| [2017-09-25 19:09:06] |
| User931283 - Posts: 55 |
|
Here're pictures, each Version, spreadsheets, Study ID29 VbP (neither has 3 cols.) (The V1615 new-created temporary test spreadsheet in Source chart for target-ID29 did have 3 cols.) V1481 showing 16 columns vs 1615 shows 4 columns same ID29 study - - - I don't need any of the extra columns generated by V1481 Suggested General Fix: VbP Option for Number Cols. to Output to Spreadsheet or a general handy "Correct-Add Fill Columns" study to adjust-fix Spreadsht columns (can add at end and move up Study list to where needed) (<-- but not add a blank column before added filler columns) CORRECTION: The Spreadsheet with 16 col's VbP study overlay was first-created by Version 1453 or prior. Date Time Of Last Edit: 2017-09-26 00:17:11
|
 V1481Chart44-VbPoutputs16Cols.jpg / V - Attached On 2017-09-25 19:01:49 UTC - Size: 209.36 KB - 417 views V1615Chart44-VbPoutputs4Cols-StudyID29.jpg / V - Attached On 2017-09-25 19:02:10 UTC - Size: 217.72 KB - 371 views |
| [2017-09-26 19:33:09] |
| |
|
We really do not see how there can be more than 3 columns in the current version. In the next version, the Volume Weighted Average Price will also be outputted, so that will be up to 4 columns. In the next release the Study/Price Overlay study will also overlay the identical columns as the Source Study. 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: 2017-09-27 04:05:37
|
| [2017-09-26 22:49:46] |
| User931283 - Posts: 55 |
|
The current version outputting 3 or 4 col's does not solve the problem: Prior versions put out different column counts- 4 and 16 columns back around V1450 on overlays. Columns count/# consistency between versions is absolutely crucial to not destroy years of users' work, on large systems. Changes of study columns' count over versions is a DISASTER. I'll lose months of hard work-6 days a week if you can't help me. How would you feel if you had to go back 6 months on Sierra Chart platform development? What do you mean the new overlay or VbP "will also overlay the identical columns". Do you mean however many columns there may be in a VbP? If SC makes column count changes without a retro-fix or serious concern, you'd be telling users that if Spreadsheet columns change, "too bad". Respectfully, if your "will overlay identical columns" only applies to new VbP studies, can we think of a simple fix-handy tool, relatively easy to program vs usefulness to all users, even for other problems--- such as a Spreadsheet Column Filler, that Adjusts-Fills subsequent columns to align as prior? PLEASE, I need to fill 13 columns with no gap column in front soon, hopefully within a week, whether a tool, or option to select # columns to output. We love SC and admire you guys. You've made great improvements. Please help or explain the above or any ideas. Date Time Of Last Edit: 2017-09-26 22:54:55
|
| [2017-09-27 04:02:46] |
| |
|
In the version you are running there should only be a maximum of three columns outputted by the Volume by Price study. We want to understand why there are 4. Attach the Chartbook you are using following the instructions here: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile We only need the Chartbook and we do not need a Spreadsheet. Columns count/# consistency between versions is absolutely crucial to not destroy years of users' work, on large systems. Changes of study columns' count over versions is a DISASTER. I'll lose months of hard work-6 days a week if you can't help me. How would you feel if you had to go back 6 months on Sierra Chart platform development? If SC makes column count changes without a retro-fix or serious concern, you'd be telling users that if Spreadsheet columns change, "too bad". Refer to: Using the Spreadsheet Study: Preventing Effect of Changes to Study Order and Subgraphs Outputted on Formula References to Study Subgraphs What do you mean the new overlay or VbP "will also overlay the identical columns". Do you mean however many columns there may be in a VbP? The answer to the question is yes.
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 |
| [2017-09-27 18:49:02] |
| User931283 - Posts: 55 |
|
I'll study your suggestions. Without my sequence of versions/spreadsheet creations/VbP overlays, from V1450, V1454, V1481, you can't reproduce what happened. But I can show you. In re your "We want to understand why there are 4", here's a pic of a new test spreadsheet created by V1615 source chart #20: V1615 creates 3 cols.--what you said/ expect. Creation-not overlay, is consistent, 3 cols after V1454. V1454 or prior created the 4-column VbP and the 15-col. (not 16) VbP (the prior #44 spreadsheet pic cut off SG2, SC not running, trailing 11 col's had 0 - no data) I ran a V1481 Replay to see if #44 Sheet would ever fill data into trailing 11 VbP columns (4+11=15) when running: NO, did not, only 4 columns had data updating in the overlay- from the source VbP 4 columns created by V1454 or prior. Here is a better pic, 15 cols of V1450-81 target #44 overlay from source #20, SC running. For a new sheet, V1481 creates 3 columns for VbP, like V1615 (not overlay). The only issue is "consistent overlay prior column count fidelity" from old source study overlays with inconsistent col's. or: How to fill 11 additional columns that were in the old spreadsheet that V1615 overlay now drops. V1615 overlay probably keeps 4 of old 15 cols because 4 have data and trailing 11 SG6-SG16 have 0's. Does "[reproduce] however many columns there may be in a VbP? The answer to the question is yes" mean you'll try to make overlays look for spreadsht columns by prior spreadsheet headings, not just by data other than 0-zeros? Before building/changing a spreadsheet, the overlay should look to see how many headings were in the old spreadsheet, (preserve column count with fidelity), regardless whether any data is in columns. EDITED: Meanwhile, Trying Workarounds: I tried "Horizontal Lines" as a columns filler; Almost works. (Your old solutions don't seem to fit). 40 lines in the sub-headings makes the spreadsheet look screwy, though. Could you add a "Number of Lines" option? (now a set #, 40) Or a similar study with 10 lines? LATEST: The V1615 overlay apparently completely lost ID30 Study. Last Pic added shows it gone, other studies now out of sequence Pic V1615Chart44-VbPoutputs4Cols-StudyID29-2-HorLines-Study30Missing Date Time Of Last Edit: 2017-09-28 16:03:42
|
| 20-testtempVbP-V1615.jpg / V - Attached On 2017-09-27 16:57:58 UTC - Size: 249.81 KB - 359 views V1481Chart44-VbPoutputs16Cols-2-SimRunning.jpg / V - Attached On 2017-09-27 16:58:15 UTC - Size: 240.29 KB - 366 views V1615Chart44-VbPoutputs4Cols-StudyID29-2-HorLines-Study30Mis.jpg / V - Attached On 2017-09-28 16:03:24 UTC - Size: 249.29 KB - 362 views |
| [2017-09-28 17:08:06] |
| User931283 - Posts: 55 |
|
The Horizontal Lines Study for Filler caused the Mess seen in the last-above pic. - - - - I started over: before & after upgrade nothing else, but a wider view of #44 Spreadsheet. See wider view pics here. All studies are there, just shifted by the 11 missing columns, as explained to you. Just stop the sheet builder from replacing the old Spreadsheet if column counts don't match prior. |
| V1481Chart44-VbPoutputs16Cols-WideView-withID30.jpg / V - Attached On 2017-09-28 17:06:59 UTC - Size: 386.37 KB - 433 views V1615Chart44-VbPoutputs4Cols-WideView-withID30showing-but-di.jpg / V - Attached On 2017-09-28 17:07:19 UTC - Size: 416.82 KB - 403 views |
| [2017-09-28 19:47:27] |
| User931283 - Posts: 55 |
|
My Chart 37 Spreadsheet also messed up by V1615 Pic of before vs after, errors missing and shifted after col CS. System needs to keep old spreadsheets. Your nice Sequence ordering in Study List has done something. |
| Chart37-Spreadsheet-Before-After-Upgrade-1481to1614-colCT-on.jpg / V - Attached On 2017-09-28 19:47:06 UTC - Size: 605.67 KB - 415 views |
| [2017-09-29 02:57:33] |
| |
|
We are not sure why you are providing all of this information. Most of this is of no use to us at all and we do not understand it. It sounds as though that you are seeing the four columns outputted to the Sheet by the Volume by Price study instead of 3 when you are using the Volume by Price study with the Study/Price Overlay study. This issue is resolved in version 1616. The inherent problem you have was solved years ago. You need to use this method to reference study subgraphs: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study (References to Study Subgraph Columns when using the Spreadsheet Study) There is no other further help we can provide. Therefore, continue to use the old version of Sierra Chart until you update the cell references used in formulas. 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: 2017-09-29 03:02:20
|
| [2017-09-29 03:01:31] |
| |
|
So prerelease version 1616 has the mentioned change to the Study/Price Overlay study where it is only going to output columns to the Sheet which correspond to the original source study. But it really does not make sense why you would use it until you update the cell references. You have to stay on the old version and update the cell references to use the referencing method documented here: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study 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: 2017-09-29 03:03:17
|
| [2017-09-29 04:31:43] |
| |
|
One thing we can make a note of doing it but we do not know how soon, is we could add to the Subgraphs settings of a study, whether a particular Subgraph would be outputted to a Sheet or not. This is not necessarily though a perfect solution. We could also add an Input to control how many blank columns are added after each study that is outputted. But the proper solution is to reference the study Subgraphs using the documented method we have linked to: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study 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: 2017-09-29 04:48:33
|
| [2017-09-29 04:39:11] |
| |
|
In regards to post #12, allow up to 12 months for these potential additions. Yes we are that busy. It will not help to post anything further. It is not anything we can pay attention to. Once again we have provided a definitive and proper solution to this years ago. You need to use it.: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study 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: 2017-09-29 04:48:54
|
| [2017-09-29 06:30:05] |
| User931283 - Posts: 55 |
|
Re #10- I give no more info than needed. V1615 added a Study-ID23 to spreadsheet that had been missing on spreadsheet, which was on the Chart #37 list of studies. (See my prior pic of before/aft.) But on an overlay of Spreadsheet from #31 to #37, the rest of #37 sheet was mostly shifted and messed up (not handling as had prior). As experienced, I know a problem must be adequately shown/explained to fully solve it. Until I've found all that V1615 changed, you can't understand what all happened. Earlier inconsistencies in Column creation were the cause. V1615 is better on spreadsheets. So I just need a Column Filler Your Fix is for one study that never showed, nor shows up to be referenced in cols K-X formulas. It's not for changing column counts by versions that shift 200 columns in 4 spreadsheets, due to overlays and changed subgraph outputs. Re #11 Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study says it's for "a specific Study Subgraph on the chart", not changed-inconsistent overlays. With 50 of 70 studies shifted & some missing-- on 4 big spreadsheets/ There's NO way to maintain sheets that way. - How can that let me insert several columns? - Does that prevent newly-changed overlays from writing over ID References? I need a better fix than a nightmare of non-standard reference methods on hundreds of changed columns; I have huge, pages-long formulas. That cumbersome method is unnecessary if a new "add X-Fill columns" study is created, and later "select columns to output" for studies with a history of different outputs. Re #12 For Fixes, go with add a number of blank columns or choose selected SubGraphs, but first: ONE general "Add Fill Columns in Sheet" study would help. I'd PAY 2 hours toward that new study, about what it should take. I see that your Versions strive to reflect what the Study List shows- the only correct source for building spreadsheets. I see why you can't just keep an old "not quite right" Spreadsheet. Re #13 We appreciate you're very busy. Understanding symptoms of serious issues can't be a long review of past minor bugs. Date Time Of Last Edit: 2017-10-01 09:49:42
|
| [2017-10-01 12:57:05] |
| User931283 - Posts: 55 |
|
V1481 Sheets w/ sheet overlay #31 to #37 Worked Great V1617 Ruins #37 Sheet. Here're spreadsheet files to see it. Also #37 Studies List as .jpg EDITED: Here's an Excel Spreadsheet of both, aligned to compare the V1481 Ch#37 Spreadsheet 37, to V1617 Looks like V1481 includes all Sheet31 Overlay Columns but V1617 puts out only col's with data? Otherwise columns both resume with ID11 after ID18. That's the problem- the shifted columns. Date Time Of Last Edit: 2017-10-01 23:14:32
|
Private File Private File Private File Private File |
To post a message in this thread, you need to log in with your Sierra Chart account: