Hi,

I wonder if anyone can help or at least point me in the right direction. I am trying to create a worksheet that with extract data from Bloomberg that will relate to a figure that i specify. I have tried a few BLP formulas and amended the examples that are on the Bloomberg Help but cannot seem to get it to work......

Column A - Security Name / Cusip (manual input field)
Column B - Notional/Balance (manual input field)
Column C - Principal Payment (MTG_CUR_PRINC_PAY) -Bloomberg calculation will be based on Notional/Balance
Column D - Interest Payment (MTG_CUR_INT_PAY) - Bloomberg calculation will be based on Notional/Balance


Hopefully this will make sense to someone (I am basically trying to extract the Principal and Interest amounts from Bloomberg based up the Notional amount that I specify for the relevant security)

Any help is appreciated. Thanks