SQL  Output

Appendix A: SQL Scripts for Sample Queries

tick_qry6.sql

Find the 10 stocks with the highest percentage spreads. Spread is the difference between the last ask-price and the last bid-price. Percentage spread is calculated as a percentage of the bid-point price (average of ask and bid price).





Copyright © 2005. Sybase Inc. All rights reserved. Output

View this book as PDF