+ Reply to Thread
Results 1 to 4 of 4

Load Values into Array to Compare

  1. #1
    Registered User
    Join Date
    11-14-2008
    Location
    Nashua
    Posts
    19

    Load Values into Array to Compare

    I have a set of old and new values that I need to compare.

    We can assume that values in column X are the master values and values in Column Y are subordinate to column X

    For example

    Yesterday's values
    x y
    abc 1
    def 2
    ghi 3

    Today's values

    x y
    abc 1
    def 4
    jkl 3

    So first i need to find out that GHI is no longer available, and second that the amount for DEF has changed from 2 to 4. Hopefully this makes sense if not let me know and I can provide a sample spreadsheet or the like.
    Last edited by prescient; 04-08-2009 at 09:19 AM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Load Values into Array to Compare

    I can provide a sample spreadsheet or the like.
    That would be a good thing. And expected results.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-14-2008
    Location
    Nashua
    Posts
    19

    Re: Load Values into Array to Compare

    So we need to find out which cusips have been deleted from the portfolio and which have been added. We can determine if they have been deleted by comparing Yest.Cusip column with the Today.Cusip column. We can determine if they cusips have been added by doing the opposite. Next we need to determine which Cusips have had their share amounts changed from yesterday to to day. Yesterday cusip 31359 (d3) had 50,000 shares and today it has 100,000. For each change something as simple as a MsgBox saying "Cusip XYZ has been added" or "Please updated the shares of cusip xyz to xxx" would suffice.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Load Values into Array to Compare

    Try this
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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