Trending target stock prices
Each week I update the target prices for 75-100 stocks. I need to see over time how these target prices are trending. I've attached a s'sheet of one example I put together. BUT do I need to create a separate graph for each of the 75-100 stocks? I would prefer a graph, but if I could do it through some lookup function that returns a calculation that shows me the price change, that might suffice.
Thanks in advance!
It seems to me that it would be easier to put the data in record order with each row having Date, Ticker and Price as modeled on Sheet1.
You could then use a pivot table and pivot chart to display any particular stock (or any set of dates) by using the filters on either the pivot table or pivot chart.
For the pivot table Date is placed in the Rows area, Ticker is placed in the Columns area and Price (sum of) is placed in the Values area.
By the way the .xlsx format was introduced along with the 2007 version of Excel, so I feel that you are not using the 2003 version, please update profile.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hey! Thank you so much! I'm going to be out of the office over the next week or so, but I will try this upon my return :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks