Spydertrader's Jack Hershey Equities Trading Journal III

Status
Not open for further replies.
Quote from gerry875:

do you know how this concept performed during the bear market 00-03?
More...

I'd be willing to bet that Jack's equity strategy performs better in a bear market. It's much easier to filter for stocks to trade with this strategy in a bear market because there won't be nearly as many stocks that fit the criteria. Where as in a bull market, there could be several.
 
Quote from Clym:

I have updated my earnings.xls spreadsheet to parse for an earnings date from Zacks.com
More...

Thank-you for sharing your efforts. I frequently use this spreadsheet to update my charts with the individual Earnings Dates.

- Spydertrader
 
Thanks for the earnings program Clym.

A note to others, the file will have an execution error if you rename it. It appears to need to be named earnings.xls to work correctly.
 
My first month I made 5% with lots of mistakes being made. but I learned from each one of them. I can not thank Spydertrader and excv8tor enough:) :)
 
Quote from bigmoose:

Thanks for the earnings program Clym.

A note to others, the file will have an execution error if you rename it. It appears to need to be named earnings.xls to work correctly.
More...

If you would like to change the workbook name without messing up the macro.

1. (close all open Excel Workbooks). Open Earnings.xls

2. Press ALT F11 (hold down ALT key then press the F11 key)

3. (visual basic window opens) Click EDIT>Replace

4 Find What: Earnings.xls
Replace With: yourfilename.xls

5 Highlight > "current project"

6. press "Replace All"

7. Close the Visual Basic Window

8. Save the sheet as yourfilename.xls


Quote from Spydertrader:

Thank-you for sharing your efforts. I frequently use this spreadsheet to update my charts with the individual Earnings Dates.

- Spydertrader
More...

Your Welcome!
 
This is a great Forum, thank you all for participating. I have been reading the prior posts, finished the 1st journal, up to page 630 of the second, and plan to paper trade starting next week. I noticed that QX04790 posted a program to populate fields in a spread sheet, but the link no longer works. Does anyone have a copy to share?

thanks,
 
Quote from Clym:

I have updated my earnings.xls spreadsheet to parse for an earnings date from Zacks.com, (in addition to clearstation and yahoo).
The dates are automatically (but slowly) filled in and placed side by side so that you can compare the earnings dates given by the different sources. The point being, that there are often discrepancies to investigate before trading the stock.
Since Spydertrader often posts a yahoo news link for the days symbols, I have also included an automatically updating link in cell H1. (When you run the earnings macro, the URL will update to include up to 20 symbols from column A. )
The directions are still the same.
(you only have to do steps 1,2 & 3 once.)

1. FIRST, open Excel (before you even download the file. )
2. Press alt + F11
3. From the Microsoft Visual Basic Menu, Select TOOLS, select REFERENCES, then find "Microsoft Internet Controls" and place a checkmark next to it. Click OK and Exit everything.

4. Import, paste or type symbols into column A
5. Press the "Get Earnings" button.
More...

This is an update of the earnings.xls file that I uploaded yesterday.

There was an issue with hidden instances of IE not being closed properly which resulted in high memory usage both during and after running the "get earnings" procedure.
 

Attachments

Clym thanks for sharing your earnings program -- very helpful.

It appears that the StockTables subscription cost is increasing on Jan 1 and there is still time today to get a discounted rate. Could the users on the board please comment on the advantages of StockTables. I am a long time Telechart user. My objective is to consolidate tools in 2007. It's charting function has been replaced by QCharts. Thanks in advance for your opinions.
 
Cipher,
It might be, thanks. I unzipped and saved it, but how do I get it into my excel sheet?

thanks

it
Quote from cipherscribe:

Hi Elvis,

Is this what you are after?
More...
 
Status
Not open for further replies.
Back
Top