Login Page - Create Account

Support Board


Date/Time: Thu, 09 Jan 2025 08:52:23 +0000



Post From: Study/Price Overlay and different bar size within spreadsheet

[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.