New version 18 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

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

Profile: traderlady
About
User Name: traderlady
Groups: Gold User, Member, Platinum User, TeleChart
Rank: Registered User
Real Name:
Location
Occupation:
Interests:
Gender: Unsure
Statistics
Joined: Thursday, October 07, 2004
Last Visit: Friday, March 22, 2019 11:45:14 AM
Number of Posts: 1,174
[0.40% of all post / 0.22 posts per day]
Avatar
Last 10 Posts
Topic: Found on Search
Posted: Friday, March 22, 2019 11:24:20 AM

Even old dogs can learn new tricks!  :>)  Thanks, Bruce.

Topic: Found on Search
Posted: Friday, March 22, 2019 11:21:28 AM

Thanks for the complete explanation.  I'll try that.

Topic: Found on Search
Posted: Friday, March 22, 2019 11:03:36 AM

I am not sure how to follow your instructions for how to transform your original formula into a 1-Ago formula when I want to use the 1-Ago as a column.

(I already know how to plot the Magnitude formula on a chart and how to place the original as a column)

Topic: Found on Search
Posted: Thursday, March 21, 2019 11:00:22 PM

Hi Bruce,

Through search, I found this useful PCF Indicator coded by you.  I intend to use this transformed into a 1-Ago indicator as a column. 

I've tested the original below as a column and it does work that way.

