ARS

Massey University

Last seen: 4年以上前 | 2012 年からアクティブ

Followers: 0 Following: 0

メッセージ

Qualifications: MBA, MFin
Professional Interests: programmed Trading

統計

ランク
4,013
of 298,292

評判
13

コントリビューション
24 質問
8 回答

回答採用率
70.83%

獲得投票数
6

バッジを表示

Feeds

回答済み
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...

約5年前 | 1

質問

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 ='...

約5年前 | 2 件の回答 | 1

2

回答

回答済み
[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 ...

9年以上前 | 0

質問

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 '...

9年以上前 | 2 件の回答 | 0

2

回答

質問

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 ...

10年弱前 | 1 件の回答 | 0

1

回答

質問

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...

11年以上前 | 1 件の回答 | 0

1

回答

回答済み
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...

12年弱前 | 0

質問

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 ...

12年弱前 | 2 件の回答 | 0

2

回答

回答済み
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)...

12年弱前 | 1

| 採用済み

質問

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...

12年弱前 | 1 件の回答 | 0

1

回答

回答済み
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 ...

約12年前 | 0

質問

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 ...

約12年前 | 2 件の回答 | 0

2

回答

質問

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...

約12年前 | 1 件の回答 | 0

1

回答

質問

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...

12年以上前 | 3 件の回答 | 0

3

回答

質問

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...

12年以上前 | 1 件の回答 | 0

1

回答

質問

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 ...

12年以上前 | 3 件の回答 | 0

3

回答

質問

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...

12年以上前 | 1 件の回答 | 0

1

回答

質問

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...

13年弱前 | 1 件の回答 | 0

1

回答

質問

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...

13年弱前 | 2 件の回答 | 0

2

回答

質問

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...

13年弱前 | 1 件の回答 | 0

1

回答

質問

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...

13年弱前 | 0 件の回答 | 0

0

回答

回答済み
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...

13年弱前 | 0

質問

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...

13年弱前 | 1 件の回答 | 0

1

回答

質問

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...

13年弱前 | 5 件の回答 | 1

5

回答

質問

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...

13年弱前 | 1 件の回答 | 0

1

回答

質問

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

13年弱前 | 0 件の回答 | 0

0

回答

回答済み
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...

約13年前 | 0

質問

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...

約13年前 | 2 件の回答 | 0

2

回答

質問

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 ...

約13年前 | 1 件の回答 | 0

1

回答

回答済み
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, ...

約13年前 | 1

| 採用済み

さらに読み込む