|Home > Forum Home > Analyzing Corporate Financial Data > Bloomberg data in an Excel Spreadsheet||Share|
|Forum Topic||Post Reply Login|
Bloomberg Data In An Excel Spreadsheet
Rate this:(3/5 from 1 vote)
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......
I have been able to pull relevant details based upon a cusip/isin i list in a column but I am not sure how i would tell Bloomberg what Notional Amount to use...??
My Spreadsheet is set up as follows:-
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
|Posted by rka81 on|
|There are currently no replies to the "Bloomberg data in an Excel Spreadsheet" topic of the Excel Help Forum for Analyzing Corporate Financial Data.|
|Find relevant Excel templates and add-ins for Bloomberg data in an Excel Spreadsheet in the Excel Business Solutions Directory|