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: 0002ct
About
User Name: 0002ct
Groups: Gold User, Member, TeleChart
Rank: Registered User
Real Name:
Location
Occupation:
Interests:
Gender: Unsure
Statistics
Joined: Thursday, November 19, 2015
Last Visit: Saturday, October 20, 2018 11:23:47 AM
Number of Posts: 425
[0.15% of all post / 0.40 posts per day]
Avatar
Last 10 Posts
Topic: equal to same as
Posted: Friday, October 05, 2018 12:46:13 PM

Thanks very much. I appreciate it.

Topic: equal to same as
Posted: Friday, October 05, 2018 12:16:13 PM

Hello:

If I want to return stocks where the EMA7 has crossed above the EMA20 exactly one time in the last 101 days, is the following correct? No fewer and no more crosses above.

COUNTTRUE(XUP(XAVGC7, XAVGC20),101) = 1

Thank you very much.


 

Topic: His vol chunks
Posted: Wednesday, September 26, 2018 7:28:03 PM

Yes, I think this is exactly it. I wanted to use the min/max values for historical vol instead of price. 

Thank you very much. Works perfectly.

 

 

Topic: His vol chunks
Posted: Wednesday, September 26, 2018 10:33:07 AM

Hello. Is it possible to do an evaluation like A but using the historical vol forumula in B instead of the H and L values max/min values?
 

A. 100 * (AVG(MAXH5 / MINL5, 96) - 1)
 
B. (1600 * ABS((SUM(LOG(C / C1) ^ 2, 23) - LOG(C / C23) ^ 2 / 23) / 23) ^ .5)

Thank you very much for any thoughts.
 
Topic: hisvol days ago
Posted: Friday, September 07, 2018 4:03:23 PM

I know what you're thinking to yourself. Well, the answer is: I'm never really sure. That's why.

Thank you, Bruce. I really appreciate it. Have an enjoyable weekend.

Topic: hisvol days ago
Posted: Friday, September 07, 2018 3:57:23 PM

Hello.

How does one write the following historical vol calc for "7 days back"? That is, how do I output the 23-day historical vol reading from 7 days ago?

(1600 * ABS((SUM(LOG(C / C1) ^ 2, 23) - LOG(C / C23) ^ 2 / 23) / 23) ^ .5)

Thank you very much.

Topic: Days back and kludge
Posted: Friday, August 24, 2018 9:58:17 PM

Hi, Bruce. Hope all is well, and thank you very much. Sorry for my late reply.

Thank you for the solutions to part A. I think for part B, simply get to know your uncle better. Take him out for coffee or miniature golf. He'll probably offer a tip or two. I don't know, just spitballing here.

Enjoy the weekend. Thanks again.

Topic: Days back and kludge
Posted: Friday, August 24, 2018 4:12:20 PM

Hello.

1. What's the correct formula for counting the days back since an event has occurred? In an example, since a cross above EMA100?

2. Is there any kludge formula for outputting a "true" check for a selected ticker? Let's say I have a watchlist of 20 stocks. One of these stocks is "held by my uncle" and I want to track that piece of information with a "true check". Is there any tricky way to do this?

Thank you very much.

Topic: truly deranged
Posted: Monday, August 06, 2018 8:31:08 PM

Hi, Bruce. I'm not sure where I went wrong, but these work well and with some adjustment of the percent do what's needed. Thank you very much for the help.

Topic: truly deranged
Posted: Monday, August 06, 2018 4:26:57 PM

Hi, Bruce. Thanks. Yes, the last paragraph you wrote was essentially what I'm trying to do. I have been using H > MAXH49.1 for the period.