Amazingly they're still very useful, mine's one of the old 'two-thumb' models which make it look as if i'm playing a PSP!

This is a facility i'm trying to create for another area.

There are 8 variables:

Swap Rate 1 Rate 2 Days Basis 1 Basis 2 Spot Coefficient

Typically the last five are know and then you know at least two of the first three.

I can't seem to upload a file but if you use these variables:


Rate 1 Rate 2 Days Basis 1 Basis 2 Spot Coefficient
5.2 2 30 360 360 1.25 10000

And this formula:

=(((1/(1+(G4%*I4)/J4))/(1/(1+(H4%*I4)/K4))*L4)-L4)*M4

G4 is Rate 1 - I4 is days - J4 is Basis 1 - H4 is Rate 2 - K4 is Basis 2 - L4 is Spot and M4 is Coefficient

This will give you the first answer (Swap) as -33.1895

But in my HP if i plug in all but one of these variables i get the 8th answer i.e. whichever one I leave out.

Does that make sense?

Thanks