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 
