tick_qry3.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.

NoteThe SQL script setup_tick_qry3_last_price.sql should be run at the end of each trading day on RAPCache database to capture data required by tick_qry3.sql.