# Excel formula for candlestick (hammer and shooting star)

#### MKej

##### Newbie
2 0
Hello
Need som help plotting the formula for Hammer and Shooting star candlestick in excel
I waant row J to scann for Hammers ang row K for Shooting stars

I've upoaded the excel file here. And i would really appreciate if someone could take a look at it. And maybe plot inn the correct formula.

Im using a norwegian excel so:
IF = HVIS
AND = OG

#### Attachments

• Candelstick test.xlsx
184 KB · Views: 2,421

#### tsunamizawa

##### Established member
666 0
Hello
Need som help plotting the formula for Hammer and Shooting star candlestick in excel
I waant row J to scann for Hammers ang row K for Shooting stars

I've upoaded the excel file here. And i would really appreciate if someone could take a look at it. And maybe plot inn the correct formula.

Im using a norwegian excel so:
IF = HVIS
AND = OG
screening candlestick patterns with excel need a lot of time.
using charting software is very helpful.

Last edited:

#### A Dashing Blade

##### Experienced member
1,373 170
Can you give the precise definitions that you'd like to use for "Hammers" and "Shooting Stars" please ??

ie the relationship between hi/lo/open and close

You'll probably have to use the AND(), OR() and ABS() -Absolute Value - functions

#### tsunamizawa

##### Established member
666 0
Can you give the precise definitions that you'd like to use for "Hammers" and "Shooting Stars" please ??

ie the relationship between hi/lo/open and close

You'll probably have to use the AND(), OR() and ABS() -Absolute Value - functions
ask google, you may find the code
reliable hammer position must be below stochastic 20 and shooting star above stochastic 80.
hammer & shooting star , upper shadow = null or 1 tick only and lower shadow must be larger or aqual to 2 times the body and the body must not be doji ( greenbody = close - open rredbody = open - close )

Last edited:

#### MKej

##### Newbie
2 0
So this one is for hammer
=IF(AND((E2-F2)>(3*(D2-G2));((G2-F2)/(0,001+E2-F2) > 0,6);((D2-F2)/(0,001+E2-F2) > 0,6));"Hammer";"Junk")

Does anybody have the shooting star?

#### tsunamizawa

##### Established member
666 0
So this one is for hammer
=IF(AND((E2-F2)>(3*(D2-G2));((G2-F2)/(0,001+E2-F2) > 0,6);((D2-F2)/(0,001+E2-F2) > 0,6));"Hammer";"Junk")

Does anybody have the shooting star?

hammer = shooting star
hammer long shadow always below body
shooting star long shadow always above body

1 0

122 20
Excel rocks!

Replies
8
Views
26K
Replies
14
Views
8K
Replies
14
Views
28K
Replies
7
Views
8K
Replies
0
Views
3K