topic Different moving averages in script in QlikView

Different moving averages in script

Mon, 29 Aug 2016 07:51:53 GMT

Can anyone give me a hand on how to create different moving averages in the script load?

I have some stock market data, daily values, and I want to create an average for the 5-10-20-50-100 and 200 days.

LOAD

'$(_vNameOfStock)' as Ticker,

'$(_vNameOfExchange)' as Exchange,

Day(Date) As StartDate,

Num(Month(Date)) As StartMonth,

Year(Date) As StartYear,

TradeDate,

Open,

High,

Low,

Close,

Volume,

[Adj Close]

FROM $(URL_String) (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Best regards

Espen

sunny_talwar — Mon, 29 Aug 2016 10:46:05 GMT

I think you might need to use Peek() or Previous() ?‌

Anonymous — Mon, 29 Aug 2016 11:01:52 GMT

may be this?

Create a Bucket of your said days like, 0-5,5-10, 10-20 etc which cud be:

TradeDate-Date as Days

Buckets

Then Expression like: avg(Close) if not wrong or your business logic for average calculation.