View Single Post
Old 07-03-2015, 12:55 AM   #3609
Perisher
High Supremacy Member
 
Perisher's Avatar
 
Join Date: Jan 2015
Posts: 49,598
how do you keep track of your winnings and losing on an excel sheet for 2 currencies? rather complicated sia....

i been fumbling with that

and to add to the complication, if you exchange SGD=> USD you have different exchange rates.
Just have 2 excel sheet?
The total P/L can just times 1.38 or whatever is the exchange rate now?
I use spot as until I really exchange I won't know what rate it is. It is a moving thing, like how you record your stock price.

BTW, scb has FCY account which seperates by currency, don't need to exchange currency immediately, can store power.
Perisher is offline