IIF(L > H1, 1, IIF(H < L1, -1, IIF(L > MINH2.1, 2, IIF(H < MAXL2.1, -2, IIF(L > MINH3.1, 3, IIF(H < MAXL3.1, -3, IIF(L > MINH4.1, 4, IIF(H < MAXL4.1, -4, IIF(L > MINH5.1, 5, IIF(H < MAXL5.1, -5, IIF(L > MINH6.1, 6, IIF(H < MAXL6.1, -6, IIF(L > MINH7.1, 7, IIF(H < MAXL7.1, -7, IIF(L > MINH8.1, 8, IIF(H < MAXL8.1, -8, IIF(L > MINH9.1, 9, IIF(H < MAXL9.1, -9, IIF(L > MINH10.1, 10, IIF(H < MAXL10.1, -10, IIF(L > MINH11.1, 11, IIF(H < MAXL11.1, -11, IIF(L > MINH12.1, 12, IIF(H < MAXL12.1, -12, IIF(L > MINH13.1, 13, IIF(H < MAXL13.1, -13, IIF(L > MINH14.1, 14, IIF(H < MAXL14.1, -14, IIF(L > MINH15.1, 15, IIF(H < MAXL15.1, -15, IIF(L > MINH16.1, 16, IIF(H < MAXL16.1, -16, IIF(L > MINH17.1, 17, IIF(H < MAXL17.1, -17, IIF(L > MINH18.1, 18, IIF(H < MAXL18.1, -18, IIF(L > MINH19.1, 19, IIF(H < MAXL19.1, -19, IIF(L > MINH20.1, 20, IIF(H < MAXL20.1, -20, IIF(L > MINH21.1, 21, IIF(H < MAXL21.1, -21, IIF(L > MINH22.1, 22, IIF(H < MAXL22.1, -22, IIF(L > MINH23.1, 23, IIF(H < MAXL23.1, -23, IIF(L > MINH24.1, 24, IIF(H < MAXL24.1, -24, IIF(L > MINH25.1, 25, IIF(H < MAXL25.1, -25, IIF(L > MINH26.1, 26, IIF(H < MAXL26.1, -26, IIF(L > MINH27.1, 27, IIF(H < MAXL27.1, -27, IIF(L > MINH28.1, 28, IIF(H < MAXL28.1, -28, IIF(L > MINH29.1, 29, IIF(H < MAXL29.1, -29, IIF(L > MINH30.1, 30, IIF(H < MAXL30.1, -30, IIF(L > MINH31.1, 31, IIF(H < MAXL31.1, -31, IIF(L > MINH32.1, 32, IIF(H < MAXL32.1, -32, IIF(L > MINH33.1, 33, IIF(H < MAXL33.1, -33, IIF(L > MINH34.1, 34, IIF(H < MAXL34.1, -34, IIF(L > MINH35.1, 35, IIF(H < MAXL35.1, -35, IIF(L > MINH36.1, 36, IIF(H < MAXL36.1, -36, IIF(L > MINH37.1, 37, IIF(H < MAXL37.1, -37, IIF(L > MINH38.1, 38, IIF(H < MAXL38.1, -38, IIF(L > MINH39.1, 39, IIF(H < MAXL39.1, -39, IIF(L > MINH40.1, 40, IIF(H < MAXL40.1, -40, IIF(L > MINH41.1, 41, IIF(H < MAXL41.1, -41, IIF(L > MINH42.1, 42, IIF(H < MAXL42.1, -42, IIF(L > MINH43.1, 43, IIF(H < MAXL43.1, -43, IIF(L > MINH44.1, 44, IIF(H < MAXL44.1, -44, IIF(L > MINH45.1, 45, IIF(H < MAXL45.1, -45, IIF(L > MINH46.1, 46, IIF(H < MAXL46.1, -46, IIF(L > MINH47.1, 47, IIF(H < MAXL47.1, -47, IIF(L > MINH48.1, 48, IIF(H < MAXL48.1, -48, IIF(L > MINH49.1, 49, IIF(H < MAXL49.1, -49, IIF(L > MINH50.1, 50, IIF(H < MAXL50.1, -50, 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Wow, are we lucky to have a master mathematician at Worden!

traderlady
 

Topic: Clear Method-ish v17
Posted: Wednesday, March 20, 2019 4:53:51 PM

Bruce, could you please include me in your Clear Method-ish indicators via TCMail?  Thanks!

traderlady

Topic: Formula Error Near the Minus
Posted: Wednesday, March 20, 2019 10:51:30 AM

Hi Bruce,

This morning I&#39;ve been following a forum discussion from years ago in which you offered the following formula:

ABS(L = MINL5) * 1 - NOT(L = MINL5) * (
ABS(L1 = MINL5) * 2 - NOT(L1 = MINL5) * (
ABS(L2 = MINL5) * 3 - NOT(L2 = MINL5) * (
ABS(L3 = MINL5) * 4 - NOT(L3 = MINL5) * (
ABS(L4 = MINL5) * 5
))))

When I try using it, there&#39;s an error message, "Formula error near the -"

Can you please correct this?

traderlady

Topic: Problem Creating a Valid CountTrue formula
Posted: Monday, March 11, 2019 12:06:57 PM

I am please to say that eliminating the two extra parentheses makes this formula as you provided work.  Thanks, Bruce.

Topic: Problem Creating a Valid CountTrue formula
Posted: Monday, March 11, 2019 11:20:30 AM

This morning I created the following Custom formula:

CountTrue((L1=L and H1=H),5)

It seems that this should be a valid CountTrue formula, but v19 rejects it as invalid and gives me the option of converting it to a Custom PCF % True instead which does not give me a count.

Bruce, am I doing something wrong or is this an issue in v19?

traderlady

 

Topic: Two Percentage Values
Posted: Thursday, March 07, 2019 2:12:02 PM

I&#39;ve placed a Custom PCF Indicator as new Plot my chart and then inserted AvgC8 in it. 

Next, I added a second Custom PCF Indicator Scaled with AvgC8 and inserted AvgC5 in it. 

Finally, I added a third Custom PCF Indicator Scaled with AvgC8 and inserted AvgC3 in it.

Now I would like to add Custom PCF Indicators as Columns and I&#39;m requesting  PERCENTAGE (Distance) VALUES BETWEEN TWO OF EACH OF THE AVERAGE CLOSES, i.e.:

1) The percentage distance between AvgC3 and AvgC8

2) The percentage distance between AvgC5 and Avg8

Thanks to Bruce,

traderlady

Topic: Request for v19
Posted: Wednesday, March 06, 2019 12:42:38 PM

In Beta v19, I can place "Bid/Ask Mid" as a Column, but not in the Toolbar at the top of my charts.

My request is that I be able place "Bid/Ask Mid" in the Toolbar.

traderlady