Rank: Newbie
Groups: Registered, Registered Users
Joined: 4/6/2006(UTC)
Posts: 9
Location: USA
|
Does anyone have a formula for Slow Stochastic with both the %K and %D values of 10?
Or better yet, can someone help me create an expert that will help me generate buy/sell signals with the following criteria:
Buy when MACD 12,26,9 crossover occurs (or when MACD is positive) AND when slow stoch 10,10 crossover occurs (or slow stoch 10,10 is positive) I changed the default %K
Sell when MACD 12,26,9 cross down occurs
Sound confusing? :eek: Well, after reading it, I think it is. Please help if you can. THX
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346
|
hey deerisaw.... to my knowledge the stoch is always positive.... can you explain that part more.... also do you mean stoch(10,10) , what is it crossing over/under....
by macd cross over are you refering to macd crossing the 0 line or its moving average....
your rules should be easy to code ..... holler back......h
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT
Was thanked: 2 time(s) in 2 post(s)
|
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 3/27/2006(UTC)
Posts: 41
Location: Singapore
|
In my case, I wanted to detect using explorer for %D crosses %K below 30% level with stochastic 10,3 for a buy signal.
Column A:
K:=(Sum(C-LLV(L,10),3))/(Sum(HHV(H,10)-LLV(L,10),3))*100;
D:=Mov(K,3,S);
If(Cross(K,D) AND D<30,1,0)
Filter:
colA = 1
While setting for a Sell signal when stochastic crosses above 70% level, what I did is swapping the K & D in the IF statement and change the 30 to 70.
i.e.
If(Cross(D,K) AND D>70,1,0)
Hope this helps.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Quote:If(Cross(K,D) AND D<30,1,0)
If(Cross(D,K) AND D>70,1,0)
The first formula says, "If the first AND second conditions (Cross(K,D) AND D<30) then return a value of 1 otherwise return a value of 0"
Both of these can be more easily written, without the If() function. Its called Boolean logic, the details of which I will not go into here, but MS does recognize it.
MS does exactly the same thing with "Cross(K,D) AND D<30" which either return TRUE (with a value of 1) or FALSE (with a value of 0)
From this, its easy to see that
If(Cross(K,D) AND D<30,1,0) === Cross(K,D) AND D<30
and
If(Cross(D,K) AND D>70,1,0) === Cross(D,K) AND D>70
Try it!
But the latter cases are easier to read and understand. They are also shorter, which becomes important when you start writing long formulas that approach the limit of formula length.
Hope this helps.
wabbit :D
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 4/6/2006(UTC)
Posts: 9
Location: USA
|
OK, now that I have had time to think about my needs, here they are:
Slow stochastic (10,10)
Buy when %K crosses over %D
Sell when MACD (12,26,9) crosses down
Basically what I am looking to do is enter an uptrending stock after I missed the original breakout.
Attached is a chart that shows buy and sell areas.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
deerisaw,
If you read the repsonses given already, the MS Users Manual and the Fourmula Primer, you will realise YOU have all the information YOU need to build this simple indicator.
The majority of the people here like to help others when they get stuck on a problem, but are not here to do all of your work for you.
Try writing the code yourself, and if you get stuck, then ask for help. Make sure you post your code, so that we can see where you go wrong.
If you do not want to help yourself, then you will have to pay for someone to do the coding for you.
Secondly:
The file you tried to attach does not download because, the XML file you created using Word does not apply absolute links, it uses relative links, and in any case those linked graphic files are stored only on your computer i.e. not available to the rest of the world (unless you want me to hack your system to get them!)
Please make sure you post any attachments onto the net in such a fashion that they may be downloaded by the people who you want to help!
wavbbit :D
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 10/15/2005(UTC)
Posts: 31
Location: The Netherlands
|
Maybe i can help with limited knowledge of the MS language. Is this what you mean?
K:=Stoch(10,10);
D:=Mov(K,3,S);
Buy:=Cross(k,d) and k>30;
Sell:=Cross(0,MACD());
If(buy=1,1,If(sell=1,-1,0));
This (very basic) solution returns a 1 in case of buying and a -1 in case of selling. I deleted the condition of selling above the 70 level because this situation did not occur very often.
Arne
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
arne,
We are trying to help deerisaw here, by allowing deerisaw the opportunity to do the coding themselves. I applaud your effort and want to help, but in this instance, it might not have what I perceive to be the desired outcome.
wabbit :D
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 10/15/2005(UTC)
Posts: 31
Location: The Netherlands
|
Haha okay :oops: , like you said only trying to help. I cannot help with the more sophisticated problems and this was not that complicated, that's why.
Anyway maybe the desired outcome will be initiated after this effort :D
Arne
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
no problems arne...
wabbit :D
P.S. With your code: you might want to try,
buy-sell
in lieu of your last line.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 4/6/2006(UTC)
Posts: 9
Location: USA
|
Dear arnevanveen-
Thank you so much. that is what I am looking for!!!!
I am sorry that I have made wabbit mad. After all, he has a PhD in MS and I am in Kindergarden. I am a trader and not a programmer. I have a 30 day trial with MS and am trying to determine if this is the correct software for me. I do not have the time to read the 400 page manual in that time frame and become a programmer. I thought the forum would be a perfect place to ask for assistance. After receiving wabbit's reply, I bacame a little gun-shy and thought of ending my trial subscription;however, arnevanveen showed his generosity.
arnevanveen, thanks for your time and generosity in teaching a kindergardener.
deerisaw
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
What's up Doc?! :lol:
arnevanveen-
This is the place to be for peer-to-peer support... you're correct. However, support starts at home. That's the message that Wabbit was trying to convey, and it is our forum policy. No one is mad. If you have such a limited time to evaluate what it is that MS can do for you, my thoughts are to open the User's Manual as long as you can every day until you get through it. You don't have to be a programmer. That a small niche that may be something to explore at a much later time. The explorations and systems that are included with MS are fully described in the EXCELLENT user's manual and in the online documentation. In addition to that, you might check out the MS FAQ section here on the forum. Also, the education library contains some super beginners videos. All in all, you are in the right place. Try not to dwell on hidden meanings... there aren't any. Help yourself and if you get stuck holler. Don't spend too much time trying to plot custom indicators during your evaluation. Evaluate the basic package thoroughly first.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
deerisaw,
As G_ stated, I am not a mind reader. Why in your first post didn't you say that you were evaluating MS and would like to know if it can achieve x,y and z? We can even show you some stuff that Equis Sales Department doesn't even know about!
You will find I, like the majority of the good folk here will try to help as best we can, but daily we are confronted by many people who have actually paid for the full versions, who have expectations that now they have spent their money that this MS box thingie will start making them money automatically. You see this day in, day out and so start to make assumptions on what people have/have not done. In your case, my assumption was wrong. Sorry.
I agree that 30 days is not long to evaluate your needs in comparison to the product, but even then, the MS Users Manual is still the key to discovering whether MS is the right tool for you. You could fumble around for days in MS code without achieving much, and yet one or two good reads of the MS Bible will reveal to you most of the capabilities and limitations of the software without programming anything!
Hope this helps.
wabbit :D
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
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.
