| halliday |
|
Gold User, Member, TeleChart
|
| Registered User |
|
|
|
|
| Unsure |
|
| Friday, December 31, 2004 |
| Wednesday, April 30, 2008 4:08:16 PM |
163
[0.06% of all post / 0.02 posts per day] |
|
Hey Bruce,
I think I was able to change the format using the 'custon' format.
What I did was selected the column, then Format Cells (I loaded these cells as MDY format - this is important because you won't be allowed to change a General cell format to a Date format), then I entered a new format ddmmyyyy.
AND Excel changed the dates!
I loaded the file into the new program and the chart looked great.
Bill
|
Hi Craig,
I need to export data from Telechart. The date format is MM/DD/YYYY or YYYYMMDD. I am trying to load the data into another software package the only understands date format of DDMMYYYY.
My output layout is:
Symbol,Stock Name,Date,Open,High,Low,Close,Volume
Do you know if anyone has a program that will read the file output from Telechart in the above format and change the date from YYYYMMDD to DDMMYYYY and output all fields with the new date format?
Jeremy at support@worden.com suggested the Telechart Developer's Kit. I haven't used it so I don't know much about it.
Bill
|
Super!
Thanks
|
Hi Bruce,
Thank you for the information.
I noticed that the Add/Subtract entry being used at:
Cumulative Indicator as posted in Feb 1 Worden Notes
was:
1+1
I'm just using 1, should I change it to 1+1?
Bill
|
Hi,
I got a Cumulative Formula (I think in the Worden Notes) some time ago and don't remember what it calculates, do you?
Up Condition:
c-avgc10>0 and avgc20>(avgc20+avgc20.1+avgc20.2)/3
Down Condition:
c-avgc10<0 and avgc20<(avgc20+avgc20.1+avgc20.2)/3
Add/Subtract:
1
Thanks,
Bill
|
If you look at StockGuy's post you'll see the answer!
The 4th formula is a combination of formulas;
1) + 2) + 3) or
1. (H-O)+(C-L) + 2. (0-((O-L)+(H-C))) + 3. (O-C1) ===>
(H-O)+(C-L) + (0-((O-L)+(H-C))) + (O-C1)
and that the 5th formula is;
the 4th formula plus Close or
(H-O)+(C-L) + (0-((O-L)+(H-C))) + (O-C1) + C
|
Oops, in reviewing the formulas again, I see that the © should have been a C. this is what I put into a custom Indicator!
(((H-O)+(C-L))) + (0-((O-L)+(H-C))) + (O-C1)) + C
Bill
|
I set them up in a Custom Indicator and this is what I found!
I had no problem with these!
1) (H-C)+(C-L)
2) 0-((O-C)+(H-C))
3) (O-C1)
These two, however, had problems.
Another way to look at all three-
((H-O)+(C-L)) + (0-((O-L)+(H-C)) + (O-C1)
was missing a close paranthesis, which I added to the end to get:
((H-O)+(C-L)) + (0-((O-L)+(H-C)) + (O-C1))
You could also add today's close-
(((H-O)+©-L)) + (0-((O-L)+(H-C))) + (O-C1)) + C
the © is a typo. I replaced it with O:
(((H-O)+O-L)) + (0-((O-L)+(H-C))) + (O-C1)) + C
and got a plot against price!
Bill
PS. In looking at the last formula, I think it would be improved with an extra set of paranthesis, but I'm not sure if that would change the plot. Mr. Tysync should be the one to tell us!
|
Yes,
You split the PCF into two parts!
1)
You got the High and Low and calculated the difference between them. Then you got a 15 day moving average of the difference and multiplied that by 3.
2)
You also found the minimum Low for the last 20 days.
You then added the average price change to the minimum Low.
It makes since after seeing what you did.
Someday, I'll be able to do it for myself.
|
Craig,
Thanks for the pointer to the Moving and Tabbing Snap-Ins video.
It showed me how to add a Tabbed Internet page to the top of the SnapSheet.
I was cloning a Tab inorder to create a link to a different Internet page. Now I know how to add it as a Tab to the SnapSheet.
As Garfield would say, "Sweet!".
Bill
|
|