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 |

Why is the same formula calculated with a different result when placed on a chart than when it is ca Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dmcca_umd
Posted : Friday, August 7, 2015 5:59:51 PM
Registered User
Joined: 7/22/2014
Posts: 6

Tried to recreate the old way to calulate 10wk SMA (c1 + c5 +c10 + . . .  )/10 and plot the PCF on the chart but the formula calculates the plot line differently for the chart than it does when the PCF tests in the creation phase and also when it is added as a column.  Is this a bug??

Attempting to post screenshots.

Here are links to the screenshots if they do not show up in the post:
http://www.cesar.umd.edu/h348m/Videos/DMCCA/ScreenshotEditFormulaOnChart.jpg
http://www.cesar.umd.edu/h348m/Videos/DMCCA/ScreenshotEditPCF.jpg
 

 

 

StockGuy
Posted : Friday, August 7, 2015 9:48:40 PM

Administration

Joined: 9/30/2004
Posts: 9,187

The time frame on your column is Daily but the time frame on the chart is Weekly so the formulas are using different data sets in their calculations.

dmcca_umd
Posted : Monday, August 10, 2015 9:29:31 AM
Registered User
Joined: 7/22/2014
Posts: 6

Ah, I get it. 

Even though I saved the PCF using the daily time frame. When it is plotted on a chart it uses the chart's time frame rather than the saved time frame. 

To write  a 10 week SMA PCF for a weekly chart that goes from the current day rather than Sunday to Sunday I need to write. ((c + c1 + c2 + c3 + c4 + c5 + c6 + c7 + c8 + c9)/10). Correct?

dmcca_umd
Posted : Tuesday, August 11, 2015 3:46:12 PM
Registered User
Joined: 7/22/2014
Posts: 6

No, that is not correct.

After experimentation I see that on a weekly chart C1,C2, C3 . . . etc are all based on Friday closes. 

Is there any way to plot a line on a weekly chart when the line is based on daily closes??

Bruce_L
Posted : Tuesday, August 11, 2015 3:49:16 PM


Worden Trainer

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

There isn't a way to plot daily values on a weekly chart or weekly values on a daily chart in TC2000 version 12.



-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.