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 |