• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

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.
0
nirajkrishna
Asked:
nirajkrishna
  • 2
1 Solution
 
EirmanChief Operations ManagerCommented:
Nothing is attached.
0
 
nirajkrishnaAuthor Commented:
Sorry here it is
Stock-Price-Test.xlsx
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.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now