Search found 12 matches
- Mon Nov 03, 2014 1:33 pm
- Forum: Programming
- Topic: Rolling Multiple Regression
- Replies: 13
- Views: 21344
Re: Rolling Multiple Regression
Is dropping one of the regressors the only option? Notice that for model1, the rolling regression runs a number 30odd iterations and on the 31st gives the error. I don't get this error message when I run it on the entire sample, just over a fixed period window.
- Mon Nov 03, 2014 12:34 pm
- Forum: Programming
- Topic: Rolling Multiple Regression
- Replies: 13
- Views: 21344
Re: Rolling Multiple Regression
Attached is the EViews workfile and the rolling regression programs for the two equations in the workfile. You'll see that in both models, once you start running the rolling regression program, you get the message "Near singular matrix error. Regressors may be perfectly collinear." I'm not...
- Fri Sep 05, 2014 10:24 pm
- Forum: Programming
- Topic: Rolling Multiple Regression
- Replies: 13
- Views: 21344
Re: Rolling Multiple Regression
Thank you. I added the below and it works fine ' estimate equation eq01.ls log(y) c log(x) log(y) Do you really want to be regressing log(y) on log(y)? That's a typo in the example - its log(z) or any other variable. A lot of other equations give me the same error message. "Near singular matri...
- Fri Sep 05, 2014 8:39 am
- Forum: Programming
- Topic: Rolling Multiple Regression
- Replies: 13
- Views: 21344
Re: Rolling Multiple Regression
Sorry, don't follow. Can you please show an example? "You can grab the command string of the existing equation (equation.@command) and use that to re-estimate it as is." I also tend to get this error message quite often when I run the regression: "Near singular matrix error. Regressor...
- Mon Aug 25, 2014 10:03 am
- Forum: Programming
- Topic: Rolling Multiple Regression
- Replies: 13
- Views: 21344
Re: Rolling Multiple Regression
Given that I already have eq01 in the workfile, is there a way for me to reference the equation in the workfile instead of manually inputting the entire equation in the program? I also have a matrix with 3 columns and would like to store regression coefficients in the columns (instead of rows that a...
- Fri Aug 22, 2014 1:56 pm
- Forum: Programming
- Topic: Rolling Multiple Regression
- Replies: 13
- Views: 21344
Re: Rolling Multiple Regression
Thank you. I added the below and it works fine
' estimate equation
eq01.ls log(y) c log(x) log(y)
Question: Given that I already have eq01 in the workfile, is there a way for me to reference the equation in the workfile instead of manually inputting the entire equation in the program?
' estimate equation
eq01.ls log(y) c log(x) log(y)
Question: Given that I already have eq01 in the workfile, is there a way for me to reference the equation in the workfile instead of manually inputting the entire equation in the program?
- Fri Aug 22, 2014 1:29 pm
- Forum: Programming
- Topic: Rolling Multiple Regression
- Replies: 13
- Views: 21344
Rolling Multiple Regression
I'm trying to run a rolling multiple regression for 52 weeks for the last 10 years. I've looked up the forum and was able to put together a code to generate and store the rolling r2. However, my r2 vector is giving me the same r2 at every point in time. The code is below - can you please suggest any...
- Fri Aug 22, 2014 1:11 pm
- Forum: Programming
- Topic: Time series of rolling eigenvalue proportion (from PCA)
- Replies: 13
- Views: 13702
Re: Time series of rolling eigenvalue proportion (from PCA)
That worked, thank you.
- Fri Aug 22, 2014 12:52 pm
- Forum: Programming
- Topic: Time series of rolling eigenvalue proportion (from PCA)
- Replies: 13
- Views: 13702
Re: Time series of rolling eigenvalue proportion (from PCA)
meaning !cumpc needs to be stored in the vector evalpc1? Can't seem to get the data stored in evalpc1
- Fri Aug 22, 2014 10:43 am
- Forum: Programming
- Topic: Time series of rolling eigenvalue proportion (from PCA)
- Replies: 13
- Views: 13702
Re: Time series of rolling eigenvalue proportion (from PCA)
Thank you. That seemed to work. However, I'm getting all zeros. The entire code is below: can you suggest any changes? ' set window size !window = 104 ' set step size !step = 1 ' get size of workfile !length = @obsrange 'calculate number of rolls !nrolls = @floor((!length-!window)/!step) 'vector to ...
- Fri Aug 22, 2014 10:12 am
- Forum: Programming
- Topic: Time series of rolling eigenvalue proportion (from PCA)
- Replies: 13
- Views: 13702
Re: Time series of rolling eigenvalue proportion (from PCA)
I get the same error message - Gareth, any suggestions?
- Fri Jul 25, 2014 2:54 am
- Forum: Econometric Discussions
- Topic: Creating a Score to Rank Single Variable Regression Results
- Replies: 0
- Views: 2043
Creating a Score to Rank Single Variable Regression Results
I have run single variable least square regression across a number of different securities. I would now like to create a score to rank the regression results. I am using three outputs from the regression as my ranking criteria: 1) R Squared, 2) Beta, 3) P-Value of Beta. So subjectively, a security w...
