logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
pakki  
#1 Posted : Monday, September 19, 2011 9:54:33 PM(UTC)
pakki

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?
mstt  
#2 Posted : Monday, September 19, 2011 10:11:26 PM(UTC)
mstt

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
pakki  
#3 Posted : Tuesday, September 20, 2011 10:17:40 PM(UTC)
pakki

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
MS Support  
#4 Posted : Friday, October 14, 2011 1:59:15 PM(UTC)
MS Support

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.