Shakti
03-09-2006, 01:36 AM
:banghead:
This is my first ever problem that I want you to teach me how to solve! PLEASE!
I was given portfolio of one person to find as on date value and profit loss share by ratio given.
I managed to sort data by script name and date now
In data given below I want to calculate net qty and net amt script name wise and if position of such script stands for more than 90 days I have to calculate profit by 50:50 ratio otherwise 60:40 ratio.
Plz see zip file attached herewith for details!
This is my first ever problem that I want you to teach me how to solve! PLEASE!
I was given portfolio of one person to find as on date value and profit loss share by ratio given.
I managed to sort data by script name and date now
In data given below I want to calculate net qty and net amt script name wise and if position of such script stands for more than 90 days I have to calculate profit by 50:50 ratio otherwise 60:40 ratio.
Plz see zip file attached herewith for details!