photo

ARS


Massey University

Last seen: 4 years 前 |  自 2012 起处于活动状态

Followers: 0   Following: 0

消息

Qualifications: MBA, MFin
Professional Interests: programmed Trading

统计学

  • Thankful Level 3
  • Knowledgeable Level 1
  • First Answer

查看徽章

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

9 years 前 | 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 years 前 | 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...

11 years 前 | 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 ...

11 years 前 | 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)...

11 years 前 | 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...

11 years 前 | 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 ...

11 years 前 | 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 ...

11 years 前 | 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...

11 years 前 | 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 years 前 | 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 years 前 | 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 years 前 | 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 years 前 | 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...

12 years 前 | 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...

12 years 前 | 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...

12 years 前 | 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...

12 years 前 | 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...

12 years 前 | 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...

12 years 前 | 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...

12 years 前 | 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...

12 years 前 | 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'); ...

12 years 前 | 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...

12 years 前 | 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...

12 years 前 | 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 ...

12 years 前 | 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, ...

12 years 前 | 1

| 已接受

加载更多