Support Board
Date/Time: Wed, 27 Nov 2024 12:33:40 +0000
spreadsheet question
View Count: 1080
| [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
|
 spreadsheetsierra1.png / V - Attached On 2014-08-25 00:49:00 UTC - Size: 127.89 KB - 351 views |
| [2014-08-25 02:10:56] |
| Sawtooth - Posts: 4120 |
|
In the Study/Price Overlay study, set the Fill Blanks With Last Value to Yes. Also, for fewer repaints, you might want to set the Data Copy Mode to Use Earliest Values... |
| [2014-08-25 05:10:25] |
| User021827 - Posts: 174 |
|
thanks Tom I appreciate your help ! regards |
To post a message in this thread, you need to log in with your Sierra Chart account: