Page 1 of 1
Formation of Portfolios Using Deciles
Posted: Sun Jul 11, 2010 9:44 am
by MoeezQureshi
Hello,
I have Data on stock lending fees and i want to form portfolios using Deciles. So i have a Multi-Series data on about 600 companies but i cant categorize data into deciles. can you please let me know how can i do that using Eviews 7 or 6. I have access to both of the versions.
Regards,
MoizQureshi
Re: Formation of Portfolios Using Deciles
Posted: Mon Jul 12, 2010 9:08 am
by EViews Glenn
Can you be a bit more specific about the exact operation you are trying to do? Are the deciles computed across all firms or within each firm?
Re: Formation of Portfolios Using Deciles
Posted: Tue Jul 13, 2010 9:12 am
by MoeezQureshi
Dear Glenn,
I want to compute the decile across all the firms for their Stock Lending Fees
Re: Formation of Portfolios Using Deciles
Posted: Tue Jul 13, 2010 2:39 pm
by EViews Glenn
Is the workfile structured as a panel or a flat file.
Re: Formation of Portfolios Using Deciles
Posted: Wed Jul 14, 2010 9:27 am
by MoeezQureshi
Its a Panel Workfile
Re: Formation of Portfolios Using Deciles
Posted: Wed Jul 14, 2010 1:53 pm
by EViews Glenn
If you have a series you wish to categorize into deciles, you may use the Generate by classification proc to perform the desired operation. Select Proc/Generate by classification..., change the Method to Quantile Values, and enter 10 as the number of quantiles. EViews will create a new series with the classifications indicating which decile the series observation was in. Note that this routine works in this setting since you want to classify your observations on the basis of the series irrespective of the cross-section identifier. If you want to do this by cross section, it's a bit more difficult.
Re: Formation of Portfolios Using Deciles
Posted: Wed Jul 14, 2010 2:27 pm
by MoeezQureshi
Well i know this function but this doesn't help with my data. Ok i will try to explain a little more the problem that i have.
I have an Excel File with the First Column As Date, and from that onwards its the different companies with their respective SL Fees, say
DATE HONDA TOYOTA FORD DAIMLER VOLKSWAGEN
01/01 11 11 21 32 44
02/01 12 12 26 29 42
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
This is how the data looks and i want to divide this into deciles, and i have been unable to do so..
Re: Formation of Portfolios Using Deciles
Posted: Thu Jul 15, 2010 8:59 am
by EViews Glenn
So when you say that you have a panel workfile, what is the cross-section identifier?
Re: Formation of Portfolios Using Deciles
Posted: Thu Jul 15, 2010 12:12 pm
by MoeezQureshi
Well i am going to send you my excel file and maybe you can see how it can be done.
It's part of the data and I am sorry i can't be sending the whole data.
Re: Formation of Portfolios Using Deciles
Posted: Thu Jul 15, 2010 4:45 pm
by EViews Glenn
Given the Excel sheet (ands I suspected from your previous post), it looks as though your workfile is not panel structured. Instead, you are working with the data in unstacked (pool) form.
What you should do is to use the Proc/Reshape Current Page workfile procedure to stack the data into a panel structured page/workfile. Then my previous suggestion will compute the quantiles for you across all of the cross-sections.