How to query quote database and bin symbols by some attribute

How to query quote database and bin symbols by some attribute

Dave Walton
2013-06-28 09:41:30

Hi, I'd like to know if it is possible to query a quote database (say Russell 3000) and dynamically bin (say 10 buckets) volatility (ATR%) of all symbols for the last 200 days. I'd like to create a function that returns the average next bar return over the last 200 days for a selected bucket.

QuantShare
2013-06-28 20:02:12

Best Answer

You will have to use the script editor (Tools -> Script Editor). The script should read quotes from a specific list of symbols, bin volatility then store the result in a custom database. After that you can create a custom function to get average next bar return from the new database.

Please contact support [at] quantshare [dot] com if you want to hire a programmer to implement this for you.

Dave Walton
2013-07-12 19:11:17

I have been working with a QS programmer on this. I'm receiving excellent service so far. Very reasonable and professional.

Get more messages

No more messages

Back


Trading Items Futures, Forex and Indices Symbols Time-series location relative to its high and low Historical Earnings Surprise, EPS and Consensus Data ETF Number of securities, percent stock and cash - Historical Dat... iShares Exchange-Traded Funds - ETF Fees and Expenses	How-to Lessons How to quickly select stocks based on the last value of a databas... How to plot support and resistance lines automatically How to download and use U.S. stocks earnings data How to create trading rules based on Put and Call volume data How to download EOD quotes for active and valid stocks only
Related Forum Threads How To? Symbols Database Cleanup How to read date and get quote of next day. How to export historical data for a list of symbols How to update NSE/BSE symbols in QuantShare? Create and Export each database for each market	Blog Posts How to create buy and sell trading rules based on News Data How to filter quotes data from high and low price spikes How To Create and Backtest an S&P 500 Trend Following System How to create a trading system, screen and composite using earnin... How to get buy and sell orders for a portfolio based on a trading...