Question

Data extraction from .txt file

I have a LARGE minute data set in the format of: 10/21/2002,0601,0.97360,0.97360,0.97360,0.97360,0,0 10/21/2002,0602,0.9...

5 years ago | 5 answers | 0

Question

mle for a custom distribution fit error

Hi all, I am trying to use a code I found on-line which should work, but I am getting an error. It is trying to estimate para...

6 years ago | 0 answers | 0

Question

How to import some large data please

Hi all I have a file called DJ.csv which has 5 columns. 1) Dates (01/02/2007), 2) Times (30.42.0), 3) prices 12553, 12442, 4) Co...

7 years ago | 1 answer | 0

Question

finding the location of the maximum of N periods

Hi all, I have prices of a financial time series in a matrix "Thai" of size "4048x1". I want to create a new matrix of size 4...

7 years ago | 2 answers | 0

Question

using the tsmovavg function

Hi all, I am trouble using the function named tsmovavg. output = tsmovavg(tsobj, 's', lag) tsobj = Financial time series ...

7 years ago | 0 answers | 0

Question

location of non zeros

Hi there if I have a 100x1 matrix which has some zeros in it, how can i find the corresponding matrix of "locations" for all the...

7 years ago | 2 answers | 0

Question

fill in zeros in a matrix

Hi all, I have a 1000x1 double matrix. It is full of numbers....but on some situations I get multiple 0s. Whenever I encounte...

7 years ago | 2 answers | 0

Question

Converting elements which repeat more than 10 times to 0

Hi there, I have an array (4048x1) full of 1s and -1s. I want change it so that, if there are more than 10 consecutive 1s or 10 ...

7 years ago | 2 answers | 0

Question

Having difficulty filtering data and extracting some information from data.

Dear all, I have a 1x3 Cell. In these 3 cells I have: Column 1 (cell 600000 x 1), with dates in the form of mm/dd/yyyy Co...

8 years ago | 1 answer | 0

Question

How can I extract only 3 columns from a large CSV without running out of memory?

I have huge CSV files containing financial trade prices. The CSV files (when opened in excel), show 5 columns. I want to extract...

8 years ago | 1 answer | 0

Question

Way of conserving memory when extracting data from CSV

Hi everybody I have few questions. I have some HUGE CSV files which I need in Matlab for analysis. The CSV it self has 5 columns...

8 years ago | 2 answers | 0

Question

Method of extracting data from CSV

Dear All, I have a very large CSV file with 5 columns which contains some historical financial prices. Column 1 is our date ...

8 years ago | 1 answer | 0

Question

Simultaneous calculations (vectorization or for loops)

How can I do thousands of calculations simultaneously? Lets say for instance I have 50k variables and I want to do some complex ...

8 years ago | 0 answers | 0

Question

matrix question (finding the smallest number in each row)

I have a matrix B, of size 1455x2. I want a matrix C of size 1455x2 which gives me the matrix B but, if there is a non-negative ...

8 years ago | 1 answer | 0

Question

Data manipulation of a financial time series

Hi all I have a 1x1 Struct called "ans". Within this I have a textdata matrix of size 5 million x 4. Now in this textdata I ...

8 years ago | 1 answer | 0

Question

Trying to upload a CSV in matlab

Hi all, I am trying to upload a csv file. I tried two methods (as follows with errors): >> importdata('C:\Users\Mate2u\Deskto...

8 years ago | 1 answer | 0

Question

location of 10 highest values

Hi all, I have a 1x34 matrix. I want to find the location of the 10 largest values. So the output should be 1x10 and have values...

8 years ago | 2 answers | 0

Question

Kurtosis ignoring 0s in matrix

Hi there, I was wondering I have a matrix A of size 295x34. I want to do the kurtosis, but want to ignore all zeros. How can ...

8 years ago | 1 answer | 0

Question

Standard deviation ignoring 0s in matrix

Hi all, I have a 295x34 matrix called Absy. I want to take the standard deviation of all the columns, however some columns conta...

8 years ago | 2 answers | 0

Question

rows which do not contain zero

Hi all, I have a matrix D = 294x34. I want to output the number of rows which which may contain a number (so I want the the numb...

8 years ago | 3 answers | 0

Question

total number of elements which are not zero

I have a matrix "Percey" of size 294x34. I want a new matrix "B" which is 294x1 where each row the number of numbers which are n...

8 years ago | 1 answer | 0

Question

returns on a portfolio

Hi all, I have a matrix called ETNWED which is a set of historical prices of 34 Shares. The size is 294x34 where there is 295 we...

8 years ago | 0 answers | 0

Question

matrix turning nans to 1

Hi all, I have a 294x1 matrix, and I want to convert all the NaNs to 1. If anybody could assist me I would be grateful. Th...

8 years ago | 1 answer | 0

Question

sum of products of matrix

Hi all I have a matrix of size 294x34. I want to to have the products of all rows so I get a 294x1 matrix of all the products of...

8 years ago | 1 answer | 0

Question

plot with dates on matlab

Hi All, I have some historical time series prices for some assets in a matrix of size 295x34. (Matrix called Absy) Also I hav...

8 years ago | 1 answer | 0

Question

legend on a plot.

Hi All, I Plot a 250x10 matrix. But I only want the legend for the 3rd 5th and 9th element. How can I do this?

8 years ago | 1 answer | 0

Question

Deleting certain columns in a matrix

Hi all, I have a 267x34 matrix. Now I want to delete certain columns within MATLAB. For instance if I want to delete the 3...

8 years ago | 2 answers | 0

Question

loop on a strfind

Hi all, I have a loop as such: parfor i =1:1000000 ZZ= strfind(A2,lm(i,:)); end now this lm is fine it's a...

8 years ago | 1 answer | 0

Question

2 data sets - Need to make the same size!

*EDITED-HAD AN ERROR CHANGE THE ARRAY SIZE OF B NOW* Hi Everybody.. I have 2 big data sets. Data set 1 is contained in ...

8 years ago | 1 answer | 0

Question

Delete unique element in column

Hi I have a 25,000,000x2 matrix. I want to delete all Rows which have the same elements in column 1. So I would require only uni...

8 years ago | 2 answers | 0