| ilbuildit |
|
Gold User, Member, Platinum User, TeleChart
|
| Registered User |
|
|
|
|
| Unsure |
|
| Wednesday, June 22, 2005 |
| Thursday, March 18, 2010 8:43:14 PM |
87
[0.03% of all post / 0.01 posts per day] |
|
Hi.
Is it possible to write a PCF that will add all the prices of each equity that is part of an index and divide it by the number of equities added together to give me the mean price?
Overall I am trying to find a quick way to calculate the average price of the entire SP500.
Is this possible with a PCF and if so how would I write that?
Thank you in advance.
|
Would like to have three rules pertaining to a moving average for sorting and scanning.
Price 10% or less above/below a moving average.
Price 10% or less above a moving average.
Price 10% or less below a moving average.
Would this have to be realcode? I can't figure a way with just a choice available when I drag a moving average on top of price action to scan and sort.
Thank you in advance.
|
|
I love it when it's simple. I couldn't see the forest for the trees!
Thank you as always Bruce!
Have a good weekend...
|
Hi.
I am using some real code that was posted by bruce on June 3, 2008.
'# PointType = UserInput.String = PP
'# TimeFrame = UserInput.String = D
Static Time As Date
Static High(1) As Single
Static Low(1) As Single
Static Close(1) As Single
If isFirstBar Then
Time = CurrentDate
High(0) = Price.High
Low(0) = Price.Low
Close(0) = Price.Last
High(1) = Single.NaN
Low(1) = Single.NaN
Close(1) = Single.NaN
End If
If (TimeFrame = "D" And _
Time.DayOfYear <> CurrentDate.DayOfYear) Or _
(TimeFrame = "W" And _
Time.DayOfWeek > CurrentDate.DayOfWeek) Or _
(TimeFrame = "M" And _
Time.Month <> CurrentDate.Month) Or _
(TimeFrame = "Y" And _
Time.Year <> CurrentDate.Year) Then
High(1) = High(0)
Low(1) = Low(0)
Close(1) = Close(0)
High(0) = Price.High
Low(0) = Price.Low
Close(0) = Price.Last
End If
If PointType = "PP" Then
Plot = (High(1) + Low(1) + Close(1)) / 3
Else If PointType = "S1" Then
Plot = 2 * (High(1) + Low(1) + Close(1)) / 3 - High(1)
Else If PointType = "S2" Then
Plot = (High(1) + Low(1) + Close(1)) / 3 - High(1) + Low(1)
Else If PointType = "S3" Then
Plot = Low(1) - 2 * (High(1) - (High(1) + Low(1) + Close(1)) / 3)
Else If PointType = "R1" Then
Plot = 2 * (High(1) + Low(1) + Close(1)) / 3 - Low(1)
Else If PointType = "R2" Then
Plot = (High(1) + Low(1) + Close(1)) / 3 + High(1) - Low(1)
Else If PointType = "R3" Then
Plot = High(1) + 2 * ((High(1) + Low(1) + Close(1)) / 3 - Low(1))
End If
Time = CurrentDate
High(0) = System.Math.Max(High(0),Price.High)
Low(0) = System.Math.Min(Low(0),Price.Low)
Close(0) = Price.Last
Prices out correctly but doesn't plot the pivots correctly on the chart. I have them all on "time frame = Day" and point type = R3 R2 R1 PP S1 S2 S3 each as a seperate indicator.
If I push the period key twice to bring up the box with all the prices on the indicators they are all correct, but on some days the PP is plotted below all the other S's and R's.
I will share the chart under "Pivot Point Plots" if you wish to review what is happening.
Thank you in advance.
|
Very nice!
Thank you!
|
Hi.
Is it possible with Stockfinder to average the price of any watchlist populated based on closing prices?
So if I have 28 equities that populate a watchlist I can quickly calculate the average value based on closing prices of that watchlist and also if possible gauge the increase or decrease in value over a period that can be changed at will either by the average change in value or give a percentage value?
Just an average price value would be enough if the other details can not be had.
Thank you in advance!
|
Hi.
Is there a list of ETF ticker symbols only within the watchlists of Stockfinder? I see the "ETF" tab and what is listed under there but would like to filter out a long list of the ETF tickers that are currently on the market.
Thank you in advance.
|
|
Thank you very much Bruce!
|
|
I will look forward to Stockfinder 5 then for ATR display values.
For ATR I would like to use a percentage of the current price .
|
Hi.
Three questions for displaying ATR in Stockfinder.
1. In TCNet I had 4 different time periods of ATR displayed in the customizable display area (Header area), I had both the dollar value and the percentage of the period displayed. Is it possible to display the dollar value and the percentage only and not an idicator plot somehow with Stockfinder?
2. On the indicator plot in the Stockfinder pane, can I change the dollar value given to a percentage and if so how do I do this?
3. I would like to create a rule to scan with ATR. I would like it to scan for greater than a specific percentage (For example I will use > 6%). So I would scan for anything that has a ATR percentage greater than 6%. As it stands right now I can only scan for a dollar value. How can I change the ATR rule to scan for the percentages?
Quick questions about Realcode. Seems to be Visual Basic. I can consider myself a beginner/novice VB programmer. Am I correct in this?
Thank you in advance.
|
|