Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 12:39:05 +0000



Post From: spreadsheet question

[2014-08-25 00:48:36]
User021827 - Posts: 174
Hi

I want to reference a study from a 180minute chart in my current chart of 8 min.
After adding the study overlay, I am not sure what range to use in the spreadsheet when referencing the study.

In the attached image, you see the macd numbers from the 180 minute chart in columns ag and ah and they skip several rows.

I want to use a formula including ag>ah ( macd > macd mov av).

Usually I would use ag3:ag4 > ah3:ah4.
It seems that would not work here, so how many cells do you have to reference in this case ?

see attached image.

thanks

shane
Date Time Of Last Edit: 2014-08-25 00:49:49
imagespreadsheetsierra1.png / V - Attached On 2014-08-25 00:49:00 UTC - Size: 127.89 KB - 351 views