Prev: Access XP & Source Safe
Next: Access 2003 Crashing after sp3 update
From: James A. Fortune on 18 Sep 2007 15:34
PeteCresswell wrote:
> Thanks James.
>
> Thanks Tom.
>
> Between the two of you, I think I'm going to be home free by COB.
> ------------------------------------------------------------------------
> James:
> By some miracle, when I un-wrapped the code it worked right out of
> the box.

Pete,

I believe in miracles, but I try not to make my code or inventions
depend on them :-).

James A. Fortune
MPAPoster(a)FortuneJames.com

Design your devices, and your life, for steady-state operation. -- Dr.
Gil Wedekind
From: (PeteCresswell) on 18 Sep 2007 19:18
Per Tom Wickerath <AOS168b AT comcast DOT net>:
>Did you get my code to work without generating any errors? (It works on my
>PC, using Windows 2000 SP-4 with Access 2003 unpatched).

Yes - for the nine bonds that I have in my little test harness.

MDURATION_Excel_TestHarness
----------------------------------------
31331VAQ9 FFCB (callable: ne .0243032264963497 vs BB's 5.6170
Diff Days = -2013.0000000000000 Diff Percent = 366.67
3133XFLE4 FHLB?????????????? 2.49689940593026 vs BB's 2.4890
Diff Days = 3.0000000000000 Diff Percent = 000.33
3133XGDD3 FHLB 3.50499621512252 vs BB's 3.4980
Diff Days = 3.0000000000000 Diff Percent = 000.24
3134A4VB7 FHLMC 2.6161241458217 vs BB's 2.6080
Diff Days = 3.0000000000000 Diff Percent = 000.32
3134A4QD9 FHLMC 4.21480388584064 vs BB's 4.2070
Diff Days = 2.0000000000000 Diff Percent = 000.13
3137EAAX7 FHLMC 2.6972028317729 vs BB's 2.6800
Diff Days = 6.0000000000000 Diff Percent = 000.62
3137EAAF6 FHLMC 3.42743477098654 vs BB's 3.4190
Diff Days = 3.0000000000000 Diff Percent = 000.24
3134A4JT2 FHLMC 3.78515515390294 vs BB's 3.7770
Diff Days = 3.0000000000000 Diff Percent = 000.22
3128X5C48 FHLMC MTN 2.20757410517533 vs BB's 2.1990
Diff Days = 3.0000000000000 Diff Percent = 000.38
----------------------------------------

The only real bad boy so far is a callable bond where I took a
SWAG and plugged NextResetDate into MaturityDate.... to no
apparent avail.

I'm now slogging through Bloomberg screens for about fifty more -
dutifully capturing BB's view of each into a grid that I then
Copy/Past into my test data table.

Once I get that populated, I'll clone the test harness and try
the same thing on James' routine - just for grins.

--
PeteCresswell
First  |  Prev  | 
Pages: 1 2 3
Prev: Access XP & Source Safe
Next: Access 2003 Crashing after sp3 update