Calculate the product of all data values in a series?

[cuccu]

Anyone tells me how to calculate the product of all data values in a series? I cannot find any function to do this. Thanks.

[EViews Gareth]

@prod(x)

[cuccu]

scalar sc1 = @prod(FTSE_return)
--> error message: @prod is an illegal name

Plz take a check, QMS Gareth!

I am using EViews 5.0

[EViews Gareth]

It doesn't work in EViews 5. Please post in the correct forum in the future.

[cuccu]

I am using 'for' loop to solve this problem. Thank you, QMS Gareth.

[startz]

I am using 'for' loop to solve this problem. Thank you, QMS Gareth.

You may also be able to do

Code: Select all

series product=FTSE_return smpl 2 @last product = product(-1)*FTSE_return

and then use the last element of product.

[EViews Glenn]

If all of the values in the series are positive, then

Code: Select all

scalar prod2 = exp(@sum(@log(s1)))

is another v5 way of getting what you want. Note that overflow or zero values are quite common for long series. Are you sure you want the product or do you want to work in a transformed space (e.g., log)?