+ Reply to Thread
Results 1 to 1 of 1

Reformatting data as simply as possible (stock example included!)

  1. #1
    Registered User
    Join Date
    Wisconsin, United States
    MS-Off Ver
    Excel 2010

    Cool Reformatting data as simply as possible (stock example included!)

    Hi, and thanks for your help! An xls file is attached, in case the data below looks wonky.

    I'm trying to take the following data:
    Ticker Type Date Percent Change in Stock
    APL Blue 10/20/2013 0.02
    APL Green 9/5/2013 -0.04
    APL Green 8/1/2012 0.03
    GOOG Blue 10/5/2013 0.06
    GOOG Green 5/1/2012 0.04
    MMM Blue 10/10/2013 0.02
    MMM Blue 5/8/2013 -0.02
    MMM Blue 4/2/2013 0.01
    MMM Blue 4/2/2012 0.06

    And turn it into a chart, with Type/Color in rows, Ticker in the columns, and a list of % changes in stock/dates in the past 12 rolling months.

    Blue +2.0% 10/13 +6.0% 10/13 +2.0% 10/13, -2.0% 5/13, +1.0% 4/13"

    Green -4.0% 9/13

    Example is attached, for better formatting. I tried doing this with a pivot table, but it seems that pivot tables demand to summarize your data. I'm hoping for an easier way, without VBA, to set this up. I can code VBA, but I'm setting this up for some colleagues, and if they have to make changes, they won't be able to sort through the VBA code for this, unless it's pretty simple.

    Can anyone help?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Code to pull Stock Balance Sheet Data from a Stock Symbol in a cell
    By akash1229 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-27-2015, 04:37 PM
  2. [SOLVED] How to Simply Copy Form Field Data to a New Empty Row?
    By playaller in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2013, 12:06 AM
  3. Replies: 4
    Last Post: 01-29-2013, 02:26 AM
  4. Replies: 0
    Last Post: 10-28-2012, 07:22 AM
  5. VBA programming: Simply trying to select cell-- or not so simply?
    By whiteliyl_111 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2005, 01:18 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1