Hi,
I have a table of bond prices and the time at which the price was quoted. I want to select only the last price. How can I do this using a query?
below are my variables where CUSIP_ID,BOND_SYS_ID and COMPAANY_SYMBOL are unique identifiers for a firm;TRD_EXCTN_DT and TRD_EXCTN_TM are the date of the transaction and the time of the quote respectively followed by a column of volume of trades and the last two columns are the prices. The databases has many firms and dates from 2002 till 2010. Any help in selecting the last price which is the 101.5 in this case is much appreciated
CUSIP_ID BOND_SYM_ID COMPANY_SYMBOL TRD_EXCTN_DT TRD_EXCTN_TM ASCII_RPTD_VOL_TX RPTD_PR RPTD_LAST_PR 00846UAB7 A.GB A 01-Jul-02 11:10:26 AM 500000 101.84 101.84 00846UAB7 A.GB A 01-Jul-02 1:08:18 PM 2000 101.5 101.5