|
How do you import a list of symbols from Excel into a watch list? I pasted a bunch of gold stocks into Excel and created a personal watchlist called Gold. When I go to import into watch list I find my Excel file and click open nothing happens. Help please.
|
|
I'm looking for help writing a condition that will identify breakouts after a market crash.The crash can be anywhere globally, and all I need is a broker to facilitate trades. The conditions are :
-
After prices climb for several years to a market top then prices drop very quickly, within 3 months to a year reaching a 2-3 year market low.
-
Then after the decline prices trade sideways
-
the consolidation can last from 3 months to a year. (within the PCF i could change time periods for different easy scans):
-
the 60 day to 200 day Bollinger Bands are shrinking
-
And the 150 and 200 day simple moving averages are converging
-
Then bam, price breaks above the 200 day Bollinger Band and its 200 day moving average, entering the start of a new Bull Market
Your help writing this equation is greatly appreciated. Thanks!
Mike
|
|
What is the formula to find stocks that have been trading sideways for a year below their 150 moving average and then for the last 2 weeks have been trading above their 150 moving average?
J. Mike M
|
|
After step 6, change active watchlist to all flagged items at 4:59 into the video where it says create a new watchlist and click "start with the symbols from the active watchlist" I lose it. When I click create a new watchlist it does not give me this option (start with the symbols from the active watchlist). Nevertheless I rename the watchlist with all flagged items as Momentum Sectors and click OK. Then all the fields in the columns disappear except the headers. I find the empty watchlist in personal. What went wrong?
|
|
The watchlist in the video uses ALL MEDIA GENERAL AVERAGES. Since this isn't present in TC2000 v_12 I'm guessing Main Industries and Sub Industries should be used to find the momentum sectors, correct?
|
Your right. When I pasted each argument in a single PCF page it works. So the procedure for running in TC2000 is the same as shown in the above video example from 2004?
Is there written procedure to follow instead of going back to the video?
|
How come when I paste the formula for sorting the top sectors in TC 2000 v_12 I get an error message?
Here are the PCF's for the sort criteria used for the sort columns in the video.
Current Month:
((C-C20)/C20)*100
Prior Month #1:
((C21-C41)/C41)*100
Prior Month #2:
((C42-C62)/C62)*100
Prior Month #3:
((C63-C83)/C83)*100
Mike
|