>Ah, I see. This is a cool technique. I don't suppose it's easy enough
>to do in SQL? Something to think about I guess. :)
Ray,
1) For your case I would just change the data population to a data sample
and just put in the notes that by Chebyshev's inequality that you removed
data that didn't fall into the expected range.
2) Depening on your db design, you can get SQL server to do moving averages
easily. The key is to add in your where statement something like
a) get the total for the span
b) divide value over total_value_over_span.
The where clause would contain the simple: WHERE (tradedate
between dateadd(mm, -1, getdate()) and getdate())
I use this to calculate the monthly moving average of the trade volume of
certain stocks that I track.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
