The Interday query scripts are located in the $RAP30/Scripts/VLDB directory on the server. See the table below for a description of each script file.
Script name |
Description |
|---|---|
interday_tick_qry1.sql |
Determine the volume-weighted price of a security considering only the ticks in a specified three-day interval. |
interday_tick_qry2.sql |
Determine the top 10 percentage losers for the specified date on the specified exchanges, sorted by percentage loss. The loss is calculated as a percentage of the last trade price of the previous day. |
interday_tick_qry3.sql |
Find the most active stocks in the “COMPUTER” industry for the last three days. |
