Recent content by MKej

  1. M

    Excel formula for candlestick (hammer and shooting star)

    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?
  2. M

    Excel formula for candlestick (hammer and shooting star)

    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...
Top