weird requirement,please can someone help me out with this issue???????

[#1]

Hi all ,

I have a peculiar issue please help me in resolving the same.

I have a table as shown in the file attached.the field to be considered is market value .I want the output in the below manner .

1)my market value needs to be rounded to 1 decimal place ,consider the minimum,+3 and -3 to increase its limit.

2)ie: each position id should have all the market values in it and buy calls and same should repeat for other is's as well.so that when I plot a graph where market value being x axis and position id as y axis I would like t get it in a line graph.Is this possible can someone please help.

position is	market value_1	buycall
162648	76.8	-0.15
162648	76.9	-0.15
162648	77	-0.15
162648	.	-0.15
162648	.	-0.15
162648	89.9	-0.15
162649	76.8	-0.15
162649	76.9	-0.15
162649	77	-0.15
162649	.	-0.15
162649	.	-0.15
162649	89.95	-0.15
159949	76.8	-0.52
159949	76.9	-0.52
159949	77	-0.52
159949	.	-0.52
159949	89.9	-0.52

[#2]

Hi Bruno,

thanks a lot for the solution provided.

I have one doubt,now where can I place my 4 'if' statements??? because it has to take the market _value_1 which is coming from the code provided by you  instead of the old market value and the rest of the fields present in the expresssion   from data_.so how do I join these so that my buy call,sell call,buy put and sell put get calculated using the new market_value1 data ???????

please can you help in sorting out this????????????????

[#3]

Hi.

need help pl..??????????????

presently I am able to take up the new fields and calculate my buy_call expression in the front end table.But how do I finish this off in the script level itself????

[Anonymous]

Hi, sahana.

Here is another qvw with, I think, everything you want. Hope it helps.

Cheers.

[#5]

Hi Bruno,

Thanks for the solution provided.

I have tried to combine the 4 if statements into a single column as shown in the attached file,but the result is not the same.I am actually bad at nested if's .Can you please check the same and re-correct it please?????????????

and there is another exp a in the chart in sheet 3.Can we put this expression as a filter into the script itself??? I tried it but that time no data comes in the front end.can we do this????

[#6]

hi,

As shown in the file attached the combined if statement in the script to match the values

buy/call

sell/call

buy/put

sell/put

according to their respective conditions.

please can you help?????????

[#7]

I was able to resolve this ... thanks a lottttt for your help Bruno

[Anonymous]

Hi, Sahana.

You're welcome. Sorry I was not able to get back to you earlier. I'm glad you managed to solve your problem.

Cheere!