MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

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

Asked by Locks on 10 Mar 2013

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.

Answer by Walter Roberson on 10 Mar 2013

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

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

1 Comment

Locks 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?

Answer by Locks on 10 Mar 2013
Edited by Walter Roberson 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?

Answer by Cedric Wannaz on 10 Mar 2013
Edited by Cedric Wannaz 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,:) ;```

Answer by Locks on 10 Mar 2013

great, thats working! thank you very much

Azzi Abdelmalek on 17 Mar 2013

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

Jan Simon 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 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!