Login Page - Create Account

Support Board


Date/Time: Sat, 23 Nov 2024 20:47:49 +0000



Post From: problem with using 2 different chart timeframes in spredsheet

[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