Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Scanning for all time highs Topic Rating:
Previous Topic · Next Topic Watch this topic · Print this topic ·
rbyrne
Posted : Tuesday, September 19, 2017 3:56:54 PM
Registered User
Joined: 10/21/2004
Posts: 28

Could someone share how I might scan all us stocks to identify those trading at all time highs...thanks!

 

Bob

Bruce_L
Posted : Tuesday, September 19, 2017 4:04:13 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Click on price history (usually this will be the symbol and time frame in green in the upper left corner of the pane where price is plotted) and select Create Scan Condition.

Choose New High in the Condition drop-down menu andset it to at 500 bars high with the TimeFrame set to daily. You can select Scan to create a new EasyScan based on your new condition.

Repeat the process but set the TimeFrame to Yearly and choose + Add to... | + Add to Conditions in the EasyScan you created earlier so you have both conditions in the same EasyScan instead selecting Scan to create a new EasyScan.

BTW, you can get away with much shorter periods than this. A period of 270 for the Daily condition should pretty much cover the number of trading days for all stocks. You might need to use more than that for Forex (but 367 would definitely cover it). And a period of 150 or so would cover every symbol we have for the Yearly conidtion for at least a few more years (only DJ-30 has more than 100 years of data at this point).



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
rbyrne
Posted : Tuesday, September 19, 2017 4:14:16 PM
Registered User
Joined: 10/21/2004
Posts: 28

Thanks Bruce. One more thing, how do I scan for new issues? Say ... stocks that have only been trading for 3 months? 

 

Thanks

Bruce_L
Posted : Tuesday, September 19, 2017 4:23:11 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

I don't know of a way to scan for new issues, but you can sort for new issues.

3 months is about 63 trading days... so if you create a daily condition checking for the price being the same as itself 63 trading days ago, it would only return true for symbols which are not new issues.

C63 = C63

You could use this as an EasyScan Condition, but it would give you the opposite of what you want.

But if you use this as a WatchList Column, you can Edit that WatchList Column and set it to Do Nothing When True and Show Dot or Show Check When False.

You can click on the name of the WatchList Column at the top of the WatchList to use it as a sort.

You could do something similar with just a price % change formulas for the desired period.

100 * (C / C63 - 1)

This would return ... for symbols without enough data to calculate (the new issues).



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
rbyrne
Posted : Tuesday, September 19, 2017 4:26:19 PM
Registered User
Joined: 10/21/2004
Posts: 28

Thanks for the help :)

Bruce_L
Posted : Tuesday, September 19, 2017 4:29:06 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.