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