Someone familiar with trading stocks on the stock market will feel at home with this request. However, it really requires someone proficient with Excel.
If you're willing to help you will need to refer to the following link.
In the attached spreadsheet you will see each symbol with a corresponding open, high, low, close.
The symbol represents a company, e.g msft is microsoft etc... the open, high, low , close, simply means the price at which it opened, how high it went, how low it went and where it closed.
There is certain pattern that market traders use in prices called the Hammer. This is where you'll need to view the link to understand what a Hammer looks like.
I have programmed a conditional formula that is taken from the link. I tweaked it to correspond with my spreadsheet. However, either I've programmed it incorrectly or the actual code is wrong.
I would truly grateful if an Expert could help.
If you need further explanation please let me know.