Hi would appreciate advice on this
what we are doing now manually is for each bond, use the ALLQ function in bloomberg to obtain all current broker quotes at a particular point in time. Can we somehow use an excel function/vba to obtain the ALLQ info (in particular Firm name, Bid Price, Time)...