Set the X Axis as the Time Axis of a Stock Chart

Question

Dima 2011-9-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/16703-set-the-x-axis-as-the-time-axis-of-a-stock-chart

Hello!)

I have the following list of the OPEN, HI,LO,CLOSE prices and a column before them which shows the corresponding dates of the candles...

10.2007  0.6933  0.6962  0.6931  0.6934
10.2007  0.6933  0.6952  0.691  0.6932
10.2007  0.6931  0.6942  0.6911  0.6921
10.2007  0.6929  0.693  0.6897  0.6898
10.2007  0.6899  0.6934  0.6893  0.6923
10.2007  0.6922  0.6938  0.6905  0.6925
10.2007  0.6926  0.6993  0.6924  0.6981
10.2007  0.698  0.7006  0.6959  0.6963
10.2007  0.6964  0.6987  0.6947  0.6957
10.2007  0.6956  0.6976  0.6949  0.6972
10.2007  0.6974  0.6985  0.6959  0.6964
10.2007  0.6963  0.6993  0.6961  0.6993
10.2007  0.6992  0.7001  0.6958  0.6969
10.2007  0.6979  0.6994  0.6966  0.698
10.2007  0.6979  0.6981  0.6944  0.6953
10.2007  0.6952  0.6961  0.6936  0.6958
10.2007  0.6959  0.6987  0.6955  0.6984
10.2007  0.6983  0.7015  0.6978  0.7011
10.2007  0.7014  0.7019  0.6986  0.6996
10.2007  0.6994  0.6996  0.6964  0.698
10.2007  0.6981  0.6983  0.6949  0.6956
11.2007  0.6955  0.6962  0.6919  0.6941
11.2007  0.6942  0.6964  0.6938  0.6941
11.2007  0.6949  0.6963  0.6932  0.6956
11.2007  0.6955  0.6978  0.6949  0.6975
11.2007  0.6974  0.7002  0.6959  0.6967
11.2007  0.6966  0.6981  0.695  0.6965
11.2007  0.6964  0.7023  0.6958  0.702
11.2007  0.7033  0.7078  0.7007  0.7071
11.2007  0.7073  0.7078  0.7038  0.7049
11.2007  0.705  0.7144  0.7042  0.7143
11.2007  0.7142  0.7166  0.7121  0.715
11.2007  0.7151  0.7171  0.7136  0.7136
11.2007  0.7142  0.7163  0.7125  0.7155
11.2007  0.7154  0.7182  0.7139  0.7177
11.2007  0.7176  0.7212  0.7167  0.7197
11.2007  0.7196  0.721  0.7176  0.7197
11.2007  0.7198  0.7216  0.718  0.7192
11.2007  0.7191  0.7195  0.7161  0.7179
11.2007  0.718  0.7196  0.716  0.7172
11.2007  0.7174  0.718  0.7121  0.713
11.2007  0.7131  0.7164  0.7128  0.7151
11.2007  0.715  0.7163  0.7109  0.7112
12.2007  0.7123  0.7136  0.7088  0.7108
12.2007  0.7107  0.7178  0.709  0.7168
12.2007  0.7169  0.7238  0.7167  0.7204
12.2007  0.7203  0.7224  0.7176  0.7219
12.2007  0.7218  0.7231  0.7194  0.7218
12.2007  0.7211  0.7212  0.7178  0.7193
12.2007  0.7191  0.7214  0.7152  0.7199
12.2007  0.7203  0.7207  0.7162  0.7189
12.2007  0.7188  0.7208  0.7146  0.7164
12.2007  0.7165  0.7176  0.7139  0.7151
12.2007  0.7143  0.7156  0.7112  0.7129
12.2007  0.7128  0.7158  0.7118  0.7154
12.2007  0.7153  0.7205  0.713  0.72
12.2007  0.7201  0.7238  0.7193  0.7216
12.2007  0.7217  0.7255  0.7216  0.7248
12.2007  0.7245  0.729  0.7242  0.7285
12.2007  0.7282  0.7311  0.7278  0.73
12.2007  0.7301  0.7338  0.7276  0.7321
12.2007  0.732  0.7387  0.7307  0.7373
12.2007  0.7368  0.738  0.7318  0.7356
01.2008  0.7389  0.7449  0.7375  0.743
01.2008  0.7429  0.7483  0.7416  0.7473
01.2008  0.7474  0.7491  0.7424  0.7468
01.2008  0.7471  0.7481  0.744  0.746
01.2008  0.7461  0.7466  0.742  0.7454
01.2008  0.7456  0.7502  0.7447  0.7487
01.2008  0.7488  0.7565  0.7463  0.7548
01.2008  0.7547  0.7585  0.7535  0.7551
01.2008  0.7555  0.7611  0.7553  0.7611
01.2008  0.761  0.7613  0.7526  0.7547
01.2008  0.7548  0.7574  0.7439  0.7467
01.2008  0.7466  0.7481  0.7415  0.7424
01.2008  0.7425  0.7495  0.7418  0.7476
01.2008  0.7457  0.7462  0.7421  0.7436
01.2008  0.7435  0.7476  0.7396  0.7472
01.2008  0.7471  0.7486  0.744  0.7478
01.2008  0.7476  0.7489  0.7459  0.747
01.2008  0.7468  0.7478  0.7399  0.7402
01.2008  0.7406  0.7458  0.7391  0.7449
01.2008  0.745  0.7451  0.7416  0.7426
01.2008  0.7425  0.7482  0.7413  0.7472
01.2008  0.7473  0.7492  0.7445  0.7468
02.2008  0.7469  0.7543  0.7459  0.7531
02.2008  0.7532  0.7543  0.7487  0.7512
02.2008  0.751  0.7516  0.7444  0.7458
02.2008  0.7459  0.748  0.744  0.7453
02.2008  0.7454  0.7502  0.7444  0.7457
02.2008  0.7459  0.7466  0.7424  0.7452
02.2008  0.7461  0.7508  0.7437  0.7442
02.2008  0.7441  0.7462  0.743  0.744
02.2008  0.7441  0.7449  0.7413  0.7423
02.2008  0.7422  0.7438  0.7403  0.7436
02.2008  0.7437  0.7491  0.7429  0.7485
02.2008  0.7495  0.7521  0.7478  0.7507
02.2008  0.7506  0.7569  0.7506  0.7558
02.2008  0.7557  0.7579  0.7531  0.7575
02.2008  0.7576  0.758  0.7518  0.7547
02.2008  0.7548  0.7552  0.7522  0.7537
02.2008  0.7534  0.7554  0.7524  0.7539
02.2008  0.7538  0.7565  0.7514  0.755
02.2008  0.7551  0.7638  0.7536  0.7625
02.2008  0.7626  0.7642  0.7609  0.7635
02.2008  0.7634  0.7676  0.7625  0.763
03.2008  0.7655  0.7676  0.7633  0.7661
03.2008  0.7662  0.7673  0.7637  0.7658
03.2008  0.7659  0.7688  0.7646  0.7665
03.2008  0.7666  0.7692  0.7636  0.7653
03.2008  0.7652  0.7657  0.76  0.7625
03.2008  0.7622  0.7654  0.7595  0.7642
03.2008  0.7641  0.7678  0.7634  0.7645
03.2008  0.7646  0.7679  0.7626  0.7664
03.2008  0.7663  0.7694  0.7643  0.7681
03.2008  0.7682  0.7763  0.7664  0.776
03.2008  0.7787  0.7911  0.7783  0.7871
03.2008  0.7869  0.7884  0.7769  0.7785
03.2008  0.7784  0.7893  0.7777  0.7876
03.2008  0.7877  0.7885  0.7759  0.7777
03.2008  0.7778  0.7801  0.7766  0.7785
03.2008  0.7781  0.7791  0.7744  0.7759
03.2008  0.776  0.7828  0.7751  0.7799
03.2008  0.7798  0.7894  0.778  0.7888
03.2008  0.7887  0.7899  0.781  0.7876
03.2008  0.7878  0.7929  0.7859  0.7918
03.2008  0.792  0.7981  0.7897  0.7947
04.2008  0.7948  0.7958  0.7871  0.7901
04.2008  0.79  0.7902  0.7852  0.7887
04.2008  0.7888  0.7909  0.7822  0.7856
04.2008  0.7857  0.7895  0.7841  0.7894
04.2008  0.7888  0.7915  0.7867  0.7897
04.2008  0.7898  0.7989  0.7895  0.7978
04.2008  0.7977  0.8023  0.7967  0.8016
04.2008  0.8015  0.8032  0.7967  0.7984
04.2008  0.7983  0.8037  0.7977  0.803
04.2008  0.7987  0.8012  0.7961  0.8011
04.2008  0.801  0.8063  0.8007  0.8042
04.2008  0.8044  0.8098  0.8024  0.8081
04.2008  0.8082  0.8096  0.797  0.7986
04.2008  0.7987  0.7994  0.7875  0.7916
04.2008  0.7913  0.8042  0.7897  0.8037

