I'm also very much interested to import TC2000 data into excel.

Easily done via yahoo.finance via API (unfortunatelly 15 min delay), so I would expect this feature also in TC2000 as Premium member.

Thanks

Rainer

Hi,

would there be a possibility to start a specific scan once exactly at 9:36 automatically ?

I mean can I arrange a timing when a scan should start ? That would really simplify my work.

kind regards

Rainer

Hi Bruce,

is there a possibility for following query:

price between 10 and 19.99: ABS(XAVGC9 / XAVGC20 - 1) <= .001

OR

price between 20 and 29.99: ABS(XAVGC9 / XAVGC20 - 1) <= .0009

OR

price between 30 and 40: ABS(XAVGC9 / XAVGC20 - 1) <= .0006

thanks for your ideas

Rainer

HI Bruce,

I took a 5 min chart (just for a test), where I can see at 12:45, 27.11. (HPE) that Exp Moving Average 9 and Exp Moving Average 20 has the same value, means 14,50

So I wrote an PCF with following pattern

 XAVGC9.3 = XAVGC20.3

Afterwards, when i put into "Test symbol" -> "HPE" and press "test formula" the result say 14,50 = 14,50 which is from my understandning definitly right.

But the result downwards also tells me "Value = False" which I don&#39;t understand, cause definitely 14,50 = 14,50

when I put instead XAVGC9.3 < XAVGC20.3  than the result says 14,50 <14,50 and "Value = True".

does it mean that XAVGC9.3 is not 14,50 but calculated to 14,499 and in TC 2000 I can only see 2 decimals ?

How can I get for calculation exacty 2 decimals, that 14,50 is exactly 14,50 ? Or is there a bug ?

I spend meanwhile half day to understand this - thanks for answer

br

Rainer

Hi Bruce,

I&#39;d like to write following PCF which meets following criteria:

*) 5 min. bar

*) VWAP = EMA9 = EMA20

http://www.weinotic.com/TC2000/VWAP.htm

I know there&#39;s the function of "Create Scan Condition" - with VWAP, but than I&#39;m only able to choose above/below/crossing down/crossing up EMA9 or EMA20, but I&#39;d like to have a PCF which have the same values - see above link.

thanks for your help

Rainer

Bruce as always - your are the best!

Hi Bruce,

I would like to create following PCF and your help would be appreciated.

Please look first on following link for better understanding:

http://www.weinotic.com/TC2000/rs.htm

Conditions:

*) Max high of last 10 bars

*) At least 1 bar should test the max. high of last 9 bars

*) Some bars should be close to max high of last 10 bars (+- 0.08%)

*) Lows from all bars shouldn&#39;t cross down exponential moving average 9 (EMA9)

*) EMA9 should be taken as "support line" - see condition above

*) C should be lower (min 0.05%) from max high

Thanks in advance for your support

Rainer

:-) - thanks.

any chance to forward this topic to R&D and this can be seen in an updated version ?

Hi,

another support needed.

need a pcf for an inidcator that tells lowest wilder&#39;s RSI based on Intraday 5 min bar in combination with value below 20

Doing via Create Scan Condition is clear. Here I can setup a period X.

But every 5 minutes a new bar arise. Meaning within an hour I have 12 - 5 min bars. In 2 hours 24 - 5 min bars etc. until the whole day up to 78 - 5 min bars - so the period changes all the time ....

The challenge is how I get the right wanted above indicator during the whole day scanned ?

thanks Bruce,

ok, I meant moving EMA9 three days ago < VWAP three days ago, EMA9 2 days ago < VWAP 2 days ago, EMA9 one day ago < VWAP one day ago and EMA9 current < VWAP current.

Hope I explained it a better way.

thanks Rainer