Pre-market data and volume average?

Pre-market data and volume average?

Kiran
2015-11-03 19:05:18

Hi,
I want to run backtest and screen on pre-market data (8-9:30am EST) where the volume is 1.5XAvgVol last 10 days of Pre-market data
My strategy is running on 30-min charts.

1) How do i ingest pre-market data for at least 1-2 quarters? Not sure i saw a Data Loader for that?

2) Pl advise formula/code for the indicator AvgVol (last 10 days of pre-market data between 8-9:30am EST).
- if it's difficult, an option is to only use volume of only the last 30minute pre-market bar (i.e. 9-9:30am).

thanks
Kiran

QuantShare
2015-11-04 04:09:43

Hi,

1/ You can import data using "Data -> ASCII Import"

2/ You can use the following function to calculate the sum of volume between 8 and 9:30 then use the "sum" function to calculate the total volume over a specific number of days and divide that result by the number of days.

Time-series Sum for the first Minutes/Hours of a Trading Day

Time-series Sum for the first Minutes/Hours of a Trading Day (by Caleb, uploaded several months ago)

No notes

Get more messages

No more messages

Back


Trading Items Advancing-Declining-Unchanged volume for NYSE, AMEX and NASDAQ NYSE Historical Volume Data Options Market - Trading volume data per Exchange for US Stocks Open Interest Data for Equity, Index and Futures Securities Individual Stocks Put and Call Volume	How-to Lessons How to create trading rules based on Put and Call volume data How to speed up watchlist and screener plug-ins when working with... How to download and use U.S. stocks earnings data How to export trading data to a CSV file How to backup your databases (EOD, Intraday, Tick and Custom) and...
Related Forum Threads Intraday data with volume INTRADAY VERSION AND SIZE OF DATA BASE ^VIX and Volume for S&P Using the same data in Amibroker and Quantshare Fundamental data for canadian and mexican stocks	Blog Posts 6 ways to download free intraday and tick data for the U.S. stock... How to filter quotes data from high and low price spikes Charting, Backtesting and Trading using Fundamental Data How to create a trading system, screen and composite using earnin... Download historical EOD data for the stock, futures, ETF and Fore...