Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have attached QVW file which has VaR column. I need to get Previous days VaR under the "Previous Days VaR" column show in QVW. Kindly advise
Also, I need to calculate IVaR, the working on IVaR has saved in the attached excel. This needs to be populated under IVaR column in the QVW please.
Many thanks for your kind help.
Regards
Deepak.
I still don't think what you want... but here I gave it a shot. Now unless you can give me the exact numbers, I might not be able to help you any further.
Hi Sunny,
I have attached QVW with 3mnth column. I have created this QVW to clarify on the sparkline trend. In this qvw I have 30days data too. So, in 3mnth column I need to get the sparkline for 30days please. Also, when we calculated IVaR, can we show the numbers for the child portfolios too. Currently they are blank like this "-".
I think you need to slow down a little here. You have 3-4 different requirements asked all at once. Can you break your requirements into bullet points and go over each one of them in detail with the expected output based on the sample provided. This way I will have a much better chance of answering all of them... right now, we have 2-3 things already going on and I have no idea what is resolved and what isn't.
For your 1st requirement... is this what you are looking for?
For the 3 month requirement... what is the output in numerical terms you are looking to get? I guess pick one of the Desk... for example FXO - Global Options and tell me what is the trend values are going to be for the COBDate 25/06/2018?
How does this look like?