Click here to Login





                                                   Pre-market data and volume average?

Back to threads
  0

0
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

  0

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

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads Notes Report an item

No more messages
0




Reply:

No html code. URLs turn into links automatically.

Type in the trading objects you want to include: - Add Objects
To add a trading object in your message, type in the object name, select it and then click on "Add Objects"





QuantShare

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
Opening and Closing Crosses - Share Volume
Open Interest Data for Equity, Index and Futures Securities
How-to Lessons
How to create trading rules based on Put and Call volume data
How to download and use U.S. stocks earnings data
How to speed up watchlist and screener plug-ins when working with...
How to export trading data to a CSV file
How to download earnings calendar data for various stocks

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...
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...
How to filter quotes data from high and low price spikes









QuantShare
Product
 QuantShare
Features
Create an account
Affiliate Program 		Support
Contact Us
Trading Forum
How-to Lessons
Manual 		Company
About Us
Privacy
Terms of Use
Copyright © 2024 QuantShare.com
 Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+ Follow us on Google+
RSS Trading Items



Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.