EViews.com

Hi, my question, is it possible to fetch using the bloomberg data base all the underlying stocks from an index choosing just the index ticket? maybe writing a code to get all members from and index at once.

Thanks

Yes, it is working, thanks Gareth.

Hi Gareth, yes it worked but the thing is I am running a loop when sometimes the inverse of the matrix is a number (because the matrix to inverse is a number matrix) and sometimes the inverse of the matrix gives me an error (because the matrix to inverse is a na matrix). I was trying to use your cod...

Hi, I am trying to take the inverse of a matrix with one value which is an NA. I want the inverse of this matrix to be an NA as well but it gives me an error. Anyone knows how to do this?

NA found in matrix in ""

Thanks

Thank you Gareth, it works perfectly.

Regards

my data is daily and have observations since 1989.

It doesnt matter if a month have 31 or 28 or 29, just need to substract 30 observations so yes 5/16/2020.

Thanks

Hi, I need to sample every 30th observation from a series starting from the last observation, this is if my last observation is on the 7/15/2020, then the 30th observation before that would be the 6/15/2020, and then 5/15/2020. I was trying to use dateadd but didnt work. I hope someone knows the ans...

I made some changes to part of your code to make it work, here it is in case anybody needs it. series return1 = @recode(@month<>@month(1), stockprice, na) series return2= @recode(return1=na, return2(-1), return1) series return3=(return2-return2(-1))/return2(-1) series return4 = @recode(@month<>@mont...

Yes, thank you, it works.

Regards

Thanks, you know it all. I have another question, how do you get the returns for a month, taking into account that some months have 31 days, others 30 and some 28 or 29?

Thanks

Hi, I am trying to sample the last day of each month in a daily series. is there a way to do it?

Thanks

Perfect, thank you.

Regards

Hi, I am trying to take an observation from a series, for example, observation corresponding to the date 06/03/2018, and save it in a matrix. Anyone knows how to do it?

Thanks

Hi, my question, is it possible to save a matrix into an existing excel file?, this would mean to update the file. I have a bunch of matrices that I want to save into the same excel file and the only code that I know is ".write(t=xls,b4)". I would like to save the matrices in different cel...

I fixed it, I needed to add this code: table(1,1) table name, before the tablename(1,1)=modela.@coef(2).

Thank you very much