Recent content by Kevvo

  1. K

    Bloomberg / MS Excel Automation

    Hi, I looked but could not find anything relevant, it's possible i'm looking in the wrong place. I used to YLD_CNV_MID - that worked however that does not any much considering i still need to manually ask BBG for the 'dirty' price using this Mid Yield. I tried using PX_Dirty_MID but that did not...
  2. K

    Bloomberg / MS Excel Automation

    Hello All, Hoping you can advise on my automation project. Part of my work is to re-price bonds using the average of the bid/ask yields. Currently my spreadsheet is setup only to extract bid/ask yields for a particular bond using a formula: =BDP(V23,$W$22) - where V23 is ISIN@XXXX govt and...
  3. K

    bloomberg ALLQ function to excel?

    Formula to re-price bonds Hello All, Hoping you can advise on my automation project. Part of my work is to re-price bonds using the average of the bid/ask yields. Currently my spreadsheet is setup only to extract bid/ask yields for a particular bond using a formula similar to above -...
Top