nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I find all transactions in a ledger that have incorrect usd/cad exchange rate set at 1.000?

questionsforever

In the multi-currency Quicken when you enter a stock trade there is an attached foreign exchange rate. I find that for some reason some transactions show 1.0000 for that day and it screws up cost basis reports with transaction exchange rate checkbox set. Is there a way to search for all stock symbols or investment accounts for stock buys or sells that have 1.000 as the exchange rate so you can change it to the correct one?

Find more posts tagged with

Multi-Currency

Comments

Arctic Hare

I believe the 1.0000 shows up if you are entering the transaction for which a F/X rate for that day has not already been downloaded/entered. I'm not aware of anyway to search for the f/x = 1 transactions. Best to ensure you have a valid F/X rate when entering the transaction each time.

Chris_QPW

How about customizing the investment transactions report so that only the buy,buyx,sell,sellx actions are selected and then just export the report to Excel and sort on the Exchange Rate column?

questionsforever

https://community.quicken.com/discussion/comment/20404356#Comment_20404356

It worked, thanks. Just wanted to add you have to select 'transaction exchange rate' ticked. If there are not many transactions you can just eyeball the report and fix the missing exchange rates..