[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Multi-period Market Indicator Values



PureBytes Links

Trading Reference Links

Rick Mortellra wrote:
> 
>  Hi Paul,
> 
> Actually, I think you made it more difficult than it should be.
> 
> The rolling weekly synthetics I had in mind would be represented by the
> following MS custom formulas:
> 
> WeeklySyntheticHigh = HHV(H,5)
> WeeklySyntheticLow = LLV(L,5)
> WeeklySyntheticOpen = ref(O,-4)
> WeeklySyntheticClose = C
> 
Isn't it a lot easier to use the compression function built in MS. ?
double click on the X-axis, go to compression, tick other and use 5 to
get a 5-day rolling chart. Then any standard indicator can be used.

Julius