idlipman |
Beta Testers, Gold User, Member, TeleChart
|
Registered User |
|
|
|
|
Unsure |
|
Tuesday, December 28, 2004 |
Monday, June 20, 2005 5:37:31 PM |
15 [0.01% of all post / 0.00 posts per day] |
|
is there a formula for absolute value? I want to take the absolute value of (xavg20.25-xavg50.25)
i also want to get the max of the above formula for 20 days. i.e. the max of (xavg20.25-xavg50.25)and (xavg20.26-xavg50.26) and (xavg20.27-xavg50.27)etc.
|
what is the formula that will return stocks that trade more than an average of 1,000,000 per day. I need the formula for today and in the past.
|
Is there a way to download "on balance volume" figures. I can see how to download open, high, low, close etc but not "OBV"
|
thanks, are you thinking of implementing a way to write a generic formula and have it run for X number of days back. that would be very helpful.
|
I want to write a formula and have it run for several days. There are a lot of variables and a lot of days that I want it run for. Can I write one formula ((C10>=AVGC20.10*.95ANDC10>=AVGC50.10*.95)AND(OBV10.10>=OBV10.11) and tell TC2005 to run that for several days back or do I have to write ((C10>=AVGC20.10*.95ANDC10>=AVGC50.10*.95)AND(OBV10.10>=OBV10.11)) OR ((C11>=AVGC20.11*.95ANDC11>=AVGC50.11*.95)AND(OBV10.11>=OBV10.12)) OR ((C12>=AVGC20.12*.95ANDC12>=AVGC50.12*.95)AND(OBV10.12>=OBV10.13)) The second way will be a much longer formula but if the same stock appears in all 3 days, it will not be duplicated in the easyscan, right? Is there a maximum length for a formula?
|
just to verify, the formula AVGC200.10 > AVGC200.11 will calculate to 14 decimals, so where AVGC200.10 = 24.2512 and AVGC200.11 = 24.2511, the above formula would return a value of true?
|
If I am trying to compare a 200 day moving average from one day to the next, how many decimal places are used in the calculation?
ie. AVGC200.10 > AVGC200.11 if AVGC200.10 = 24.2511 and AVGC200.11 = 24.2512 would the above formula return a value of True or is it comparing 24.25 and 24.25?
|
thanks
|
can you re-send that e-mail?
and is there a way to tell TC2000 which pcf's to update so all of them are not updated everyday?
|
Can I import and export personal criteria formulas into and out of TC2000 from excel? ie if i have the name of the formula in column A and the formula itself in column B?
I am doing some backtesting and need to create several detailed formula's and I am looking for an easy way to create them.
Also, I have several detailed pcf's that I don't use all the time. Is there a way to export these so as not to bog down TC2000 or instruct TC2000 which pcf's to update.
One more question, I am having trouble downloading the "Gold package". Where is the download located on the Worden website.
|
|