Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 4/13/2011(UTC)
Posts: 7
|
I chart futures and open interest is important as part of the analysis. The exchanges do not report the open interest until a day later. Therefore the open interest line always is shown to be zero on the last day. The open interest line because of the last day being zero is compressed. I have tried rescaling the Y axis and saving the change but when rereopening the chart it reverts back to the origimal scaling and my line is again compressed. I there any way to correct this?
Thanks
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,975
Thanks: 95 times
Was thanked: 158 time(s) in 153 post(s)
|
the following formula will prevent an open interest value of 1 from being displayed after the first non-zero value is plotted:
If( OI = 0, prev, OI)
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 4/13/2011(UTC)
Posts: 7
|
Thank you. This solved the problem.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
