Canadian Money Forum banner
1 - 1 of 6 Posts

· Registered
13 Posts
Discussion Starter · #1 ·

I'm new to the forum, so apologies if this doesn't belong in this particular sub-forum - feel free to move it elsewhere if it truly belongs there.

I'm currently writing a little web application for me to track my stock transactions, and have it automagically rolled up into positions, asset allocation breakdowns, etc. I'm currently 'stuck' researching the best way to calculate ACB across multiple currencies.

i.e., I trade with Questrade. If I bought 100 shares of stock XYZ at 10$ USD/share, I would have paid a 4.95$ CAD commission.

As I understand it, my ACB is the cost + fees divided by the number of shares. In this case since since my currencies differ, I'd imagine I need to do some currency conversion to make the results mean something. Would I:

- Convert the CAD fee into USD using the exchange rate for the date of purchase and/or sale?
- Convert the USD cost into CAD for the given date, and then do the ACB calc?
- Something else?

There's a variety of sub questions that fall out of this depending on what is the 'correct' answer, but hopefully someone can help me figure this much out. :)

Thanks in advance!

1 - 1 of 6 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.