freshpotato
36 posts
msg #58062
- Ignore freshpotato |
12/13/2007 10:00:44 AM
Hello guys!
I want to figure this out, how to create a filter that tells me how many percent the last 1 month has moved, 2 months and 3 months and so on..
So for the first month it should be something like:
set {Mov1M,count(absolute day change,30)}
but how can I do for the month before without including this month..
Thanks
Tor L
|
TheRumpledOne
6,407 posts
msg #58071
- Ignore TheRumpledOne
modified |
12/13/2007 11:36:37 AM
Is this close enough?
|
nikoschopen
2,824 posts
msg #58072
- Ignore nikoschopen |
12/13/2007 11:46:23 AM
The count() should only be used when you want to see how many times such and such occurred within the x number of days. Use the sum() instead:
OR
**Also you don't want to use the ABS function because this will return the negative value as positive.
how can I do for the month before without including this month??
Depending on how many days (or weeks) have elapsed for the current month, you can use the above example to find the cumulative change for the previous months. Suppose we're into the second week of the month. Here's a simple way to find last month's ROC.
|