EViews.com

I can't use a 5-day lag because I specifically want Wednesdays and the data can start at any weekday. I tried converting the workfile into a weekly file but as far as I understood it then transforms the data by taking the average for example. I just want to keep the observations on Wednesdays exactl...

I'm trying to do something as simple as calculating weekly returns from daily indexes. I want the returns Wednesday to Wednesday but I will not know what weekday the data starts on (it will be different for different sample periods) so I can't use a simple loop. I've used the weekday function and th...

Is there a way I can get the resulting varlist converted to an alpha series? I'm trying to get the information in a format so I can save it to a SQL database using odbc.

I want to save the result from a stepwise regression in a matrix but I do not only need to know the coefficient values (@coefs) but I also need to know which variables were actually chosen. Can I also save the names of the selected variables?

Hi, I'm wondering if I can use a string variable when calling a SQL SP? I want the program to loop when it's fetching data for different dates. Now I have: wfopen(type=odbc) "tycheodbc" "{call spEXFGetClose ('2008-11-03')}" @keep * where you enter the date manually each time I wa...

It works when I set up the query inside the SQL server as a View and then fetch it. I can then get the full dataset with 50 variables into Eviews without problems. So I guess it has something to do with Eviews not being able to read the full query correctly. But great to have a way to make it work a...

Hi, Thank you for the reply. I've tried adding the variables one by one with different variables as the 11th but no luck. Posting the code that works in Eviews. Any other ideas on what I could try to make it work? Btw, is there a way to write the SQL code with line breaks - with long codes it's very...

Hi, I'm trying to import time-series data from our SQL database into Eviews using wfopen(type=odbc)... It works fine until I add more than 9 variables (plus date variable). Then I get the error message "unmatched parenthesis". I can't find anything wrong in the SQL question (works fine in ...

Hi, I haven't worked with data directly from/to databases before and I'm wondering if I can save the output stats from a regression directly in the database (odbc format)? Using wfsave(type=odbc)? Or does the output(x) support odbc ?

Thanks. I'm new to Eviews and I don't know how to set the data labels to the end date series. What would the code be that puts the end dates on the x-axis? "graph graph01.bar freq" obviously isn't enough, then I'm just stuck with a graph with the same problem I started with - no dates on x...

Here's the workfil. It's pretty basic, I just want to see the frequency of trades at each date. Hence, the code is the standard "first_tradedate.distplot" which works fine except for the fact that the dates are converted into numbers. Many thanks for the help.

I have the transaction dates of investors and want to do a histogram showing the frequency of trading at each date. However, the histogram automatically makes the dates into numbers and then you cannot read the graph. How do I get the histogram to show dates (i.e 2005-12-30) on the bottom axis?

Hi, I want to loop @movecor with series names but get get the values NA using the following code %name1_1 = "A" %name1_2 = "B" for !loop1=1 to 2 %name1 = %name1_{!loop1} series corr1 = @movcor(%name1,C,50) next It seems that @movecor does not understand that the name should be A ...