search for: official_bid

...the.is.date <- day.list(the.tranche$issdate) #get the data from a given auction/tranche cmnd <- paste("SELECT submitted_by_fi_id AS fiid , bid_yield AS yld,bid_amt/100000000 AS amt,bid_allotted_amt/100000000 AS aamt,on_target as target, on_rate as rate FROM official_bid,rates,auction WHERE auction.auction_id = ",the.tranche$id," AND auction.auction_id = official_bid.auction_id AND auction.auction_type_code like '",auction.type,"%' AND rates.day = '",sprintf('%i-%i-%i',the.auc.date[1],the.auc.date[2],the.auc.date[3]),&qu...