This SQL script should be run on the RAP cache database at the end of each trading day to capture the last price of that day. This data is stored in the LAST_TRADE_PRICE table and is referenced by tick_qry3.sql. Before running the script, change the date in the two WHERE clauses to the date of the trading day for which the last trade price is to be captured.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
