Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Currency issue on "Cost Basis "only...for one symbol
Hello
I track cash by making up a symbol called "money.to". I assign a value of one dollar to that symbol and then enter transactions for cash using it. It has always worked well. In my last update, I noticed that the COST BASIS for "money.to" is correct for Canadian currency (which i operate in) but wildly incorrect for US. This is causing PS to have problems when it does a refresh. Where should i be looking to see why the US dollar amount for the cost basis is in error ( for example $31,982 CDN converts to $40,078,053 US Dollars)This problem only occurs for this symbol and only for the cost basis. The actual value of the symbol is correct and converts correctly between currencies. The cost basis for all other symbols convert between currencies correctly. (even other symbols i made up to deal with GICs etc)
Thank you.
I track cash by making up a symbol called "money.to". I assign a value of one dollar to that symbol and then enter transactions for cash using it. It has always worked well. In my last update, I noticed that the COST BASIS for "money.to" is correct for Canadian currency (which i operate in) but wildly incorrect for US. This is causing PS to have problems when it does a refresh. Where should i be looking to see why the US dollar amount for the cost basis is in error ( for example $31,982 CDN converts to $40,078,053 US Dollars)This problem only occurs for this symbol and only for the cost basis. The actual value of the symbol is correct and converts correctly between currencies. The cost basis for all other symbols convert between currencies correctly. (even other symbols i made up to deal with GICs etc)
Thank you.
Comments
I would do following:
1. In the source filter transactions just to symbol money.to and carefully review all transactions, especially last ones. Pay extra close attention to Qty, Price and CostBasisOverride columns.
2. If above does not help, delete last few related to money.to transactions and attempt to refresh.
Let me know if you still have issues after these steps.