Spreadsheet: 105581d1302886821-get-data-from-a-table-in-the-right-order-question-money-in-15-04
Sheet: Sheet1

DAYS |  |  |  |  |  |  |  |  |  |  |  |  |  | DAYS--> | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32
0 | OPEN | LOW | HIGH |  |  |  |  | 100 | # options |  | MONEY IN | Right answers
1 | 0.35 | 0.35 | 0.35 |  |  |  |  |  | 1 |  |  |  |  | 1 | 0
2 | 0.4 | 0.4 | 0.4 |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0
3 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 1
4 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 1 | 1
5 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 5 | 0 | 0 | 1 | 1 | 1
6 | 0.25 | 0.2 | 0.25 |  |  |  |  |  | 2 |  |  |  |  | 6 | 0 | 0 | 1 | 1 | 1 | 0
7 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 7 | 0 | 0 | 1 | 1 | 1 | 0 | 1
8 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 8 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1
9 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 9 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1
10 | 0.15 | 0.15 | 0.3 |  |  |  |  |  | 5 |  |  | 0.75 |  | 10 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1
11 | 0.1 | 0.1 | 0.1 |  |  |  |  |  | 1 |  |  |  |  | 11 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0
12 | 0.25 | 0.15 | 0.25 |  |  |  |  |  |  |  |  | 0.1 |  | 12 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0
13 | 0.15 | 0.15 | 0.2 |  |  |  |  |  | 4 |  |  |  |  | 13 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 0
14 | 0.3 | 0.25 | 0.35 |  |  |  |  |  |  |  |  | 0.6 |  | 14 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0
15 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 15 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1
16 | 0.25 | 0.25 | 0.25 |  |  |  |  |  | 1 |  |  |  |  | 16 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0
17 | 0.2 | 0.2 | 0.2 |  |  |  |  |  |  |  |  |  |  | 17 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0
18 | 0.15 | 0.15 | 0.15 |  |  |  |  |  |  |  |  |  |  | 18 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
19 | 0.15 | 0.15 | 0.15 |  |  |  |  |  | 4 |  |  |  |  | 19 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
20 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 20 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1
21 | 0.05 | 0.05 | 0.05 |  |  |  |  |  | 8 |  |  |  |  | 21 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0
22 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 22 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1
23 | 0.15 | 0.15 | 0.15 |  |  |  |  |  | 4 |  |  | 0.4 |  | 23 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0
24 | 0.1 | 0.1 | 0.25 |  |  |  |  |  |  |  |  | 1.2 |  | 24 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
25 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 25 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1
26 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 26 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1
27 | 0.05 | 0.05 | 0.05 |  |  |  |  |  | 1 |  |  |  |  | 27 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0
28 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 28 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 1
29 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 29 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 1
30 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 30 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 1
31 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 31 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 1 | 1
32 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 32 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  | By # options you can see which options you bought and how many (you can also see it by the yellow marks)
 |  |  |  |  |  |  |  |  |  |  |  | So if you bought B4 you have to look to look in the table at collumn P  if you sold this one ( you didn't so value keeps 0)
 |  |  |  |  |  |  |  |  |  |  |  | Look at the next B9, look in collumn U if you sold this one (You didnt't)
 |  |  |  |  |  |  |  |  |  |  |  | Look at the next B13, look in collum Y if you sold this one ( you sold this one the first dat so in collumn money in you put at [NAME] (8*B13)
 |  |  |  |  |  |  |  |  |  |  |  | And this goes on
 |  |  |  |  |  |  |  |  |  |  |  | If you sold an option at day 14 put it in in the table at day 14