![photo](/responsive_image/150/150/0/0/0/cache/matlabcentral/profiles/8820449_1522129608258_DEF.jpg)
John
University of Cape Town
Followers: 0 Following: 0
Statistics
14 Questions
0 Answers
RANK
39 036
of 293 508
REPUTATION
1
CONTRIBUTIONS
14 Questions
0 Answers
ANSWER ACCEPTANCE
64.29%
VOTES RECEIVED
1
RANK
of 20 037
REPUTATION
N/A
AVERAGE RATING
0.00
CONTRIBUTIONS
0 Files
DOWNLOADS
0
ALL TIME DOWNLOADS
0
RANK
of 148 733
CONTRIBUTIONS
0 Problems
0 Solutions
SCORE
0
NUMBER OF BADGES
0
CONTRIBUTIONS
0 Posts
CONTRIBUTIONS
0 Public Channels
AVERAGE RATING
CONTRIBUTIONS
0 Highlights
AVERAGE NO. OF LIKES
Feeds
Question
Calculations on cell pairs that meet multiple pre-defined criteria?
*My goal: Depending on which of the 5 scenarios is prevalent in each row (cell pairs in red, see below), make the calculation fo...
mer än 7 år ago | 0 answers | 0
0
answersQuestion
Matlab's writetable() function only exporting partial data of a table
The _writetable()_ function at the end of my code only exports the first row (namely FR_1w, FR_2w and FR_3w), whereas I *wan...
mer än 7 år ago | 2 answers | 0
2
answersQuestion
Matlab's Movsum() doesn't start calc at defined starting point X in frame [X X+t]
Suppose the following: A = [1;2;3;4;5;6;7]; A1 = table(A); <</matlabcentral/answers/uploaded_files/68439/Screen%20Sho...
mer än 7 år ago | 1 answer | 0
1
answerQuestion
Matlab's 'VariableNames' not accepting mix of numerical & non-numerical entries
Suppose we have a 1x3 table: A=table(1,2,3); whose header names should contain a mix of numericals and non-numericals: ...
mer än 7 år ago | 1 answer | 0
1
answerQuestion
How to create “Date” containers in Matlab, ignoring months and years?
My goal is to extract specific rows from a table (see below) that fall into specific "date" containers, e.g. month-end ( *25th-3...
mer än 7 år ago | 3 answers | 1
3
answersQuestion
How to overwrite 'NaN' strings in a table using the for-loop
I want to replace the strings 'NaN' with NaN in my table using a loop / or any other strategy that returns NaN, leaving all else...
mer än 7 år ago | 2 answers | 0
2
answersQuestion
Trailing Sum Calculation using pre-defined kernel starting at incorrect cell
Table Z: <</matlabcentral/answers/uploaded_files/67273/Screen%20Shot%202017-01-11%20at%2010.53.19%20AM.png>> *Goal*: Ca...
mer än 7 år ago | 1 answer | 0
1
answerQuestion
How to transform 'double' into 'cell array'?
My code: B = zeros(height(A),1); col_names = A.Properties.VariableNames; % Replicate header names for k = 1:height(A...
mer än 7 år ago | 1 answer | 0
1
answerQuestion
How to let Matlab know 'NaN' should be treated as NaN?
I have imported the following .xlsx file into Matlab: <</matlabcentral/answers/uploaded_files/66987/Screen%20Shot%202017-01-0...
mer än 7 år ago | 0 answers | 0
0
answersQuestion
How to use "movsum()" with panel data in a table using loop mechanisms?
I have the following 606 x 281 table ('ABC'): <</matlabcentral/answers/uploaded_files/66545/Screen%20Shot%202016-12-31%20at%2...
mer än 7 år ago | 2 answers | 0
2
answersQuestion
How to calculate Trailing Moving Sums going up vertically in a table?
I have the following _table_: <</matlabcentral/answers/uploaded_files/66397/Screen%20Shot%202016-12-28%20at%2010.51.15%20AM.p...
mer än 7 år ago | 1 answer | 0
1
answerQuestion
How to use the Percentile Function for Ranking purpose?
*Goal*: For _every date_ calculate lower and upper 20% percentiles and, based on the outcome, create 2 new variables, e.g. '...
mer än 7 år ago | 1 answer | 0
1
answerQuestion
How to calculate Sums in a Panel Data framework using "For Loops"
The following table consists of *Price Returns* returns at different *Dates*: <</matlabcentral/answers/uploaded_files/65818/S...
mer än 7 år ago | 1 answer | 0
1
answerQuestion
Using panel data, how can I create a new table with weekly price data based on a table with daily price data, for every stock?
My current table (dimension 743644 x 3) consists of Column 1 'Ticker' (278 different stock tickers), Column 2 'Date' (daily fo...
nästan 8 år ago | 1 answer | 0