| Welcome Guest, please  sign in  to participate in a discussion. | 	Search | 	Active Topics |  | 
	
	
	
	
		Registered User Joined: 1/28/2005 Posts: 6,049 
	 | 
	
		 
	Bruce, 
	Do you have access to FEB 2017, Technical Analysis of Stocks and Commodities Magaizine? 
	  
	Thanks 
	  
	 | 
	 | 
	
	
	
		 
   Worden Trainer
  Joined: 10/7/2004 Posts: 65,138 
	 | 
	
		 
	I do have access to the February 2017 issue of Technical Analysis of Stocks and Commodities magazine. 
  -Bruce Personal Criteria Formulas TC2000 Support Articles
	 | 
	 | 
	
	
	
		Registered User Joined: 1/28/2005 Posts: 6,049 
	 | 
	
		 
 In that issue Ken Calhoun shows a chart of FAS 15min timeframe 
 using a 50 period VWMA. 
   
 It looks quite smooth. 
   
 I tried making one and its very noisy. (I used VPCI type PCFs) 
   
 I was wondering if i missed something? 
 TC2000 has a different data feed? 
 His software has a different defintion of a VWMA? 
 Can you take a look and see if you can generate something like his chart. 
   
   
 Thanks 
   
   
   
   
   
	 | 
	 | 
	
	
	
		  Administration
  Joined: 9/30/2004 Posts: 9,187 
	 | 
	
		 
	If you're running version 17, try this as a custom PCF indicator: 
	SUM((C*V),50) / SUM(V,50) 
	  
	 | 
	 | 
	
	
	
		  Administration
  Joined: 9/30/2004 Posts: 9,187 
	 | 
	
		 
	You can create a custom formula scan column to find where VWMA 50 is crossing up through AVGC70 using: 
	XUP(SUM((C*V),50) / SUM(V,50),AVGC70) 
	Or cross downs: 
	XDOWNUP(SUM((C*V),50) / SUM(V,50),AVGC70) 
	 | 
	 | 
	
	
	
		 
   Worden Trainer
  Joined: 10/7/2004 Posts: 65,138 
	 | 
	
		 
	I really don't have a way to compare since I can't go that far back on a fifteen minute chart. I don't know if his VWMA using simple or exponential moving averages (or another type for that matter although I think it unlikely). 
	In TC2000 v17, the short way to write a simple 50 period VWMA would be: 
	SUM(C * V, 50) / SUM(V, 50) 
	And the short way to write an exponential 50 period VWMA would be: 
	XAVG(C * V, 50) / XAVG(V, 50) 
  -Bruce Personal Criteria Formulas TC2000 Support Articles
	 | 
	 | 
	
	
	
		Registered User Joined: 12/17/2004 Posts: 17 
	 | 
	
		 
	Is there a way for me to use this in Ver 12.6? 
	 | 
	 | 
	
	
	
		 
   Worden Trainer
  Joined: 10/7/2004 Posts: 65,138 
	 | 
	
		 
	The 70 period simple VWMA can be written for earlier versions of TC2000 as follows. 
	(C * V + C1 * V1 + C2 * V2 + C3 * V3 + C4 * V4 + C5 * V5 + C6 * V6 + C7 * V7 + C8 * V8 + C9 * V9 + C10 * V10 + C11 * V11 + C12 * V12 + C13 * V13 + C14 * V14 + C15 * V15 + C16 * V16 + C17 * V17 + C18 * V18 + C19 * V19 + C20 * V20 + C21 * V21 + C22 * V22 + C23 * V23 + C24 * V24 + C25 * V25 + C26 * V26 + C27 * V27 + C28 * V28 + C29 * V29 + C30 * V30 + C31 * V31 + C32 * V32 + C33 * V33 + C34 * V34 + C35 * V35 + C36 * V36 + C37 * V37 + C38 * V38 + C39 * V39 + C40 * V40 + C41 * V41 + C42 * V42 + C43 * V43 + C44 * V44 + C45 * V45 + C46 * V46 + C47 * V47 + C48 * V48 + C49 * V49 + C50 * V50 + C51 * V51 + C52 * V52 + C53 * V53 + C54 * V54 + C55 * V55 + C56 * V56 + C57 * V57 + C58 * V58 + C59 * V59 + C60 * V60 + C61 * V61 + C62 * V62 + C63 * V63 + C64 * V64 + C65 * V65 + C66 * V66 + C67 * V67 + C68 * V68 + C69 * V69 ) / 70 / AVGV70 
	A formula for the 70 period exponential VWMA is too long and slow to be practical or post in the forums for earlier versions of TC2000. 
  -Bruce Personal Criteria Formulas TC2000 Support Articles
	 | 
	 | 
	
	
	
		Registered User Joined: 12/17/2004 Posts: 17 
	 | 
	
		 
	Thanks, Bruce. You are so responsive. 
	 | 
	 | 
	
	
	
		 
   Worden Trainer
  Joined: 10/7/2004 Posts: 65,138 
	 | 
	
		 
	You're welcome. 
  -Bruce Personal Criteria Formulas TC2000 Support Articles
	 | 
	 | 
| 
Guest-1 |