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

PPG - Price Percent Gain between dates Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
montecarlos
Posted : Sunday, December 5, 2010 6:15:07 PM

Registered User
Joined: 4/10/2007
Posts: 38
My apologies to all, I was busy and previously posted this (twice) in the wrong forum area. Ready, fire, aim. 
Hopefully it is both useful and properly placed here. Thank you.

PPG - Price Percent Gain between dates

 XRAY vision into actual price movement using this now stable realcode indicator to rank order 
price movement performance. 

IMHO Ignorance isn't bliss, but timely market intelligence is. 

I can't ride what I can't see and I can't manage what I can't measure.

(1) Use the Green "+" symbol in the chart window to "create a new realcode indicator" 
and name it "PPG"

(2) Copy and paste in the code below. Delete the other header text. 
Click Apply, Save, and OK.

(3) Use the indicator to create one or more watchlist columns of "values." 

You do this by dragging the indicator over to your column area, use "values"
then you can delete the part below the chart box.

Your column will display PPG as a positive or negative gain/loss to 2 decimal places. 

It doesn't plot, so it is useless in the chart area. And it won't work without the "Plot=Change" realcode line, so don't try removing that. I already did.

(4) Use column to click-rank-order & measure the actual relative price movement of stocks, ETF's, or mutual funds you are interested in, or have available to you in your plans, between desired SPY pivot points or other calendar points of interest.

(a) With the indicator built, and the column functional, right click and "edit column" to easily adjust the dates.

Recent dates of interest:

31 Dec 2009 ............ YTD
09 March 2009 ..........Market Low
30 June 2010 ............Q3 CY2010, and a rally begin point
25 August 2010 .........another approximate SPY pivot point

Suggestion: Learn to use the "Add Date Pointer" in SF5 ... it is very useful in marking visual pivot points. 

Right click in the monthly calendar date area to access it, then you can click & drag it left right, and place it into different timeframes with various bar lengths.

(b) Select the fund style or family ... if you have SF5 with Mutual Funds... which I recommend. 

(c) Click your PPG column once or twice to rank the funds or stocks in descending order of performance. 

Now click & type in SPY or other desired index ETF or fund, etc. in the chart window to place that benchmark at the top of the watchlist screen. 

Compare relative price percent performance in the PPG column.


The net SF5 result is very similiar to using the "C" function ... Custom Date Sort... in Telechart
and then creating a "sort value" column to display the value of the movement of the
ranked securities. 

To the advanced user-analyst this is all child's play, but to the new market participant
it may be salvation.

http://www.worden.com/legacy/TeleChartHelp/Content/Sorting/Custom_Date_Sort.htm


Mutual Fund Managers ?  

They can run, but they cannot hide, from accurate, timely numerical analysis.
Think Fantasy Football.

Retirement investing is no football game, I'll grant you, but it is not supposed to
be an easter egg hunt done without battlefield intelligence.

Semper Fidelis.
Monte


Example:

GE 12/03/2010 ........$16.78
GE 12/31/2009 ....... $15.13

16.78 / 15.13 = 1.1091

PPG = 10.91%

PPG realcode indicator 
column's output = 10.91

Credit for the coding goes to Bruce Loebrich & the support team at Worden. 

I had to tweak a parenthese or two to get the code to output the number I wanted, but the 
real code authorship is theirs, responding to a request I submitted. 



'|******************************************************************
'|*** StockFinder RealCode Indicator
'|*** Indicator: PPG - Price Percent Gain between Dates
'|******************************************************************
'# Cumulative
'# StartDate = UserInput.Date = "12/31/2009"
'# EndDate = UserInput.Date = "12/03/2010"
Static Ref(1) As Integer
Static Change As Single
If isFirstBar Then
    Ref(0) = Math.Min(IndexForDate(StartDate), IndexForDate(EndDate))
    Ref(1) = Math.Max(IndexForDate(StartDate), IndexForDate(EndDate))
    Change = (Price.Bar.Value(Ref(1)) / Price.Bar.Value(Ref(0)) - 1)*100
End If
Plot = Change

montecarlos
Posted : Sunday, December 5, 2010 6:37:24 PM

Registered User
Joined: 4/10/2007
Posts: 38
If you build this and get "Infinity" in all column cells ... try "unlinking" the column from the chart
and then delete the green PPG in the chart box area.

When I imported this indicator into my desktop PC, this is how I resolved my 
own set of "infinities."

The data was accurate as compared to another, independent measurement
realcode indicator.

It never hurts to crosscheck the columns with some real world, hand 
calculated data.

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