Thank you Gareth.I think I would loop through them calculating the covariance once at a time, recording the covariances in to a column of a matrix. Then you could sort the matrix and take the top (or bottom) 100.
Search found 16 matches
- Thu Aug 26, 2010 5:10 am
- Forum: Programming
- Topic: Correlation
- Replies: 4
- Views: 4657
Re: Correlation
- Wed Aug 25, 2010 12:26 pm
- Forum: Programming
- Topic: Correlation
- Replies: 4
- Views: 4657
Re: Correlation
what does "and then take, say, 100 at least correlated series" mean? OK, so let's say I have 10,000 series + 1 index, and I want to create a portfolio of 100 series which have the lowest correlation with the index. As I understand, I would have to create a correlation matrix, and then tak...
- Wed Aug 25, 2010 11:48 am
- Forum: Programming
- Topic: Correlation
- Replies: 4
- Views: 4657
Correlation
Hello,
I'm trying to compute a correlation matrix for a number of series, and then take, say, 100 at least correlated series. Is there any way to achieve this? In other words, how can I take names of those 100 series which are at least correlated among the entire sample?
Best
I'm trying to compute a correlation matrix for a number of series, and then take, say, 100 at least correlated series. Is there any way to achieve this? In other words, how can I take names of those 100 series which are at least correlated among the entire sample?
Best
- Sat Aug 14, 2010 2:30 am
- Forum: Programming
- Topic: Extracting Probability Function from Heteroskedasticity Test
- Replies: 2
- Views: 3461
Re: Extracting Probability Function from Heteroskedasticity Test
Thank you Gareth.
- Fri Aug 13, 2010 2:27 am
- Forum: Programming
- Topic: Extracting Probability Function from Heteroskedasticity Test
- Replies: 2
- Views: 3461
Extracting Probability Function from Heteroskedasticity Test
Hello, There's the archtest() function, but it has only additional option to print the output. Can I somehow obtain the probability function (from F-statistic) from that test? I estimate hundreds of regressions, and I'd like to put the results from the test into a table, instead of separately openin...
- Thu Aug 12, 2010 1:50 am
- Forum: Suggestions and Requests
- Topic: Escape button
- Replies: 2
- Views: 4264
Escape button
That's very annoying issue. If an user has several windows open in EViews, a current window should be closed after pressing escape button. It's annoying to clicking on "X" if there are dozens of windows open. Sometimes is just faster to close EViews and and reopen it. The "escape opti...
- Thu Aug 12, 2010 1:44 am
- Forum: Suggestions and Requests
- Topic: Interface for program writing
- Replies: 1
- Views: 3526
Interface for program writing
OK, three things that might be useful for someone who writes a program: Lines numbering. When user selects a text and press a tab button, the text should be tabulated to the right, not deleted. When program is run and there's an error, the message could point out a line number in which the syntax is...
- Thu Aug 12, 2010 1:39 am
- Forum: Suggestions and Requests
- Topic: Customized toolbar
- Replies: 0
- Views: 2522
Customized toolbar
Hello,
I though it would be useful if the user had an option to define a customized toolbar (something like a "floating" toolbar in Word and Excel 2003 and earlier). The toolbar could contain command or program often being used.
Best
I though it would be useful if the user had an option to define a customized toolbar (something like a "floating" toolbar in Word and Excel 2003 and earlier). The toolbar could contain command or program often being used.
Best
- Tue Aug 10, 2010 11:22 am
- Forum: Data Manipulation
- Topic: Lower/upper tails
- Replies: 2
- Views: 3730
Re: Lower/upper tails
Thank you!
- Tue Aug 10, 2010 11:15 am
- Forum: Data Manipulation
- Topic: Lower/upper tails
- Replies: 2
- Views: 3730
Lower/upper tails
Hello,
How can I obtain an observation corresponding to, say, 5% in the lower and upper tail of the distribution in the series?
Best
How can I obtain an observation corresponding to, say, 5% in the lower and upper tail of the distribution in the series?
Best
- Fri Jul 30, 2010 10:36 am
- Forum: Programming
- Topic: Illogical syntax?
- Replies: 4
- Views: 6190
Re: Illogical syntax?
Thank you for your reply. I do understand that the program variables don't have rows, etc. In the below statement: !no_45 = 0 smpl 1/1/2010 1/1/2010 if d45 = 1 !no_45 = !no_45 + 1 smpl @all I specify the variable !no_45 equal to 0. Then, I select the first row in the workfile by smpl statement. Then...
- Fri Jul 30, 2010 9:41 am
- Forum: Programming
- Topic: Illogical syntax?
- Replies: 4
- Views: 6190
Illogical syntax?
Hello there, I'm trying to understand the syntax of EViews (7), but sometimes it just doesn't make sense. Two problems. 1. First: for !industry=1 to 10 !no_{!industry} = 0 for !firm=1 to 100 smpl 1/1/2010 1/1/2010 if d{!firm} = {!industry} !no_{!industry} = !no_{!industry} + 1 smpl @all next next Le...
- Fri Jul 23, 2010 6:47 am
- Forum: Programming
- Topic: Strings and variables together in the FOR loop?
- Replies: 1
- Views: 3757
Strings and variables together in the FOR loop?
I wrote a long program performing a number of tests. Previously, I had just a couple of workfiles, so I specified strings/variables at the beginning of the program and changed them each time I ran the program: %name = "wf1" <-- here !number = 100 <-- here etc. wfopen {%name} [body of the p...
- Fri Jul 23, 2010 5:46 am
- Forum: Data Manipulation
- Topic: p-value for t-test
- Replies: 1
- Views: 4891
p-value for t-test
OK, so I encounter the following error when I compute p-value. I calculate it as follows: 'Calculates number of observations: !number = @obs(series1) 'Calculates t-statistic: !t = (@mean(series1)-@mean(series2))/(@stdev(series1)/@sqr({!number})) 'Calculates p-value for t-distribution with N-1 degree...
- Wed Jul 14, 2010 6:24 am
- Forum: Data Manipulation
- Topic: Saving Correlogram in word
- Replies: 2
- Views: 7086
Re: Saving Correlogram in word
Just print as a "Microsoft XPS Document Writer", and import that image into a Word document. Make sure that you fist setup the fonts, etc. that you use in your Word document, so that when you insert the graph into the Word document with a 100% size, no-one will tell the difference when you...
