Hi,

I try to export the Open/high/low/closing price of daily charts to excel (by right mouseclick on chart, "export chart data"). When I import the respective txt file into excel, I receive 8 columns instead of 4, and each of these prices is seperated into TWO columns (e.g. open column shows 35 dollars and high column 72 cents, although the opening price is 35,72 $, and so on.)
I don't know how to upload screenshots- I hope you understand what I mean.

How can I make dollars and cents show up in the same column??

Thank you and best regards

Thomas

Hmmm, my TC 2000 first said "syntax error" and didn't show anything. Pasted and copied again, now it works. Sorry and thanx!

I tried to extend that to 22 days but something must be wrong....can u help? Thanx!!

100 * (AVGC22 - AVGL22) / ((AVGH22 - AVGL22) / 2 + (ABS(H - C1) + ABS(C1 - L) + ABS(H1 - C2) + ABS(C2 - L1) + ABS(H2 - C3) + ABS(C3 - L2) + ABS(H3 - C4) + ABS(C4 - L3) + ABS(H4 - C5) + ABS(C5 - L4) + ABS(H5 - C6) + ABS(C6 - L5) + ABS(H6 - C7) + ABS(C7 - L6) + ABS(H7 - C8) + ABS(C8 - L7) + ABS(H8 - C9) + ABS(C9 - L8) + ABS(H9 - C10) + ABS(C10 - L9) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)+ ABS(H14 - C15) + ABS(C15 - L14) + ABS(H15 - C16) + ABS(C16 - L15) + ABS(H16 - C17) + ABS(C17 - L16) + ABS(H17 - C18) + ABS(C18 - L17) + ABS(H18 - C19) + ABS(C19 - L18) + ABS(H19 – C20) + ABS(C20 - L19) + ABS(H20 – C21) + ABS(C21 – L20) + ABS(H21 – C22) + ABS(C22 – L21)) / 44)

Thanks a lot, Bruce,

that's exactly what I was looking for!

Thomas

Hi, I am looking for a scan which shows me the ratio of a close to a given range:

The equation I am looking for is an X Bar Moving Average of the Close minus the Low and dividing it by the Average True Range of X Bars. Then I want to take that result and multiply it by 100.

Appreciate any help!

Thank you and best regards

Thomas

Thanx a lot, Bruce!

Hi,

I would like to screen markets for the following condition:

Lagging span (which, as I understand, is the same as Chikou Span) crossed price 26 periods ago (from below to above = bullish sign; from above below = bearish sign)

Is there a pcf for that (in both directions)?

Thanx a lot!!

Thomas

ups, sorry - right on your website! :-)

Bruce, thanks - where do I find version 7 for download?

Hi;

would it be possible to export HLOC Data of a watchlist (EOD data to ASCII?

Thanx

Thomas