ARS
Massey University
Followers: 0 Following: 0
Qualifications: MBA, MFin
Professional Interests: programmed Trading
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...
대략 4년 전 | 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 ='...
4년 초과 전 | 답변 수: 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 ...
8년 초과 전 | 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 '...
8년 초과 전 | 답변 수: 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년 전 | 답변 수: 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...
10년 초과 전 | 답변 수: 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년 전 | 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년 전 | 답변 수: 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년 전 | 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년 전 | 답변 수: 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년 전 | 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년 전 | 답변 수: 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년 전 | 답변 수: 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...
11년 초과 전 | 답변 수: 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...
11년 초과 전 | 답변 수: 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...
거의 12년 전 | 답변 수: 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년 전 | 답변 수: 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년 전 | 답변 수: 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년 전 | 답변 수: 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년 전 | 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년 전 | 답변 수: 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년 전 | 답변 수: 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년 전 | 답변 수: 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년 전 | 답변 수: 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년 전 | 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년 전 | 답변 수: 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년 전 | 답변 수: 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년 전 | 1
| 수락됨