Help need it for stochastic having exponential as method

Viewing 4 posts - 1 through 4 (of 4 total)

Author

Posts
12/23/2017 at 4:17 AM #56407 quote

Petru
Participant

Junior

Hi,

I want to create an excel spreadsheet for stochastic with the following settings:

Nbr periods=14

%K Nbr periods=5

%D Nbr periods=5

Method = Exponential

Apply to =close

I am able to test method ‘simple’ (I am guessing that is a simple moving average). What is interesting is that my spreadsheet doesn’t match prorealtime data but it is very close which is OK.
I would appreciate very much your help for this spreadsheet with the above settings.

Regards,

Petru

SP500.xlsx

01/02/2018 at 12:49 AM #57033 quote

Petru
Participant

Junior

Hi again and A Happy New Year to all of you,

Does anybody know the formula for stochastic with these parameters?

Nbr periods=14

%K Nbr periods=5

%D Nbr periods=5

Method = Exponential

Apply to =close

Thank you very much,

Petru

01/03/2018 at 11:22 PM #57203 quote

AVT
Participant

Senior

I made an example with your data, format is .ods (libre office), you should be able to import it into exel; formula is german but I added translations on top.

Check it if it fits – oh, forgot to add yellow fields are the ones where you put your periods in (to play with it).

If you have questions, just ask again.

SP500.ods

01/05/2018 at 12:15 PM #57343 quote

Petru
Participant

Junior

Thank you very much AVT. Now I can move on with my project. I really very appreciate your help.

Regards,

Petru
Author

Posts

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

Login your account

Help need it for stochastic having exponential as method

General Trading: Market Analysis & Manual Trading

New Reply

Author

Petru @petru Participant

Summary

This topic contains 3 replies,
has 2 voices, and was last updated by Petru
8 years, 1 month ago.

Topic Details

Forum:	General Trading: Market Analysis & Manual Trading
Language:	English
Started:	12/23/2017
Status:	Active
Attachments:	2 files

Loading...