Creating a start routine

[Former Member]

Hi

I need to create a start routine for the following. Please can someone assist.

1. Contracts ex ABC & XYZ with a start date pre 01/10/1998 whose days in arrears is < 122 days & the ratio of DI closing balance over collateral <= 80% will get a risk weighting of 50%, otherwise 100%.

2. Contracts ex ABC & XYZ with a start date on or post 01/10/1998 whose days in arrears is < 122 days & the ratio of DI closing balance over collateral <= 100% will get a risk weighting of 50%, otherwise 100%.

3. Other EFG residenial deals on or post start date 01/10/1998 whose days in arrears is < 122 days & the ratio of DI closing balance over collateral <= 100% will get a risk weighting of 50% otherwise 100%.

Thanks in advance. Will reward good points for resolution.

Niki

[Former Member · Accepted solution]

Niki,

Every thing is fine... one quick question... what do u mean by Otherwise.

Tell me one case where we need to assign the RW to 100%. Let us assume we have 5 contracts...

Contract Start Date Days Ratio DI risk weighting

X1 <01/10/1998 122 <=80% 50

X2 >=01/10/1998 122 <=80% 50

X3 >=01/10/1998 122 <=100% 50

E4(efg) <01/10/1998 122 <=100% 50

Tell me one case for 100%. you kept other wise for all the conditions. so you will get 100% eevrytime... if last otherwise executes. for 50% risk weighting ... it's perfect. for 100% devide in the same manner... then assign 100%. means ... contracts with days in arrears greater then 122... then we need to assign 100%. what do mean other EFG residential deals... is it also one type contract? put only one ELSE or... devide individually for every case.

All the best.

Nagesh Ganisetti.

[Former Member · Accepted solution]

Hi Nagesh

Thanks for the assitance.

What happens if the date < 01/10/98 and DI ratio is =90%, then risk weighting can be 100. Not sure if I'm confusing myself here.

If you think it maybe incorrect then lets ignore the otherwise for now.

EFG is one type of contract

Are you able to provide me with the start routine as I am new to routines

Niki

[Former Member · Accepted solution]

Niki,

we can include the condition also in start routine.

Contract StartDate Days Ratio DI risk weighting

X1 <01/10/1998 122 <=80% 50

X2 >=01/10/1998 122 <=80% 50

X3 >=01/10/1998 122 <=100% 50

E4(efg) <=01/10/1998 122 <=100% 50

put if <b>x1 and start date <19981001 and days<122 and Ratio <= 80%</b>.

Risk = 50%.

elseif x2.

risk = 50.

elseif x3.

Risk = 50.

else if E4.

risk = 50.

else.

risk = 100.

endif.

I think this will include all the cases. check it out, try to put all the possibilities. As you said... DI ratio is 90%, all the if stattements will be failed. last else statement will be processed. that is 100. try consider all the cases.

Regards,

Nagesh Ganisetti.

[Former Member]

Hi Strini

Fields are coming from diff datasources/infosources.

Thanks

Niki

[Former Member]

Hi Niki,

You can do this. But your conditions are overlaping. can you check once again.

All the fields start data, arrears, ration of DI closing balance and risk weghting are you getting from same datasource or infosource or you have to fetch data from any other tables...??

IF all the fields coming in one data source or infosurce, you can do it at field level routine, no need of start routine.

Hope it Helps

Srini