Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Open stock postion formula question

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Adam
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a worksheet which extracts buy and sell info that refrence a specific stock. The buys are in one column and the sells are in antoher. However they do not line up becasue of the way they extracted What I am looking to do is creat a formula that will reference the symbol in and return the sum of the buys and sells.There may be several lines of both so I would need it to sum all buys and sells that reference that symbol.
    Any help on this would be great.
    Thanks!

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    you might want to run a pivot table for this information.

    <table style="background-color:#0e54be" cellspacing="1" cellpadding="2"><td style="background-color:#ceffff;font-family:arial;color:#072c63;font-size:8pt;"> DALEY :P </td></table>

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    or A DSUM function will also do the job nicely!

  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    Adam
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have tried the Pivot tables but in order to do what I am looking to do its too slow, I was hoping their was a formula that would do the trick.

    DSUM sounds good but I am not sure how to make this work any ideas.
    Thanks

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi ajr123:
    =DSUM(database,field,criteria)

    database is your table reference where your data is located
    field is the number of column from the left of your database which will be used for summing up
    criteria is the range of cells that define the criteria that will be used to select which cells would be summed up .. this range must lie outside the table -- first row will have the field name(s), and the row(s)below will have the criteria associated with each field name
    HTH!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,425
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default



    You could use Sumif

    =SUMIF(rSym,A3,rBuy)-SUMIF(rSym,A3,rSell)

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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