Support Board
Date/Time: Wed, 08 Jan 2025 18:13:25 +0000
Study/Price Overlay and different bar size within spreadsheet
View Count: 1341
| [2016-07-15 14:01:20] |
| JamesP - Posts: 89 |
|
Hello, I'm trying to take entries off different range bar size charts on one spreadsheet for auto trading. I have a smaller range chart(destination) with a couple of studies that is taking auto entries and a larger range chart(source chart) with a couple of studies taking auto entries. I have used the study/price overlay to overlay the main price graph and studies of the larger range(source) chart onto the smaller(destination) chart. First Question: I want the formula(s) to execute at bar close for the smaller(destination) chart but I also what the other formula of the larger(source) chart to execute at bar close but bar close of the larger chart. What's happening is that because the spreadsheet is on the smaller destination chart the entries for the larger source chart are using the bar close of the smaller destination chart. Second Question: Is it possible to take different exits for the smaller destination chart and larger source chart. So basically the smaller chart entries use the the smaller range bars for an exit and the larger range bar entries use the bars from the larger chart for exits. Can I do all of this from one spreadsheet or do I need to set up multiple spreadsheets? I basically want to take entries of different sized charts within the same account and if there is already on entry on one chart then the other chart doesn't take an entry. Thanks in advance. |
| [2016-07-17 09:30:18] |
| |
|
1. It is impossible for us to help with this unless we have a Chartbook and Spreadsheet and can see everything related to this clearly but this is not within the scope of our support. 2. Yes this should be possible and you should be able to do it with one Spreadsheet study as long as the other charts are overlaid onto the chart using that Spreadsheet study, but the details of this is also not within the scope of our support. 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-17 09:32:43
|
| [2016-07-17 18:04:26] |
| JamesP - Posts: 89 |
|
Is it possible to simply tell me how to reference bar close of the source chart i'm using for study/price overlay instead of bar close of the destination chart the spreadsheet study is on?
|
| [2016-07-18 17:31:52] |
| |
|
Set this Input: https://www.sierrachart.com/index.php?page=doc/doc_StudyPriceOverlayStudy.php#DataCopyMode to Use Latest Value Set this Input: https://www.sierrachart.com/index.php?page=doc/doc_StudyPriceOverlayStudy.php#CopySourceDataToLatestCorrespondingDestinationBar to Yes With these settings, you should have access to the latest close price of the last bar of the source chart at row 3 in the Spreadsheet column containing the Study/Price Overlay study data. 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 17:32:32
|
| [2016-07-19 02:45:01] |
| JamesP - Posts: 89 |
|
My source chart is a larger range bar chart than the destination chart so I have "fill blanks with last value" set to yes, this means the input for "Copy Source Data to Latest Corresponding Destination Bar" is ignored correct? Thanks in advance.
|
| [2016-07-19 04:43:25] |
| |
|
Yes. Using Fill Blanks with Last Value will have the same result. This is no problem.
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-19 04:44:02
|
To post a message in this thread, you need to log in with your Sierra Chart account: