Rank: Member
Groups: Registered, Registered Users
Joined: 8/19/2011(UTC)
Posts: 16
|
How do i write a formula to find out average true range(ATR) on a hourly basis in a given market for a given scrip for past "x" number of days?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
Hi Pakki
Your question is open to several interpretations so can you provide give more explicit details. Any assumptions I might make may be wide of the mark and I'd just end up answering the wrong question.
Roy
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 8/19/2011(UTC)
Posts: 16
|
Hi Roy,
For example. Assume the scrip is traded between 9 am to 3 pm, i want to find the hourly volatility(using true range, ATR). Say i will take past 21 days data and find when was the volatility good enough, whether during 9 am, 12 pm etc.
Thanks
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,960
Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
|
I'm still a little confused by this request. Please let me state what I think you are asking:
- look at hourly data for the past 21 days.
- for each hour the market is open, calculate the true range for that hour
- for each day average the true ranges for each hour. That is total the true range values for the hour that starts at 9am and average them to get the average range for the 9am bar. then do the same for each of the other hour segments
If this is not what you are asking, please explain what is actually desired
|
|
|
|
|
|
| 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.
