Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Profile: ErinAnn
About
User Name: ErinAnn
Groups: Member, Platinum User, TeleChart
Rank: Registered User
Real Name:
Location
Occupation:
Interests:
Gender: Unsure
Statistics
Joined: Sunday, October 12, 2008
Last Visit: Monday, July 25, 2011 8:21:14 PM
Number of Posts: 46
[0.02% of all post / 0.01 posts per day]
Avatar
Last 10 Posts
Topic: PCF Syntax Error
Posted: Friday, May 28, 2010 11:22:27 PM
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
Topic: PCF Syntax Error
Posted: Friday, May 28, 2010 1:06:03 PM

Unfortunately, I have no way to contact the author.

Do you have an formula experts there that could look at this?

Thanks....Erin

Topic: PCF Syntax Error
Posted: Friday, May 28, 2010 12:48:30 PM
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
Topic: PCF Syntax Error
Posted: Friday, May 28, 2010 12:11:33 PM
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
Topic: PCF Syntax Error
Posted: Thursday, May 27, 2010 6:49:48 PM
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
Topic: PCF Syntax Error
Posted: Thursday, May 27, 2010 5:34:22 PM
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
Topic: PCF Syntax Error
Posted: Thursday, May 27, 2010 3:32:50 PM

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

Topic: PCF Syntax Error
Posted: Thursday, May 27, 2010 2:37:16 PM
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
Topic: PCF Syntax Error
Posted: Thursday, May 27, 2010 1:32:50 PM
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
Topic: PCF Syntax Error
Posted: Thursday, May 27, 2010 10:38:35 AM
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