Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 06 May 2024 16:08:38 +0000
Missing Initial Balance Data
View Count: 1342
| [2016-12-07 10:30:38] |
| User642139 - Posts: 20 |
|
Hello, I am using the spreadsheet study to extract initial balance data for my analysis on /ES. I am using an intraday chart and then overlaying the initial balance data onto another chart that is attached to the spreadsheet. I have compiled 1200 days of data, of these days there are 13 days that do not show data for the initial balance. Yet the data for the OHLC for these same days is showing. I have gone through and excluded all the non-trading days. To add to the confusion when I go and double check the chart the initial balance lines are there as normal on the dates that are not showing the data in the spreadsheet fields. I have restarted the whole process in a new chartbook and the same result occurs. Any suggestions? Thanks |
| [2016-12-07 21:18:28] |
| |
|
You are going to need to show us very clear evidence of this by showing an image of the chart with the data that you do not see on the Sheet in the Spreadsheet. Here are instructions to provide an image of the chart: https://www.sierrachart.com/index.php?page=PostingInformation.php#Image You also need to provide a screenshot of the Spreadsheet Sheet where the data is missing. The problem could also be due to what is explained here: http://www.sierrachart.com/index.php?page=doc/ChartStudies.html#ChartValuesAndSpreadsheetStudies Also make sure the Number of Rows setting is high enough: http://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#NumberofRows 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-12-08 14:05:04] |
| User642139 - Posts: 20 |
|
Here is the chart with a couple of the dates in question 2012-6-29 and 2012-07-06. The initial balance lines are included. http://www.sierrachart.com/image.php?Image=1481205312615.png And here is the accompanying spreadsheet with the missing data fields. http://prntscr.com/dgw6ui The number of rows is high enough. Thanks |
| [2016-12-08 18:06:47] |
| |
|
We will not accept a link to an external image service. We will only accept an attached file. Follow the instructions here: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile 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-12-08 18:11:52] |
| User642139 - Posts: 20 |
|
Sorry, didn't realize you wanted the same procedure for the spreadsheet also. The previous method did not let me save chart, so I had to upload entire desktop. http://www.sierrachart.com/image.php?Image=1481220597687.png |
| [2016-12-08 18:41:14] |
| |
|
We understand what you are doing now. Apparently you are using the Study/Price Overlay study: http://www.sierrachart.com/index.php?page=doc/StudyPriceOverlayStudy.php We do not see a match with the dates between the two images you provided. They are for different periods of time. Anyway, check the Input settings for that study. Review the documentation for them. 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-12-08 19:11:16] |
| User642139 - Posts: 20 |
|
Sorry again, I can't believe I didn't match the chart and data up. And yes, I am using study/price overlay. I explained this in my original question, but upon re-reading I guess I didn't really make it clear. I have followed all the directions in the documentation and still no change. I am attaching the chart again to match the spreadsheet data. http://www.sierrachart.com/image.php?Image=1481224073297.png |
| [2016-12-09 04:26:06] |
| |
|
It really is impossible from our limited perspective to know what the issue is. There is a lot of complexity to analyze this in general. The simple solution is to set this Input to Yes: Study/Price Overlay Study: Fill Blanks with Last Value But you really need to read through the descriptions of the other Inputs and fully understand how the data matching is done to understand what is happening. 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-12-09 09:28:08] |
| User642139 - Posts: 20 |
|
Thanks, Yes, filling blanks with the last value would indeed remove the blanks. But this drastically alters and in fact makes my statistical analysis of the product inaccurate. I guess I should just ignore the missing data in my calculations going forward. |
| [2016-12-09 10:17:47] |
| |
|
Apparently what is happening is that there is a single chart bar in the source chart which is matching to two daily bars in the destination chart and only one source bar can match per destination bar and any other matching destination bars/columns will just be left blank. This should be resolvable with the different Inputs which affect matching. 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-12-09 10:19:01
|
To post a message in this thread, you need to log in with your Sierra Chart account: