Community Profile

photo

ARS


Massey University

Last seen: plus de 3 ans il y a |  Actif depuis 2012

Followers: 0   Following: 0

Contact

Qualifications: MBA, MFin
Professional Interests: programmed Trading

Statistiques

  • Thankful Level 3
  • Knowledgeable Level 1
  • First Answer

Afficher les badges

Feeds

Afficher par

A répondu
How do you pass MATLAB date (or user input) to SQL query for execution
Hi, Thanks for your answer but this one didn't work for me. I used the following and it works: selectquery = 'SELECT * FROM m...

environ 4 ans il y a | 1

Question


How do you pass MATLAB date (or user input) to SQL query for execution
>> myDate= datetime('2020-01-01'); >> selectquery = 'SELECT * FROM myTABLE WHERE reportDate >= '''myDate''' AND portfolio ='...

plus de 4 ans il y a | 2 réponses | 1

2

réponses

A répondu
[DEPRECATED] What frustrates you about MATLAB?
One thing which I find frustrating is that If X=[NaN NaN NaN] Then nanmean(X)=> NaN Whereas nansum(X)=> 0 This ...

plus de 8 ans il y a | 0

Question


Manipulating data in Cell Arrays
Hi All I have a simple question as follows: I have a cell matrix of size (20 X 20). All cells are filled with data like '...

plus de 8 ans il y a | 2 réponses | 0

2

réponses

Question


Weekly to six monthly sum
Hi All I have a matrix (named "X") with dimension 2196,7 Matlab (weekly) dates are in the first column and next 6 columns ...

presque 9 ans il y a | 1 réponse | 0

1

réponse

Question


merging two matrices (cell matrices)
Hi, I have two cell matrices with same dimensions (63,820) for each cell of Matrix AA there is a corresponding numeric val...

plus de 10 ans il y a | 1 réponse | 0

1

réponse

A répondu
How to create matrices and change matrix names in a for loop (Sprint and Eval) ?
Hi, No, I wish to retain it as a cell array and thats why it ends with {}. I want the cell array name to be from Period1Retu...

presque 11 ans il y a | 0

Question


How to create matrices and change matrix names in a for loop (Sprint and Eval) ?
Hi, I have the following loop. periods=28 *for z=1:periods Period(z)Return{s,j}= open - close ...

presque 11 ans il y a | 2 réponses | 0

2

réponses

A répondu
Where is the intercept in regress
Hi, In my limited knowledge, you will have to include a very first column of 'ones' in the independent variables side(matrix)...

presque 11 ans il y a | 1

| A accepté

Question


Getting element row and column (index location) out of a matrix?
Hi, I have a correlation output matrix which I obtain through function *Resultant= Corr(x)* Let Resultant be a 10x...

presque 11 ans il y a | 1 réponse | 0

1

réponse

A répondu
how to treat dataset as matrix
If you are talking about converting a dataset array then this might be a possible solution. First convert your dataset array ...

environ 11 ans il y a | 0

Question


merging two matrices (cell matrices)
Hi, I have two Matrices of dimension A=(63x181) and B=(63x181) I wish to get a matrix 'C' which has its first column from A ...

environ 11 ans il y a | 2 réponses | 0

2

réponses

Question


Help in Syntax of Eval and Sprintf
Hi, I want to run the following expression: *X = fts2mat(ESP('01-Jan-97::31-Dec-2012'))* The above statemement works...

environ 11 ans il y a | 1 réponse | 0

1

réponse

Question


wald test or test of equality of means
Hi, I am interested in finding a test of equality of two means (*mu1=mu2*). Is there any function/command in matlab through...

plus de 11 ans il y a | 3 réponses | 0

3

réponses

Question


finding mean and storing in a new cell
Hi, I have the following data series: -0.01342 -0.00200 0.04210 0.01854 0.07183 0.01343 0.07494 0.0...

plus de 11 ans il y a | 1 réponse | 0

1

réponse

Question


finding average of a percentile of rows in a matrix?
Hi All, In the below given matrix, I wish to calculate the mean/average of first 20% rows and subtract it from the mean of ...

plus de 11 ans il y a | 3 réponses | 0

3

réponses

Question


isnan in Dataset Array
Hi All, I am sorting a dataset array "RR2" with the below given code and it works perfect. But it positions the rows with NaNs a...

plus de 11 ans il y a | 1 réponse | 0

1

réponse

Question


for loop in matrix names (Syntax)
Hi All, I want to use a new vector every time in my function using for loop. My code is as follows: for g=1:40 hac=re...

presque 12 ans il y a | 1 réponse | 0

1

réponse

Question


for loop
Hi All, I have a basic syntax question regarding a for loop. I am trying to change the matrix(struct) name in a loop to copy...

presque 12 ans il y a | 2 réponses | 0

2

réponses

Question


Matlab integer accuracy VS MS EXCEL
Hi All, I am exporting my time series data from EXCEL to MATLAB as time series objects (fints). Now after exporting, the e...

presque 12 ans il y a | 1 réponse | 0

1

réponse

Question


t-test, HAC Standard Errors, Statistics, Time series
Hi All, I want to test the significance of a financial time series using t-stats. But I want to use Hetroskedasticity and ser...

presque 12 ans il y a | 1 réponse | 0

0

réponse

A répondu
Memory Pre allocation, Dataset Array
Hi All, This is for the info of the MATLAB community that when I used dataset array in my loops which had 44340 iterations, t...

presque 12 ans il y a | 0

Question


Cell Array Indexing is Much Much Much Superior to Dataset Indexing(Life is in peace now)
Hi All, This is for the info of the MATLAB community that when I used dataset array in my loops which had 44340 iterations, t...

presque 12 ans il y a | 1 réponse | 0

1

réponse

Question


Memory Pre allocation, Dataset Array
Hi All, How Can I Pre allocate memory for a DATASET ARRAY which should have 69 Rows and 740 Columns. There is another datas...

presque 12 ans il y a | 5 réponses | 1

5

réponses

Question


Error "Too many DATANAMES" for number series
Hi all, I am loading a time series file from Excel to Matlab which contains 208 columns and 700 rows. But as soon as pressing...

presque 12 ans il y a | 1 réponse | 0

1

réponse

Question


Inconsistent Performance by MATLAB 2010b
Hi All (specially MATLAB developers) I run the following code for k=1:783 sortedfile=sortrows(tosort,k,'descend'); ...

presque 12 ans il y a | 1 réponse | 0

0

réponse

A répondu
Date in a loop
Also I found another good way to do that: sortednew{c,r}= fts2mat(Apple.ARG(Spot.dates(r)) - fts2mat(Applenew.ARG(Spot.da...

environ 12 ans il y a | 0

Question


Date in a loop
Hi All, I am using the following code to use a sorted file which matches elements of sorted file with financial time series t...

environ 12 ans il y a | 2 réponses | 0

2

réponses

Question


looping in Dataset Array
Hi All, I am using a Dataset array named myarray of dimension 6x40 including headers. I wish to loop through each element ...

environ 12 ans il y a | 1 réponse | 0

1

réponse

A répondu
XLSwrite to write in a different column in each iteration
Hi, This solves the purpose...first create a dataset array of sorted names and then export to excel.... for k=1:39, ...

environ 12 ans il y a | 1

| A accepté

Charger plus