| ErinAnn |
|
Member, Platinum User, TeleChart
|
| Registered User |
|
|
|
|
| Unsure |
|
| Sunday, October 12, 2008 |
| Monday, July 25, 2011 8:21:14 PM |
46
[0.02% of all post / 0.01 posts per day] |
|
Bustermu,
You're the best! Thanks so much....you've made my holiday weekend....and it's only Fri night.
Have a great weekend.....Erin
|
|
Unfortunately, I have no way to contact the author.
Do you have an formula experts there that could look at this?
Thanks....Erin
|
StockGuy,
Do you know how I would add ABS after the SQR? Meaning, where would the right parenthesis go?
I got the left part down, SQR(ABS(
but I don't know where to put the right parenthese. (I don't totally understand the formula.)
Also, there are 2 SQRs in the formula.
Thanks....Erin
|
Diceman or StockGuy,
I called customer service and they couldn't help me....they said that there was a problem with the formula.
I got to thinking about what you said Diceman....it was taking the sq root of a negative number....so I decided to try and put in an "absolute" calculation in after the sq root, using ABS....but I'm having problems.
I still get a syntax error and I"m wondering if I'm putting the parenthesis in the wrong place. Any help would be greatly appreciated.
Thanks...Erin
|
Thanks StockGuy. I have no clue what's wrong....mine shows "not calculated"....I can't get it to calculate. I guess I'll try and call customer support tommorrow and see if they can figure it out.
Thanks again....Erin
|
Diceman or StockGuy,
When you click on fx, and see your list of pcfs....does it show "calculated" or "not calculated" for the pcf we're working with?
Thanks....Erin
|
|
StockGuy, I can't even get that far as I can't calculate the PCF. Under my list of PCFs, it says Not Calculated. When I try to calculate, I get the syntax error. Any ideas to get past that step?
Thanks....Erin
|
Great Diceman...thanks. But here's a question....that would change the formula, so wouldn't it totally change what it's supposed to be doing? Like I said, I didn't write the formula, but it's supposed to be a formula to find stocks that are in a weekly volatility squeeze less than 6%.
Thanks for the help....Erin
|
Thanks StockGuy. I still can't get the PCF to calculate. Since you say it's working fine, I don't know what to do. I guess the problem is on my end, but I can't figure out what it would be. I've deleted everything....restarted TC and tried to create it again....but it always gives me a syntax error when I try to calculate.
Diceman, I see your suggestion, but why would StockGuy be able to calculate the formula and I can't. Also, how do you know it's taking a square root of a neg number? I didn't write this PCF.
Thanks for the help....Erin
|
I'm having problems writing a pcf....when I test it, it seems fine, but when I try to update I get a message that there is a syntax error.
((AVGC100 + 2 * SQR((20 * (C * C + C5 * C5 + C10 * C10 + C15 * C15 + C20 * C20 + C25 * C25 + C30 * C30 + C35 * C35 + C40 * C40 + C45 * C45 + C50 * C50 + C55 * C55 + C60 * C60 + C65 * C65 + C70 * C70 + C75 * C75 + C80 * C80 + C85 * C85 + C90 * C90 + C95 * C95) - (AVGC100 * 20) * (AVGC100 * 20)) / (20 * 20))) - (AVGC100 - 2 * SQR((20 * (C * C + C5 * C5 + C10 * C10 + C15 * C15 + C20 * C20 + C25 * C25 + C30 * C30 + C35 * C35 + C40 * C40 + C45 * C45 + C50 * C50 + C55 * C55 + C60 * C60 + C65 * C65 + C70 * C70 + C75 * C75 + C80 * C80 + C85 * C85 + C90 * C90 + C95 * C95) - (AVGC100 * 20) * (AVGC100 * 20)) / (20 * 20)))) / AVGC100 <= .06
Thank you for your help.....Erin
|
|