## how can I delete a full row based on a if condition?

on 10 Mar 2013

### Walter Roberson (view profile)

for example if I have a matrix with call (1) and putoption (2) data and I would like to have only the calloption data. Iwas thinking maybe I could run a for condition and create a new matrix just using the call data, is that possible?

## Products

No products are associated with this question.

### Walter Roberson (view profile)

on 10 Mar 2013

Yes, that is one option. Another is (e.g.)

```idx = (profit < 0);
funds(idx,:) = [];
```

Locks

### Locks (view profile)

on 10 Mar 2013

I am still not sure how does should work. For example, I have the following matrix: 1270.35 1110 2 0.5250 0.052 734506 0.0026425 1270.35 1115 2 0.5500 0.052 734506 0.0026425 1270.35 1120 2 0.5750 0.052 734506 0.0026425 1270.35 1125 2 0.600 0.052 734506 0.0026425 1270.35 1130 2 0.700 0.052 734506 0.0026425 1270.35 1135 2 0.8500 0.052 734506 0.0026425 1270.35 1165 1 107 0.052 0.0026 0.0026425

an so on

first column: future price 2nd column: strike 3rd: 2=put, 1=call 4th: option price 5th: time to maturity 6th: date 7th: interest rate

the total matrix consist of 150'000 columns of call and put optiondata, how can I create a matrix out of this with just the data of the put options? and how can I create another one with just the call option data?

### Locks (view profile)

on 10 Mar 2013
Edited by Walter Roberson

### Walter Roberson (view profile)

on 10 Mar 2013

I am still not sure how does should work. For example, I have the following matrix:

``` 1270.35 1110 2 0.5250 0.052 734506 0.0026425
1270.35 1115 2 0.5500 0.052 734506 0.0026425
1270.35 1120 2 0.5750 0.052 734506 0.0026425
1270.35 1125 2 0.600 0.052 734506 0.0026425
1270.35 1130 2 0.700 0.052 734506 0.0026425
1270.35 1135 2 0.8500 0.052 734506 0.0026425
1270.35 1165 1 107 0.052 0.0026 0.0026425```

an so on

first column: future price 2nd column: strike 3rd: 2=put, 1=call 4th: option price 5th: time to maturity 6th: date 7th: interest rate

the total matrix consist of 150'000 columns of call and put optiondata, how can I create a matrix out of this with just the data of the put options? and how can I create another one with just the call option data?

### Cedric Wannaz (view profile)

on 10 Mar 2013
Edited by Cedric Wannaz

### Cedric Wannaz (view profile)

on 10 Mar 2013

If your data is stored in a 150000x7 matrix D, you can build D_call and D_put as follows:

``` D_call = D(D(:,3)==1,:) ;
D_put  = D(D(:,3)==2,:) ;```

### Locks (view profile)

on 10 Mar 2013

great, thats working! thank you very much

Azzi Abdelmalek

### Azzi Abdelmalek (view profile)

on 17 Mar 2013

Sven, you have to accept the answer that helped you by clicking accept this answer

Jan Simon

### Jan Simon (view profile)

on 18 Mar 2013

@Sven: You do not have to accept an answer, but it would be helpful for the readers and for the author of the answer. So please take the time to accept an answer, such that this question is marked as "solved".

Cedric Wannaz

### Cedric Wannaz (view profile)

on 18 Mar 2013

Thank you Azzi and Jan; I stopped making this kind of remarks, but I should have gone on. I appreciate that you took the time to do it!