Excel Formulas for Candlesticks

breadman

Established member
526 25
I am trying to formulate candlestick patterns on Excel for analysis of open/high/low/close data

I have identified formulas to use on other platforms and have tried to re-configure them to use on Excel without success.

I have obtained the formulas from:
http://www.candlestickforum.com/PPF/Parameters/16_263_/candlestick.asp

I would like assistance with the formulas for bullish/bearish engulfings. I would like the formula to recognize a bullish/bearish engulfing with a (1,0) as a result in the appropriate column

Can anyone with better working knowledge assist me in converting the formulas to allow analysis of OHLC data using Excel.

Thank you for any assistance.
 

breadman

Established member
526 25
post up your spreadsheet and i'll have a diddle when I get a minute

Thank you for having a look.
I have attached a excel spreadsheet with basic OHLC data.
My attempts at converting the formulas was to follow them as they are set out on the website.

Hopefully you will be more successful

Appreciate your assistance
 

Attachments

  • audnzd T2W spreadsheet.xlsx
    110.1 KB · Views: 3,451
Last edited:

scose-no-doubt

Veteren member
4,630 954
Howzat?


edit: changed it to 1 and 0 for you and have sorted out the x axis on chart.

also the data I've charted only encompasses to row 37 in the series for test purposes. You'll have to edit the data source if you want to chart it all but there's so much data the chart will look sh*t.
 

Attachments

  • audnzd T2W spreadsheet.xlsx
    144.9 KB · Views: 2,816
Last edited:

breadman

Established member
526 25
what are you using this for if you don't mind my asking?

SCOSE-NO-DOUBT

I'm just going to have a look at some historical data using candlesticks engulfing initially, I may consider other bullish/bearish patterns as well. It will cover both absolute/relative data. Just looking for any bias that might be thrown up by the analysis...
 
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock