Add earning dates for 1000 symbols

Add earning dates for 1000 symbols

Kiran
2018-11-04 11:22:43

I've created a database to add a single field (Earning Date) for 1000 stocks - in a year, this database will have only 4 entries (the 4 earning dates).
Would like to use this database to report the Price before and on Earning day and the Earning day return in a screener.

1) How do i use ASCII Import (or any other mechanism) to upload this field for 1000 stocks? The Importer expects 1 file for each symbol.

(Note, I tried using Earnings_cal database and the Historical Earnings Downloader but they have 2 issues -
a) they don't report every earning date for these 1000 stocks
b) The Time field is not standard (e.g. 3:47am EST, Before Market Open, 12 noon, After Market Close, 12:01pm EST), and difficult to parse in a regex string.
earnings_var = GetDataString('earnings_cal', 'etime', 'regex string pattern');

2) If there is no solution to (1), please advise a regex pattern with which i can get (b) above working.

thanks
Kiran

QuantShare
2018-11-05 05:42:19

You can use the ASCII Import with a single file. In the parser settings, simply add "Quotes -> Symbol" to specify the column that contains the symbol data. Please read our documentation for more info about how to use the ASCII Import tool.

Kiran
2018-11-06 03:11:12

Thanks, that worked.
Another challenge is the screener only reports 1 date at a time. Is there a way to report multiple dates (e.g. July1-Oct30), so i can report all earning-day price action during that period in a single report?

If not Screener, is there another tool in Quantshare that could do this (not sure if Pivot Tables could support something like this)?

QuantShare
2018-11-07 06:07:45

Not with the screener. Try "Tools -> Databases Data".

Get more messages

No more messages

Back


Trading Items Valuation ratios for US stocks Advancing-Declining-Unchanged volume for NYSE, AMEX and NASDAQ US Stock symbols - CUSIP One-Minute Data for Intraday Futures Intraday Quotes for Major Stock Exchanges	How-to Lessons How to add future bars to plan for market scenarios How to quickly add a ticker symbol How to download EOD quotes for active and valid stocks only How to get stocks for a particular index using the global script How to display the number of stocks per day for different RSI gro...
Related Forum Threads Add new symbols for download How to download data for selected symbols ? Intraday Data for NSE Symbols In-Sample and Out-Of-Sample Dates for Optimization Obtain symbols for a particular index	Blog Posts Different Ticker Symbols for Each Data Source How to download the history of dividend payments for stocks in th... How to Download Trading Data for Certain Securities Only How to Backtest Your Trading System for Each Industry How to Select the Best Market Indicator for your Trading System