Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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????????????????
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????
Hi, sahana.
Here is another qvw with, I think, everything you want. Hope it helps.
Cheers.
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????
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?????????
I was able to resolve this ... thanks a lottttt for your help Bruno
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!