Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Which formula is more accurate? Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
traderlady
Posted : Monday, September 10, 2018 10:09:58 AM
Registered User
Joined: 10/7/2004
Posts: 1,178

Each of the PCF Indicator formulas below typically provide slightly difference values (although ocassionally they are the same).

Can you tell me which formula based on Daily Candles is more accurate?

((C-O)/O)*100

or

100 * (1 - O/C)

 

Bruce_L
Posted : Monday, September 10, 2018 10:20:43 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Neither is more accurate. They just check for different things.

The first is the percentage that price is above or below the open as a percentage of the open. It could also be written as follows (this should allow you to better compare it to the second formula).

100 * (C / O - 1)

The second is the percentage that price is above or below the open as a percentage of the close. It could also be written as follows (this should allow you to better compare it the first formula).

((C - O) / C) * 100



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
traderlady
Posted : Monday, September 10, 2018 10:40:11 AM
Registered User
Joined: 10/7/2004
Posts: 1,178

Regarding your explanation of the second formula below:

((C - O) / C) * 100

Do you mean that kthis represents the percentage that price is above or below the open as a percentage of the previous day's close?

Bruce_L
Posted : Monday, September 10, 2018 10:42:11 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

No, it is the percentage that price is above or below the open as a percentage of the current bar's close (which is the current price).

If the basis was yesterday's close, then the second C would need to be C1 instead.

100 * (C - O) / C1



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
traderlady
Posted : Monday, September 10, 2018 12:15:18 PM
Registered User
Joined: 10/7/2004
Posts: 1,178

Thanks, working with these!

Bruce_L
Posted : Monday, September 10, 2018 12:54:50 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
traderlady
Posted : Monday, September 10, 2018 9:27:40 PM
Registered User
Joined: 10/7/2004
Posts: 1,178

Another question about percentage change...

When I right click on a column tab, then select value, then select basic, and finally select "Today's %" what appears in the new column tab is named "% Change".

My understanding of "Today's %" which is also named "% Change" is the Price Percent Change from Yesterday's Close thru today's Open.

At the close today (Monday 9/10/18) % Change was 11.02%.

Unfortunately, when a TC subscriber clicks on % Change, the formula is hidden from the subscriber.

Now backing up to our previous posts, Bruce, you offered the following (bolded below):

If the basis was yesterday's close, then the second C would need to be C1 instead.

100 * (C - O) / C1

However, when I use this exact formula, the result was 9.79%.

I am seeking a formula that will duplicate Todays% called % Change on the tab.

 

 

traderlady
Posted : Monday, September 10, 2018 9:29:23 PM
Registered User
Joined: 10/7/2004
Posts: 1,178

I meant to say for CVNA "At the close today (Monday 9/10/18) % Change was 11.02%.

Bruce_L
Posted : Tuesday, September 11, 2018 9:47:40 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

If you are trying to duplicate the Todays % or % Change tab, please use the following.

100 * (C / C1 - 1)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
traderlady
Posted : Tuesday, September 11, 2018 10:28:29 AM
Registered User
Joined: 10/7/2004
Posts: 1,178

Thanks, Bruce! 

Bruce_L
Posted : Tuesday, September 11, 2018 10:51:02 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.