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

summation Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
bryceln
Posted : Wednesday, January 2, 2019 2:40:04 PM
Registered User
Joined: 1/10/2013
Posts: 91

In Schwabs platform there is a moneyflow indicator that I cant seem to get any indicators in TC2000 to match.  The formula for it is below - I wrote the pcf for the back end but Im not sure about how to write the summation part if even possible.  Im also not sure what the n-period it uses is and of course their cust serv seems to be reading from a help file that I alerady have available whcich doesnt say.  But I can play with that later.  If not possible is there any indicator that I can use that returns a dollar value like this one does.

                                                  t

                                                  ∑      (((C1-L1) - (H1-C1)) / H1-L1) * V1 

                                               i=t-n+1

Their description:

Money Flow keeps a running total of the money flowing into and out of a security. 

bryceln
Posted : Wednesday, January 2, 2019 2:43:17 PM
Registered User
Joined: 1/10/2013
Posts: 91
the symbol didnt come out right  its supposed to be the E (summation) symbol
Bruce_L
Posted : Wednesday, January 2, 2019 2:53:59 PM


Worden Trainer

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

That kind of looks like an intermediate step in the Chaikin Money Flow caclulations.

If we stop at the sum, we would get the following for a period of 21.

SUM((2 * C - L - H) / (H - L - (H = L)) * V, 21)

Your formula could be for 1-bar ago, or it could be that the formula using a starting index of 1 instead of a starting index of 0 like we do. If it is 1-bar ago, the formula would be the following.

SUM((2 * C1 - L1 - H1) / (H1 - L1 - (H1 = L1)) * V1, 21)

Note that you can actually can have a running total and not need to use a period at all if you create a Custom PCF Cumulative Indicator with the following settings.

Up Condition: C > C - 1
Down Condition: C < C - 1
Value to Add/Subtract: (2 * C - L - H) / (H - L - (H = L)) * V


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
bryceln
Posted : Wednesday, January 2, 2019 3:08:55 PM
Registered User
Joined: 1/10/2013
Posts: 91

The custom PCF Cumulative Indicator looks pretty exact.  Doesnt have the same value but the charted line is the same on everything I've put it on so far.  As always thanks for the excellent service.  

Bruce_L
Posted : Wednesday, January 2, 2019 3:14:01 PM


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.