I have a bunch of plain vanilla interest rate swap contracts with all the relevant details regarding payment structure such as notional, fixed rate, index, payment frequency, reset convention, etc.. My goal is to calculate the bumps of these swaps over time with respect to their relevant curves. I can do it manually (and one-by-one) through Bloomberg terminal in SWPM (Risk panel) but I was wondering if there is a way to use Excel Bloomberg add-in to calculate the bumps automatically. So the problem is twofold:
1- How to define a plain vanilla interest rate swap with its parameters to Bloomberg? 2- How to get curve sensitivities as an output?