Support Board

Date/Time: Thu, 19 Sep 2024 01:17:30 +0000

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

[2013-08-05 14:12:04] Link To Thread - Link To Post [Go To First Post]
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