Hi,
Soory I was trying to insert excel rows but I didn't manage to. I believe the context of the problem is clear.
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
Soory I was trying to insert excel rows but I didn't manage to. I believe the context of the problem is clear.
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
Last edited:
