Login Page - Create Account

Support Board


Date/Time: Mon, 16 Sep 2024 19:25:20 +0000



problem with using 2 different chart timeframes in spredsheet

View Count: 1733

[2013-08-05 14:12:04]
User60591 - Posts: 39
hi, I have a problem with spreadsheet for Trading.
I'm usig two different timeframes for confirmations and to generate signals when the conditions are met.
I'm usig a higher timeframe to see if the price is below or above Moving average. here I use LSMA Above/Below Last to get 1 or -1 in my spreadsheet.

The problem is, naturaly, that the rows does not match for my lower and higer time frame in spreadsheet.
I use Overlay (Bar) study to link the higher timeframe to spreadsheet.

When I synchronize them the moving avarages is not drawn ok as on the original chart.
Because the gaps are filled and and MA is calculated based on theem aswell.

So basicaly i can't get the right numbers in the speadsheet.

I.e. when rhe conditons are met on the lower time frame and the last is above/below MA it should generate a signal.

Is there another way to link a different chart with different timeframe to one of the sheets?


thnx









[2013-08-05 14:54:13]
User60591 - Posts: 39
I have compensated the gap fill with the moving average set x2 since the higher timeframe chart is 2 times larger.
I'm not sure if this is right.

I tryed to link a chart to new sheet by right clicking the "set chart link" in Sheet2. I get This command is not supported in his version of AtChart (package3).
i'm using Infinity as a broker.

Is it possible to set a chart link in Package5?
Date Time Of Last Edit: 2013-08-05 14:54:44
[2013-08-05 17:45:38]
Sierra Chart Engineering - Posts: 104368
You need to use the Study/Price Overlay study instead. This is documented here:
http://www.sierrachart.com/index.php?l=doc/doc_ReferencingChartsFormulas.html

There is no need for chart linking for what you are doing and that command has been removed in newer versions. Update by selecting Help >> Download Current 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

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account