›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Fixed Investment Shows Gain and Loss on Daily Tab

mg3puttmg3putt
in Excel Workbook
I purchased a new USD fixed investment that pays interest at the end of each month and for some reason on January 31st the workbook reports a gain of $1 and on February 1st a loss of $610. The monthly tab also shows a gain/loss for January and February.

I have used this same method for an equivalent CAD fixed investment that does not exhibit this same behaviour. What have I done wrong to cause this?

Daily tab


Monthly tab


PSConfig.txt


Transactions



Thanks...Mark


Comments

  • VidasMatelisVidasMatelis
    Please check what you selected for "Reporting Currency" . When you have symbol that has fixed value of 10$ in USD, when you check report using "Report Currency" as CAD, you see the impact of exchange rate change.
  • mg3puttmg3putt
    Didn't think of that and that makes sense...and it worked. Thanks Vidas.

    Mark
Sign In or Register to comment.