Rank: 190 based on 283 downloads (last 30 days) and 62 files submitted
photo

Michael Robbins

E-mail
Company/University
CIBC

Personal Profile:
Professional Interests:

 

Watch this Author's files

 

Files Posted by Michael View all
Updated   File Tags Downloads
(last 30 days)
Comments Rating
12 Nov 2008 Screenshot BreakPlot Produces a plot who's y-axis skips to avoid unnecessary blank space Author: Michael Robbins axis, break, graph, potw, specialized, plot 29 2
  • 5.0
5.0 | 1 rating
23 Oct 2008 Screenshot BinomialProbability Probability of surviving k of n trials where the outcome is to win or to lose. Author: Michael Robbins probability, chance, combination, permutation, binomial, survivor 4 0
05 Apr 2006 Screenshot mode Statistical mode. Author: Michael Robbins statistics, probability, mean, median, stats 2 9
  • 4.8
4.8 | 5 ratings
31 Jan 2006 Screenshot df2fts_ Fetch from bloomberg and put in financial time series object. Author: Michael Robbins finance, modeling, analysis, bloomberg fetch ftsgu... 3 1
26 Jan 2006 Screenshot FASTGETGRID Extracts values and formuals form all worksheets in a Microsoft Office Spreadsheet Object (OWC). Author: Michael Robbins gui tools, example, excel spreadsheet wor... 5 1
  • 5.0
5.0 | 1 rating
Comments and Ratings on Michael's Files View all
Updated File Comment by Comments Rating
17 Oct 2011 Tick2Bar Divides a time series into periods and returns high, low, open, close, volume. Author: Michael Robbins mathworks2011

sorry - copied an old version in by mistake. Pls see below:

function trade =cce_Tick2Bar_synchronous(t,p,g)
% error check
[t,tix]=sort(t);
p=p(tix);
vix=~isnan(p);
t=t(vix);
p=p(vix);

% create bins
mySynchTime=[floor(min(t)):g:ceil(max(t))];
[n,bin]=histc(t,mySynchTime); % n is the number of obs per bin

% pre-allocate
C=NaN(numel(n),1);
for i = 1: length(mySynchTime)
    if(i==1)
        from = 1;
    elseif(i == length(mySynchTime))
        from = cumsum(n(1:i-1));
        from = from(end);
    else
        from = cumsum(n(1: i-1));
        from = from(end) + 1;
    end
    to =cumsum(n(1:i));
    to = to(end);
    
    % These are the index numbers you are accessing
        %disp([num2str(from) ' ' num2str(to)]);
    
    %Observe which timestamps you are taking.
        %disp(datestr(t(from:to)));
    
    % As you are interested in the close, just take the last value
    tmp = p(from:to);
    if(isempty(tmp) && i ~=1)
        %we have no observations in that window. Thus no price change.
        tmp = C(i-1,1);
    elseif(isempty(tmp) && i ==1)
       %Special case. we are right at the start.
       tmp = p(1);
    end
    C(i,1) = tmp(end);
    clear tmp;
end

% Make sure you align correctly!
trade = timeseries(C(1:end-1), mySynchTime(2:end));

end

17 Oct 2011 Tick2Bar Divides a time series into periods and returns high, low, open, close, volume. Author: Michael Robbins mathworks2011

a good effort. Doesnt support synchronous data though. ie you may have a security which trades infrequently, yet you still want to map it on a discrete grid:

function trade =cce_Tick2Bar_synchronous(t,p,g)
% error check
[t,tix]=sort(t);
p=p(tix);
vix=~isnan(p);
t=t(vix);
p=p(vix);

% create bins
mySynchTime=[floor(min(t)):g:ceil(max(t))];
[n,bin]=histc(t,mySynchTime); % n is the number of obs per bin

% pre-allocate
C=NaN(n,1);
for i = 1: length(mySynchTime)
    if(i==1)
        from = 1;
        to = cumsum(n(1:i));
        to = to(end);
    elseif(i == length(mySynchTime))
        from = cumsum(n(1:i-1));
        from = from(end);
        to =cumsum(n(1:i));
        to = to(end);
    else
        from = cumsum(n(1: i-1));
        from = from(end) + 1;
        to =cumsum(n(1:i));
        to = to(end);
    end
    % These are the index numbers you are accessing
        %disp([num2str(from) ' ' num2str(to)]);
    
    %Observe which timestamps you are taking.
        %disp(datestr(t(from:to)));
    
    % As you are interested in the close, just take the last value
    tmp = p(from:to);
    if(isempty(tmp))
        %we have no observations in that window. Thus no price change.
        tmp = C(i-1,1);
    end
    C(i,1) = tmp(end);
    clear tmp;
end

% Make sure you align correctly!
trade = timeseries(C(1:end-1), mySynchTime(2:end));

end

17 Aug 2011 BreakPlot Produces a plot who's y-axis skips to avoid unnecessary blank space Author: Michael Robbins BERTIN, Aurélien

Works very well for my purpose. Most powerfull from my point of vue than breakxaxis for y-axis breaking

12 Aug 2010 graph_and_table Creates a graph and a data table below it. The table is put in an activex control using the column. Author: Michael Robbins Jeff

Is this control still available for free download? If so can you tell me where I might find it? I found a download at www.octatec.com for around $93.00. Or is there a better method now, 7 years later? Thanks.

08 Jul 2010 StringIsNumber STRINGISNUMBER returns 1 if the input string contains only a number and otherwise a zero. Author: Michael Robbins Simon, Jan

Another idea:
  [x, count, err, next] = sscanf(Str, '%g', 1);
  isNumber = (count == 1) && (next == numel(Str) + 1);

Top Tags Applied by Michael
example, gui tools, plot, strings, data export
Files Tagged by Michael View all
Updated   File Tags Downloads
(last 30 days)
Comments Rating
12 Nov 2008 Screenshot BreakPlot Produces a plot who's y-axis skips to avoid unnecessary blank space Author: Michael Robbins axis, break, graph, potw, specialized, plot 29 2
  • 5.0
5.0 | 1 rating
23 Oct 2008 Screenshot BinomialProbability Probability of surviving k of n trials where the outcome is to win or to lose. Author: Michael Robbins probability, chance, combination, permutation, binomial, survivor 4 0
05 Apr 2006 Screenshot mode Statistical mode. Author: Michael Robbins statistics, probability, mean, median, stats 2 9
  • 4.8
4.8 | 5 ratings
31 Jan 2006 Screenshot df2fts_ Fetch from bloomberg and put in financial time series object. Author: Michael Robbins finance, modeling, analysis, bloomberg fetch ftsgu... 3 1
26 Jan 2006 Screenshot FASTGETGRID Extracts values and formuals form all worksheets in a Microsoft Office Spreadsheet Object (OWC). Author: Michael Robbins gui tools, example, excel spreadsheet wor... 5 1
  • 5.0
5.0 | 1 rating

Contact us at files@mathworks.com