How to look at stock prices in excel and see if price increased or decreased a certain amount

I have the tick data for prices of a stock ticker. I want to evaluate for each row if it went up or down $0.05 first from that specific row. I also want a column to show me the max number of cents that it went up before it hit the plus or minus 5 cents, and one that shows the lowest negative amount that it decreased before it hits my plus or minus 5 cent threshold. I have attached an example spreadsheet.
nirajkrishnaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
nirajkrishnaConnect With a Mentor Author Commented:
Sorry here it is
Stock-Price-Test.xlsx
0
 
EirmanChief Operations ManagerCommented:
Nothing is attached.
0
 
Rgonzo1971Commented:
HI,

see attachment

Regards
Stock-Quotes.xlsx
0
 
nirajkrishnaAuthor Commented:
Excel is not capable of this but nice array formulas!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.