+ Reply to Thread
Results 1 to 3 of 3

keeping a bank total

  1. #1
    Registered User
    Join Date
    09-21-2010
    Location
    grenfell
    MS-Off Ver
    Excel 2007
    Posts
    10

    keeping a bank total

    i want to be able to keep a running total of a bank account with buying a selling. i have attached my spreadsheet which is half working. the bank balances need to minus the buy price each day but on the day where it has sold it needs to add that to the balance. plus the brokerage needs to be taken out of each both the buy and sell.

    so on 100701 i have bought 2086 so that needs to be minused from the bank total of starting at zero.

    then on the 100708 2198 needs to be misused but also because there are 2 dates where it is best to sell 2189 and 2190 need to be added.

    im not quite sure how to do this
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Exclamation Re: keeping a bank total

    Your attrached file is corrupt. Please delete and try again.
    Turn Data into Information
    Turn Information into Knowledge
    Turn Knowledge into Direction
    Turn Direction into Leadership
    Turn Leadership into Results
    Stephen Druley

    It's not how quickly you think
    But how deeply you think
    The quality of thinking is measured
    by remoteness to conformance
    Stephen Druley

  3. #3
    Registered User
    Join Date
    09-21-2010
    Location
    grenfell
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: keeping a bank total

    have attached the file again.
    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)

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