Dear asnavale,
For explorations it is very easy to use...just define the date range with the from and to on top left of the automatic analysis window and u get it or if u know the no of days...pls click on the button n = and put the number of days.
For explorations it is very easy to use...just define the date range with the from and to on top left of the automatic analysis window and u get it or if u know the no of days...pls click on the button n = and put the number of days.
I have already mentioned in my post that the Exploration window has the date range option. I also mentioned that it does not do what I want. Let me explain:
Suppose I want to determine cumulative volume for RELIANCE from Jan 01, 2005 to June 30, 2005. The calculation should start from Jan 03, 2005 (Jan 1 and 2 are holidays, no data is available). and end on 30 Jun, 2005. The Cum(V) for Jan 3, 2005 should be same as Volume for Jan 3, the Cum(V) for Jan 4, 2005 should be sum of Volumes for Jan 3 and 4 and so on. But what you get from exploration is on Jan 3, 2005 Cum(V) is sum of all volumes starting from the first day of listing of RELIANCE upto Dec 31, 2004. This not what I want. The Cum(V) should be calculated only for the date range selected. In other words it should appear as if there is no data before the start date and no data after the end date. I hope I made my point clear. Is such a thing possible?
Of course I can do it by exporting data for the selected date range and using that exported data as if it were a new security. But it is a tedious job to do for a large number of securities.
The Cum(V) I mentioned is a simple formula meant only for this example. I actually want to use some more complicated calculations.
Can nyou help?
Thanks in advance.
-Anant