help calculating gain and loss

Discussion in 'Trading' started by ephi144, Feb 21, 2008.

  1. ephi144


    i am new to trading. i made some trades in last two days but cannot really figure out my gains/losses. according to TDAmeritrade i am in hole for 421 however with my calculations i should be positive ~175$.

    the way i calculate my total gain/loss for the day at the end of the day is by summing up the Gain($) column and then adding gain/loss from sell of securities.

    i am posting excel sheet with screen shots and other info. of my current positions + buy sells i did today.

    please let me know if you need more info.

    besides my account number :)

    thanks for your help
  2. Gyles


    I downloaded the attached file, and it does not seem clear, take for instance, you have two columns on profit and loss. Moreover, you seem to be on margin, and hence shall have some margin interest paid.

    Please explain the file so that we can discuss further.
  3. It looks like you failed to put how much you are paying in commissions with your trades. Also, i dont know how much your broker charges for margin rates, but if its like my account and you are paying 9% interest like i do, then you will be paying a little over 200 per month in interest.