clear; 
clc;
[num, txt]=xlsread('BDE - Kopie'); 
tday=txt(2:end, 1); 
tday=datestr(datenum(tday, 'mm/dd/yyyy'), 'yyyymmdd'); % convert the format into yyyymmdd.

tday=str2double(cellstr(tday)); 

cls=num(:, end); 

[tday sortIndex]=sort(tday, 'ascend');
cls=cls(sortIndex); 
dailyret=(cls(2:end)-cls(1:end-1))./cls(1:end-1); 

excessRet=dailyret - 0.04/252; 

sharpeRatio=sqrt(252)*mean(excessRet)/std(excessRet)