Question

Extracting the second decimal point of a number

Hi, I want to extract the 2nd decimal point without rounding from a vector of numbers. For example: A=[8.18750]; I wa...

5 years ago | 1 answer | 0

Question

Extracting data from pdf files

Hi, I have around 300 pdf files with 19 pages each. I want to extract from each of them a fraction of a table on page 4 in or...

5 years ago | 1 answer | 0

Question

export csv file without NaN values

Hi, I am using the following code: filename='AllFirms.csv'; %write string to csv fileID = fopen(filename,'w...

6 years ago | 2 answers | 1

Question

Using a loop to write to excel

I have a long list of variables in my workspace that I want to write to excel. I am just quoting few here: List={'B_AfterEm...

6 years ago | 1 answer | 0

Question

Concatenate Aphabets and numbers

Hi, I am trying the following code: Alphabet=char('a'+(1:26)-1)'; [I,J]=ndgrid(1:26,1:26); I=I'; J=J'; XX=[Alph...

6 years ago | 2 answers | 0

Question

save the results of who function

Hi, I want to store the results of variables that start with B in a cell array where each row display the name of one variabl...

6 years ago | 1 answer | 0

Answered

find an ID that has two values for another variable

No I want them both to exist the 1990 and 1996 . It is not an "or " but rather an also.

find an ID that has two values for another variable

No I want them both to exist the 1990 and 1996 . It is not an "or " but rather an also.

6 years ago | 0

Question

find an ID that has two values for another variable

Hi, ID and fyear are vectors of the same size year(x00-1)=1996;year(x00-7)=1990 I want to find the ID that is equal to ID(i) ...

6 years ago | 2 answers | 0

Question

Matching two matrices by sign

A=[1,1,-3;2,-1,4]; B=[2,4,-2; 2,-1,-3]; *How can I get that the sign of B(2,3) is different than the sign of A(2,3)?...

6 years ago | 1 answer | 0

Question

converting a text to number

I have a cell array with cells that have the following format: C={'-0.17' '1.85*' '0.22' '0.43' '2.23**' '-0.18' '-0....

6 years ago | 1 answer | 0

Question

Extracting text from a cell

A='00003H102' How can I write a code to extract the first 6 letters and numbers. i.e. I want B='00003H';

6 years ago | 3 answers | 0

Question

exporting from matlab to excel

I have 236 vectors and arrays named A, B, C.....etc... Some of them are cell arrays and some of them are double vectors. How can...

6 years ago | 2 answers | 0

Question

Matching only parts of two cell arrays

A= {'36450A107';'36467A107';'38067A107'} B={'36467A'}; How can I find that the 2nd cell in A matches the first 6 character...

6 years ago | 3 answers | 0

Question

random vectorof zeros and 1

Hi, if I want to generate a random vector of length 1000 where 700 are zeros and 300 are ones how can I do so? I want the zer...

6 years ago | 1 answer | 0

Question

finding the breakeven point

Hi, I have the following equation: nanmean(R(x0+1))-(fm1.*BHR)+(ntrades/2*n)*log((1-c)./log(1+c)); I know every param...

6 years ago | 1 answer | 0

Question

ttest of a portfolio

Hi, I have a portfolio of stock returns,and R is a matrix of individual stock returns (rows are dates and columns are the sto...

6 years ago | 0 answers | 0

Question

How to edit a cell to include a parantheses

I have a number 7.511502463068333e-04. I want to put it in a cell. I used : B=[7.511502463068333e-04]; A=num2cell(...

6 years ago | 1 answer | 0

Question

find where number changes in a matrix

I have a matrix of +1 and -1 values. I want to find where the number flips from 1 to -1 or vice versa where the change is a chan...

6 years ago | 2 answers | 0

Question

save in a folder

Hi, I want to save in a folder mat files with a changing name. for i=1:length(ID) Filename=[num2cell(ID(i)) '...

6 years ago | 2 answers | 1

Question

Inserting a 1000 separator

Hi, I am building a table in which I need to insert numbers with a comman 1000 separator and two decimal points. For example: ...

6 years ago | 2 answers | 0

Question

finding the number of consecutive data

Hi, I have a vector of 5000 obeservations containing nan values and prices. How can I tell if this vector contains 60 consecu...

6 years ago | 1 answer | 0

Question

Filling the gaps in a vector

I have a vector of nans A=[nan;nan;2;nan;4;nan;nan;nan;7;nan;nan;nan;nan] how can I fill the nan gaps by the closest number ...

6 years ago | 4 answers | 0

Question

closest day a year back

Hi, I have a vector of dates and my alogorithm is picking one observation X in a loop. I want to go back an exactly year back...

6 years ago | 2 answers | 0

Answered

getting rid of a loop

Thanks Nirmal for your efforts but still it doesn't work. Just in case my question wasn't clear I will rephrase it here X has...

getting rid of a loop

Thanks Nirmal for your efforts but still it doesn't work. Just in case my question wasn't clear I will rephrase it here X has...

7 years ago | 0

Question

getting rid of a loop

Hi, I have a cell array X which has around 1 million rows. each row has a 1x18 cell in it. I want to select columns 4,5,10,18...

7 years ago | 2 answers | 0

Question

time to number conversion

I have a cell array that has the following format: v0={'1/4/2011','12:17:09'} I converted the date to number using the datenum...

7 years ago | 1 answer | 0

Question

parcing comma delimited column to multiple vectors and cell arrays

Hi, I am importing a series of CSV files of 18 columns each with different row sizes (can be up to 800,000 rows) using teh fo...

7 years ago | 1 answer | 0

Question

ismember for many datasets

Hi, I have many vectors sorted: A1,A2,.....A7 is it possible to know in one function which number is common between all of...

7 years ago | 2 answers | 0

Question

identifing the beginning and the end of a series

Hi, I have long vectors that have the following structures of zeros and ones: <0 1 1 1 1 1 1 1 0 0 0 0 0 0 1 ...

7 years ago | 1 answer | 0

Question

T test critical values

Hi, I am using regstats2 function to get the HAC Newey West t statistics. However, I want to compare this t test with a criti...

7 years ago | 0 answers | 0