tag:infinitekind.tenderapp.com,2009-01-14:/discussions/general-questions/93785-exporting-exchange-rates-from-quickenInfinite Kind: Discussion 2020-04-21T20:30:23Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/480234432020-01-21T15:37:48Z2020-01-21T15:37:50ZExporting Exchange Rates from Quicken<div><p>Hi Des,<br>
I'm in Australia and moving from Reckon Home & Business 2020 to MD on Windows. I believe it's been similar for at least the last 5 versions of H&B</p>
<p>I've tested all of the above and have attached a quick-and-dirty spreadsheet result below. Reckon gives you the choice to export the complete currency list with name, symbol and LATEST rate only, or to export a Full Currency History, ONE CURRENCY PAIR AT A TIME (including date and rate).<br>
Export to Text, Print to Text and Print to PRN all give the same output which is perfectly usable although my symbols needed attention during Excel import to choose the correct charset which defaulted wrongly. (In my case Windows (ANSI) was required but the files defaulted to Shift-JIS - perhaps by recognising my ¥ Yen symbol.) The screenshot is the result of Tools | Currency List | Historical Rates | Print<br>
Hope that helps.</p></div>tgilbert666tag:infinitekind.tenderapp.com,2009-01-14:Comment/480234432020-01-21T20:23:16Z2020-01-21T20:23:16ZExporting Exchange Rates from Quicken<div><p>Hi,</p>
<p>Thanks for the effort. That is the soft of thing I wanted to see. When I migrated from Reckon myself I had to export a transaction report from each account and I remembered there was a funny way through Print then export to an Excel "compatible" format. A screen shot I saw during my research triggered some memories.</p>
<p>Why I asked about the two formats was that I found another note about some subtle differences between the two formats that might make PRN (which is what was used with Lotus 1-2-3) more straightforward. A file with a format that is close may just need to be opened in something like Notepad and have some little changes made which then make it importable into Moneydance.</p>
<p>It is the first page of your Excel file that is the interesting one. I have been able to make some little changes, save it as a true CSV file and import it successfully. I'm particularly glad you did Sterling as it looks like the rates need to be inverted for Moneydance. Time for some more fiddling :)</p>
<p>The whole reason for looking at this is for migrating away from Quicken/Reckon. A fellow user found that if exchange rates were loaded first and an account was set to use a loaded foreign currency then transfers between accounts would be converted. This has the potential to avoid the duplicates that otherwise occur and avoid some manual corrections, as what is in Quicken is hopefully the exchange rate used for the transactions rather then just being indicative rates you could get from other sources.</p>
<p>Des</p></div>dwg