King To Leung

Last seen: 3 years ago | Active since 2022

Followers: 0 Following: 0

Statistics

Feeds

Question

dummy variable for calculating
Hi all, I have a bunch of sector code in c.sic column (column19). However, there are too many sub sectors and I need to group t...

3 years ago | 1 answer | 0

1

answer

Question

there is nan in a column, delete the whole row
I have a data base called data_crsp, and there might be some nan values in c.lagpe column (column 18), I want the whole row of d...

3 years ago | 1 answer | 0

1

answer

Question

Transfer Quarterly dates to Monthly
Hi all, I extracted quarterly data for eps in matlab data form (i think datevec is needed). from 31/3/1992, 30/6/1992, 30/9/199...

3 years ago | 1 answer | 0

1

answer

Question

regstats The design matrix has more predictor variables than observations.
I used the following code to run a regression, the system shows Error using regstats (line 132) The design matrix has more pr...

3 years ago | 2 answers | 0

2

answers

Question

Inf resulted when calculating mean
I am calculating the mean pe each year from 1993-2021. I have rounded my data set, drdata, to the 2 decimal place. However, the ...

3 years ago | 1 answer | 0

1

answer

Question

Calculating the value, excluding nan
I was calculating the average stock return of each year using the following code, and it shows error. This is due to the nan val...

3 years ago | 2 answers | 0

2

answers

Question

Finding the value according to row number
I have an array which has 3 columns and a lot of rows(dr). In the first column, it has the row number (column 2)that of the data...

3 years ago | 1 answer | 0

1

answer

Question

Sorting return by dates
I would like to sort the average return of each year. I have a data base of stock returns from 1992-2021. I would like to know t...

3 years ago | 2 answers | 0

2

answers