Registered User
Joined: 11/2/2004
Posts: 16
|
How could one view indicator data in TC2000 for any particular day ? Also I would like to find out if it is possible to view price, volume and indicator data for say the last 10 days in a tabular format.
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
The pointer mode will display values for indicators plotted in the top price window. Just press the period key (.) on your keyboard twice to bring up the pointer bar and data box.
To view the data in tabular format, you would need to export it to text format using Databank | Export to Text and then view the data in Notepad or a spreadsheet like Excel.
|
|
Registered User
Joined: 11/2/2004
Posts: 16
|
Thanks !! Any way to view the value of indicators in the middle and bottom windows ? One is really having a hard time comparing the data/indicator values of say the last 2-3 days - any other suggestions ?
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
Not a way to view the indicator values in the middle and bottom windows, but this is an excellent suggestion for version 6 which is in development.
|
|
Registered User
Joined: 11/2/2004
Posts: 16
|
Could you please include this suggetion or do I need to post it in the Suggestions forum ?
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
You do not need to post your suggestion in the suggestion forum. It has already been passed on to the development guys.
Thanks for checking!
- Doug
Teaching Online!
|
|
Registered User
Joined: 11/13/2004
Posts: 141
|
Salreja
Which indicator do you want to see the values for?
It may be possible to work around this by creating a few PCFs to find the value of the indicator at different points in time, then add them to columns on a watch list tab to display the results side by side, but this depends on how the indicator you want to use is calculated
UserTM
|
|
Registered User
Joined: 11/2/2004
Posts: 16
|
Basically, I would like to see the following in a tabular format for say last 3-5 days/time periods:-
Open,High,Low,Close,Volume,OBV40
Close,MA5,MA13,MA34,MACD8,17,9 & MACD12,26,9
ADX,+DI,-DI
RSI7,9,Stochastics7,3,3
BOP,MS,TSV
My screening requirement, if I may say so is pretty complex. I would really like to have one prospective BUY PCF & one prospective SELL PCF which has all the above indicators linked with OR conditions. The crossovers I would like are pretty standard (same as given in Technical Analysis literature) eg ADX going from below 20 to above 20 for buy etc
Any ideas how one could shortlist with the least amount of effort and then just have the results/symbols available in one single easyscan list !!
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
Salreja:
TeleChart can do some of what you’re looking for, though not all.
Here is a link to a video about finding stocks where ADX has been below 20 but recently moved above it:
http://forums.worden.com/default.aspx?g=posts&t=167
You can get some of the data you mentioned in tabular format by printing the “Today’s Prices” report. For every stock in your WatchList, you’ll get a tabular presentation of Open, High, Low, Close, Volume, Net Change (from previous day’s close), percent change (from previous day’s close),. The final column will display data from the sort value column based on your current sort criterion.
You’ve mentioned a lot of indicators. If they were all somehow put into one single EasyScan, they would all be connected with an AND, not an OR. I can’t envision a PCF including all of the conditions you mentioned, and especially if joined by OR, I’m not sure the the PCF would be effective at all.
If you could be a bit more specific, perhaps, about the things you’re looking for with certain indicators (like you were with ADX), I’ll bet I could come up with some ideas to help. No “magic PCF” or “magic EasyScan” that will do it all, but maybe some solid ideas to help your process along.
Then, if we discover specific things you’re looking for that we can’t provide, we can submit those as product suggestions.
- Doug
Teaching Online!
|
|
Registered User
Joined: 11/2/2004
Posts: 16
|
Doug - first of all my complements to you and your team. Today is my first day in this forum and I am really overwhelmed with both the quality and speed of responses - it is simply superb.
I have gone through the ADX video and two of the candlestick videos (hammer/hanging man & dojis with gaps), I seem to be getting clearer. One of the issues that I am slightly perplexed about pertains to PCFs and Easyscans using user-defined PCFs. Here are three PCFs defined by me:-
PCF Buy-MA Crossover - (C > AVGC5 ) AND (C1 < AVGC5.1) (Result 1/6799 stocks AAPL)
PFC Buy-MACD Crossover - ((C > AVGC5) AND (C1 < AVGC5.1)) OR ((XAVGC12.1 - XAVGC26.1) < (XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9))) AND ((XAVGC12 - XAVGC26) > (XAVG(XAVGC12,9) - XAVG(XAVGC26,9))) (Result 0/6799 stocks)
PCF Bullish Engulfing candlestick pattern -
((C1 > O1) AND (O > C) AND (O >= C1) AND (O1 >= C) AND ((O - C) > (C1 - O1))) (Result 2/6799 WAG & AAPL)
The Easyscans defined for each of the above includes All Stocks to start with and the condition Buy MA Crossover/Buy MACD crossover PCF/Bullish Engulfing pattern, whichever is applicable. The results do not seem OK to me. Am I defining the crossover formuale correctly or is there a different way to do it ? My experience is similiar with whole lot of other candlestick formulae I picked up from http://www.tradeon.com/tradeon/tc2000/canstiug.html. Most of the bullish candle patterns return 0 results. Something seems to be amiss !!
A simple trading system that I would like to follow to identify/shortlist stocks would be :-
ADX crossover from below 20 to above 20
AND
+DI crosses -DI from below
AND
Volume > OBV40
AND
(Price crosses MA5 from below or MACD12,26,9 crosses its 9 day average signal)
I appreciate your help.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
salreja:
Thanks for the kudos! We're thrilled that you're finding the forums so helpful.
I'm chewing on your last post, and I'll get back to you soon.
- Doug
Teaching Online!
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
If you don't mind, I'll address your issues piecemeal for now.
For your Buy-MA Crossover PCF, it appears that you are looking for stocks where the close was below the 5 day MA yesterday, and the close is above the 5 day MA today. Your boolean PCF will return a true or false. Let me make a suggestion.
Create two separate non-boolean PCF's as follows:
PCF #1: (C / AVGC5)* 100
PCF #2: (C1 / AVGC5.1) * 100
Put both of these PCF's in an EasyScan. For PCF #1, use the range selector to accept values greater than 100. For PCF #2, use the range selector to accept values less than 100.
You'll find the crossups you want, and you would also be able to use the same PCF's to find crossdowns, if you ever want to.
In case you haven't seen them yet, here are links to two videos you might find informative. The first is a link to a video about the difference between a boolean and a math PCF:
http://www.worden.com/training/default.aspx?g=posts&t=209
This next link is to a video about using EasyScan to find moving average crossovers. The same concept applies to price/MA crossovers:
http://www.worden.com/training/default.aspx?g=posts&t=103
- Doug
Teaching Online!
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
OK...let's talk about your Bullish Engulfing Pattern. I think what you've described is actually a bearish engulfing pattern. You've got yesterday being an up day, and today being a down day. That would be bearish...which is fine...still a valid pattern.
Try this boolean PCF:
(C1 < O1) AND (C > O) AND (O < L1) AND (C > H1)
This should result in yesterday being a down day, today being an up day, and today's body should completely engulf yesterday's entire candle...tails and all.
Based on last night's market close, I came up with 18 stocks out of 6,799.
Here is a link to a nice article about the Bullish Engulfing Pattern:
http://www.investopedia.com/terms/b/bullishengulfingpattern.asp
- Doug
Teaching Online!
|
|
Registered User
Joined: 11/2/2004
Posts: 16
|
I am trying the closing price vs moving average crossover PCFs & Easyscan. The Easyscan reflects only 0 as values against both PCF conditions. Do I need to do anything for values to be displayed. The PCFs tested fine and generated calculated values.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
Did you update your PCF's after you created them?
- Doug
Teaching Online!
|
|
Registered User
Joined: 11/2/2004
Posts: 16
|
Have updated a couple of times Databasnk|Update (both options checkmarked) and have even restarted TC2000 also - no luck !!
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
Go into your sort menu, and click the PCF button. Make sure that next to the PCF you're having trouble with, it says updated through today's date.
If that looks OK, copy the formula exactly as you have it and paste it into a post here, and I'll take a look at it.
We'll get to the bottom of this for you.
- Doug
Teaching Online!
|
|
Registered User
Joined: 11/2/2004
Posts: 16
|
Both the PCFs are updated till 11/19/04. Here are the PCF's (suggested by you only)
C vs MA 5- (C / AVGC5) * 100
C vs MA5 one day ago - (C1 / AVGC5.1) * 100
I am into first 30 days of my TC2000 (free trial period) - I hope the TC2000 version is not crippled !! TC2000 defined PCFs Volume 1 day - H does show me the values.
Satish
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
I created the PCF's exactly as you have them, updated them, and put them in an EasyScan. I found 484 stocks where the close was below the MA5 yesterday, but the stock closed above the MA5 today. I scrolled through a bunch of stocks, and they look perfect. So...... let's take this step by step just to make sure we're not missing something.
1. Click NEW button
2. select New EasyScan
3. Change your WatchList to Scan to All Stocks
4. Click Add New Condition to open the conditions library
5. Find and click on the name of your first PCF.
6. Find and click on the name of your second PCF.
7. Click on the yesterday PCF to highlight it. You should have a range selector with a blue bar over to the right. The selector has (at the bottom) a Value side and a Rank side. Click the Value button.
8. Along the value side of the selector, you should see numbers or values. If I understand you correctly, is this where you see only zeros? If the values are there, click and drag the blue bar from the top down to jsut under 100 (you can look in the Value column across the top to see when you get below 100).
9. Click on the today PCF. Click and Drag the blue bar up to just over 100. Again, look in the value column above to make sure you're above 100.
10. The count should tell you how many stocks the scan found.
11. Click SAVE, give the EasyScan a name, and click OK.
If you are doing this exactly as described, and you still get zeros for values on the range selectors, we may need to refer you to the tech department. It could be something as simple as a corrupted file, which could be corrected easily. I'm just not educated in solving tech problems, or I'd help you myself.
Please let me know the status after reading this post. Thanks!
- Doug
Teaching Online!
|
|
Registered User
Joined: 11/2/2004
Posts: 16
|
Tried that again, I just get 5 zeros on the value side for both PCFs. Maybe I have some corrupted files as you say. There is no hurry on this, we could resolve this in consultation with your Tech Dept on Monday !! I am just playing around and trying to get a grip over your software.
Satish
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
I'm really sorry, Satish. This is definitely a tech issue. On Monday, you can reach them via email at support@worden.com, or you can call them at 919-408-0542.
Make sure you tell them that your PCF's are correct and updated...and that they test fine in the PCF window. Explain that you have nothing but 5 zeros on the value side of the range selector for both PCF's in your scan.
I'm confident they'll be able to fix you up. This is not a flaw in the program...it sounds like an unfortunate bad file, or something like that.
Please let me know how this turns out if you get a chance!
- Doug
Teaching Online!
|
|
Registered User
Joined: 11/13/2004
Posts: 141
|
Salreja
As for your PCFs, I also wondered if your criteria had been updated as I also return results, so I am not sure why this is not working for you. Hopefully the good folks at Worden can help you get this straightened out.
As for your MACD cross over formulas, I am pretty sure there is something wrong with the formula syntax, as when I tried the crossover formulas you posted, I kept getting syntax errors in the test Window of the PCF builder,
I myself am not too familiar with how MACD is calculated and admit my algebra eludes me, but I came across this some where on the net a while back. It may be of some help to you. It finds the cross over based on the standard MACD settings Perhaps you can adjust for your own time frame
I created a PCF using the following
AVGC12.1 - AVGC24.1 < ((AVGC12.1 - AVGC24.1) + (AVGC12.2 - AVGC24.2) + (AVGC12.3 - AVGC24.3) + (AVGC12.4 - AVGC24.4) + (AVGC12.5 - AVGC24.5) + (AVGC12.6 - AVGC24.6) + (AVGC12.7 - AVGC24.7) + (AVGC12.8 - AVGC24.8) + (AVGC12.9 - AVGC24.9)) / 9 AND AVGC12 - AVGC24 > ((AVGC12 - AVGC24) + (AVGC12.1 - AVGC24.1) + (AVGC12.2 - AVGC24.2) + (AVGC12.3 - AVGC24.3) + (AVGC12.4 - AVGC24.4) + (AVGC12.5 - AVGC24.5) + (AVGC12.6 - AVGC24.6) + (AVGC12.7 - AVGC24.7) + (AVGC12.8 - AVGC24.8)) / 9
The above formula creates a true or false value
I then create an Easy scan that includes all stocks and just this PCF, running it today I get 149 stocks, However the problem I discovered with this formula is that it finds the cross over of MACD based on a simple moving average rather than the exponential, but I modified the MACD indicator on a chart tab and tested the results and it appears to work if you don’t mind the SMA instead of exponential.
Also, along these lines I would like to offer some chart tab settings I have been working on along this area as I am also interested in crossovers
Top
Prices candle stick chart
Bollinger bands 20, 20
Moving average 20 bars,-simple - red
Moving average 10 bars –exponential-blue
Middle.
MACD – Histogram - 10, 20, 20
Stochastics 20, 1, 1 - Blue
Stochastics 28, 1, 1 – Blue
MACD 12, 26, 9 Exp (standard MACD).
Bottom
Stochastics 17, 3, 1 – Green
Stochastics 20, 5, 5 – Blue and Red
I have tried these settings with the formula listed above, but the results are mixed, I have also tried this using this with a easy scan that looks for cross-overs of the 20 day or 30 day averages here the results are still mixed, but I have also found on another chart tab with multiple moving averages, that when Stochastics make a MACD 0 line crossover that coincides with a crossover of compressed moving averages the signal is much more powerful, but I am not sure how to write a PCF to find the crossover plus moving averages that are all aligned on the chart. If you look at a chart for CNLG on the chart described above, and then add the 10,20,30,50,and 200, day moving averages and look at the last several days you will see what I mean.
Hope this helps
UserTM
|
|
Registered User
Joined: 11/10/2004
Posts: 39
|
i have been playing with the ADX and i'm confused as to the DX period and the AVG. period i am not a day trader more intermediate I read the help page on the ADX and have the periods set to the setting that were on the example DX at 50 AVG at 14 i know there is no set period but it would help me to understand the setting also i was woundering if it is possible when the DX is visible to place the actual value on the screen as we can do with the closing price of the stock thanks rich
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
salreja,
You can also display your PCFs in tab-like form within the WatchList window. Check out this video I made on how to add a criterion (like your PCFs) to the WatchList window. I am sure Doug or the support department will have the PCFs working for you in no time.
Here is the link to the video on WatchList tabs:
http://www.worden.com/training/default.aspx?g=posts&t=14
I hope this helps!
- Craig
Here to Help!
|
|
Registered User
Joined: 11/2/2004
Posts: 16
|
Any updates from your Tech Support ?
Satish
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
I forwarded this thread to tech support. Someone will follow up with you by phone or email.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
slareja:
Were you able to contact our support department yesterday about this issue? If not, send them an email: support@worden.com
To save yourself the trouble of re-explaining everything, point them to this link out here on the discussion boards, and ask them to read the last 7 or 8 posts so they understand the difficulty you've had with those zero values:
http://www.worden.com/training/default.aspx?g=posts&t=248
I'm sure they'll be able to get it straightened out in no time!
- Doug
Teaching Online!
|
|
Registered User
Joined: 11/2/2004
Posts: 16
|
Doug,
I spoke to Tom in Tech Support and he helped me resolve the issue. For the benefit of everybody on the forum my calculations were being performed on a particular watchlist and not All Items in System (should have been All Items in System). Navigation path Databank|Personal Criteria Formulas|Calculate for: All Items in System|Update All Criteria.
Will appreciate the ability to use ADX, +DI & -DI values in PCF as also inclusioon of indicators such as KST,TRIX and VHF.
usertm: Thanks for pointing out the MACD formula error, I will review the formula
All my PCFs are working now - thanks a lot !!
Satish
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
AHHHHHH! I should have thought of that. I asked if your PCF's were updated...I just didn't remember to make sure you had your program set to All Items in System when you updated your PCF's! Sorry to have caused a delay in finding a solution to your problem, but I'm glad Tom discovered what it was, and that you're up and running with your PCF's now.
The requests you've mentioned will be submitted to the development team for review and consideration.
- Doug
Teaching Online!
|
|
|
Guest-1 |