indeHow to index values from a cell array
이전 댓글 표시
Hello. I am trying to index a cell array. Each cell stored in the variable DataE20 looks like this.
1.1244 1.1207 1.1209 1.1291 1.1294 1.1330 1.1320 1.1307 1.1303 1.1285 1.1273
1.1255 1.1231 1.1322 1.1298 1.1382 1.1358 1.1348 1.1332 1.1310 1.1299 1.1339
1.1188 1.1204 1.1208 1.1259 1.1246 1.1304 1.1302 1.1267 1.1269 1.1231 1.1270
1.1245 1.1203 1.1210 1.1293 1.1293 1.1330 1.1320 1.1306 1.1305 1.1287 1.1277
1.1344 1.1294 1.1311 1.1283 1.1259 1.1293 1.1335 1.1243 1.1277
1.1346 1.1323 1.1316 1.1328 1.1278 1.1364 1.1349 1.1305 1.1303
1.1279 1.1267 1.1264 1.1267 1.1249 1.1282 1.1268 1.1237 1.1262
1.1346 1.1293 1.1312 1.1285 1.1261 1.1291 1.1334 1.1244 1.1278
I am tryin to select the numbers where 1.1244 and 1.1278 are and store them in a variabe. This is the Open for the first day and the Close for the last day. I want to store the open for the first day in a variale called Start and the close for the Last day in a variable called Finish.
Here is my code so far:
data =readtable('EURUSD=X.csv')
Open = data(:,2);
High= data(:,3);
Low = data(:,4);
Close = data(:,5);
stackedplot(Open)
%Store the data Open,High, Low and Close for every 20 days in the variable
%DataE20
G = floor((0:height(data)-1)/20).' + 1;
DataE20 = splitapply(@(Date,Open,High,Low,Close,AdjClose,Volume) {[Open,High,Low,Close].'}, data, G)
celldisp(DataE20(1))
%Create Labels for every 20 days. If the last day close is greater than the
%first day open, then the label is 1. If the last day close if less than
%the first day open then it is a 0. A 1 indicates that the stock price has
%increased overall and a 0 indicates it has decreased overall for those 20
%days.
Data20 = DataE20(:)
Start = Data20(1,1)
Finish = Data20(4,20)
Any help will be greatly appreciated thank you.
채택된 답변
data =readtable('EURUSD=X.csv');
disp(data)
G = floor((0:height(data)-1)/20).' + 1;
DataE20 = splitapply(@(Date,Open,High,Low,Close,AdjClose,Volume) {[Open,High,Low,Close].'}, data, G);
Start (Open on day 1) and Finish (Close on day 20) for each block of 20 days:
Start = cellfun(@(x)x(1),DataE20)
Finish = cellfun(@(x)x(end),DataE20)
추가 답변 (0개)
카테고리
도움말 센터 및 File Exchange에서 Resizing and Reshaping Matrices에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
