EViews.com

Thank you!

Hi Gareth, Thanks for the answer above, I have another question please. When i run the following code (below) I get this error message (Test01@col is not defined or is an illegal command in test01@col(1) = mktrates.@col(val1)+mktrates@col(val3) - (2*mktrates@col(val2)). Why does the second to last l...

Thank you very much Gareth - just what I wanted.

HI Gareth, Sorry if i wasn't clear - I shall rephrase. I have time series of interest rates...1Y, 2Y, 3Y, 4Y, 5Y, 6Y, 7Y, 8Y, 9Y,10Y which are in a matrix. So my matrix has 10 columns and multiple rows depending on how far back in time i am looking. Column 1 is the time series for the 1Y rate, colum...

I just need pointers or pointers to examples for the permutation/combination problem. What i really would appreciate help with is the first part using the @replace and @left/@right functions in eviews.

Thank you in advance!

Hi, I have a number of time series of rates so I have 1Y, 2Y, 3Y out to 10Y. I would like to define some other time series which are three point combinations of the individual rate time series - for example 1Y2Y3Y= 1Y+3Y - (2*2Y). I have a list of some of the three point combinations - so i have str...

And simply copy pasting does not work as it is nolonger a 'link' so it won't update when i update the program file

well originally i did state i was using the addin: Hi Gareth, I am running a program and then I am linking my eviews workfile results to excel using the eviews addin version 8.1 (excel version 2010). The data is always formatted as an excel table and if convert this to a standard range then I lose m...

yes of course, sorry

Hi Gareth, Thanks for your screenshot. Attached is mine (using the eviews Getdata addin), the options are 'import and link' or 'import'.

Thanks.

Hi Gareth,

Thanks for the quick reply. Excel only seems to let me paste as link or simply paste....If I just paste then obviously it is nolonger linked. Do you know whether there are some settings in excel I need to fiddle with?

Thanks!

HI Gareth/Glenn, I've asked you this before (sorry for asking again)...N/A fixes with data from bloomberg. Sometimes the code work and sometimes it doesn't, is seems my code doesn't clear out an N/A if it appears at the first entry in a series, could you tell me what is wrong with the following plea...

Hi Gareth, I am basically copying and 'pasting as links' some matrices from my eviews workfile into an excel sheet. I am doing this so that I can just run my program every week and then refresh the excel sheet, which will pull in the new results. But when I paste in the results from eviews into exce...

Hi Gareth,
I am running a program and then I am linking my eviews workfile results to excel using the eviews addin version 8.1 (excel version 2010). The data is always formatted as an excel table and if convert this to a standard range then I lose my links. How can I fix this?

Thanks!

I am restating the problem, in the hope of getting an answer! If i run the following master and child programs it works: Master program: %0 = "P:\documents\test1\usd.wf1" %1 = "31/07/2000" %2 = "15/12/2015" exec "P:\documents\test1\testing.prg" {%0} {%1} {%2} ...