Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2014-01-02
4
Medium Priority
?
254 Views
Last Modified: 2014-01-25
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
Comment
Question by:nirajkrishna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 24

Expert Comment

by:Eirman
ID: 39750932
Nothing is attached.
0
 

Accepted Solution

by:
nirajkrishna earned 0 total points
ID: 39750965
Sorry here it is
Stock-Price-Test.xlsx
0
 
LVL 52

Expert Comment

by:Rgonzo1971
ID: 39751243
HI,

see attachment

Regards
Stock-Quotes.xlsx
0
 

Author Closing Comment

by:nirajkrishna
ID: 39808469
Excel is not capable of this but nice array formulas!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question