bonds

Hi Guys, By referring to the older post, I found something below as Cubic Spline Interpolation. The formula I found was s(x) = a(x-xi)^3+ b(x-xi)^2 + c(x-xi) + d, I would like to understand how it translate to the algorithm below. Much Appreciate. Function spline(periodcol As Range, ratecol...

Hi guys, I've run into a mental roadblock trying to figure this out. I thought it was simple, but it was not as simple as I thought. In the table below, I can easily calculate the return of the portfolio and break it down into equity and fixed income allocation. However, through time, this...

I want to compare the winnings from my premium bonds over the last 4.5 years with what I'd have got in interest if the capital had been in a savings account. Basically I started with £x in bonds 4.5 years ago, I won 7 x £25 in prizes at random intervals and now have £Y in bonds (the winnings...

I'm sorry that I'm posting this in a rush so this may not be the best way to illustrate my problem - but here's an idea of what I want and how I'm getting it now: <tbody> A B C D E F G H I J 1 Fund Value Large Stock Mid Stock Small Stock Intl Stock ST Bonds Mid Bonds LT...

Hi all, I'm trying to extract data form a pivot table, but =GETPIVOTDATA or =VLOOKUP aren't helping me much. The pivot table I want to extract from has groups of values on its X axis: in my case I am working on bonds and the headings are: <3 years, 3-6 years, 6-10 years, 10-20 years, 20+ years...

Hi Forum, I am currently trying to build a dynamic bond investment portfolio with rolling tranches of monthly investments. Now, doing this in a static and unsexy way is not a challenge, however, I have difficulities in finding an automated formula based or vba solution. I want to enter start...

All, I am importing raw trade data into excel where I then need to run yield calculations. This is where I am getting hung up. Although there is a yield function in the worksheet there doesn't appear to be anything equivalent when I try to write it up in VBA. The Analysis Toolpak for VBA...