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 
