Mixed aggregation periods in custom watchlist


Category:
0
0

ChandraFebruary 22, 2021 at 9:05 pm
Mr Hahn,I have a requirement to find MACD(1HR).Diff-MACD(2HR).Diff and if the absolute difference is <0.02 then display “Tight” else” Loose” as Custom column

To do this I am trying first to verify if MACD(1HR).Diff and MACD(2hr).Diff custom values are matching MACD.Diff for 1hr and 2 hr columns.

I find that MACD(1hr) custom column value matches MACD(1HR) column but MACD(2hr).Diff Custom column values doesn’t match corresponding MACD(2HR).Diff

Could you help what could be the issue..

 

Attachments:
Marked as spam
Posted by (Questions: 1, Answers: 0)
Asked on February 22, 2021 9:37 pm
145 views
0
Private answer

The title of your question has been updated to better reflect the context of your request. The original title you entered was far too vague to be of any use for the rest of our viewers. "Custom Watchlist Column - To display".

From your description I see you have two issues you are trying to reconcile. The main issue is that it is not possible to combine two different time frames (aggregation periods) within the same custom quote column.

So when you say you need to subtract the 2 hour MACD diff from the 1 hour MACD diff.... right there at that point is where this request becomes completely impossible.

As for the reason your 2 hour MACD column is not matching your charts. The most likely reason for this discrepancy is that you have your chart set to "start aggregation at market open". This setting must be turned off for all charts because there is no equivalent setting for scans, study alerts or watchlist columns.

Marked as spam
Posted by (Questions: 37, Answers: 4079)
Answered on February 23, 2021 8:25 am