I am using the Candle function to plot the above prices after they are imported from Excel. I wonder how do I set the X axis in such a way so that it shows the dates on major ticks based on the first date in the first column above (03.10.2007)?

Thanks!

D

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2011-9-26

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/16703-set-the-x-axis-as-the-time-axis-of-a-stock-chart#answer_22549

在 MATLAB Online 中打开

Let DateColumnCell be a cell array of strings containing the various dates you give above. Then,

XD = datenum(DateColumnCell,'DD.MM.YYYY');
plot using XD as the X axis
datetick('x','DD.MM.YYYY')

4 个评论
显示 2更早的评论隐藏 2更早的评论

Walter Roberson 2011-9-26

candle() has an unusual calling sequence, which I did not know when I replied earlier.

Do not call datetick() yourself. Instead, call

XD = datenum(DateColumnCell,'DD.MM.YYYY');

candle(HighPrices, LowPrices, ClosePrices, OpenPrices,

Color, XD, 'DD.MM.YYYY')

Dima 2011-9-26

thanks....please see the code below...I tried candle with the XD and it does not plot anything((

请先登录，再进行评论。

Answer 2

Dima 2011-9-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/16703-set-the-x-axis-as-the-time-axis-of-a-stock-chart#answer_22658

在 MATLAB Online 中打开

thank you very much for your replies...here is teh original code that imports the data from the testg.xls file:

[Num,Txt,Raw]=xlsread('testg.xls');
colors = {'r', 'b', 'g'};  %red, black, green
linetypes = {'-', ':'};   %dashed, solid
figure(1);hold on;
% grid;
% date = Num(6:end,56);
% matlabdate= x2mdate(date);
% datem=datestr(matlabdate);
% XD = datenum(date,'DD.MM.YYYY');
% candle(HighPrices, LowPrices, ClosePrices, OpenPrices,
% Color, XD, 'DD.MM.YYYY') 
candle(Num(7:end,3),Num(7:end,4),Num(7:end,5),Num(7:end,2),'k'); %,matlabdate,'DD.MM.YYYY');

The excel dates are placed in the BD column of the first sheet, the B TO E columns contain the prices....I am quite confused on how to make the Matlab show the correct dates on the X axis...as you will see above, this code converts the dates into matlab understandable format and then into the string.....but how do I use that with the Candle function remains hidden to me....can you please clarify?

I have uploaded the excel file here:

http://ifile.it/zn2eowi

Thanks!

D

9 个评论
显示 7更早的评论隐藏 7更早的评论

Walter Roberson 2011-9-26

But before the test mentioned above, I would try using candle() exactly the way you show above, generating the apparent blank chart, and then right afterwards, command

xlim([matlabdate(1)-1, matlabdate(end)+1])

and see if the plot appears.

Dima 2011-9-27

thank you very much for this help....I updated the above code a little, it had previously told me that the date numbers do not match:

%%

[Num,Txt,Raw]=xlsread('testg.xls');

colors = {'r', 'b', 'g'}; %red, black, green

linetypes = {'-', ':'}; %dashed, solid

figure(1);hold on;

grid;

dates = Num(6:900,56);

matlabdate= x2mdate(dates);

datem=datestr(matlabdate);

% XD = datenum(date,'DD.MM.YYYY');

% candle(HighPrices, LowPrices, ClosePrices, OpenPrices,

% Color, XD, 'DD.MM.YYYY')

candle(Num(6:900,3),Num(6:900,4),Num(6:900,5),Num(6:900,2),'k',matlabdate,'DD.MM.YYYY');

it does plot the candlestick chart with the dates on the x axis now...here is the snapshot

http://imageshack.us/photo/my-images/835/dateticks.png/

I have two more questions if you allow)

1)...one thing I would like to change is to have more date ticks on the X axis instead of only three as you see on that picture.....

2)I have one more question...there is a "10^5" label in the right hand corner of the chart, must be because the original serial date x values are high - I wonder how do I remove it...

Thanks for your help!

I love this place!)

D

请先登录，再进行评论。

Answer 3

Dima 2011-9-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/16703-set-the-x-axis-as-the-time-axis-of-a-stock-chart#answer_22699

I also had a separate question.....I wonder if it possible to assign a vector of the textual date ticks (taken from the serial date column imported from excel) to the already existing x axis that runs from o to 1000.

that would help a lot as I have some code that operates on the 0-1000 x axis labels to reduce the chart to show only the relevant price action.

THANKS!!!