Results 1 to 9 of 9

Fill points using interpolating closet two points

Threaded View

  1. #1
    Registered User
    Join Date
    03-11-2016
    Location
    London,England
    MS-Off Ver
    Windows 7
    Posts
    8

    Question Fill points using interpolating closet two points

    I have following USD LIBOR rates for key maturities and want to fill LIBOR rates for all dates from day 1 to 360 days by interpolating available rates. Appreciate very much for help.

    USD Days (x) Rate (y)
    *USD LIBOR - overnight 1 0.39340*%
    *USD LIBOR - 1 week 7 0.42095*%
    *USD LIBOR - 2 weeks 14 -
    *USD LIBOR - 1 month 30 0.44930*%
    *USD LIBOR - 2 months 60 0.52440*%
    *USD LIBOR - 3 months 90 0.62360*%
    *USD LIBOR - 4 months 120 -
    *USD LIBOR - 5 months 150 -
    *USD LIBOR - 6 months 180 0.89410*%
    *USD LIBOR - 7 months 210 -
    *USD LIBOR - 8 months 240 -
    *USD LIBOR - 9 months 270 -
    *USD LIBOR - 10 months 300 -
    *USD LIBOR - 11 months 330 -
    *USD LIBOR - 12 months 360 1.20520*%

    New table should be as follows.
    Days(x) Rate (y)
    1 0.39340*%
    2 ?
    3 ?
    . ?
    . ?
    . ?
    360 1.20520*%

    Formula should be worked for negative rates since LIBOR EUR is currently negative.
    Last edited by NG7267; 06-27-2016 at 02:45 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 08-05-2015, 06:18 PM
  2. Color chart data points/marker points vba error
    By nmckever in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-12-2014, 07:10 AM
  3. Replies: 1
    Last Post: 04-09-2014, 01:33 PM
  4. Interpolating between data points
    By 21jackj in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-15-2013, 06:05 PM
  5. [SOLVED] Interpolating multiple points between known values
    By gumpstump in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-21-2012, 07:54 PM
  6. VBA fill inbetween two points
    By 0mgatr33 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-11-2012, 01:56 AM
  7. Replies: 0
    Last Post: 10-08-2010, 12:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1