whether the stock price is raising trend or fallen trend analysis by excel macro

Dear all, There are lots of tools for analyzing the stock price in the Google , but I always like to analysis the stock price with the help of excel formula. But the problem is that while I am going to analysis multiple stock at time,then it kills my valuable times , so I need all of your assistance to solve my issue, I have explained in the attached file . take care everybody…

solved by pivot table